BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Firebird - Teminated Abnormally (4294967295)

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers)
View previous topic :: View next topic  
Author Message
Robin
Guest





PostPosted: Tue Mar 27, 2007 6:43 am    Post subject: Firebird - Teminated Abnormally (4294967295) Reply with quote



Hi everyone,

I have been tearing my hear out treying to find the problem with a
firebird server.

This server holds multiple firebird 1.5 databases, all of which have
been running fine for over a year. Just the last two weeks we have been
getting the following error at seemingly random intervals, a couple of
times each day.

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

I have been looking for anything which may have changed on the server in
that time and have not come up with much.

Has anyone else encountered this? Any possible solutions?

Thank you all in advance.

--
Robin.

Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/
Back to top
Guillem
Guest





PostPosted: Tue Mar 27, 2007 3:42 pm    Post subject: Re: Firebird - Teminated Abnormally (4294967295) Reply with quote



Robin wrote:

Quote:
Hi everyone,

I have been tearing my hear out treying to find the problem with a
firebird server.

This server holds multiple firebird 1.5 databases, all of which have
been running fine for over a year. Just the last two weeks we have
been getting the following error at seemingly random intervals, a
couple of times each day.

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

I have been looking for anything which may have changed on the server
in that time and have not come up with much.

Has anyone else encountered this? Any possible solutions?


I have investigated this a bit further and it seems to affect older FB
1.5 versions. I haven't found any reference to FB 1.5.4 or higher
versions being affected.

If the sources I found are correct it seems to happen when doing
certain SELECT statements and concurrency of about/above 50 users , or
when playing with FKs.

References are:

http://sourceforge.net/mailarchive/forum.php?forum_id=6330&max_rows=25&s
tyle=nested&viewmonth=200405

http://archive.netbsd.se/?ml=firebird-devel&a=2006-02&t=1794778

http://tracker.firebirdsql.org/browse/CORE-544

http://www.mail-archive.com/firebird-net-provider (AT) lists (DOT) sourceforge.net/
msg00067.html

http://entwickler-forum.de/archive/index.php/t-7297.html


Hope this gets you in the right path,
--
Best regards :-)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
Back to top
Robin
Guest





PostPosted: Wed Mar 28, 2007 4:44 am    Post subject: Re: Firebird - Teminated Abnormally (4294967295) Reply with quote



Guillem wrote:
Quote:
I have investigated this a bit further and it seems to affect older FB
1.5 versions. I haven't found any reference to FB 1.5.4 or higher
versions being affected.

Hi Guillem,

Thank you for your help!

We upgraded to the higest 1.x version we could (not ready to go to 2.x
yet) and the problem continued.

While testing everything under the sun I discovered one development
machine connected to the server which had previously had Interbase2007
installed on it still had the GDS32 on it, and not the FireBird 1.5 one.

We have purged that machine of all Interbase and firebird installs,
deleted all GDS32's by hand and then re-installed firebird 1.5. It has
been running for almost 24 hours now without fault.

So it would appear that the newer GDS32 does not play well with FireBird
1.5.



--
Robin.

Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/
Back to top
Guillem
Guest





PostPosted: Wed Mar 28, 2007 1:40 pm    Post subject: Re: Firebird - Teminated Abnormally (4294967295) Reply with quote

Robin wrote:

Quote:

Hi Guillem,

Thank you for your help!

you're welcome :-)

Quote:

We upgraded to the higest 1.x version we could (not ready to go to
2.x yet) and the problem continued.

Same for me. I think I'll wait until Vulcano comes out.

Quote:

While testing everything under the sun I discovered one development
machine connected to the server which had previously had
Interbase2007 installed on it still had the GDS32 on it, and not
the FireBird 1.5 one.

We have purged that machine of all Interbase and firebird installs,
deleted all GDS32's by hand and then re-installed firebird 1.5. It
has been running for almost 24 hours now without fault.

So it would appear that the newer GDS32 does not play well with
FireBird 1.5.


whoa! AFAICS there was no reference to mixed DLLs in all those reports.
Maybe they also had the same issue.

It could really be the problem. FB and IB not always play well
together...
--
Best regards :-)

Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
Back to top
Robin
Guest





PostPosted: Thu Mar 29, 2007 8:11 am    Post subject: Re: Firebird - Teminated Abnormally (4294967295) Reply with quote

Guillem wrote:
Quote:
whoa! AFAICS there was no reference to mixed DLLs in all those reports.

Yeah, Tell me about it! It was actually a really embarrsing mistake on
my part which led to discovering it. Absolute fluke.

Quote:
Maybe they also had the same issue.

It could really be the problem. FB and IB not always play well
together...

Not in this case it would seem!

Anyhow, hopefully next time someone else gets this problem, maybe this
will be found in their googling and my pain can help someone :-)

--
Robin.

Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.