[python-sybase] sybase connection hanging

[Rocky Burt]

Well, the interpreter wasn't crashing, but was hanging.  In any event, I actually tracked down the problem.  The issue was that i was reusing the same cursor instance amongst different threads.  And as Sybase.threadsafety identifieds, cursors are not threadsafe.  Once I stopped reusing cursors, all was well.  I haven't had a single hang since.

Regards,
Rocky


> --------- Original Message ---------
> From: Eric Uski [mailto:e_uski@hotmail.com]
> Sent: April 13, 2003 13:09:55 +0200
> To: Shai.Berger@integration.sungard.com, rocky.burt@bricsnet.com, python-sybase@object-craft.com.au
> Subject: Re: [python-sybase] sybase connection hanging
> 
> 
> Hello,
> 
> I had some problems like that. The only way I found to prevent the Python
> interpreter to crash is to remove the line for the server callback messages
> in Sybase.py. the line is:
> _ctx.ct_callback(CS_SET, CS_SERVERMSG_CB, _servermsg_cb)
> 
> eric
> 
> ----- Original Message -----
> From: <Shai.Berger@integration.sungard.com>
> To: <rocky.burt@bricsnet.com>; <python-sybase@object-craft.com.au>
> Sent: Sunday, April 13, 2003 10:21 AM
> Subject: RE: [python-sybase] sybase connection hanging
> 
> 
> Rocky,
> 
> You've got to give us some more meat here to get any real help.
> What are you doing with the database? Are you playing games with
> threads? Transactions? The kind of symptom you describe is typical
> for database locking problems, but I don't think you'll get anything
> more specific without some details.
> 
> Have fun,
> Shai.
> 
> 
> -----Original Message-----
> From: Rocky Burt [mailto:rocky.burt@bricsnet.com]
> Sent: Thursday, April 10, 2003 20:09
> To: python-sybase@object-craft.com.au
> Subject: [python-sybase] sybase connection hanging
> 
> 
> All,
> 
> Every so often I'm finding my sybase connection hanging.  And its
> hanging to a point where the only way to stop the python app is to 'kill
> -9' the python interpreter.
> 
> My setup is as follows:
>   Server: Solaris(sparc) 8 with Sybase ASE 12.5
>   Machine Running Application: Redhat Linux 8.0 (intel), Python 2.1.3
> 
> This happens with Sybase drivers 0.35 and 0.36pre6.
> 
> Anyone have any ideas?
> 
> Regards,
> Rocky
> 
> 
> _______________________________________________
> Python-sybase mailing list
> Python-sybase@object-craft.com.au
> https://object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase
> _______________________________________________
> Python-sybase mailing list
> Python-sybase@object-craft.com.au
> https://object-craft.com.au/cgi-bin/mailman/listinfo/python-sybase