Re: [pysqlite] Pysqlite 2.5.5 Regression Test failed

Melton Low wrote:
> Hi,
> 
> I just installed Pysqlite 2.5.5 and the CheckOnConflictRollback test
> failed.  I have attached the log of my build and install.  The error
> message from my IDLE is as follows:

OMG. This arises from time to time since years. And I thought we finally
got rid of these problems ...

> IDLE 2.6.2     
>>>> from pysqlite2 import test
>>>> test.test()
> ................................................................................................................................................................................................F..............
> ======================================================================
> FAIL: CheckOnConflictRollback (pysqlite2.test.regression.RegressionTests)

I don't know the real cause of the problem. But building statically
should fix it:

$ python setup.py build_static

> [...] Any idea or suggestion as to what I have to do to clear this up?
> 
> My environment is:
> Mac OS X 10.5.7 Intel MacBook
> Python 2.6.2
> Sqlite 3.6.14.1

I can't reproduce that here with a similar environment. MacOS on Intel
is still 10.5.6 here (will update in a minute), Python 2.6.2 and SQLite
3.6.12 from Macports. And I don't get that problem.

Anyway the issue you see here is nothing fatal, it's just that it's not
the correct SQLite library that's loaded on runtime, but something
different - most probably the Apple one.

Here it does work as it should though.

> ghaering@server-88~/src/gh/pysqlite/build/lib.macosx-10.5-i386-2.6$ otool -L pysqlite2/_sqlite.so 
> pysqlite2/_sqlite.so:
> 	/opt/local/lib/libsqlite3.0.dylib (compatibility version 9.0.0, current version 9.6.0)
> 	/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
> 	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.1.3)

-- Gerhard