Bug 481189 - Yum broken with new sqlite-3.6.10 in rawhide
Yum broken with new sqlite-3.6.10 in rawhide
Product: Fedora
Classification: Fedora
Component: sqlite (Show other bugs)
x86_64 Linux
low Severity urgent
: ---
: ---
Assigned To: Panu Matilainen
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2009-01-22 12:04 EST by Nicholas Wourms
Modified: 2014-01-21 18:07 EST (History)
7 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2009-01-22 15:01:31 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Nicholas Wourms 2009-01-22 12:04:46 EST
Description of problem:
Yum fails with latest sqlite 3.6.10 in rawhide.

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. Update to new sqlite.
2. Remove /var/cache/yum directory.
3. Run a yum update.
Actual results:
It fetches the primary dbs for all the repos and then returns the following error:
Error: malformed database schema (removals) - no such table: main.packages

Expected results:
Update without error.

Additional info:
Yum works as expected if you revert to the previous sqlite-3.6.7, so it is definitely some change in the sqlite api.

There is also an issue with local repositories created with createrepo. I had a local repository in my repos.d and it causes the following error:
localrepo                                                                                                                                                                                                             | 1.0 kB     00:00
localrepo/primary                                                                                                                                                                                                     |  27 kB     00:00

(process:5225): GLib-CRITICAL **: g_timer_stop: assertion `timer != NULL' failed

(process:5225): GLib-CRITICAL **: g_timer_destroy: assertion `timer != NULL' failed
Traceback (most recent call last):
  File "/usr/bin/yum", line 29, in <module>
    yummain.user_main(sys.argv[1:], exit_code=True)
  File "/usr/share/yum-cli/yummain.py", line 229, in user_main
    errcode = main(args)
  File "/usr/share/yum-cli/yummain.py", line 104, in main
    result, resultmsgs = base.doCommands()
  File "/usr/share/yum-cli/cli.py", line 339, in doCommands
  File "/usr/lib/python2.6/site-packages/yum/depsolve.py", line 101, in _getTs
  File "/usr/lib/python2.6/site-packages/yum/depsolve.py", line 112, in _getTsInfo
    pkgSack = self.pkgSack
  File "/usr/lib/python2.6/site-packages/yum/__init__.py", line 592, in <lambda>
    pkgSack = property(fget=lambda self: self._getSacks(),
  File "/usr/lib/python2.6/site-packages/yum/__init__.py", line 435, in _getSacks
  File "/usr/lib/python2.6/site-packages/yum/repos.py", line 251, in populateSack
    sack.populate(repo, mdtype, callback, cacheonly)
  File "/usr/lib/python2.6/site-packages/yum/yumRepo.py", line 184, in populate
    dobj = repo_cache_function(xml, csum)
  File "/usr/lib64/python2.6/site-packages/sqlitecachec.py", line 45, in getPrimary
TypeError: Can not create packages table: near "release": syntax error

Again, when I revert to the previous sqlite 3.6.7, yum works as expected.
Comment 1 Tom London 2009-01-22 12:45:58 EST
It also "works for me" if I leave the new sqlite update but revert the new fedora-release.
Comment 2 James Antill 2009-01-22 14:01:19 EST
Tom can you make sure that's true ... do a:

yum list sqlite yum fedora-release
sha1sum /var/cache/yum/rawhide/*

...both before and after?
Comment 3 James Antill 2009-01-22 14:02:38 EST
rpm -q if the yum list doesn't work.
Comment 4 Tom London 2009-01-22 14:11:07 EST

No, I was mistaken.  Sorry.

Appears I had backed out both fedora-release and sqlite at the same time.
Comment 5 Panu Matilainen 2009-01-22 14:42:16 EST
This is sqlite bug alright, see

My bad (insufficient testing), apologies. Will fix right away.
Comment 6 seth vidal 2009-01-22 14:57:02 EST
You're my hero.
Comment 7 Panu Matilainen 2009-01-22 15:01:31 EST
Fixed in sqlite-3.6.10-2.fc11.

If I hadn't put out a broken version, there wouldn't have be anything to fix and I wouldn't get called anybody's hero. Wonder what the morale of this is ;)
Comment 8 seth vidal 2009-01-22 15:05:47 EST
We still love you, Panu. :)

Note You need to log in before you can comment on or make changes to this bug.