Bug 697652

Summary: pkgtags.sqlite.gz download loop
Product: [Fedora] Fedora Reporter: Thibault Nélis <thib>
Component: gnome-packagekitAssignee: Richard Hughes <richard>
Status: CLOSED NOTABUG QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 14CC: richard
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-05-26 00:07:19 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Thibault Nélis 2011-04-18 20:44:40 UTC
Description of problem:
gpk-application (Add/Remove Software) loops for *minutes* while searching, displaying either "Starting" or "Querying" (seemingly unreliably) in the lower-left corner.

Analyzing network activity shows it *successfully* fetches pkgtags.sqlite.gz multiple times from many fedora-update repositories.  All HTTP mirrors seem to report the same Last-Modified date and the same Content-Length.  At one point I saw FTP traffic as well, I would assume they all answered MDTM/SIZE queries correctly too.

Workarounds include (a) disconnecting from the network before searching and reconnecting after the search (so it doesn't try to fetch the file) and (b) using yum directly.

Version-Release number of selected component (if applicable):
gnome-packagekit-2.32.0-2.fc14
PackageKit-0.6.12-2.fc14

How reproducible:
That's the thing;  right now I can reproduce it 100%, but some days I don't hit it at all.  I'm not sure if the behavior changes across reboots or strictly across time.

Steps to Reproduce:
1. Start gpk-application (System -> Administration -> Add/Remove Software)
2. Type anything in the search field
3. Click "find"
  
Actual results:
Either "Starting" (more common) or "Querying" (more rare) is displayed in the lower-left corner, and the program starts downloading the file endlessly behind the scene.  After a few minutes, the correct search results are finally displayed.

Expected results:
The correct search results should appear in a few seconds only, and the file should be downloaded only once, if necessary.

Additional info:
* Looks a bit like https://bugzilla.redhat.com/show_bug.cgi?id=678865, but I've never seen any error message.
* I've been encountering the bug for "quite some time" now (read "a few weeks").  I was unfortunately a bit busy and didn't take the time to investigate in time;  it *could* be connected to the PackageKit update of February 10th.
* Four copies of the file reside in my filesystem.  (I hit the bug a few minutes ago, so apparently only the compressed /var/cache version is touched but never written to / is left truncated.)

[thib@dhow ~]$ ll /var/{cache/yum,tmp/yum-thib-clPV6L}/x86_64/14/updates/pkgtags.sqlite*
-rw-r--r--. 1 root root 152576 Apr 14 19:19 /var/cache/yum/x86_64/14/updates/pkgtags.sqlite
-rw-r--r--. 1 root root      0 Apr 18 22:42 /var/cache/yum/x86_64/14/updates/pkgtags.sqlite.gz
-rw-r--r--. 1 thib thib 153600 Apr 18 22:22 /var/tmp/yum-thib-clPV6L/x86_64/14/updates/pkgtags.sqlite
-rw-r--r--. 1 thib thib  62653 Apr 17 22:59 /var/tmp/yum-thib-clPV6L/x86_64/14/updates/pkgtags.sqlite.gz

Thanks for your help;  tell me how I can be useful.

Comment 1 Thibault Nélis 2011-05-26 00:07:19 UTC
Like https://bugzilla.redhat.com/show_bug.cgi?id=678865;  didn't happen again for a long time now.