[Cooker] postgresql conflict

[Frank Griffin-4]

Installation failed:
     postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
libpq8.3_5-8.3.6-3mdv2009.1.i586

[Olivier Thauvin-2]

* Frank Griffin (ftg@...) wrote:
> Installation failed:
>      postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
> libpq8.3_5-8.3.6-3mdv2009.1.i586

Can you give me please the result of:

rpm -q lib64pq8.3_5 lib64pq5

[Frank Griffin-4]

Olivier Thauvin wrote:

> * Frank Griffin (ftg@...) wrote:
>  
>> Installation failed:
>>      postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
>> libpq8.3_5-8.3.6-3mdv2009.1.i586
>>    
>
> Can you give me please the result of:
>
> rpm -q lib64pq8.3_5 lib64pq5
>  

[root@ftglap ftg]# rpm -q lib64pq8.3_5 lib64pq5
package lib64pq8.3_5 is not installed
package lib64pq5 is not installed

[Olivier Thauvin-2]

* Frank Griffin (ftg@...) wrote:

> Olivier Thauvin wrote:
> > * Frank Griffin (ftg@...) wrote:
> >  
> >> Installation failed:
> >>      postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
> >> libpq8.3_5-8.3.6-3mdv2009.1.i586
> >>    
> >
> > Can you give me please the result of:
> >
> > rpm -q lib64pq8.3_5 lib64pq5
> >  
> [root@ftglap ftg]# rpm -q lib64pq8.3_5 lib64pq5
> package lib64pq8.3_5 is not installed
> package lib64pq5 is not installed
>

Then, what was the list of packages you were trying to install ?

[Frank Griffin-4]

Olivier Thauvin wrote:
> * Frank Griffin (ftg@...) wrote:
>  
>> Olivier Thauvin wrote:
>>    
>
> Then, what was the list of packages you were trying to install ?
>  

Here's the latest urpmi --auto-select output.  It doesn't seem to matter
what the package list is:

[root@ftgme2 ftg]# urpmi --auto-update --split-level=1 --split-length=1
medium "Main" is up-to-date
medium "Main Updates" is up-to-date
medium "Contrib" is up-to-date
medium "Contrib Updates" is up-to-date
medium "Non-free" is up-to-date
medium "Non-free Updates" is up-to-date
medium "plf-nonfree" is up-to-date
medium "plf-free" is up-to-date
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch  
(medium "Main")
  drakx-installer-stage2         12.1         1mdv2009.1    i586  
  drakx-net                      0.67         1mdv2009.1    noarch
  drakx-net-text                 0.67         1mdv2009.1    noarch
  dynamic                        0.26.16      1mdv2009.1    noarch
  gnome-desktop                  2.25.92      1mdv2009.1    i586  
  gnome-media                    2.25.92      1mdv2009.1    i586  
  gnome-panel                    2.25.92      1mdv2009.1    i586  
  gnome-session                  2.25.92      1mdv2009.1    i586  
  gnome-sharp2                   2.24.1       1mdv2009.1    i586  
  gurpmi                         6.22         1mdv2009.1    noarch
  libcddb-slave2_0               2.25.92      1mdv2009.1    i586  
  libdrakx-net                   0.67         1mdv2009.1    noarch
  libglibmm2.4-devel             2.19.8       1mdv2009.1    i586  
  libglibmm2.4_1                 2.19.8       1mdv2009.1    i586  
  libgtkmm2.4-devel              2.15.5       1mdv2009.1    i586  
  libgtkmm2.4_1                  2.15.5       1mdv2009.1    i586  
  libgweather                    2.25.92      1mdv2009.1    i586  
  libgweather1                   2.25.92      1mdv2009.1    i586  
  libpanel-applet-2_0            2.25.92      1mdv2009.1    i586  
  libpq8.3_5                     8.3.6        3mdv2009.1    i586  
  postgresql8.3-server           8.3.6        3mdv2009.1    i586  
  proftpd                        1.3.2        4mdv2009.1    i586  
  qt4-database-plugin-mysql      4.5.0        1mdv2009.1    i586  
  qt4-database-plugin-sqlite     4.5.0        1mdv2009.1    i586  
  qt4-doc                        4.5.0        1mdv2009.1    i586  
  qt4-examples                   4.5.0        1mdv2009.1    i586  
  urpmi-parallel-ssh             6.22         1mdv2009.1    noarch
  usermode                       1.99         2mdv2009.1    i586  
  usermode-consoleonly           1.99         2mdv2009.1    i586  
