[Bug 881858] New: file conflicts between postgresql92 and postgresql93

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c0 Summary: file conflicts between postgresql92 and postgresql93 Classification: openSUSE Product: openSUSE Factory Version: 13.2 Milestone 0 Platform: Other OS/Version: openSUSE 13.2 Status: NEW Severity: Normal Priority: P5 - None Component: Basesystem AssignedTo: max@suse.com ReportedBy: suse-beta@cboltz.de QAContact: qa-bugs@suse.de Found By: Beta-Customer Blocker: --- While zypper dup'ing to latest factory, I got lots of file conflicts between postgresql92 and postgresql93. There are also file conflicts between postgresql92-server and postgresql93-server. Please add a Conflicts: or make sure the two packages don't contain conflicting files. Here's the detailed list of file conflicts: # zypper dup [...] Checking for file conflicts: ...........................................................................[error] Detected 21 file conflicts: File /usr/bin/clusterdb from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/createdb from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/createlang from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/createuser from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/dropdb from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/droplang from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/dropuser from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/initdb from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_basebackup from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_controldata from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_ctl from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_dump from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_dumpall from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_receivexlog from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_resetxlog from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/pg_restore from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/postgres from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/postmaster from install of postgresql93-server-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-server-9.2.4-5.3.x86_64(@System) File /usr/bin/psql from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/reindexdb from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) File /usr/bin/vacuumdb from install of postgresql93-9.3.4-1.1.x86_64(factory-oss) conflicts with file from package postgresql92-9.2.4-5.3.x86_64(@System) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c1 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO InfoProvider| |suse-beta@cboltz.de --- Comment #1 from Reinhard Max <max@suse.com> 2014-06-10 09:48:35 CEST --- (In reply to comment #0)
While zypper dup'ing to latest factory,
Coming from where?
Please add a Conflicts: or make sure the two packages don't contain conflicting files.
These packages are designed to be installable in parallel, so I'll never add a conflicts tag to them. The files you report as conflicts are in fact handled by update-alternatives. So, it smells like a zypper problem to me. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c2 Christian Boltz <suse-beta@cboltz.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW InfoProvider|suse-beta@cboltz.de | --- Comment #2 from Christian Boltz <suse-beta@cboltz.de> 2014-06-10 15:27:00 CEST --- (In reply to comment #1)
(In reply to comment #0)
While zypper dup'ing to latest factory,
Coming from where?
An older factory version, about two months old. However the postgresql92 packages were from Dec 2013: # grep postgresql92 /var/log/zypp/history [...] 2013-10-12 21:06:37|install|postgresql92|9.2.4-5.3|x86_64||factory-oss|5605921399bcb22e99754b8de854263356759b66337d2b9bd93d1fc7568aa123| 2013-10-12 21:07:10|install|postgresql92-server|9.2.4-5.3|x86_64||factory-oss|3db76b31c8f6d4505337605f4b1cdbbad3cfd809ec97fc218fcccdcc683946b4| 2014-06-09 13:18:41|remove |postgresql92-server|9.2.4-5.3|x86_64|| 2014-06-09 13:18:41|remove |postgresql92|9.2.4-5.3|x86_64|root@geeko| # grep postgresql93 /var/log/zypp/history # not shortened 2014-02-08 21:44:28|install|postgresql93|9.3.2-1.1|x86_64||factory-oss|9fec1220e0596418e911c6742e244ad12b90ba38f54a5e94529f89119f8f9f29| 2014-02-08 21:51:10|install|postgresql93-server|9.3.2-1.1|x86_64||factory-oss|4f61d050d2e4a3c7e8f54f6a2398377407bfd659bb1419b2bc1a8857c24566fc| 2014-04-13 01:48:28|install|postgresql93|9.3.3-2.2|x86_64||factory-oss|63f03290794a0cf11b659c7d01e8655f300f656eee26af2733e36d2305032cee| 2014-04-13 01:52:20|install|postgresql93-server|9.3.3-2.2|x86_64||factory-oss|3c080beff0850ab5e95f473bb8017d338c944b99dc054e3b52f9db25bad63bfa| 2014-06-09 13:18:56|install|postgresql93|9.3.4-1.1|x86_64||factory-oss|35ee4f05ded0737e2864f0164f0a4b4d8482aaa2f56b1db0a1df522953a4c4ef| 2014-06-09 13:18:57|install|postgresql93-server|9.3.4-1.1|x86_64||factory-oss|f439ea98e10d20686a379f3a0a4ad4297bafd7c8d7b8764cbe44f2b3e19d81fe|
Please add a Conflicts: or make sure the two packages don't contain conflicting files.
These packages are designed to be installable in parallel, so I'll never add a conflicts tag to them. The files you report as conflicts are in fact handled by update-alternatives. So, it smells like a zypper problem to me.
This, or the old package I had did not use update-alternatives yet (when did you introduce that?) Unfortunately I uninstalled the postgresql92{,-server} packages, so I can't check it myself :-( -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c3 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID --- Comment #3 from Reinhard Max <max@suse.com> 2014-06-10 15:43:04 CEST --- (In reply to comment #2)
An older factory version, about two months old. However the postgresql92 packages were from Dec 2013:
Unsupported. But feel free to reopen if you can reproduce it when upgrading from 13.1 to Factory.
This, or the old package I had did not use update-alternatives yet (when did you introduce that?)
The new packaging schema which allows the installation of multiple PostgreSQL versions in parallell for easier migration was introduced to Factory in October 2012. But in early 2014 new rules were put into place for the handling of alternatives and so I had to make a few adjustments. Maybe that's what has bitten you. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c4 Christian Boltz <suse-beta@cboltz.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID | --- Comment #4 from Christian Boltz <suse-beta@cboltz.de> 2014-06-10 23:46:16 CEST --- (In reply to comment #3)
(In reply to comment #2)
An older factory version, about two months old. However the postgresql92 packages were from Dec 2013:
Unsupported. But feel free to reopen if you can reproduce it when upgrading from 13.1 to Factory.
I just downloaded the 13.1 packages postgresql92-9.2.4-4.1.3.x86_64.rpm and postgresql92-server-9.2.4-4.1.3.x86_64.rpm and wanted to install them with zypper. This gives me a lot of file conflicts, most probably the same as in the initial bugreport. I then downloaded postgresql92-9.2.7-4.4.1.x86_64.rpm and postgresql92-server-9.2.7-4.4.1.x86_64.rpm with a similar list of conflicts. (Needless to say that I didn't continue to install the postgresql92* packages.) I know this isn't exactly "upgrade 13.1 to factory", but it's very close, so I take it as a reason to reopen the bug ;-) Hint: the symlinks in postgresql92 look like this: /usr/bin/clusterdb -> ../lib/postgresql92/bin/clusterdb while postgresql93 contains symlinks like /usr/bin/clusterdb -> /etc/alternatives/clusterdb Note the different symlink targets (../lib/postgresql92 vs. /etc/alternatives). That's explains why zypper complains about conflicts. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c5 --- Comment #5 from Reinhard Max <max@suse.com> 2014-06-11 10:14:15 CEST --- Yes, that's the change of rules I mentioned in my last comment. BTW, these packaged symlinks get overwritten by update-alternatives in %post anyway, so you can safely ignore the conflict warnings. If you want to avoid the warnings completely, you can upgrade postgresql92 from server:database:postgresql before doing the zypper dup. I don't think this justifies a maintenance update for 13.1 and 12.3 at this point, but I plan to integrate it with the next regular patchlevel update. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=881858 https://bugzilla.novell.com/show_bug.cgi?id=881858#c6 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |DUPLICATE --- Comment #6 from Reinhard Max <max@suse.com> 2014-08-06 15:17:59 CEST --- dup *** This bug has been marked as a duplicate of bug 888507 *** http://bugzilla.novell.com/show_bug.cgi?id=888507 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com