pysqlite2.dbapi2.ProgrammingError: library routine called out of sequence

Robert Gravina <[email protected]>
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
Pysqlite-list,

I am writing an application which makes use of Twisted <http:// 
twistedmatrix.com/trac/> and Divmod Axiom <http://divmod.org/trac/ 
wiki/DivmodAxiom>, which in turn makes use of pysqlite 2.0.7 and  
sqlite 3.3.6.

I have made an application bundle (for the Mac) using py2app, which  
runs fine on my mac and other macs on my network, but for some reason  
I get the following traceback when I (well, a user) tries to run this  
any one of several macs on their network. I have tried various Macs  
and network connections (cable, dialup) to try and rule out a single  
mac or the network as the problem.

Traceback (most recent call last):
   File "twisted/python/log.pyc", line 53, in callWithLogger
   File "twisted/python/log.pyc", line 38, in callWithContext
   File "twisted/python/context.pyc", line 59, in callWithContext
   File "twisted/python/context.pyc", line 37, in callWithContext
--- <exception caught here> ---
   File "twisted/internet/threadedselectreactor.pyc", line 299, in  
_doReadOrWrite
   File "twisted/internet/tcp.pyc", line 111, in doRead
   File "twisted/internet/tcp.pyc", line 348, in doRead
   File "twisted/spread/banana.pyc", line 184, in dataReceived
   File "twisted/spread/banana.pyc", line 114, in gotItem
   File "twisted/spread/banana.pyc", line 81, in callExpressionReceived
   File "twisted/spread/pb.pyc", line 559, in expressionReceived
   File "twisted/spread/pb.pyc", line 928, in proto_answer
   File "twisted/spread/pb.pyc", line 820, in unserialize
   File "twisted/spread/jelly.pyc", line 890, in unjelly
   File "twisted/spread/jelly.pyc", line 519, in unjellyFull
   File "twisted/spread/jelly.pyc", line 542, in unjelly
   File "twisted/spread/flavors.pyc", line 455, in unjellyFor
   File "salespipeline/model/remote.pyc", line 89, in setCopyableState
   File "/Library/Frameworks/Python.framework/Versions/2.4/lib/ 
python2.4/site-packages/axiom/store.py", line 533, in __init__
   File "/Library/Frameworks/Python.framework/Versions/2.4/lib/ 
python2.4/site-packages/axiom/store.py", line 693, in _initdb
   File "/Library/Frameworks/Python.framework/Versions/2.4/lib/ 
python2.4/site-packages/axiom/_pysqlite2.py", line 24, in  
fromDatabaseName
pysqlite2.dbapi2.ProgrammingError: library routine called out of  
sequence

The line it is referring to in my source  (File "salespipeline/model/ 
remote.pyc", line 89, in setCopyableState) is this:

         self.db = Store()

This is how you create an Axiom in-memory SQLlite database, and  
should work fine.

So... it dies while trying to make an in-memory store. I'm not sure  
the problem is with my code, or something to do with how I've used  
py2app, Axiom or pysqlite. I've already send a similar mail to the  
Divmod mailing list..

I believe it may be related to the problems Skip is having here:
http://mail.python.org/pipermail/python-dev/2006-October/069504.html

I will try and reproduce his problems tomorrow.

Thanks!

Robert
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.