Bug 1188455
| Summary: | packageKit -- Software can not be installed after several ones are installed - Install and update blank | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Murray <murrayweiser> | ||||||
| Component: | PackageKit | Assignee: | Richard Hughes <rhughes> | ||||||
| Status: | CLOSED EOL | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 22 | CC: | agajan, Alessio.AguirrePimentel, andrea.abaterusso, argento3k, dragomir.dan, jonathan, jshubin, kalevlember, miminar, murrayweiser, ossman, qguo, rdieter, rhughes, smparrish, tom, will | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | i686 | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2016-07-19 18:52:06 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
Murray
2015-02-02 23:56:23 UTC
Info requested in email from Adam Williamson author of this: http://fedoramagazine.org/special-update-information-for-fedora-21-users-packagekit-errors/ I have the same problem in Linux ivyOne.labs 3.18.5-201.fc21.x86_64 #1 SMP Mon Feb 2 21:00:58 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux packagekit.service status say: Feb 07 11:30:20 ivyOne.labs packagekitd[14892]: Failed to load the backend: Failed to execute statement 'CREATE TABLE transactions (transaction_id TEXT PRIMARY KEY,timespec TEXT,duration INTEGER,succeeded INTEGER DEFAULT 0,role TEXT,data TEXT,description TEXT,uid INTEGER DEFAULT 0,cmdline TEXT);': table transactions already exists Feb 07 11:30:59 ivyOne.labs PackageKit[14949]: daemon start Feb 07 11:31:00 ivyOne.labs PackageKit[14949]: daemon quit Feb 07 11:31:00 ivyOne.labs packagekitd[14949]: Failed to load the backend: Failed to execute statement 'CREATE TABLE transactions (transaction_id TEXT PRIMARY KEY,timespec TEXT,duration INTEGER,succeeded INTEGER DEFAULT 0,role TEXT,data TEXT,description TEXT,uid INTEGER DEFAULT 0,cmdline TEXT);': table transactions already exists Feb 07 11:31:35 ivyOne.labs PackageKit[14994]: daemon start Feb 07 11:31:35 ivyOne.labs PackageKit[14994]: daemon quit Feb 07 11:31:35 ivyOne.labs packagekitd[14994]: Failed to load the backend: Failed to execute statement 'CREATE TABLE transactions (transaction_id TEXT PRIMARY KEY,timespec TEXT,duration INTEGER,succeeded INTEGER DEFAULT 0,role TEXT,data TEXT,description TEXT,uid INTEGER DEFAULT 0,cmdline TEXT);': table transactions already exists Feb 07 11:44:35 ivyOne.labs PackageKit[15378]: daemon start Feb 07 11:44:35 ivyOne.labs PackageKit[15378]: daemon quit Feb 07 11:44:35 ivyOne.labs packagekitd[15378]: Failed to load the backend: Failed to execute statement 'CREATE TABLE transactions (transaction_id TEXT PRIMARY KEY,timespec TEXT,duration INTEGER,succeeded INTEGER DEFAULT 0,role TEXT,data TEXT,description TEXT,uid INTEGER DEFAULT 0,cmdline TEXT);': table transactions already exists This happened to me as well. This worked for me: * sudo rm /var/lib/PackageKit/*.db * sudo systemctl restart packagekit.service * sudo pkcon repair I'm not really sure this is the right thing to do. But, it did make gnome-software start working again. *** Bug 1191540 has been marked as a duplicate of this bug. *** I tried deleting the files /var/lib/PackageKit/*.db as suggested by Tom Tromey, and it worked. Same thing here: Mar 23 14:55:26 ossman.lkpg.cendio.se gnome-session[2056]: (org.gnome.Software:2512): GLib-GObject-CRITICAL **: g_object_ref: assertion 'G_IS_OBJECT (object)' failed Mar 23 14:55:26 ossman.lkpg.cendio.se dbus[765]: [system] Activating via systemd: service name='org.freedesktop.PackageKit' unit='packagekit.service' Mar 23 14:55:26 ossman.lkpg.cendio.se PackageKit[17216]: daemon start Mar 23 14:55:26 ossman.lkpg.cendio.se PackageKit[17216]: daemon quit Mar 23 14:55:26 ossman.lkpg.cendio.se packagekitd[17216]: Failed to load the backend: Failed to execute statement 'CREATE TABLE transactions (transaction_id TEXT PRIMARY KEY,timespec TEXT,duration INTEGER,succeeded INTEGER DEFAULT 0,role TEXT,data TEXT,description TEXT,uid INTEGER DEFAULT 0,cmdline TEXT);': table transactions already exists Mar 23 14:55:51 ossman.lkpg.cendio.se dbus[765]: [system] Failed to activate service 'org.freedesktop.PackageKit': timed out Mar 23 14:55:51 ossman.lkpg.cendio.se gnome-session[2056]: (org.gnome.Software:2512): Gs-WARNING **: Not already a started task for 0x2a7b8f0~packagekit-refresh::transaction Mar 23 14:55:51 ossman.lkpg.cendio.se gnome-session[2056]: (org.gnome.Software:2512): Gs-WARNING **: failed to convert to GsApp: Error calling StartServiceByName for org.freedesktop.PackageKit: GDBus.Error:org.freedesktop.DBus.Error.TimedOut: Activation of org.freedesktop.PackageKit timed out I've saved the old db files if you want to have a look at them. Just let me know. Can you attach the old DB files to this ticket, please, if you still have them? Thanks! Created attachment 1036723 [details]
broken database
(In reply to Tom Tromey from comment #3) > This happened to me as well. > > This worked for me: > > * sudo rm /var/lib/PackageKit/*.db > * sudo systemctl restart packagekit.service > * sudo pkcon repair > I can confirm I have this issue on two different Fedora machines, one F21, one F22. The above commands also fixed the issue. The only relevant thing that the two machines have in common (AFAIK) is that they both were upgrades from previous Fedora versions as opposed to clean installs. HTH I get error "Error calling StartServiceByName for org.freedesktop.PackageKit: Timeout was reached" I tried the following, as suggested: # su - # rm /var/lib/PackageKit/*.db rm: cannot remove ‘/var/lib/PackageKit/*.db’: No such file or directory # systemctl restart packagekit.service Job for packagekit.service failed. See "systemctl status packagekit.service" and "journalctl -xe" for details. # pkcon repair Failed to contact PackageKit: Error calling StartServiceByName for org.freedesktop.PackageKit: Timeout was reached I am also seeing this in Fedora 23. It happened on a clean install after trying to install Chrome. First the Software Center got stuck with Chrome installing at about 75%. After a restart the whole Software Center was unusable: no apps were loading and trying to install other packages (e.g. Flash) from the interface failed with a timeout on the PackageKit service. Installing packages from the command line with dnf was not affected. Running the commands suggested in comment #3 worked and I was able to install other packages from the interface (tested with Flash). Fedora 22 changed to end-of-life (EOL) status on 2016-07-19. Fedora 22 is no longer maintained, which means that it will not receive any further security or bug fix updates. As a result we are closing this bug. If you can reproduce this bug against a currently maintained version of Fedora please feel free to reopen this bug against that version. If you are unable to reopen this bug, please file a new report against the current release. If you experience problems, please add a comment to this bug. Thank you for reporting this bug and we are sorry it could not be fixed. |