Red Hat Bugzilla – Bug 162010
Warning, could not load sqlite, falling back to pickle
Last modified: 2014-01-21 17:52:04 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; zh-CN; rv:1.7.8) Gecko/20050524 Fedora/1.0.4-4 Firefox/1.0.4
Description of problem:
When I invoke the yum, it always report this messages: "Warning, could not load sqlite, falling back to pickle"
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.invoke yum such as "update","search" and so on.
Actual Results: everything is ok except reports "Warning, could not load sqlite, falling back to pickle"
Expected Results: no such warning message be reported
I have sqlite-3.1.2-3 and python-sqlite-1.1.6-1 installed
rpm -ql python-sqlite
I bet it is for python 2.3, not python 2.4, hence the problem.
$ rpm -ql python-sqlite
okay that looks right.
then at the prompt type:
Python 2.4.1 (#1, May 16 2005, 15:19:29)
[GCC 4.0.0 20050512 (Red Hat 4.0.0-5)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite
Traceback (most recent call last):
File "<stdin>", line 1, in ?
line 1, in ?
ImportError: /usr/lib/python2.4/site-packages/_sqlite.so: undefined symbol:
rpm -V sqlite python-sqlite
and post the results, please.
rpm -V sqlite python-sqlite has no message be printed. echo $? is 0.
okay a few final things b/c this has got me boggled.
$ which python
$ python -V
$ which yum
you are welcome
okay - I'm beginning to say you're fibbing to me but can you run:
does that succeed?
sqlite3: symbol lookup error: sqlite3: undefined symbol: sqlite3_libversion
Tha't is the problem?
yes, that is the problem.
just for fun run this:
rpm -qa | grep sqlite
rpm -qi sqlite
$ rpm -qa|grep sqlite
$ rpm -qi sqlite
Name : sqlite Relocations: (not relocatable)
Version : 3.1.2 Vendor: Red Hat, Inc.
Release : 3 Build Date: Sun 10 Apr 2005 12:07:24
Install Date: Fri 13 May 2005 05:44:28 PM CST Build Host:
Group : Applications/Databases Source RPM: sqlite-3.1.2-3.src.rpm
Size : 379847 License: Public Domain
Signature : DSA/SHA1, Tue 26 Apr 2005 03:41:38 AM CST, Key ID da84cbd430c9ecf8
Packager : Red Hat, Inc. <http://bugzilla.redhat.com/bugzilla>
URL : http://www.sqlite.org/
Summary : Library that implements an embeddable SQL database engine
SQLite is a C library that implements an SQL database engine. A large
subset of SQL92 is supported. A complete database is stored in a
single disk file. The API is designed for convenience and ease of use.
Applications that link against SQLite can enjoy the power and
flexiblity of an SQL database without the administrative hassles of
supporting a separate database server. Version 2 and version 3 binaries
are named to permit each to be installed on a single host
remove the sqlite2 and sqlite2-devel packages.
see if the problem goes away.
no. I have removed the sqlite2 and sqlite2-devel, but the problem does't go away.
Your LD_LIBRARY_PATH isn't defined in some funky way, is it? You're not loading
your libraries or loading some old libraries, are you?
No, it isn't. No, I hava not do that.
Then you've got me stumped. I can't think of anything else to try other than
removing ALL of the associated parts and reinstalling them.
Heck if you want try that.
but right now I can neither replicate nor fix your problem.
I am sorry. I have found that I had installed a old sqlite3 in the
/usr/local/lib .... The sqlite3 linked to /usr/local/lib/libsqlite.so. Thank you
very very much!