Subject Re: [firebird-support] Re: Firebird Unstable under load
Author Helen Borrie
At 07:19 AM 25/02/2006, you wrote:

>more information:
>Running FB as an application with the Guardian as an application
>crashes about as ofter but with a different return code:
>
>MACHINE (Client) Fri Feb 24 09:47:32 2006
> C:\Firebird\bin\fbserver.exe: terminated abnormally (3221225477)
>
>
>Also It seems to NOT crash when I run FB without the guardian as
>an application????
>
>does that make any sense?

No, because what you're telling us is a) ambiguous and b) in a different box.

Do you mean, for example, that you are trying to run Guardian as an
application and fbserver.exe as a service? or vice versa?

Or that you have been running both as applications all along?

Also, we still haven't seen any sign that you are interested in
exploring the part that Apache server is playing in all this (aside
from the obvious memory starvation issue). Did you know that Apache
on Windows runs its TCP/IP attachments in threads? Did you know that
Apache by default hobbles the number of allowed threads? It's a low
number, used to be 50 but I think it stepped up to ~250 in Apache 2.

Regarding the AV that you reported: have you considered the
possibility that your php code is trying to do something illegal
across thread boundaries? For example, establishing a connection in
one thread, opening a cursor, and then starting another thread to try
to operate on that cursor? Each threaded session between client and
server *must* consist of a self-contained connection and only its own
transactions; and each transaction can only refer to its own cursor
resources.

regarding your coredumps: post them to firebird-devel if you want
some useful eyes on them. They are pretty meaningless to most people
who monitor this list regularly - we are end-use interpreters, by and
large. Try to be exact about your environment and your run-time
conditions, as well. And if you're trying to run Firebird as an
application, say so explicitly, as well.

./heLen