Hello all once again,

I have spent quite long time with analyzing firebird.log files on many
different servers I can access today.

All servers I checked are running on Windows 7/2008R2 and they have in
firebird.log very often logged this problem:

"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)

I thought if it is really not related to broken UDF, ... but this
crash happens when no one is connected too. Therefore I think it
cannot be related to any part of my database(s).

All servers are in version 2.5.1 or 2.5.2 64bit where customers are
having SuperServer instance and average database size is 8 GB and all
servers are working with the only database all the day.

Do you have any recommendation what to check?

TRoland;

<<< 21. 2. 2013 23:59 - Roland Turcan "konf@..." >>>
RT> Hello Alexey and others,
RT>
RT> I have done today the following:
RT>
RT> 1. gbak -b -v -m ---- no problem
RT> 2. used fbcopy (thanks to M.Babuskov) to copy data to healthy DB
RT> 3. gbak -b -v on new database ---- no problem.
RT>
RT> Sooo, once again thanks to all of you at least for reading my emails.
RT> Of course especially to Alexey who spent his valuable time to help me
RT> and to M.Babushov for FBCopy utility.
RT>
RT> TRoland;
RT>
RT> <<< 20. 2. 2013 8:28 - Alexey Kovyazin "ak@..." >>>
AK>> Hi Roland,
RT>
AK>> Terminated abnormally is indication of the server crash, not
AK>> database corruption (though it can be some relation).
AK>> First of all, you need to look at UDFs you are using.
AK>> Did you migrate recently from 32 bit version, and one UDFs is 32
AK>> bit? Did you add new UDFs recently?
RT>
AK>> Then, if UDF are Ok (or, better, no UDFs at all) try to reproduce
AK>> crash with metadata only backup.
AK>> If it constantly repeats, this can be sign of some internal bug
AK>> in Firebird. In this case you need to add bug into
AK>> tracker.firebirdsql.org with test case (zip and attach there metadata backup).
RT>
AK>>
AK>>
AK>>
AK>>
AK>>
AK>> I also tried to use IBFirstAid 2.5 diagnose I can
AK>> see the only strange
AK>> thing about "Found 6757 undefined pages".
AK>>
AK>>
AK>>
AK>>
AK>>
AK>>
AK>> It's not stange - in 2.1+ Firebird allocates additional
AK>> undefined pages in the end of the database file for
AK>> performance and safety reason.
AK>>
AK>>
AK>>
AK>>
AK>>
AK>>
AK>> 21:55:18 INFO: Analyzing database low-level structures...
AK>> 21:55:18 INFO: Process database file #1 of 1 files.
AK>> 22:08:48 INFO: Actual PageCount: 1838521 found in database
AK>> 22:08:48 INFO: Found 6757 undefined pages.
AK>> 22:08:48 INFO: ====== DATABASE IS READY FOR
AK>> DIAGNOSING AND REPAIRING. ====
AK>> 22:08:48 INFO: ====== Now choose "Diagnose" or "Repair". ====
AK>>
AK>>
AK>>
AK>>
AK>>
AK>>
AK>> Did you run Diagnose after that?
AK>> Though, since you was able to make backup, and problem at
AK>> restore level, I doubt that FBFirstAID will show anything.
AK>>
AK>> Regards,
AK>> Alexey Kovyazin
AK>> IBSurgeon

--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk