Bug 253430

Summary: repoquery crashes with sqlite3.OperationalError when used with --archlist
Product: [Fedora] Fedora Reporter: Thorsten Leemhuis <fedora>
Component: yumAssignee: Seth Vidal <skvidal>
Status: CLOSED UPSTREAM QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: low Docs Contact:
Priority: low    
Version: 7CC: tim.lauridsen
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2007-08-19 14:06:18 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Thorsten Leemhuis 2007-08-19 11:33:03 UTC
Description of problem:

On two of my up2date Fedora 7 machines some repoquery command stopped working:

# sudo repoquery --repoid=fedora -a --archlist 'noarch'
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
fedora                    100% |=========================| 2.1 kB    00:00     
Excluding Packages in global exclude list
Finished
Traceback (most recent call last):
  File "/usr/bin/repoquery", line 708, in <module>
    main(sys.argv)
  File "/usr/bin/repoquery", line 687, in main
    repoq.doSackSetup(archlist=archlist)
  File "/usr/lib/python2.5/site-packages/yum/__init__.py", line 344, in doSackSetup
    return self._getSacks(archlist=archlist, thisrepo=thisrepo)
  File "/usr/lib/python2.5/site-packages/yum/__init__.py", line 375, in _getSacks
    self._pkgSack.excludeArchs(archlist)
  File "/usr/lib/python2.5/site-packages/yum/packageSack.py", line 331, in
excludeArchs
    sack.excludeArchs(archlist)
  File "/usr/lib/python2.5/site-packages/yum/sqlitesack.py", line 725, in
excludeArchs
    executeSQL(cur, myq)
  File "/usr/lib/python2.5/site-packages/yum/sqlutils.py", line 146, in
executeSQLQmark
    return cursor.execute(query)
sqlite3.OperationalError: near ")": syntax error

Version-Release number of selected component (if applicable):
$ rpm -q yum yum-utils
yum-3.2.2-1.fc7
yum-utils-1.1.6-1.fc7

How reproducible:
Always

Steps to Reproduce:
1. sudo repoquery --repoid=fedora -a
-> works fine
2. sudo repoquery --repoid=fedora -a --archlist 'noarch'
-> fails (see above)
3. sudo repoquery --repoid=fedora-source -a --archlist="src
-> fails in a similar way
  
Additional info:
I noticed I got new yum and yum-utils package over the last few days on both the
machine where the error happens. The same commands that fail work fine on
another machine that still has yum-3.2.1-1.fc7 and yum-utils-1.1.5-1.fc7

All three testmachines are x86_64 (in case it matters).

Comment 1 Seth Vidal 2007-08-19 14:06:18 UTC
are you partially upgraded to rawhide?

maybe a sqlite update?

nevertheless this is fixed in GIT of yum - it'll be out in 3.2.3 which should be
soonish.


Comment 2 Thorsten Leemhuis 2007-08-19 14:46:51 UTC
(In reply to comment #1)
> are you partially upgraded to rawhide?

no

> maybe a sqlite update?

no
 
> nevertheless this is fixed in GIT of yum - it'll be out in 3.2.3 which should be
> soonish.

thx