See upstream ticket http://www.sqlite.org/cvstrac/chngview?cn=6186
** Also affects: sqlite3 (Ubuntu Jaunty)
Importance: Undecided
Status: New
** Changed in: sqlite3 (Ubuntu Jaunty)
Importance: Undecided => Medium
** Changed in: sqlite3 (Ubuntu Jaunty)
Status: New => Triaged
** Changed in: sqlite3 (Ubuntu Jaunty)
Milestone: None => jaunty-updates
** Changed in: sqlite3 (Ubuntu Jaunty)
Assignee: (unassigned) => Loïc Minier (lool)
** Summary changed:
- Cannot work with actual yum repo
+ sqllite doesn't support tables with names such as release or savepoint
** Description changed:
- Binary package hint: yum
+ sqlite3 doesn't support tables with the names release or savepoint; this
+ notably breaks yum.
- yum(3.2.21, the latest) can be installed and can even run. But after I add
actual repos to its config, and run yum to cache them, it will encounter some
fatal error and quit.
- e.g.:
- 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 343, in doCommands
- return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd,
self.extcmds)
- File "/usr/share/yum-cli/yumcommands.py", line 758, in doCommand
- base.repos.populateSack()
- File "/var/lib/python-support/python2.6/yum/repos.py", line 251, in
populateSack
- sack.populate(repo, mdtype, callback, cacheonly)
- File "/var/lib/python-support/python2.6/yum/yumRepo.py", line 184, in
populate
- dobj = repo_cache_function(xml, csum)
- File "/var/lib/python-support/python2.6/sqlitecachec.py", line 42, in
getPrimary
- self.repoid))
- TypeError: Can not create packages table: near "release": syntax error
+ TESTCASE:
+ cat <<EOF | sqlite3
+ CREATE TABLE savepoint(release);
+ INSERT INTO savepoint(release) VALUES(10);
+ UPDATE savepoint SET release = 5;
+ SELECT release FROM savepoint;
+ EOF
- or with other repos, 'yum makecache' can work, but when run other yum
commands, it will show:
- Error: malformed database schema (removals) - no such table: main.packages
+ 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
- I have traced this problem myself, and found it's compatibility problem
- of yum, python's sqlite module, sqlite, etc.
+ passes:
+ 5
--
sqllite doesn't support tables with names such as release or savepoint
https://bugs.launchpad.net/bugs/375852
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