(medium "Contrib")
  liblash1                       0.5.4        7mdv2009.1    i586  
  libpq5                         8.2.12       1mdv2009.1    i586  
  pvm                            3.4.5        10mdv2009.1   i586  
  scilab                         5.1          2mdv2009.1    i586  
2.8MB of additional disk space will be used.
145MB of packages will be retrieved.
Proceed with the installation of the 33 packages? (Y/n)

installing
/mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm
/mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm
Installation failed:
    postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
libpq8.3_5-8.3.6-3mdv2009.1.i586

installing postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Installation failed:
    libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
postgresql8.3-server-8.3.6-3mdv2009.1.i586
    libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
postgresql8.3-server-8.3.6-3mdv2009.1.i586

installing usermode-consoleonly-1.99-2mdv2009.1.i586.rpm
usermode-1.99-2mdv2009.1.i586.rpm from /mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     1/33: usermode-consoleonly
#############################################
     2/33: usermode            
#############################################

installing dynamic-0.26.16-1mdv2009.1.noarch.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     3/33: dynamic              
#############################################

installing urpmi-parallel-ssh-6.22-1mdv2009.1.noarch.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     4/33: urpmi-parallel-ssh  
#############################################

installing gurpmi-6.22-1mdv2009.1.noarch.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     5/33: gurpmi              
#############################################

installing proftpd-1.3.2-4mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     6/33: proftpd              
#############################################
----------------------------------------------------------------------
More information on package proftpd-1.3.2-4mdv2009.1.i586
Mandriva RPM specific notes

modules support
---------------
proftpd-1.3.0 now loads the modules dynamically, very few modules are
compiled
into the proftpd binary. The new configuration file /etc/proftpd.conf uses a
"Include /etc/proftpd.d/*.conf" statement which makes proftpd very
similar to
how modules are loaded and the configuration of apache-2.x. Because of
this you
may have to manually merge your old configuration into the new
/etc/proftpd.conf file.  This is especially true if you are using LDAP,
because
then the mod_ldap.so proftpd module will not be automatically loaded.
Here is a
list of the modules that are compiled as DSO's:

 o mod_autohost.so         <- NEW
 o mod_ban.so              <- NEW
 o mod_case.so             <- NEW
 o mod_ctrls_admin.so      <- NEW
 o mod_facl.so
 o mod_gss.so
 o mod_ifsession.so
 o mod_ldap.so
 o mod_load.so             <- NEW
 o mod_quotatab.so         <- NEW
 o mod_quotatab_file.so    <- NEW
 o mod_quotatab_ldap.so    <- NEW
 o mod_quotatab_sql.so     <- NEW
 o mod_quotatab_radius.so  <- NEW
 o mod_radius.so
 o mod_ratio.so
 o mod_rewrite.so
 o mod_shaper.so           <- NEW
 o mod_site_misc.so        <- NEW
 o mod_sql.so              <- NEW
 o mod_sql_mysql.so        <- NEW
 o mod_sql_postgres.so     <- NEW
 o mod_time.so             <- NEW
 o mod_tls.so
 o mod_wrap2.so            <- NEW
 o mod_wrap2_file.so       <- NEW
 o mod_wrap2_sql.so        <- NEW
 o mod_vroot.so            <- NEW
 o mod_sftp                <- NEW
 
anonymous access configuration
------------------------------
Starting with 1.3.0-3mdv2007.1, there is no proftpd-anonymous package
anymore.
As it is just a configuration issue, providing a dedicated package was a bit
overkill. Samples configuration files are available among normal package
documentation. You may have to update your configuration manually.
----------------------------------------------------------------------

