Bug 310870 - Unknown error when refreshing list of available actualizations
Summary: Unknown error when refreshing list of available actualizations
Status: RESOLVED FIXED
Alias: None
Product: apper
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Ubuntu Linux
: NOR major
Target Milestone: ---
Assignee: Daniel Nicoletti
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-11-29 12:24 UTC by karaluh
Modified: 2013-01-10 13:41 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
Screenshot of the error message (15.17 KB, image/png)
2012-11-29 13:22 UTC, karaluh
Details
Corrupted database (87.77 KB, application/zip)
2012-11-30 07:05 UTC, karaluh
Details

Note You need to log in before you can comment on or make changes to this bug.
Description karaluh 2012-11-29 12:24:04 UTC
As in summary, when i click the button to refresh the list, error message appears. Also, I'm unable to find any software to install, the list is empty no matter what I type in the filter box.

Reproducible: Always
Comment 1 Daniel Nicoletti 2012-11-29 13:02:07 UTC
Do you have packagekit, packagekit-backend-aptcc installed?
Can you upload an screenshot of the error?
Comment 2 karaluh 2012-11-29 13:22:13 UTC
Created attachment 75533 [details]
Screenshot of the error message
Comment 3 karaluh 2012-11-29 13:22:38 UTC
(In reply to comment #1)
> Do you have packagekit, packagekit-backend-aptcc installed?

Yes.

> Can you upload an screenshot of the error?

Attached.
Comment 4 Daniel Nicoletti 2012-11-29 13:43:25 UTC
Ok, that wans't helpfull :P

Can you run:
sudo /usr/lib/packagekit/packagekitd --verbose
then try to open Apper and paste here the output of the above app.
Thanks.
Comment 5 karaluh 2012-11-29 14:10:03 UTC
(In reply to comment #4)
> Ok, that wans't helpfull :P

Don't expect anything else from unknown errors :)

> Can you run:
> sudo /usr/lib/packagekit/packagekitd --verbose
> then try to open Apper and paste here the output of the above app.
> Thanks.

15:04:45        PackageKit          Verbose debugging enabled (on console 1)
15:04:45        PackageKit          keep_environment: 0                                                                                                                                                              

15:04:45        PackageKit          using config file '/etc/PackageKit/PackageKit.conf'                                                                                                                              
15:04:45        PackageKit          syslog fucntionality disabled                                                                                                                                                    
15:04:45        PackageKit          Log all transactions: 1                                                                                                                                                          
15:04:45        PackageKit          daemon shutdown set to 300 seconds                                                                                                                                               
15:04:45        PackageKit          using default backend aptcc                                                                                                                                                      
15:04:45        PackageKit          Trying to load : aptcc                                                                                                                                                           
15:04:45        PackageKit          dlopening '/usr/lib/i386-linux-gnu/packagekit-backend/libpk_backend_aptcc.so'                                                                                                    
15:04:45        PackageKit          clearing download cache at /var/cache/PackageKit/downloads                                                                                                                       
15:04:45        PackageKit          destination eth1 is valid                                                                                                                                                        
15:04:45        PackageKit          setting config file watch on /etc/PackageKit/PackageKit.conf                                                                                                                     
15:04:45        PackageKit          ProxyHTTP read error: Plik klucza nie zawiera klucza "ProxyHTTP"                                                                                                                 
15:04:45        PackageKit          ProxyHTTPS read error: Plik klucza nie zawiera klucza "ProxyHTTPS"                                                                                                               
15:04:45        PackageKit          ProxyFTP read error: Plik klucza nie zawiera klucza "ProxyFTP"                                                                                                                   
15:04:45        PackageKit          ProxySOCKS read error: Plik klucza nie zawiera klucza "ProxySOCKS"                                                                                                               
15:04:45        PackageKit          NoProxy read error: Plik klucza nie zawiera klucza "NoProxy"                                                                                                                     
15:04:45        PackageKit          PAC read error: Plik klucza nie zawiera klucza "PAC"                                                                                                                             
15:04:45        PackageKit          install root now /                                                                                                                                                               
15:04:45        PackageKit          searching for plugins in /usr/lib/i386-linux-gnu/packagekit-plugins                                                                                                              
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin_scripts.so: Runs external scrips                                                                           
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk-plugin-clear-firmware-requests.so: Clears firmware requests                                                       
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-update-check-processes.so: Checks for running processes during update for session restarts                 
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-no-update-process.so: Updates the package lists after refresh                                              
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-scan-desktop-files.so: Scans desktop files on refresh and adds them to a database                          
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-check-shared-libraries-in-use.so: checks for any shared libraries in use after a security update           
15:04:45        PackageKit          opened plugin /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-update-package-list.so: Updates the package lists after refresh                                            
15:04:45        PackageKit          trying to open database '/var/lib/PackageKit/transactions.db'                                                                                                                    
15:04:45        PackageKit          creating table to repair: database disk image is malformed                                                                                                                       
15:04:45        PackageKit          altering table to repair: database disk image is malformed                                                                                                                       
15:04:45        PackageKit          adding last action details: database disk image is malformed                                                                                                                     
15:04:45        PackageKit          adding config: database disk image is malformed                                                                                                                                  
15:04:45        PackageKit          adding table proxy: database disk image is malformed                                                                                                                             
15:04:45        PackageKit          altering table to repair: database disk image is malformed                                                                                                                       
15:04:45        PackageKit          adding table root: database disk image is malformed                                                                                                                              
15:04:45        PackageKit          run pk_plugin_initialize on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-update-check-processes.so                                                                    
15:04:45        PackageKit          run pk_plugin_initialize on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-no-update-process.so                                                                         
15:04:45        PackageKit          run pk_plugin_initialize on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-scan-desktop-files.so                                                                        
15:04:45        PackageKit          run pk_plugin_initialize on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-check-shared-libraries-in-use.so                                                             
15:04:45        PackageKit          run pk_plugin_initialize on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-update-package-list.so                                                                       
15:04:45        PackageKit          notify::connected                                                                                                                                                                
15:04:45        PackageKit          notify::connected                                                                                                                                                                
15:04:45        PackageKit          notify::connected                                                                                                                                                                
15:04:45        PackageKit          PkEngine: acquired name: org.freedesktop.PackageKit                                                                                                                              
15:04:50        PackageKit          idle is 4                                                                                                                                                                        
15:04:55        PackageKit          idle is 9                                                                                                                                                                        
15:05:00        PackageKit          idle is 14                                                                                                                                                                       
15:05:05        PackageKit          idle is 3                                                                                                                                                                        
15:05:10        PackageKit          idle is 8                                                                                                                                                                        
15:05:15        PackageKit          idle is 13                                                                                                                                                                       
15:05:20        PackageKit          idle is 18                                                                                                                                                                       
15:05:20        PackageKit          GetTid method called                                                                                                                                                             
15:05:20        PackageKit          job count now 1                                                                                                                                                                  
15:05:20        PackageKit          deferring low priority write until idle                                                                                                                                          
15:05:20        PackageKit          trying to open database '/var/lib/PackageKit/transactions.db'                                                                                                                    
15:05:20        PackageKit          creating table to repair: database disk image is malformed                                                                                                                       
15:05:20        PackageKit          altering table to repair: database disk image is malformed                                                                                                                       
15:05:20        PackageKit          adding last action details: database disk image is malformed                                                                                                                     
15:05:20        PackageKit          adding config: database disk image is malformed                                                                                                                                  
15:05:20        PackageKit          adding table proxy: database disk image is malformed                                                                                                                             
15:05:20        PackageKit          altering table to repair: database disk image is malformed                                                                                                                       
15:05:20        PackageKit          adding table root: database disk image is malformed                                                                                                                              
15:05:20        PackageKit          transaction now new                                                                                                                                                              
15:05:20        PackageKit          setting sender to :1.147                                                                                                                                                         
15:05:20        PackageKit          uid=1000, count=0                                                                                                                                                                
15:05:20        PackageKit          adding transaction 0x9e9a000, item 0x9e993a0                                                                                                                                     
15:05:20        PackageKit          sending tid: '/1_acbdbcad_data'                                                                                                                                                  
15:05:20        PackageKit          SetHints method called: locale=pl.UTF-8                                                                                                                                          
15:05:20        PackageKit          GetUpdates method called                                                                                                                                                         
15:05:20        PackageKit          marking transaction /1_acbdbcad_data as committed                                                                                                                                
15:05:20        PackageKit          transaction now committed                                                                                                                                                        
15:05:20        PackageKit          transaction now ready                                                                                                                                                            
15:05:20        PackageKit          emitting changed
15:05:20        PackageKit          emitting ::changed
15:05:20        PackageKit          emitting transaction-list-changed
15:05:20        PackageKit          1 transactions in list, 1 committed but not finished
15:05:20        PackageKit          running /1_acbdbcad_data as no others in progress
15:05:20        PackageKit          schedule idle running /1_acbdbcad_data
15:05:20        PackageKit          transaction now running
15:05:20        PackageKit          GetTid method called
15:05:20        PackageKit          job count now 2
15:05:20        PackageKit          trying to open database '/var/lib/PackageKit/transactions.db'
15:05:20        PackageKit          creating table to repair: database disk image is malformed
15:05:20        PackageKit          altering table to repair: database disk image is malformed
15:05:20        PackageKit          adding last action details: database disk image is malformed
15:05:20        PackageKit          adding config: database disk image is malformed
15:05:20        PackageKit          adding table proxy: database disk image is malformed
15:05:20        PackageKit          altering table to repair: database disk image is malformed
15:05:20        PackageKit          adding table root: database disk image is malformed
15:05:20        PackageKit          transaction now new
15:05:20        PackageKit          setting sender to :1.147
15:05:20        PackageKit          uid=1000, count=1
15:05:20        PackageKit          adding transaction 0x9e9a160, item 0x9eaba30
15:05:20        PackageKit          sending tid: '/2_caebbeba_data'
15:05:20        PackageKit          actually running /1_acbdbcad_data
15:05:20        PackageKit          setting backend tid as /1_acbdbcad_data
15:05:20        PackageKit          locale changed to pl.UTF-8
15:05:20        PackageKit          frontend_socket changed to (null)
15:05:20        PackageKit          SQL error: database disk image is malformed

15:05:20        PackageKit          failed to set the session state (non-fatal): failed to get the proxy from the database
15:05:20        PackageKit          emitting changed
15:05:20        PackageKit          run pk_plugin_transaction_run on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin_scripts.so
15:05:20        PackageKit          run pk_plugin_transaction_run on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-no-update-process.so
15:05:20        PackageKit          run pk_plugin_transaction_run on /usr/lib/i386-linux-gnu/packagekit-plugins/libpk_plugin-check-shared-libraries-in-use.so
15:05:20        PackageKit          setting transaction role to get-updates
15:05:20        PackageKit          setting role to get-updates
15:05:20        PackageKit          setting role for /1_acbdbcad_data to get-updates
15:05:20        PackageKit          no plugins provided pk_plugin_transaction_started
15:05:20        PackageKit          emitting changed
15:05:20        PackageKit          setting role to get-updates
15:05:20        PackageKit          saving 2 for filters
15:05:20        PackageKit          no transaction reset vfunc
15:05:20        PackageKit          saving 1 for getUpdates
15:05:20        PackageKit  15:05:20    PackageKit          SetHints method called: locale=pl.UTF-8
15:05:20        PackageKit          GetDistroUpgrades method called
15:05:20        PackageKit          marking transaction /2_caebbeba_data as committed
15:05:20        PackageKit          transaction now committed
15:05:20        PackageKit          transaction now ready
        no transaction start vfunc
15:05:20        PackageKit          emitting allow-cancel 1
15:05:20        PackageKit          emitting changed
15:05:20        PackageKit          emitting ::changed
15:05:20        PackageKit          emitting transaction-list-changed
15:05:20        PackageKit          2 transactions in list, 2 committed but not finished
15:05:20        PackageKit          doing deferred write syncronous

(packagekitd:24635): PackageKit-ERROR **: failed to set job id: database disk image is malformed
Comment 6 Daniel Nicoletti 2012-11-29 14:13:19 UTC
Ok, it's a PackageKit bug, I'm forwarding to the list since I never saw it.
Thanks for the info so far.
Comment 7 Daniel Nicoletti 2012-11-29 15:00:59 UTC
Can you please attach the file here:
/var/lib/PackageKit/transactions.db

After that remove this file and see if it fixes your problem.
Comment 8 karaluh 2012-11-30 07:05:52 UTC
Created attachment 75542 [details]
Corrupted database
Comment 9 karaluh 2012-11-30 07:08:02 UTC
(In reply to comment #7)
> Can you please attach the file here:
> /var/lib/PackageKit/transactions.db
> 
> After that remove this file and see if it fixes your problem.

Unfortunately it doesn't. Should I restart some services or something?
Comment 10 Daniel Nicoletti 2013-01-09 17:57:29 UTC
Even after removing do you have the issue?
Comment 11 karaluh 2013-01-10 07:10:57 UTC
(In reply to comment #10)
> Even after removing do you have the issue?

I just tried it one more time to be sure and the workaround works. I probably... misdeleted it previously.