Solved

How do I identify and resolve the cause of Firebird Abnormal Termination (4294967295)?

Posted on 2007-12-05
4
4,865 Views
Last Modified: 2013-12-09
We produce an accounting system and we are presently migrating our system across to Firebird 1.54 from Interbase 5.6.  We have found that at some sites on an irregular basis we get the following error in the firebird event log.  We have now installed a debug version of firebird installed at one of the sites experiencing the problem (around 10 incidents over a 4 week period).

SERVER1 (Client)          Fri Nov 23 14:27:50 2007
C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated abnormally (4294967295)

NOTE: The value of 4294967295 (0xFFFFFFFF) reported in the log file could perhaps be interrupted as -1 for a 32 bit signed INT if that has more meaning for this problem.  

In the windows event log the following messages appear:
The description for Event ID ( 281 ) in Source ( FirebirdGuardianDefaultInstance ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Abnormal Termination: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated abnormally (4294967295).
 
The servers on which Firebird run are dedicated IBM Windows 2003 Servers, configured with RAID 5, 3.x ghz processor with typically 4 Gig of Memmory installed.  The method of connection to the database is by the BDE which we are getting ready to replace and we have a number of applications that access the database.  The firebird debug version of firebird has been installed at one of the sites (Firebird-1.5.4.4910-0-Win32_pdb.exe) and a Crash Dump file has been generated for one of the abnormal terminations.  This file can be made available if it is of use.

0
Comment
Question by:MTP1971
  • 2
4 Comments
 
LVL 19

Expert Comment

by:NickUpson
Comment Utility
I think the advice you received elsewhere is good, in addition, I suggest you check the hardware on the specific site, as bad memory/cpu/etc could cause this
0
 

Expert Comment

by:Paulplaysafe
Comment Utility
And I joined just to see this rubbish answer?
What advice received elsewhere?
0
 
LVL 19

Accepted Solution

by:
NickUpson earned 500 total points
Comment Utility
I fyou have a specific problem please start a new question including as much detail as possible.

The same question was asked, by the same person, on a support email list I'm also a member of.

here is the response they received, from Helen Borrie <helebor@...> wrote:

At 05:18 PM 5/12/2007, you wrote:
>We produce an accounting system and converted our system across to
>Firebird 1.54 from Interbase 5.6.  We have found that at some sites on
>an irregular basis we get the following error in the firebird event log.
>
>SERVERX (Client) Thu Nov 08 17:00:50 2007
> C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
>abnormally (4294967295)

Unfortunately that numeric code comes from Windows and, as far as we can tell, it indicates exactly what you picked up in the win event log, i.e., it means nothing.

>In the windows event log the following messages appear:
>The description for Event ID ( 281 ) in Source (
>FirebirdGuardianDefaultInstance ) cannot be found. The local computer
>may not have the necessary registry information or message DLL files
>to display messages from a remote computer. You may be able to use the
>/AUXSOURCE= flag to retrieve this description; see Help and Support
>for details. The following information is part of the event: Abnormal
>Termination: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe:
>terminated abnormally (4294967295).

All this means is that the Guardian service was installed without anything in the "comment" field of the service, which is optional text for services whose purpose isn't clear from their name.  This message is not a cause, it is an effect.

The Guardian service's job is just to sit there waiting, in case the Firebird server crashes, at which it will attempt to restart it.  So the firebird.log messages before and after it are more interesting in the quest for reasons for the server crash.

>The servers on which Firebird run are dedicated IBM Windows 2003
>Servers, configured with RAID 5, 3.x ghz processor with typically 4
>Gig of Memmory installed.  The method of connection to the database is
>by the BDE

If you're getting site-specific crashes then the BDE is almost certainly at the bottom of the problem.  Even the most recent BDE (5.2) is terribly ancient:  it predates Fb 1.5 and doesn't even fully support IB 6.  So - if this crashing problem is more than just an occasional annoyance, copy the BDE configuration from one of the good sites and see whether that improves anything.

OTOH, it could be that this one site is using some byway of your application that other sites don't use, so don't eliminate that possibility.

>which we are getting ready to replace and we have a number
>of applications that access the database. This is our application
>suite (comprised of many seperate programs such as Debtors, Creditors
>etc) not 3rd party utilities or db tools etc.
>
>The firebird debug version of firebird has been installed at one of
>the sites (Firebird-1.5.4.4910-0-Win32_pdb.exe) and a Crash Dump file
>has been generated for one of the abnormal terminations.  This file
>can be made available if it is of use.
>
>Does anyone know what may cause this sort of problem.  From the
>message I infer it comes from our client application but what sort of
>operation would induce this error?  Although this may not be directly
>relevant this did not occur under Interbase 5.6.

It's not directly relevant that it didn't occur in IB 5.6, except that it does suggest there is something in your migration that was missed for this site.  Have you tried to back up the database in IB 5.6 and restore it in Fb 1.5, for example?  Do you perhaps have a generator in this database that is overflowing the ODS 9 limit?  (In Fb 1.5, generators are BigInt whereas in IB 5.x they are integer...) i.e. there could be many things at play here.  You might like to review the IB 6 Migration Guide for some issues you might have overlooked.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now