Help with large data set and fatal python error (pysqlite)

[Vineet Jain]

I've tried to close all the db connections after I use them and still et the
problem. I still get the problem if I add:

cur = None
conn.close()

after I retrieve each reult set.




-----Original Message-----
From: python-list-bounces+vineet=eswap.com at python.org
[mailto:python-list-bounces+vineet=eswap.com at python.org]On Behalf Of
Terry Reedy
Sent: Wednesday, May 19, 2004 5:54 PM
To: python-list at python.org
Cc: pysqlite-users at lists.sourceforge.net
Subject: Re: Help with large data set and fatal python error (pysqlite)



"Vineet Jain" <vineet at eswap.com> wrote in
message news:KPENJIMKHJPNKOLFIHBNKEPNCJAA.vineet at eswap.com...
> I've been able to recreate the problem with the following code segment.
It
> seems that the problem comes when you have multple db files open at the
same
> time. In my application I have many database files open at the same time.
> I'm not using threads so all access to the db files are done
sequenetially.
>
> At the end of the program I get the following error:
>
> Fatal Python error: deallocating None
>
> This application has requested the Runtime to terminate it in an unusual
> way.
> Please contact the application's support team for more information.

Have you done so?  In this case, the 'application' is, it would seem,
sqlite.

> If I change the numInnerLoop to 5, 10, 20, or 30 it works however
anything
> over 35 gives the above error. In my actual application, when run for a
> larger set, the error can come in the middle of the program and is
causing
> me a lot of grief.

Do the docs for sqlite specify max open connections?
If not, maybe send them your example.
If so, ask if limit can be raised.
In the meanwhile, stay under it.

Terry J. Reedy




--
http://mail.python.org/mailman/listinfo/python-list