I found something weird after trying to upgrade some RPM packages using YUM. The problem was hang by message as follow.

Setting up package sacks

It happened when I was running yum update since the repository had changed from CentOS 4.3 to CentOS 4.4. It seems this was a popular problem because I found a thread at CentOS board. The solution is also available to guide me through the step. Not exact one but useful.

The reason is version mismatch of SQLite and its python binding. In particular, SQLite 3.x.x is not compatible with SQLite 2.x.x so python-sqlite must be upgraded to match SQLite 3.x.x to make it work properly. Anyway, the dependency is not correct. If you have already hanged, you have to download python-sqlite 1.1.7 and install it via rpm manually.

rpm -Uvh python-sqlite-1.1.7-1.2.i386.rpm

If you are going to upgrade some packages, simply upgrade yum, sqlite, python-sqlite, python-urlgrabber and python-elementtree first.

yum update yum sqlite python-sqlite python-urlgrabber python-elementtree

So now you could upgrade as usual.

yum upgrade

Tags: centos, yum, rpm, sqlite, python