Todd wrote...

> I had this problem some time ago using a Sybase database.  
> The problem was
> that I goofed in my code and one of my queries was taking too long to
> complete.  Eventually, it timed out. When the client gave up 
> waiting, it
> popped up an error message and stopped.  This left a 
> connection open on  the
> server, or left a process running, or something.  When I 
> would look at the
> running processes under Task Manager, I would see about 7 - 
> 10 "mtx.exe"'s
> running.  If I killed all of these off except for 1 or 2, 
> then the server
> would start working again.  If I just left them, the sever 
> appeared to be
> locked up.

Looking at the log files after this happened the first time, I also thought
it was a lengthy query causing problems.  After seeing the same thing happen
over and over again, sometimes without even having called a single page from
the server, I had to rethink.  Most (if not all) of the queries I'm using
are pretty lightweight and would take no more than a couple of seconds, but
this could be what Nille is experiencing.

Neil
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to