installing drakx-installer-stage2-12.1-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     7/33: drakx-installer-stage2
                               
#############################################

installing gnome-session-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     8/33: gnome-session        
#############################################

installing gnome-desktop-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
     9/33: gnome-desktop        
#############################################

installing libpanel-applet-2_0-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    10/33: libpanel-applet-2_0  
#############################################

installing libgweather-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    11/33: libgweather          
#############################################

installing libgweather1-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    12/33: libgweather1        
#############################################

installing gnome-panel-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    13/33: gnome-panel          
#############################################

installing drakx-net-0.67-1mdv2009.1.noarch.rpm
drakx-net-text-0.67-1mdv2009.1.noarch.rpm
libdrakx-net-0.67-1mdv2009.1.noarch.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    14/33: libdrakx-net        
#############################################
    15/33: drakx-net-text      
#############################################
    16/33: drakx-net            
#############################################

installing gnome-sharp2-2.24.1-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    17/33: gnome-sharp2        
#############################################

installing qt4-database-plugin-mysql-4.5.0-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    18/33: qt4-database-plugin-mysql
                               
#############################################

installing qt4-database-plugin-sqlite-4.5.0-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    19/33: qt4-database-plugin-sqlite
                               
#############################################

installing libglibmm2.4-devel-2.19.8-1mdv2009.1.i586.rpm
libglibmm2.4_1-2.19.8-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    20/33: libglibmm2.4_1      
#############################################
    21/33: libglibmm2.4-devel  
#############################################

installing qt4-doc-4.5.0-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    22/33: qt4-doc              
#############################################

installing qt4-examples-4.5.0-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    23/33: qt4-examples        
#############################################

installing libgtkmm2.4-devel-2.15.5-1mdv2009.1.i586.rpm
libgtkmm2.4_1-2.15.5-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    24/33: libgtkmm2.4_1        
#############################################
    25/33: libgtkmm2.4-devel    
#############################################

installing gnome-media-2.25.92-1mdv2009.1.i586.rpm
libcddb-slave2_0-2.25.92-1mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
    26/33: libcddb-slave2_0    
#############################################
    27/33: gnome-media          
#############################################

installing pvm-3.4.5-10mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/contrib/release
Preparing...                    
#############################################
    28/33: pvm                  
#############################################
userdel: user pvm does not exist
warning: %postun(pvm-3.4.5-9mdv2009.0.i586) scriptlet failed, exit status 6

installing liblash1-0.5.4-7mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/contrib/release
Preparing...                    
#############################################
    29/33: liblash1            
#############################################

installing scilab-5.1-2mdv2009.1.i586.rpm from
/mnt/cooker/i586/media/contrib/release
Preparing...                    
#############################################
    30/33: scilab              
#############################################
Installation failed:
    postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
libpq8.3_5-8.3.6-3mdv2009.1.i586
    libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
postgresql8.3-server-8.3.6-3mdv2009.1.i586
    libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
postgresql8.3-server-8.3.6-3mdv2009.1.i586

[Olivier Thauvin-2]

* Frank Griffin (ftg@...) wrote:

> Olivier Thauvin wrote:
> > * Frank Griffin (ftg@...) wrote:
> >  
> >> Olivier Thauvin wrote:
> >>    
> >
> > Then, what was the list of packages you were trying to install ?
> >  
>
> Here's the latest urpmi --auto-select output.  It doesn't seem to matter
> what the package list is:
>
> installing
> /mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm
> /mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm
> Installation failed:
>     postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
> libpq8.3_5-8.3.6-3mdv2009.1.i586
>
> installing postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm from
> /mnt/cooker/i586/media/main/release
> Installation failed:
>     libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
> postgresql8.3-server-8.3.6-3mdv2009.1.i586
>     libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
> postgresql8.3-server-8.3.6-3mdv2009.1.i586

Urpmi bug, it try to install libpq5-8.2.12-1mdv2009.1.i586.rpm, but
libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm conflict with, all dependencies
need to install postgresql8.3* are provided by libpq8.3_5.

