Bug 1348653

Summary: dnf removes sqlite
Product: [Fedora] Fedora Reporter: Wolfram Wagner <wolfram>
Component: dnfAssignee: Packaging Maintenance Team <packaging-team-maint>
Status: CLOSED DUPLICATE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 23CC: jsilhan, mluscon, mmraka, packaging-team-maint, pnemade, vmukhame
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-06-23 14:31:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
The incident and the struggles to reinstall it after I copied the so file from the cdrom system into the sysimage none

Description Wolfram Wagner 2016-06-21 16:31:26 UTC
Created attachment 1170335 [details]
The incident and the struggles to reinstall it after I copied the so file from the cdrom system into the sysimage

Description of problem:
I almost destroyed my installation by issuing:
dnf remove plasma-desktop 
This command removed the packages sqlite-libs and libidn. When I saw the removal happen, I wondered if this lib is really not needed anymore.
Right. Neither dnf nor firefox, nor rpm does work, if sqlite lib is missing.

Date of problem: 11.6.
Version-Release number of selected component (if applicable):
plasma-desktop.x86_64 5.6.4-1.fc23
sqlite-libs.x86_64 3.11.0-3.fc23
libidn.x86_64 1.32-1.fc23

How reproducible:
WARNING! DONT CONFIRM!


Steps to Reproduce:
1. Install plasma desktop
2. dnf remove plasma-desktop 

Expected results:
Please add sqlite to the list of protected packages. Or check, why it could be removed!
The system is not booting anymore, without the rpm

Additional info:
Fix: 
Boot via recent fedora rescue (live) disk, 
mount sysimage read-write, 
copy the /usr/lib64/libsqlite3.so.0 from the cdrom system to your sysimage
reboot
dnf install sqlite-libs

Attached my struggling to get a functional system back.

Comment 1 Michael Mráka 2016-06-22 14:49:46 UTC
Most likely there's another package on your system providing libsqlite3.so.
What's the output of
rpm -q --whatprovides 'libsqlite3.so.0()(64bit)' ?

Comment 2 Wolfram Wagner 2016-06-22 16:27:52 UTC
There are really two rpms:

plexmediaserver-0.9.16.6.1993-5089475.x86_64
sqlite-libs-3.11.0-3.fc23.x86_64

locate libsqlite3.so 
delivers:
/usr/lib/libsqlite3.so.0
/usr/lib/libsqlite3.so.0.8.6
/usr/lib/plexmediaserver/libsqlite3.so.0
/usr/lib64/libsqlite3.so.0
/usr/lib64/libsqlite3.so.0.8.6

rpm -ql plexmediaserver-0.9.16.6.1993-5089475.x86_64 | grep libsql
/usr/lib/plexmediaserver/libsqlite3.so.0

rpm -ql sqlite-libs-3.11.0-3.fc23.x86_64 | grep libsql
/usr/lib64/libsqlite3.so.0
/usr/lib64/libsqlite3.so.0.8.6

I guess the plex lib is not accessible from any other application?
Does this help?

Comment 3 Michael Mráka 2016-06-23 14:31:11 UTC
> I guess the plex lib is not accessible from any other application?

Correct, that's the issue. Plexmediaserver provides sqlite lib so dnf choose to remove the other version. But other application can't use that library because it isn't in standard library path.

*** This bug has been marked as a duplicate of bug 1338921 ***