pysqlite2.0.3 test fails on both Solaris 9 (sparc) and FC3 (AMD 32 bit)

Frank Middleton <f.middleton-32Y6zK5BtvRWk0Htik3J/[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
Tried searching the archive and Googled to little avail....

Python 2.5.1 (r251:54863, Jul 21 2007, 15:31:47)
[GCC 4.1.1] on sunos5
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import test
>>> test.test()
.............EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......EE....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE..EEEEEEEEEEE
======================================================================
ERROR: CheckClose (pysqlite2.test.dbapi.ConnectionTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/pysqlite2/test/dbapi.py", line 87, in setUp
    cu.execute("create table test(id integer primary key, name text)")
Warning: You can only execute one statement at a time.
........

----------------------------------------------------------------------
Ran 142 tests in 0.179s

FAILED (errors=116)
>>>

All the errors seemed to be similar (one line traceback followed by the
same warning), and seem to fail on self.cur.execute("create table test(i)")

sqlite-3.3.6-sol9-sparc-local

$ uname -a
SunOS apogee6 5.9 Generic_118558-35 sun4u sparc SUNW,Ultra-80

(4 processor Ultra 10 with 4GB physical memory).

Try again on Linux (AMD uniprocessor with 1GB)
$ uname -a
Linux apogee10.apogeect.com 2.6.9-1.667 #1 Tue Nov 2 14:41:25 EST 2004 i686 athlon i386 GNU/Linux

>>> from pysqlite2 import test
>>> test.test()
.............EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......EE....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE..EEEEEEEEEEE
======================================================================
ERROR: CheckClose (pysqlite2.test.dbapi.ConnectionTests)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/pysqlite2/test/dbapi.py", line 87, in setUp
    cu.execute("create table test(id integer primary key, name text)")
Warning: You can only execute one statement at a time.
.......
----------------------------------------------------------------------
Ran 142 tests in 0.114s

FAILED (errors=116)
>>>

Tried rebuilding sqlite with ./configure --disable-threadsafe and it made no
difference on either platform (so now both are at sqlite-3.5.3).

For it to fail on both platforms in such a similar way suggests something
rather basic is wrong. If someone can point me in the right direction, it
would be much appreciated - please CC me since I'm not subscribed to the list.

TIA -- Frank Middleton
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.