So either urpmi try to solve dependencies by installing libpq5 instead
libpq8.3_5, either urpmi try to update libpq5 whereas it should be
removed.

A way to workaround could be having libpq8.3_5 obsoleting libpq5, the
problem is if I do that, what will do the buildsystem ? If someone can
clearly reply ?... (none of them should be removed).

[Frank Griffin-4]

Olivier Thauvin wrote:

> Urpmi bug, it try to install libpq5-8.2.12-1mdv2009.1.i586.rpm, but
> libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm conflict with, all dependencies
> need to install postgresql8.3* are provided by libpq8.3_5.
>
> So either urpmi try to solve dependencies by installing libpq5 instead
> libpq8.3_5, either urpmi try to update libpq5 whereas it should be
> removed.
>
> A way to workaround could be having libpq8.3_5 obsoleting libpq5, the
> problem is if I do that, what will do the buildsystem ? If someone can
> clearly reply ?... (none of them should be removed).
>  

This may give a hint:

[root@ftglap ftg]# urpmi --auto-select --keep
Some requested packages cannot be installed:
libpq5-8.2.12-1mdv2009.1.i586 (in order to keep
libpq8.3_5-8.3.5-3mdv2009.1.i586)
libpq8.3_5-8.3.6-3mdv2009.1.i586 (in order to keep
libpq5-8.2.11-3mdv2009.1.i586)
Continue installation anyway? (Y/n)

[Anssi Hannula-3]

Olivier Thauvin wrote:

> * Frank Griffin (ftg@...) wrote:
>> Olivier Thauvin wrote:
>>> * Frank Griffin (ftg@...) wrote:
>>>  
>>>> Olivier Thauvin wrote:
>>>>    
>>> Then, what was the list of packages you were trying to install ?
>>>  
>> Here's the latest urpmi --auto-select output.  It doesn't seem to matter
>> what the package list is:
>>
>> installing
>> /mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm
>> /mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm
>> Installation failed:
>>     postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
>> libpq8.3_5-8.3.6-3mdv2009.1.i586
>>
>> installing postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm from
>> /mnt/cooker/i586/media/main/release
>> Installation failed:
>>     libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
>> postgresql8.3-server-8.3.6-3mdv2009.1.i586
>>     libpq8.3_5 >= 8.3.6-3mdv2009.1 is needed by
>> postgresql8.3-server-8.3.6-3mdv2009.1.i586
>
> Urpmi bug, it try to install libpq5-8.2.12-1mdv2009.1.i586.rpm, but
> libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm conflict with, all dependencies
> need to install postgresql8.3* are provided by libpq8.3_5.
>
> So either urpmi try to solve dependencies by installing libpq5 instead
> libpq8.3_5, either urpmi try to update libpq5 whereas it should be
> removed.

Frank, please provide output with --debug option.

Whether or not a packaging bug exists, urpmi should catch the failure
before proceeding with installation.

> A way to workaround could be having libpq8.3_5 obsoleting libpq5, the
> problem is if I do that, what will do the buildsystem ? If someone can
> clearly reply ?... (none of them should be removed).

Buildsystem will remove libpq5 (at least it should do that, and IIRC it
still works).

--
Anssi Hannula

[Frank Griffin-4]

