[CentOS] yum fails with invalid dependency on sqlite

[Yusuf Goolamabbas]

> 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 ?

> Check yum version and yum-metadata-parser version.

[root at amd64 ~]# rpm -qa | grep yum
yum-metadata-parser-1.0-8.el4.centos
yum-2.4.3-4.el4.centos

This machine was update from 4.5 to 4.6 and I can't recollect if this
happened right after the update

I also came across this bug in the CentOS bug list

http://bugs.centos.org/view.php?id=2611