Bug 1330723

Summary:	Uninstalling python-pyside package removes sqlite-libs package, which breaks Fedora completely
Product:	[Fedora] Fedora	Reporter:	Sam Thursfield <ssssam>
Component:	dnf	Assignee:	Packaging Maintenance Team <packaging-team-maint>
Status:	CLOSED DUPLICATE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	22	CC:	jsilhan, mluscon, mmraka, packaging-team-maint, pnemade, ssssam, vmukhame
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-04-27 07:56:09 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:

Description Sam Thursfield 2016-04-26 19:48:27 UTC

Steps to reproduce (which will break your system!):

sudo dnf install python-pyside
sudo dnf uninstall python-pyside


Note the output of the second command:

sudo dnf remove python-pyside Dependencies resolved.
================================================================================
 Package                  Arch        Version               Repository     Size
================================================================================
Removing:
 python-pyside            x86_64      1.2.2-2.fc22          @fedora        22 M
 python-pyside-devel      x86_64      1.2.2-2.fc22          @fedora       1.1 M
 sqlite-libs              x86_64      3.11.0-3.fc22         @updates      881 k

Transaction Summary
================================================================================
Remove  3 Packages

Installed size: 24 M
Is this ok [y/N]: n


Removing sqlite-libs made my computer pretty much unusable. Neither `dnf` nor `rpm` function when /usr/lib/sqlite3.so is missing, so I couldn't reinstall the package. Most web browsers also link against sqlite so I couldn't start a browser to go to koji and download the rpm manually. In the end I used lynx and rpm2cpio to reinstall the rpm.


I'm not sure what bugs are at work here; there may be more than one. The package manager really needs to have proper safeguards against removing its own dependencies, in any case.

Comment 1 Sam Thursfield 2016-04-26 20:01:25 UTC

Same issue for VLC:

sudo dnf remove vlc 
Dependencies resolved.
================================================================================
 Package         Arch       Version           Repository                   Size
================================================================================
Removing:
 libebml         x86_64     1.3.3-1.fc22      @updates                    233 k
 libmatroska     x86_64     1.4.4-1.fc22      @updates                    763 k
 sqlite-libs     x86_64     3.11.0-3.fc22     @updates                    881 k
 vlc             x86_64     2.2.2-1.fc22      @rpmfusion-free-updates     4.4 M
 vlc-core        x86_64     2.2.2-1.fc22      @rpmfusion-free-updates      47 M
 zvbi            x86_64     0.2.35-1.fc22     @updates                    1.3 M

Transaction Summary
================================================================================
Remove  6 Packages

Installed size: 55 M

Comment 2 Sam Thursfield 2016-04-27 06:26:25 UTC

This can be worked around with `dnf mark install sqlite-libs`

Comment 3 Michael Mráka 2016-04-27 07:27:09 UTC

Most likely there's another package installed which pretends it provides sqlite.

What's output of 
  rpm -q --whatprovides sqlite 'libsqlite3.so.0()(64bit)'
?

Comment 4 Sam Thursfield 2016-04-27 07:32:11 UTC

$ rpm -q --whatprovides sqlite "libsqlite3.so.0()(64bit)"
sqlite-3.11.0-3.fc22.x86_64
hipchat-2.2.1388-1.x86_64
sqlite-libs-3.11.0-3.fc22.x86_64


Thanks for the pointer! Seems the problem is the 3rd-party RPM provided for Atlassian Hipchat ... 


$ rpm -q -i hipchat
Name        : hipchat
Version     : 2.2.1388
Release     : 1
Architecture: x86_64
Install Date: Wed 30 Sep 2015 12:10:10 CEST
Group       : unknown
Size        : 147143192
License     : unknown
Signature   : RSA/SHA1, Tue 23 Jun 2015 18:45:03 CEST, Key ID aad4aa21729b5780
Source RPM  : hipchat-2.2.1388-1.src.rpm
Build Date  : Tue 23 Jun 2015 18:42:13 CEST
Build Host  : ip-172-30-215-103
Relocations : / 
Vendor      : Atlassian Inc
Summary     : Persistent group chat using XMPP.
Description :
DESCRIPTION
===========

This is an installer created using CPack (http://www.cmake.org). No additional installation instructions provided.


I'll try and report this to Atlassian Inc and link to this bug report. Is there a way DNF can guard against this sort of disaster in future?

Comment 5 Michael Mráka 2016-04-27 07:56:09 UTC


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