Anssi Hannula wrote:
>
> Frank, please provide output with --debug option.
>
[root@ftglap ftg]# urpmi --auto-select --debug
getting lock on urpmi
examining synthesis file [/var/lib/urpmi/Main/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/Main Updates/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/Contrib/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/Contrib
Updates/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/Non-free/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/Non-free
Updates/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/plf-nonfree/synthesis.hdlist.cz]
examining synthesis file [/var/lib/urpmi/plf-free/synthesis.hdlist.cz]
getting exclusive lock on rpm
opening rpmdb (root=, write=)
auto-select: adding postgresql8.3-server-8.3.6-3mdv2009.1.i586 replacing
postgresql8.3-server-8.3.5-3mdv2009.1.i586
auto-select: adding libpq8.3_5-8.3.6-3mdv2009.1.i586 replacing
libpq8.3_5-8.3.5-3mdv2009.1.i586
auto-select: adding libpq5-8.2.12-1mdv2009.1.i586 replacing
libpq5-8.2.11-3mdv2009.1.i586
selecting libpq5-8.2.12-1mdv2009.1.i586
set_rejected: libpq5-8.2.11-3mdv2009.1.i586
installed package libpq5-8.2.11-3mdv2009.1.i586 is conflicting with
libpq5-8.2.12-1mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.2.12-1mdv2009.1])
promoting libpq5-8.2.12-1mdv2009.1.i586 because of conflict above
installed package libpq8.3_5-8.3.5-3mdv2009.1.i586 is conflicting with
libpq5-8.2.12-1mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.5-3mdv2009.1])
promoting libpq8.3_5-8.3.6-3mdv2009.1.i586 because of conflict above
selecting libpq8.3_5-8.3.6-3mdv2009.1.i586
set_rejected: libpq8.3_5-8.3.5-3mdv2009.1.i586
installed package libpq8.3_5-8.3.5-3mdv2009.1.i586 is conflicting with
libpq8.3_5-8.3.6-3mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.6-3mdv2009.1])
promoting libpq8.3_5-8.3.6-3mdv2009.1.i586 because of conflict above
installed package libpq5-8.2.11-3mdv2009.1.i586 is conflicting with
libpq8.3_5-8.3.6-3mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.6-3mdv2009.1])
selecting postgresql8.3-server-8.3.6-3mdv2009.1.i586
set_rejected: postgresql8.3-server-8.3.5-3mdv2009.1.i586
To satisfy dependencies, the following packages are going to be installed:
   Package                        Version      Release       Arch  
(medium "Main")
  libpq8.3_5                     8.3.6        3mdv2009.1    i586  
  postgresql8.3-server           8.3.6        3mdv2009.1    i586  
(medium "Contrib")
  libpq5                         8.2.12       1mdv2009.1    i586  
27KB of additional disk space will be used.
2.7MB of packages will be retrieved.
Proceed with the installation of the 3 packages? (Y/n)
opening rpmdb (root=, write=)
getting graph of dependencies for sorting
sorting graph of dependencies
rpms sorted by dependence: libpq5+libpq8.3_5 postgresql8.3-server
selecting libpq5-8.2.12-1mdv2009.1.i586
set_rejected: libpq5-8.2.11-3mdv2009.1.i586
installed package libpq5-8.2.11-3mdv2009.1.i586 is conflicting with
libpq5-8.2.12-1mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.2.12-1mdv2009.1])
promoting libpq5-8.2.12-1mdv2009.1.i586 because of conflict above
installed package libpq8.3_5-8.3.5-3mdv2009.1.i586 is conflicting with
libpq5-8.2.12-1mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.5-3mdv2009.1])
promoting libpq8.3_5-8.3.6-3mdv2009.1.i586 because of conflict above
selecting libpq8.3_5-8.3.6-3mdv2009.1.i586
set_rejected: libpq8.3_5-8.3.5-3mdv2009.1.i586
installed package libpq8.3_5-8.3.5-3mdv2009.1.i586 is conflicting with
libpq8.3_5-8.3.6-3mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.6-3mdv2009.1])
promoting libpq8.3_5-8.3.6-3mdv2009.1.i586 because of conflict above
installed package libpq5-8.2.11-3mdv2009.1.i586 is conflicting with
libpq8.3_5-8.3.6-3mdv2009.1.i586 (Conflicts: postgresql-libs[<
8.3.6-3mdv2009.1])
selecting postgresql8.3-server-8.3.6-3mdv2009.1.i586
set_rejected: postgresql8.3-server-8.3.5-3mdv2009.1.i586
transaction valid: remove= update=libpq5,postgresql8.3-server,libpq8.3_5
scheduled sets of transactions:
remove=0= update=3=libpq5,postgresql8.3-server,libpq8.3_5

verifying signature of
/mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm
verifying signature of
/mnt/cooker/i586/media/main/release/postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm
verifying signature of
/mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm
installing
/mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm
/mnt/cooker/i586/media/main/release/postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm
/mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm
starting installing packages
opening rpmdb (root=, write=1)
created transaction for installing on / (remove=0, install=0, upgrade=3)
trans: scheduling update of libpq5-8.2.12-1mdv2009.1.i586 (id=17632,
file=/mnt/cooker/i586/media/contrib/release/libpq5-8.2.12-1mdv2009.1.i586.rpm)
trans: scheduling update of postgresql8.3-server-8.3.6-3mdv2009.1.i586
(id=5818,
file=/mnt/cooker/i586/media/main/release/postgresql8.3-server-8.3.6-3mdv2009.1.i586.rpm)
trans: scheduling update of libpq8.3_5-8.3.6-3mdv2009.1.i586 (id=5834,
file=/mnt/cooker/i586/media/main/release/libpq8.3_5-8.3.6-3mdv2009.1.i586.rpm)
Installation failed:
    postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
libpq8.3_5-8.3.6-3mdv2009.1.i586
Installation failed:
    postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
libpq8.3_5-8.3.6-3mdv2009.1.i586
unlocking urpmi database
unlocking rpm database
EXITING (pid=1621)
[root@ftglap ftg]#

[Anssi Hannula-3]

Frank Griffin wrote:
> Anssi Hannula wrote:
>> Frank, please provide output with --debug option.
>>
> [root@ftglap ftg]# urpmi --auto-select --debug
[...]
> Installation failed:
>     postgresql-libs < 8.3.6-3mdv2009.1 conflicts with
> libpq8.3_5-8.3.6-3mdv2009.1.i586
> Installation failed:
>     postgresql-libs < 8.3.6-3mdv2009.1 conflicts with

Try attached patch on /usr/lib/perl5/vendor_perl/5.10.0/*/URPM/Resolve.pm.

--
Anssi Hannula

Index: URPM/Resolve.pm
===================================================================
--- URPM/Resolve.pm (revision 253707)
+++ URPM/Resolve.pm (working copy)
@@ -996,6 +996,9 @@
 
     _handle_conflicts($urpm, $db, $state, $pkg, \@properties, \%diff_provides_h, $options{keep} && \@keep);
 
+    #- abort if _handle_conflicts unselected this package
+    exists $state->{selected}{$pkg->id} or next;
+
     #- examine if an existing package does not conflict with this one.
     $db->traverse_tag('whatconflicts', [ $pkg->provides_nosense ], sub {
  @keep and return;
@@ -1039,8 +1042,15 @@
  if (my ($n, $o, $v) = property2name_op_version($_)) {
     foreach my $p ($urpm->packages_providing($n)) {
  $pkg == $p and next;
- $p->name eq $n && (!$o || eval($p->compare($v) . $o . 0)) or next;
- _set_rejected_from($state, $p, $pkg);
+ $p->provides_overlap($_) or next;
+ if (exists $state->{selected}{$p->id}) {
+    disable_selected($urpm, $db, $state, $pkg);
+    _set_rejected_from($state, $pkg, $p);
+    _add_rejected_backtrack($state, $pkg, { conflict => [ $p ] });
+    return;
+ } else {
+    _set_rejected_from($state, $p, $pkg);
+ }
     }
  }
  if (my ($file) = m!^(/[^\s\[]*)!) {

[Frank Griffin-4]

Anssi Hannula wrote:
> Try attached patch on /usr/lib/perl5/vendor_perl/5.10.0/*/URPM/Resolve.pm.
>
>  
OK, thanks for the patch:

[root@ftgme2 i386-linux-thread-multi]# pwd
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
[root@ftgme2 i386-linux-thread-multi]# patch -p0 </home/ftg/tmp/*.patch
patching file URPM/Resolve.pm
[root@ftgme2 i386-linux-thread-multi]# urpmi --auto-update
--split-level=1 --split-length=1
updated medium "Main"
medium "Main Updates" is up-to-date
updated medium "Contrib"
medium "Contrib Updates" is up-to-date
updated medium "Non-free"
medium "Non-free Updates" is up-to-date
medium "plf-nonfree" is up-to-date
medium "plf-free" is up-to-date
To satisfy dependencies, the following package is going to be installed:
   Package                        Version      Release       Arch  
