Re: [pysqlite] Erratic behavior under high loads, with APSW code sample

On 6/30/08, Roger Binns <[email protected]> wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Frank McIngvale wrote:
> > Hi, I'm having a strange problem with APSW & pysqlite that shows up
> > under higher loads.
>
>
> Your problem is strange because you made the mistake of silently
> ignoring all exceptions :-)


Really, I promise, my production code does it right, this was just a minimal
sample :-) I had a much longer test case that did the full transaction dance
and had timeout/exception handling, and the problem still showed up. I tried
adding the setbusytimeout() and it is still not working. I made a pysqlite
equivalent test, and it does the same thing. I think it must be down at the
SQLite level (or lower?). I need to investigate this some more, because it
sounds like no one else is seeing this problem. I'll post back to the list
if I figure something out.

thanks,
Frank



> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFIaVpomOOfHg372QQRAtJsAKDK88gATAQLxpORfubfW60+68vPpwCgnLU4
> lvOyaRKJebqA2oAHeatqbYw=
> =t+Ek
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite