Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension

[Tom Parker]

Package: sqlite3
Version: 3.5.6-3
Severity: grave

***@scrumpy:[~] sqlite3
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> quit;
sqlite3: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension

Also, if you give a db on the command line

***@scrumpy:[~/shared/movies/epgrabber] sqlite3 watch.db
sqlite3: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension

which makes it basically unusable. Upgrading the sqlite3 package will
probably fix this (as libsqlite3-0 is on 3.5.7-2 and this is at
3.5.6-2), but it should have had a tighter dependancy.

-- System Information:
Debian Release: lenny/sid
APT prefers stable
APT policy: (500, 'stable'), (104, 'experimental'), (103, 'unstable'), (102, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.24-1-686 (SMP w/1 CPU core)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash

Versions of packages sqlite3 depends on:
ii libc6 2.7-9 GNU C Library: Shared libraries
ii libreadline5 5.2-3 GNU readline and history libraries
ii libsqlite3-0 3.5.7-2 SQLite 3 shared library

sqlite3 recommends no packages.

-- no debconf information

[Julien Cristau]

severity 478337 serious
kthxbye

package libsqlite3-0
severity 478337 important
thanks
Hi Tom,

Post by Tom Parker
Package: sqlite3
Version: 3.5.6-3
Severity: grave
SQLite version 3.5.7

You mix lib and binary package versions, that's one source of your
problems. As I see, your libsqlite3-0 package is version 3.5.7-2 but the
binary is version 3.5.6-3 . Please do upgrade it and retest. I do expect
that your problems will disappear.

WTF? A library isn't allowed to drop symbols without changing SONAME.
This symbol is exported by libsqlite3.so.0 in etch and used by sqlite3,
and the dependencies of sqlite3 don't prevent you from upgrading the lib
without upgrading sqlite3 itself, which means your package is broken.

Cheers,
Julien

[Debian Bug Tracking System]

Post by Julien Cristau
severity 478337 serious

Bug#478337: libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped)
Severity set to `serious' from `important'

Post by Julien Cristau
kthxbye

Stopping processing here.

Please contact me if you need assistance.

Debian bug tracking system administrator
(administrator, Debian Bugs database)

[Laszlo Boszormenyi]

Hi Julien,

Post by Julien Cristau
severity 478337 serious
kthxbye

It's still only important, read on.

Post by Julien Cristau

You mix lib and binary package versions, that's one source of your
problems. As I see, your libsqlite3-0 package is version 3.5.7-2 but the
binary is version 3.5.6-3 . Please do upgrade it and retest. I do expect
that your problems will disappear.

WTF? A library isn't allowed to drop symbols without changing SONAME.
This symbol is exported by libsqlite3.so.0 in etch and used by sqlite3,
and the dependencies of sqlite3 don't prevent you from upgrading the lib
without upgrading sqlite3 itself, which means your package is broken.

I'm a DD as well and I know the rules. Still, SQLite3 extensions was
not enable by upstream but me. As version 3.5.7 restructured the source
a bit I missed to enable it in that version as well. I have corrected
this in version 3.5.8-1, so the bug reported is only temporary until
3.5.8-1 reaches Lenny and can be easily corrected with upgrading sqlite3
binary to the same version as the library package. Read: the sqlite3
binary package does not need extensions to function properly, extensions
support is optional and re-enabled in 3.5.8-1.

Regards,
Laszlo/GCS

[Florian Weimer]

$ objdump -T /usr/lib/libsqlite3.so.0|grep -c sqlite3_enable_load_extension
0

% lib-compare.sh libsqlite3-0_3.5.6-3_i386.deb libsqlite3-0_3.5.8-1_i386.deb pts/13 [18:50]
./usr/lib/libsqlite3.so.0.8.6
--- /tmp/adeodato/tmp.ourGU28796 2008-04-29 18:48:12.000000000 +0200
+++ /tmp/adeodato/tmp.aORRO28797 2008-04-29 18:48:12.000000000 +0200
-B sqlite3_io_trace
-D sqlite3_apis
-R sqlite3IsAsciiIdChar
-R sqlite3UpperToLower
-R sqlite3one
-T sqlite3AddCheckConstraint

Anything that doesn't start with sqlite3_* isn't part of the public API,
so it's okay to remove that.

However, sqlite3_enable_load_extension is indeed missing in version
3.5.8-1.

[Debian Bug Tracking System]

Your message dated Wed, 30 Apr 2008 21:18:48 +0000
with message-id <E1JrJhQ-0006cw-***@ries.debian.org>
and subject line Bug#478337: fixed in sqlite3 3.5.8-2
has caused the Debian Bug report #478337,
regarding libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped)
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ***@bugs.debian.org
immediately.)