(medium "Main")
  meta-task                      2009.1       7mdv2009.1    noarch
4B of additional disk space will be used.
39KB of packages will be retrieved.
Proceed with the installation of one package? (Y/n)

installing meta-task-2009.1-7mdv2009.1.noarch.rpm from
/mnt/cooker/i586/media/main/release
Preparing...                    
#############################################
      1/1: meta-task            
#############################################
restarting urpmi
The following package has to be removed for others to be upgraded:
libpq5-8.2.11-3mdv2009.1.i586
 (due to conflicts with libpq8.3_5-8.3.6-3mdv2009.1.i586) (y/N)

I'm not sure whether this fixes things or not.  My expectation would be
that one version of postgresql would silently replace the last, but now
I think of it, this type of thing happens every time postgresql gets
updated.  How is a sysadmin supposed to know whether it's safe to reply
Y to the above message, and why doesn't this happen with every other app
on the face of the earth ?

[Anssi Hannula-3]

Frank Griffin wrote:
> Anssi Hannula wrote:
>> Try attached patch on /usr/lib/perl5/vendor_perl/5.10.0/*/URPM/Resolve.pm.
>>
> OK, thanks for the patch:
[...]
> The following package has to be removed for others to be upgraded:
> libpq5-8.2.11-3mdv2009.1.i586
>  (due to conflicts with libpq8.3_5-8.3.6-3mdv2009.1.i586) (y/N)
>
> I'm not sure whether this fixes things or not.  My expectation would be
> that one version of postgresql would silently replace the last,

This only fixes the urpmi bug (it continued installation even though it
was impossible).

There's also the postgresql packaging bug, I agree that there should be
an obsoletes entry so that it would silently replace it.

> but now
> I think of it, this type of thing happens every time postgresql gets
> updated.  How is a sysadmin supposed to know whether it's safe to reply
> Y to the above message, and why doesn't this happen with every other app
> on the face of the earth ?

Postgresql packages on Mandriva have a big mess of 'Conflicts' entries,
even new versions of the same package 'conflict' with the older version
(e.g. libpq8.3_5-8.3.6 conflicts with libpq8.3_5-8.3.5), even though
that doesn't make sense.

--
Anssi Hannula

[Olivier Thauvin-2]

* Anssi Hannula (anssi@...) wrote:
> Frank Griffin wrote:
> > Anssi Hannula wrote:
> There's also the postgresql packaging bug, I agree that there should be
> an obsoletes entry so that it would silently replace it.

I explained earlier why I can't use obsoletes.

>
> > but now
> > I think of it, this type of thing happens every time postgresql gets
> > updated.  How is a sysadmin supposed to know whether it's safe to reply
> > Y to the above message, and why doesn't this happen with every other app
> > on the face of the earth ?
>
> Postgresql packages on Mandriva have a big mess of 'Conflicts' entries,
> even new versions of the same package 'conflict' with the older version
> (e.g. libpq8.3_5-8.3.6 conflicts with libpq8.3_5-8.3.5), even though
> that doesn't make sense.

Hu ?

Rpm ignore conflicts when it apply to the package itself.

>
> --
> Anssi Hannula

[Olivier Thauvin-2]

* Frank Griffin (ftg@...) wrote:

> Anssi Hannula wrote:
> > Try attached patch on /usr/lib/perl5/vendor_perl/5.10.0/*/URPM/Resolve.pm.
> >
> >  
> OK, thanks for the patch:
>
> [root@ftgme2 i386-linux-thread-multi]# pwd
> /usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
> [root@ftgme2 i386-linux-thread-multi]# patch -p0 </home/ftg/tmp/*.patch
> patching file URPM/Resolve.pm
> [root@ftgme2 i386-linux-thread-multi]# urpmi --auto-update
> --split-level=1 --split-length=1

 restarting urpmi

