Launchpad has imported 9 comments from the remote bug at https://bugzilla.redhat.com/show_bug.cgi?id=481189.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2009-01-22T17:04:46+00:00 Nicholas wrote: Description of problem: Yum fails with latest sqlite 3.6.10 in rawhide. Version-Release number of selected component (if applicable): yum-3.2.21-3 How reproducible: Always 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 self._getTs(needTsRemove) File "/usr/lib/python2.6/site-packages/yum/depsolve.py", line 101, in _getTs self._getTsInfo(remove_only) 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 self.repos.populateSack(which=repos) 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 self.repoid)) 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. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/0 ------------------------------------------------------------------------ On 2009-01-22T17:45:58+00:00 Tom wrote: It also "works for me" if I leave the new sqlite update but revert the new fedora-release. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/1 ------------------------------------------------------------------------ On 2009-01-22T19:01:19+00:00 James wrote: 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? Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/2 ------------------------------------------------------------------------ On 2009-01-22T19:02:38+00:00 James wrote: rpm -q if the yum list doesn't work. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/3 ------------------------------------------------------------------------ On 2009-01-22T19:11:07+00:00 Tom wrote: Uhhh.. No, I was mistaken. Sorry. Appears I had backed out both fedora-release and sqlite at the same time. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/4 ------------------------------------------------------------------------ On 2009-01-22T19:42:16+00:00 Panu wrote: This is sqlite bug alright, see http://www.mail-archive.com/sqlite-users@sqlite.org/msg39666.html My bad (insufficient testing), apologies. Will fix right away. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/5 ------------------------------------------------------------------------ On 2009-01-22T19:57:02+00:00 seth wrote: You're my hero. Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/6 ------------------------------------------------------------------------ On 2009-01-22T20:01:31+00:00 Panu wrote: 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 ;) Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/7 ------------------------------------------------------------------------ On 2009-01-22T20:05:47+00:00 seth wrote: We still love you, Panu. :) Reply at: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/comments/8 ** Changed in: sqlite (Fedora) Importance: Unknown => Critical -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to sqlite3 in Ubuntu. https://bugs.launchpad.net/bugs/375852 Title: sqllite doesn't support tables with names such as release or savepoint Status in sqlite3 package in Ubuntu: Fix Released Status in sqlite3 source package in Jaunty: Fix Released Status in sqlite package in Fedora: Fix Released Bug description: sqlite3 doesn't support tables with the names release or savepoint; this notably breaks yum. TESTCASE: cat <<EOF | sqlite3 CREATE TABLE savepoint(release); INSERT INTO savepoint(release) VALUES(10); UPDATE savepoint SET release = 5; SELECT release FROM savepoint; EOF fail: SQL error near line 1: near "savepoint": syntax error SQL error near line 2: near "savepoint": syntax error SQL error near line 3: near "savepoint": syntax error SQL error near line 4: near "release": syntax error passes: 5 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/375852/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp