[Yum] yum on Centos 4.6 fails with invalid dependency on sqlite

[Yusuf Goolamabbas]

Hi, I am 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 -y 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

I have done yum -y clean all
                      yum clean metadata

but still get the same result


versions of various tools which I think are relevant


[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

[root at amd64 ~]# rpm -q rpm rpm-python yum python
rpm-4.3.3-23_nonptl
rpm-python-4.3.3-23_nonptl
yum-2.4.3-4.el4.centos
python-2.3.4-14.4.el4_6.1