> The following package has to be removed for others to be upgraded:
> libpq5-8.2.11-3mdv2009.1.i586
>  (due to conflicts with libpq8.3_5-8.3.6-3mdv2009.1.i586) (y/N)
>
> I'm not sure whether this fixes things or not.  My expectation would be
> that one version of postgresql would silently replace the last, but now
> I think of it, this type of thing happens every time postgresql gets
> updated.  How is a sysadmin supposed to know whether it's safe to reply
> Y to the above message, and why doesn't this happen with every other app
> on the face of the earth ?

Because postgresql 8.2 and 8.3 provides the libpq (client library), and
I tried to have both versions in cooker to allow people to keep their
database from 8.2 version.

Moreover, it has been asked to have several version for long supported
mandriva distro (eg corporate server).

[Frank Griffin-4]

Olivier Thauvin wrote:
> * Frank Griffin (ftg@...) wrote:
>  
> Because postgresql 8.2 and 8.3 provides the libpq (client library), and
> I tried to have both versions in cooker to allow people to keep their
> database from 8.2 version.
>
> Moreover, it has been asked to have several version for long supported
> mandriva distro (eg corporate server)

Fair enough.  So why do the two libpq's conflict ?  If their internal
file structure conflicts, then they obviously can't be installed
side-by-side, and if they can't, then I don't see how you can hope to
have two postgresql's installed side-by-side.

[Olivier Thauvin-2]

* Frank Griffin (ftg@...) wrote:

> Olivier Thauvin wrote:
> > * Frank Griffin (ftg@...) wrote:
> >  
> > Because postgresql 8.2 and 8.3 provides the libpq (client library), and
> > I tried to have both versions in cooker to allow people to keep their
> > database from 8.2 version.
> >
> > Moreover, it has been asked to have several version for long supported
> > mandriva distro (eg corporate server)
>
> Fair enough.  So why do the two libpq's conflict ?  If their internal
> file structure conflicts, then they obviously can't be installed
> side-by-side, and if they can't, then I don't see how you can hope to
> have two postgresql's installed side-by-side.
>

Postgresql provide both client and server, the is not installing both
version in same, but providing both version.

If packages have same name, te bs will remove the older.

[Frank Griffin-4]

Olivier Thauvin wrote:
> Postgresql provide both client and server, the is not installing both
> version in same, but providing both version.
>
> If packages have same name, te bs will remove the older.
>  

If I understand you, you're saying that you want both packages available
in cooker even though they can't be installed at the same time, and a
side effect is that the newer package can't silently replace the older,
in case the user wants to keep the older one installed.

Is this correct packaging policy ?  Why can't postgresql be packaged so
that different versions install side by side (like pretty much
everything else that has this issue) ?

[Anssi Hannula-3]

Frank Griffin wrote:

> Anssi Hannula wrote:
>> Try attached patch on /usr/lib/perl5/vendor_perl/5.10.0/*/URPM/Resolve.pm.
>>
>>  
> OK, thanks for the patch:
>
> [root@ftgme2 i386-linux-thread-multi]# pwd
> /usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
> [root@ftgme2 i386-linux-thread-multi]# patch -p0 </home/ftg/tmp/*.patch
> patching file URPM/Resolve.pm
> [root@ftgme2 i386-linux-thread-multi]# urpmi --auto-update
> --split-level=1 --split-length=1

[...]
> The following package has to be removed for others to be upgraded:
> libpq5-8.2.11-3mdv2009.1.i586
>  (due to conflicts with libpq8.3_5-8.3.6-3mdv2009.1.i586) (y/N)

For the record, I've reported this issue as perl-URPM bugs #52135 and
#52145 and provided (better) patches for them:
https://qa.mandriva.com/show_bug.cgi?id=52135
https://qa.mandriva.com/show_bug.cgi?id=52145

Thanks for your report.

--
Anssi Hannula

[Frank Griffin-4]

Anssi Hannula wrote:
> For the record, I've reported this issue as perl-URPM bugs #52135 and
> #52145 and provided (better) patches for them:
> https://qa.mandriva.com/show_bug.cgi?id=52135
> https://qa.mandriva.com/show_bug.cgi?id=52145
>
> Thanks for your report.
>
>  
Thanks for the followup !