[CentOS] yum fails with invalid dependency on sqlite

Tue Jan 29 23:07:55 UTC 2008
Yusuf Goolamabbas <yusufg at gmail.com>

Hi, I am using Centos 4.6 on x86-64. recently when I tried to do a yum -y
check-update this is the output I get

[root at amd64 ~]# yum check-update
Setting up repositories
update                    100% |=========================|  951 B    00:00
base                      100% |=========================| 1.1 kB    00:00
addons                    100% |=========================|  951 B    00:00
Reading repository metadata in from local files
primary.xml.gz            100% |=========================|  74 kB    00:01

(process:1999): GLib-CRITICAL **: file gtimer.c: line 106
(g_timer_stop): assertion `timer != NULL' failed

(process:1999): GLib-CRITICAL **: file gtimer.c: line 88
(g_timer_destroy): assertion `timer != NULL' failed
Traceback (most recent call last):
  File "/usr/bin/yum", line 29, in ?
    yummain.main(sys.argv[1:])
  File "/usr/share/yum-cli/yummain.py", line 97, in main
    result, resultmsgs = do()
  File "/usr/share/yum-cli/cli.py", line 534, in doCommands
    ypl = self.returnPkgLists()
  File "/usr/share/yum-cli/cli.py", line 1176, in returnPkgLists
    ypl = self.doPackageLists(pkgnarrow=pkgnarrow)
  File "__init__.py", line 904, in doPackageLists
  File "/usr/share/yum-cli/cli.py", line 75, in doRepoSetup
    self.doSackSetup(thisrepo=thisrepo)
  File "__init__.py", line 260, in doSackSetup
  File "repos.py", line 277, in populateSack
  File "/usr/lib64/python2.3/site-packages/sqlitecachec.py", line 40,
in getPrimary
    self.repoid))
TypeError: Can not create index on requires table: near "NOT": syntax error

This is the output of rpm -qa | grep sqlite

[root at amd64 ~]# rpm -qa | grep sqlite
python-sqlite-1.1.7-1.2.1
sqlite-3.3.6-2
sqlite-devel-3.3.6-2

any suggestions ?