Firebird 3 crashing randomly
----------------------------
Key: CORE-5615
URL: http://tracker.firebirdsql.org/browse/CORE-5615
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.2
Environment: Firebird running on windows 2012 R2, being accessed by
php through apache on linux servers
Reporter: Rudi Feijó
Firebird 3 is crashing randomly on my server. It may crash once, twice, or 10
times a day. Or not once during the day.
Server load is always minimal during the crashes, and so is the memory usage.
With the help of the community, my latest attempts where to change the
firebird.conf, and I tried a lot of different combinations, even returning to
the default combination, but the problem still happens.
Before turning off the guardian, firebird.log always wrote a terminated
abnormally (4294967295) error, not without the guardian it doesn't write
anything at all, it just crashes silently.
The community have been trying to help me a lot, I'm going to paste some of the
conversation here :
>but did you checked your DB against corruption?
>gfix -validate -full
>any errors (also in firebird.log)?
The server have about 20 db's, haven't performed a validate full on each one of
them.
At the moment Im assuming theres no corruption because all of our clients are
fully operational and there are no incidents reported by them.
>Did you performed backup/restore process.
Yes all db's were backed up in 2.5 and restored in 3
>Do you use any udf? also system udf?
We use quite a few udf's , mosltly from freeAdhocUdf and some system ones.
If an UDF was the culprit of the crash, Im assuming it would always crash at a
certain query or function call, is this safe to assume?
>Do you have enough free mem, free disk space also for temp files like sorting?
Yes I don't think this firebird installation every got above 2gb of peak ram
usage out of 10gb free
>Do you have recent Firebird version (which exactly) and also fbclient.dll
>version (if you use it or gds32.dll)
The latest stable firebird version 3.0.2 march/22
From what I can tell, we don't use the client libraries (we do use for ibexpert
but we rarely use ibexpert)
We are running apache with php 5.6 on linux machines, connecting to the windows
firebird server.
The linux machines themselves have no firebird installation, only pure apache
and php.
What I do know is that the php firebird extension was not updated to work with
firebird 3.
One thing that I know that doesn't work, for instance, are the new Boolean
fields (we cannot use Boolean fields because php will not be able to read them).
So, while php continues to be my number one suspict here, I was unable to
capture a single error log which I'm able to recreate the crash.
If php was crashing on a certain query, it would be trivial for me to get it
from my logs (we log queries prior their execution) and recreate the crash.
So, not only that is not happening, but also I can't seem to get crash dump
logs as described initially.
This problem have been happening since day 1 of our new servers operating with
firebird 3, about 5 months now.
Specs :
Firebird-3.0.2.32703_0_x64 on windows 2012 R2 VM (2 core 2.30gh xeon, 13gb ram)
Config :
ServerMode = Super
GuardianOption = 0
WireCrypt = Enabled
TempDirectories = C:\firebird-temp
AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager, Srp
DefaultDbCachePages = 20000
TempBlockSize = 2M
TempCacheLimit = 364M
LockMemSize = 9M
LockHashSlots = 30011
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
