RPM shows the same Package in two versions / can only be uninstalled once

[obel1x]

Currently i have:

pcmsi-i7-4790k:~ # rpm -qa wine
wine-7.21-lp154.1505.2.x86_64
wine-7.22-lp154.970.1.x86_64
pcmsi-i7-4790k:~ #

well it IS only installed once, so this is strange as such.

i remove the one existing version

pcmsi-i7-4790k:~ # rpm -ev wine-7.22-lp154.970.1.x86_64
Preparing packages...
wine-7.22-lp154.970.1.x86_64
pcmsi-i7-4790k:~ #

which works:

pcmsi-i7-4790k:~ # rpm -qa wine
wine-7.21-lp154.1505.2.x86_64
pcmsi-i7-4790k:~ #

now i want to also remove that version.

pcmsi-i7-4790k:~ # rpm -ev wine-7.21-lp154.1505.2.x86_64
error: package wine-7.21-lp154.1505.2.x86_64 is not installed
pcmsi-i7-4790k:~ # rpm -ev --justdb wine-7.21-lp154.1505.2.x86_64
error: package wine-7.21-lp154.1505.2.x86_64 is not installed
pcmsi-i7-4790k:~ #

? again check versions:

pcmsi-i7-4790k:~ # rpm -qa wine
wine-7.21-lp154.1505.2.x86_64
pcmsi-i7-4790k:~ #

what the heck is wrong here, how to get rid of that broken version?

Edit:
OpenSuSE Leap 15.4
RPM version 4.14.3

[obel1x]

solved it by running
rpmdb --rebuilddb
as written in docs. For me it was hard to find the right backup strategy, as some parts of https://rpm.org/user_doc/db_recovery.html would not work:

pcmsi-i7-4790k:/usr/lib/sysimage/rpm # /usr/lib/rpm/rpmdb_stat -CA
rpmdb_stat: DB_ENV->open: No such file or directory

Did not align with "output under the sections headed ‘Locks grouped by lockers’ and ‘Locks grouped by object’" as there is no such output. Maybe one could add what to do with that message?

[pmatilai]

Oh, that db_recovery stuff is only relevant for Berkeley DB backend, and in upstream configuration. On Suse, the BDB usage differs and you wouldn't see such messages (IIRC). Also 4.14 fell out of upstream support a couple of years ago already.

The db_recovery doc needs to be updated though.

[pmatilai]

So actually the db_recovery docs already separate BDB from the other cases, with instructions on how to tell which one is being used.

Support for BDB databases has been removed entirely in more recent rpm versions so there's nothing we can do about this now. And note that the "locks grouped by..." output comes from BDB utilities, not rpm.