Subject | Re: App freezing |
---|---|
Author | sllimr7139 |
Post date | 2004-02-12T21:41:48Z |
> Iam following this thread to learn something from you guys.I too am interested in the answer to this problem. About 6 months ago
> Since Jason suggest to take this matter on the private, will the
> result be posted here for the purpose of providing information in
> this IBO community? :-)
>
I changed the way my Apache web application was running for a very
similar reason.
I had FB 1.03 and IBO running as a Win32 ApacheDSO. Every now and
then the connection to the database would suddenly drop out from under
my application and the server would then appear to be hung.
The connection type was Local so it shouldn't have been affected by
the TCP/IP problem of SP4 as previously mentioned in this thread, and
in fact my problem pre-dated SP4. I had explicit transaction
handling in my application as well as a global session object. The
DSO was only doing selects on the database with an isolationlevel of
commited.
The only consistent thing I've possibly noticed between the problem of
the threads owner and my problem was a consistent long term DB
connection.
I got so sick and tired of trying to figure out why it was happening I
just changed the game. I went with a CGI application and I haven't
had to reboot the server since, except when I'm installing windows
patches <g>.
Anyone else got any similar stories?
Ryan.