[Bug 375852] Re: sqllite doesn't support tables with names such as release or savepoint

Fri Oct 27 00:08:45 UTC 2017

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
Foundations Bugs, 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