Processed: Re: Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
Processing commands for [EMAIL PROTECTED]: severity 478337 serious Bug#478337: libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped) Severity set to `serious' from `important' kthxbye Stopping processing here. Please contact me if you need assistance. Debian bug tracking system administrator (administrator, Debian Bugs database) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
severity 478337 serious kthxbye On Tue, Apr 29, 2008 at 07:21:28 +0200, Laszlo Boszormenyi wrote: package libsqlite3-0 severity 478337 important thanks Hi Tom, On Mon, 2008-04-28 at 21:26 +0100, Tom Parker wrote: Package: sqlite3 Version: 3.5.6-3 Severity: grave [EMAIL PROTECTED]:[~] sqlite3 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
Hi Julien, On Tue, 2008-04-29 at 13:42 +0200, Julien Cristau wrote: severity 478337 serious kthxbye It's still only important, read on. On Tue, Apr 29, 2008 at 07:21:28 +0200, Laszlo Boszormenyi wrote: 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
On Tue, Apr 29, 2008 at 18:07:43 +0200, Laszlo Boszormenyi wrote: Hi Julien, On Tue, 2008-04-29 at 13:42 +0200, Julien Cristau wrote: severity 478337 serious kthxbye It's still only important, read on. Not as far as I can tell. On Tue, Apr 29, 2008 at 07:21:28 +0200, Laszlo Boszormenyi wrote: 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. Package: libsqlite3-0 Status: install ok installed Architecture: i386 Source: sqlite3 Version: 3.5.8-1 $ objdump -T /usr/lib/libsqlite3.so.0|grep -c sqlite3_enable_load_extension 0 I'm not sure what you're saying, but that symbol is still missing from the lib, and the SONAME is still the same as in etch. Upgrading the sqlite3 binary package to the same version as the lib is not a fix. Either change the SONAME, or revert the ABI change (unless you're absolutely sure that nothing other than sqlite3 is affected by the change, in which case you might be able to add an appropriate Conflicts in libsqlite3-0, but that's ugly). Cheers, Julien -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
* Julien Cristau [Tue, 29 Apr 2008 18:40:05 +0200]: $ objdump -T /usr/lib/libsqlite3.so.0|grep -c sqlite3_enable_load_extension 0 Additionally: % 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.ourGU287962008-04-29 18:48:12.0 +0200 +++ /tmp/adeodato/tmp.aORRO287972008-04-29 18:48:12.0 +0200 -B sqlite3_io_trace -D sqlite3_apis -R sqlite3IsAsciiIdChar -R sqlite3UpperToLower -R sqlite3one -T sqlite3AddCheckConstraint -T sqlite3AddCollateType -T sqlite3AddColumn -T sqlite3AddColumnType -T sqlite3AddDefaultValue -T sqlite3AddNotNull -T sqlite3AddPrimaryKey -T sqlite3AffinityType -T sqlite3AlterBeginAddColumn -T sqlite3AlterFinishAddColumn -T sqlite3AlterFunctions -T sqlite3AlterRenameTable -T sqlite3AnalysisLoad -T sqlite3Analyze -T sqlite3ApiExit -T sqlite3ArrayAllocate -T sqlite3AtoF -T sqlite3Atoi64 -T sqlite3Attach -T sqlite3AttachFunctions -T sqlite3AuthCheck -T sqlite3AuthContextPop -T sqlite3AuthContextPush -T sqlite3AuthRead -T sqlite3AutoLoadExtensions -T sqlite3BeginParse -T sqlite3BeginTransaction -T sqlite3BeginTrigger -T sqlite3BeginWriteOperation -T sqlite3BinaryCompareCollSeq -T sqlite3BtreeBeginStmt -T sqlite3BtreeBeginTrans -T sqlite3BtreeCacheOverflow -T sqlite3BtreeClearTable -T sqlite3BtreeClose -T sqlite3BtreeCloseCursor -T sqlite3BtreeCommit -T sqlite3BtreeCommitPhaseOne -T sqlite3BtreeCommitPhaseTwo -T sqlite3BtreeCommitStmt -T sqlite3BtreeCopyFile -T sqlite3BtreeCreateTable -T sqlite3BtreeCursor -T sqlite3BtreeCursorDb -T sqlite3BtreeData -T sqlite3BtreeDataFetch -T sqlite3BtreeDataSize -T sqlite3BtreeDelete -T sqlite3BtreeDropTable -T sqlite3BtreeEnter -T sqlite3BtreeEnterAll -T sqlite3BtreeEnterCursor -T sqlite3BtreeEof -T sqlite3BtreeFactory -T sqlite3BtreeFirst -T sqlite3BtreeFlags -T sqlite3BtreeGetAutoVacuum -T sqlite3BtreeGetDirname -T sqlite3BtreeGetFilename -T sqlite3BtreeGetJournalname -T sqlite3BtreeGetMeta -T sqlite3BtreeGetPage -T sqlite3BtreeGetPageSize -T sqlite3BtreeGetReserve -T sqlite3BtreeGetTempCursor -T sqlite3BtreeIncrVacuum -T sqlite3BtreeInitPage -T sqlite3BtreeInsert -T sqlite3BtreeIntegrityCheck -T sqlite3BtreeIsInReadTrans -T sqlite3BtreeIsInStmt -T sqlite3BtreeIsInTrans -T sqlite3BtreeIsRootPage -T sqlite3BtreeKey -T sqlite3BtreeKeyFetch -T sqlite3BtreeKeySize -T sqlite3BtreeLast -T sqlite3BtreeLeave -T sqlite3BtreeLeaveAll -T sqlite3BtreeLeaveCursor -T sqlite3BtreeLockTable -T sqlite3BtreeMaxPageCount -T sqlite3BtreeMoveToParent -T sqlite3BtreeMoveto -T sqlite3BtreeMutexArrayEnter -T sqlite3BtreeMutexArrayInsert -T sqlite3BtreeMutexArrayLeave -T sqlite3BtreeNext -T sqlite3BtreeOpen -T sqlite3BtreePager -T sqlite3BtreeParseCell -T sqlite3BtreeParseCellPtr -T sqlite3BtreePrevious -T sqlite3BtreePutData -T sqlite3BtreeReleaseTempCursor -T sqlite3BtreeRestoreOrClearCursorPosition -T sqlite3BtreeRollback -T sqlite3BtreeRollbackStmt -T sqlite3BtreeSchema -T sqlite3BtreeSchemaLocked -T sqlite3BtreeSetAutoVacuum -T sqlite3BtreeSetCacheSize -T sqlite3BtreeSetPageSize -T sqlite3BtreeSetSafetyLevel -T sqlite3BtreeSyncDisabled -T sqlite3BtreeTripAllCursors -T sqlite3BtreeUpdateMeta -T sqlite3ChangeCookie -T sqlite3CheckCollSeq -T sqlite3CheckObjectName -T sqlite3CloseExtensions -T sqlite3CodeRowTrigger -T sqlite3CodeSubselect -T sqlite3CodeVerifySchema -T sqlite3ColumnDefault -T sqlite3CommitInternalChanges -T sqlite3CommitTransaction -T sqlite3CompareAffinity -T sqlite3CompleteInsertion -T sqlite3CreateForeignKey -T sqlite3CreateFunc -T sqlite3CreateIdExpr -T sqlite3CreateIndex -T sqlite3CreateView -T sqlite3DbMallocRaw -T sqlite3DbMallocZero -T sqlite3DbRealloc -T sqlite3DbReallocOrFree -T sqlite3DbStrDup -T sqlite3DbStrNDup -T sqlite3DefaultRowEst -T sqlite3DeferForeignKey -T sqlite3DeleteFrom -T sqlite3DeleteTable -T sqlite3DeleteTrigger -T sqlite3DeleteTriggerStep -T sqlite3Dequote -T sqlite3DequoteExpr -T sqlite3Detach -T sqlite3DropIndex -T sqlite3DropTable -T sqlite3DropTrigger -T sqlite3DropTriggerPtr -T sqlite3EndTable -T sqlite3ErrStr -T sqlite3Error -T sqlite3ErrorClear -T sqlite3ErrorMsg -T sqlite3ExpirePreparedStatements -T sqlite3Expr -T sqlite3ExprAffinity -T sqlite3ExprAnalyzeAggList -T sqlite3ExprAnalyzeAggregates -T sqlite3ExprAnd -T sqlite3ExprAssignVarNumber -T sqlite3ExprCode -T sqlite3ExprCodeAndCache -T sqlite3ExprCodeExprList -T sqlite3ExprCodeGetColumn -T sqlite3ExprCodeTemp -T sqlite3ExprCollSeq -T sqlite3ExprCompare -T sqlite3ExprDelete -T sqlite3ExprDup -T sqlite3ExprFunction -T sqlite3ExprIfFalse -T sqlite3ExprIfTrue -T sqlite3ExprIsConstant -T sqlite3ExprIsConstantNotJoin -T sqlite3ExprIsConstantOrFunction -T sqlite3ExprIsInteger -T sqlite3ExprListAppend -T sqlite3ExprListCheckLength -T sqlite3ExprListDelete -T sqlite3ExprListDup -T sqlite3ExprResolveNames -T sqlite3ExprSetColl -T sqlite3ExprSetHeight -T sqlite3ExprSpan -T
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
* Adeodato Simó: * Julien Cristau [Tue, 29 Apr 2008 18:40:05 +0200]: $ objdump -T /usr/lib/libsqlite3.so.0|grep -c sqlite3_enable_load_extension 0 Additionally: % 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.ourGU287962008-04-29 18:48:12.0 +0200 +++ /tmp/adeodato/tmp.aORRO287972008-04-29 18:48:12.0 +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. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
Package: sqlite3 Version: 3.5.6-3 Severity: grave [EMAIL PROTECTED]:[~] 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 [EMAIL PROTECTED]:[~/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-2SQLite 3 shared library sqlite3 recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Processed: Re: Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
Processing commands for [EMAIL PROTECTED]: reassign 478337 libsqlite3-0 Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension Bug reassigned from package `sqlite3' to `libsqlite3-0'. retitle 478337 libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped) Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension Changed Bug title to `libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped)' from `symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension'. kthxbye Stopping processing here. Please contact me if you need assistance. Debian bug tracking system administrator (administrator, Debian Bugs database) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
reassign 478337 libsqlite3-0 retitle 478337 libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped) kthxbye On Mon, Apr 28, 2008 at 21:26:59 +0100, Tom Parker wrote: [EMAIL PROTECTED]:[~] 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 [EMAIL PROTECTED]:[~/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. No, libsqlite3 shouldn't have dropped the symbol in the first place (without changing SONAME and package name, that is). Cheers, Julien -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
package libsqlite3-0 severity 478337 important thanks Hi Tom, On Mon, 2008-04-28 at 21:26 +0100, Tom Parker wrote: Package: sqlite3 Version: 3.5.6-3 Severity: grave [EMAIL PROTECTED]:[~] sqlite3 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. Regards, Laszlo/GCS -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Processed: Re: Bug#478337: symbol lookup error: sqlite3: undefined symbol: sqlite3_enable_load_extension
Processing commands for [EMAIL PROTECTED]: package libsqlite3-0 Ignoring bugs not assigned to: libsqlite3-0 severity 478337 important Bug#478337: libsqlite3-0: ABI change without SONAME change (symbol sqlite3_enable_load_extension dropped) Severity set to `important' from `grave' thanks Stopping processing here. Please contact me if you need assistance. Debian bug tracking system administrator (administrator, Debian Bugs database) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]