Process crash with no reason

[gil.shinar at gmail.com]

On Jan 28, 7:37 pm, Philip Semanchuk <phi... at semanchuk.com> wrote:
> On Jan 28, 2009, at 12:12 PM, gil.shi... at gmail.com wrote:
>
> > On Jan 27, 5:59 pm, Philip Semanchuk <phi... at semanchuk.com> wrote:
> >> On Jan 27, 2009, at 10:34 AM, gil.shi... at gmail.com wrote:
> >>> On Jan 27, 2:10 pm, Tim Golden <m... at timgolden.me.uk> wrote:
> >>>> Then how are you interacting with Sybase?
>
> >>> I'm using python's functions to run sybase sql commands.
>
> >> Can you give a short code sample? I'm unaware of how one would use  
> >> the
> >> standard Python library to talk to Sybase, unless Sybase has a raw
> >> socket interface or some such.
>
> > First of all I have found the following python's import:
>
> > import Sybase
>
> This isn't part of the Python standard library. It's a 3rd party  
> module -- exactly what we were looking for.
>
> Personally, I think this (or another C++ or C-based 3rd party module  
> that you use heavily) is your prime suspect for the origin of the  
> crashes you're having. That's not because I think the people who wrote  
> or maintain it are bad or lazy coders. In fact, it's no reflection on  
> their skill at all. It's just that a lot more people have used and  
> exercised the Python standard library modules. A 3rd party module like  
> this one will be less well-used and therefore less well-tested and  
> therefore more likely to contain a bug that causes a crash.
>
> That said, I don't know how to advise you to proceed from here. You  
> could perhaps turn on logging at the database level. I know Postgres,  
> for instance, can write very detailed logs and so if you get a crash  
> at 9:33:22 you can look in the log and see what was happening at that  
> time. If you get several crashes and they all happen when a certain  
> SQL statement is being executed, that's probably the culprit.
>
> You could also alter the Sybase module to add logging using Python's  
> logging module. Who knows, it might already be there, waiting to be  
> turned on with a switch.
>
> But I'm jumping the gun a little. As I said, it could be this module  
> or another that's causing your problem. It's a lot easier to cause a  
> hard crash using C or C++ than it is using pure Python, so pure Python  
> modules would be lower on my list of suspects. Enumerate all of the  
> modules you're using and find out where they come from. Any of them  
> that are not in the standard library and are not written in pure  
> Python should top your list of suspects.
>
> Good luck
> Philip

Thanks a lot and sorry for the late response. My main suspect is the
CherryPy.
I'm still investigating it.

Gil