QEMU removes postgresql

[Joe Doe]

>sudo apt-get install kvm virt-manager removed postgresql-9.2 from my system.
Furthermore, it seem impossible for me to run postgresql and qemu at the same time.
Starting one, kills the other.

[Serge Hallyn (serge-hallyn)]

Quoting Joe Doe (<email address hidden>):
> Public bug reported:
>
> >sudo apt-get install kvm virt-manager removed postgresql-9.2 from my system.

Could you please show your OS release and from where and how you
installed postgresql-9.2? I'd like to try and reproduce, but
don't see any versions of postgresql-9.2 in the build archive.

Thanks!

 status: incomplete

[Michael Tokarev (mjt+launchpad-tls)]

Furthermore, I completely fail to see how this is relevant to the qemu project. This bug should be filed against the distribution supplied the binary packages, whose metadata is (apparently) wrong. Upstream qemu does not provide .deb packages and repositories.

[Michael Tokarev (mjt+launchpad-tls)]

(Having said that, I'd say this bugreport should be closed as invalid instead of being investigated further)

[Serge Hallyn (serge-hallyn)]

Agreed, closing against QEMU project. If you feel this is a bug in the ubuntu qemu package, then please target it as such (but I suspect that will also become invalid)

[Joe Doe (joe-doe-launchpad)]

You guys speak in technical terms that I can hardly understand.
postgresql-9.2 is not the default version for Ubuntu(I believe 9.1 is), but can easily be installed by using the steps here -> http://www.postgresql.org/download/linux/ubuntu/ .

Anyways, the issue seems to be here:

>sudo apt-get install kvm virt-manager
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'qemu-system-x86' instead of 'kvm'
qemu-system-x86 is already the newest version.
The following extra packages will be installed:
  libvirt-bin logrotate
Suggested packages:
  radvd python-guestfs python-spice-client-gtk
The following packages will be REMOVED:
  postgresql-9.2 postgresql-common postgresql-plperl-9.2
The following NEW packages will be installed:
  libvirt-bin logrotate virt-manager
0 upgraded, 3 newly installed, 3 to remove and 0 not upgraded.
Need to get 0 B/3,570 kB of archives.
After this operation, 5,177 kB disk space will be freed.
Do you want to continue [Y/n]? Y
(Reading database ... 210251 files and directories currently installed.)
Removing postgresql-plperl-9.2 ...
Removing postgresql-9.2 ...
 * Stopping PostgreSQL 9.2 database server [ OK ]
Removing postgresql-common ...
Removing 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Selecting previously unselected package logrotate.
(Reading database ... 209976 files and directories currently installed.)
Unpacking logrotate (from .../logrotate_3.8.3-3ubuntu2_amd64.deb) ...
Selecting previously unselected package libvirt-bin.
Unpacking libvirt-bin (from .../libvirt-bin_1.1.1-0ubuntu8_amd64.deb) ...
Selecting previously unselected package virt-manager.
Unpacking virt-manager (from .../virt-manager_0.9.5-1ubuntu1_all.deb) ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
Processing triggers for gconf2 ...
Processing triggers for bamfdaemon ...
Rebuilding /usr/share/applications/bamf-2.index...
Processing triggers for desktop-file-utils ...
Processing triggers for gnome-menus ...
Processing triggers for mime-support ...
Processing triggers for hicolor-icon-theme ...
Setting up logrotate (3.8.3-3ubuntu2) ...
Setting up libvirt-bin (1.1.1-0ubuntu8) ...
libvirt-bin start/running, process 24248
Setting up libvirt-bin dnsmasq configuration.
Setting up virt-manager (0.9.5-1ubuntu1) ...

As you can see from the logs, installing kvm removes postgresql automatically.

Furthermore, even if I install postgresql later on, starting qemu, shuts down postres.
No matter how much I tried, it was impossible for me to run qemu and postgresql-9.2 on my machine at the same time.

My version of Ubuntu is Saucy Salamander.

So are you saying this is not something related to QEMU project?
Who should this be addressed to?

Thank you

[Serge Hallyn (serge-hallyn)]

Quoting Joe Doe (<email address hidden>):
> You guys speak in technical terms that I can hardly understand.
> postgresql-9.2 is not the default version for Ubuntu(I believe 9.1 is), but can easily be installed by using the steps here -> http://www.postgresql.org/download/linux/ubuntu/ .
>
> Anyways, the issue seems to be here:
>
> >sudo apt-get install kvm virt-manager

I installed the postgresql-9.2 packages from the url you
listed, and installed qemu-kvm, kvm, and virt-manager,
but still was not able to reproduce this.

Please show the results of

 cat /etc/apt/sources.list
 for f in /etc/apt/sources.list.d/*; do
  echo $f
  cat $f
 done
 apt-cache show libvirt-bin
 apt-cache show logrotate
 apt-cache show qemu-kvm
 apt-cache show kvm
 apt-cache show virt-manager
 apt-cache show postgresql-9.2
 apt-cache show postgresql-common
 apt-cache show postgresql-plperl-9.2

(then re-mark the status of the bug as New)

> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Note, selecting 'qemu-system-x86' instead of 'kvm'
> qemu-system-x86 is already the newest version.
> The following extra packages will be installed:
> libvirt-bin logrotate
> Suggested packages:
> radvd python-guestfs python-spice-client-gtk
> The following packages will be REMOVED:
> postgresql-9.2 postgresql-common postgresql-plperl-9.2
> The following NEW packages will be installed:
> libvirt-bin logrotate virt-manager
> 0 upgraded, 3 newly installed, 3 to remove and 0 not upgraded.
> Need to get 0 B/3,570 kB of archives.
> After this operation, 5,177 kB disk space will be freed.
> Do you want to continue [Y/n]? Y
> (Reading database ... 210251 files and directories currently installed.)
> Removing postgresql-plperl-9.2 ...
> Removing postgresql-9.2 ...
> * Stopping PostgreSQL 9.2 database server [ OK ]
> Removing postgresql-common ...
> Removing 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
> Processing triggers for ureadahead ...
> Processing triggers for man-db ...
> Selecting previously unselected package logrotate.
> (Reading database ... 209976 files and directories currently installed.)
> Unpacking logrotate (from .../logrotate_3.8.3-3ubuntu2_amd64.deb) ...
> Selecting previously unselected package libvirt-bin.
> Unpacking libvirt-bin (from .../libvirt-bin_1.1.1-0ubuntu8_amd64.deb) ...
> Selecting previously unselected package virt-manager.
> Unpacking virt-manager (from .../virt-manager_0.9.5-1ubuntu1_all.deb) ...
> Processing triggers for man-db ...
> Processing triggers for ureadahead ...
> Processing triggers for gconf2 ...
> Processing triggers for bamfdaemon ...
> Rebuilding /usr/share/applications/bamf-2.index...
> Processing triggers for desktop-file-utils ...
> Processing triggers for gnome-menus ...
> Processing triggers for mime-support ...
> Processing triggers for hicolor-icon-theme ...
> Setting up logrotate (3.8.3-3ubuntu2) ...
> Setting up libvirt-bin (1.1.1-0ubuntu8) ...
> libvirt-bin start/running, process 24248
> Setting up libvirt-bin dnsmasq configuration.
> Setting up virt-manager (0.9.5-1ubuntu1) ...
>
> As you can see from the logs, installing ...

[Joe Doe (joe-doe-launchpad)]

Hi Serge,

Please find the results below:
>cat /etc/apt/sources.list
# deb cdrom:[Ubuntu 13.04 _Raring Ringtail_ - Release amd64 (20130424)]/ raring main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://us.archive.ubuntu.com/ubuntu/ saucy main restricted
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://us.archive.ubuntu.com/ubuntu/ saucy-updates main restricted
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://us.archive.ubuntu.com/ubuntu/ saucy universe
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy universe
deb http://us.archive.ubuntu.com/ubuntu/ saucy-updates universe
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://us.archive.ubuntu.com/ubuntu/ saucy multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy multiverse
deb http://us.archive.ubuntu.com/ubuntu/ saucy-updates multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://us.archive.ubuntu.com/ubuntu/ saucy-backports main restricted universe multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ saucy-backports main restricted universe multiverse

deb http://security.ubuntu.com/ubuntu saucy-security main restricted
deb-src http://security.ubuntu.com/ubuntu saucy-security main restricted
deb http://security.ubuntu.com/ubuntu saucy-security universe
deb-src http://security.ubuntu.com/ubuntu saucy-security universe
deb http://security.ubuntu.com/ubuntu saucy-security multiverse
deb-src http://security.ubuntu.com/ubuntu saucy-security multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu raring partner
# deb-src http://archive.canonical.com/ubuntu raring partner

## This software is not part of Ubuntu, but is offered by third-party
## developers who want to ship their latest software.
deb http://extras.ubuntu.com/ubuntu saucy main
deb-src http://extras.ubuntu.com/ubuntu saucy main

And the second one:

for f in /etc/apt/source...

[Serge Hallyn (serge-hallyn)]

Oh, I see - you are on a saucy machine using the precise postgresql
packages.

Anyway the problem is with postgresql-common versus logrotate. Now the
logrotate version in saucy is 3.8.3-3ubuntu2, and the postgresql-common
version is 149.pgdg12.4+1. postgresql-common says it breaks on
logrotate (>= 3.8). libvirt-bin depends on logrotate, and so you have
posgresql-common wanting to remove both logrotate and libvirt-bin.

qemu-kvm isn't even involved here, and it isn't a bug in libvirt or
its packaging. You simply need a newer postgresql package which
works with newer logrotate.

[Joe Doe (joe-doe-launchpad)]

Thank you, Serge!