Issues with firebird blocking

Business edition tips, tricks, problems and discussions

Moderators: TerryRogers, Max

Post Reply
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Issues with firebird blocking

Post by gertone »

An annoying one this is since I need to restart Firebird multiple times per day... it makes the entire EPIM app unreliable

I posted before in a different thread, but it has not been picked up nor replied to so it might be better to make it a fresh post after all


For quite a while I am having issues with the FireBird service that blocks or stops a couple of times a day
I need to stop the firebird service on the server (if it did not stop from itself)

Here is what I find in the firebird logs

Code: Select all

ARIEIRO (Server)   Mon Sep 28 06:03:22 2015
   *** DUMP ***


ARIEIRO (Server)   Mon Sep 28 06:03:22 2015
   Fatal exception during clumplet dump: Invalid clumplet buffer structure: spb in service attach should begin with isc_spb_version1 or isc_spb_version


ARIEIRO (Server)   Mon Sep 28 06:03:22 2015
   Plain dump starting with offset 864: BNNpSKTEjsKsdvfLbJtHUAFqsJUvHcRReqKsEvagwsbL


ARIEIRO (Server)   Mon Sep 28 06:03:25 2015
   INET/inet_error: read errno = 10054


Browsing the Firebird fora, I find all sorts of advice: Don't use the guardian on wiondows. Do use the guardian on windows ;-)

The server is a win2003 machine (not likely to change soon), 32 bit. The firebird version is 2.1
Adviec I do seem to find a lot is to backup and update to the latest firebird 2.5.4
but I am a bit reluctant given that the cause could be an inconsistency in the DB
upgrading wil likely either solve the issue or kill the DB

So,
- can I safely upgrade firebird to 2.5.4 32 bit on a win
- should I install classic, superclassic or classic?
- should I use guardian?
- how can I backup the data before I upgrade?

Thanks

Geert
Trinitylab
Guru
Posts: 682
Joined: Mon Jan 23, 2012 1:31 pm
Has thanked: 16 times
Been thanked: 41 times

Re: Issues with firebird blocking

Post by Trinitylab »

I am interested in the solution, this is probably related to other similar problems with FB loosing network licenses.
EPIM Pro Business Network always newest
Win 8.1 Pro 64x, C2D 2x3GHz, 16 GB RAM or Win 10 Pro, i7, 16 GB RAM.
gertone
Novice
Posts: 28
Joined: Fri Feb 03, 2012 10:14 pm
Been thanked: 2 times

Re: Issues with firebird blocking

Post by gertone »

2 weeks - no reply
What does that mean?
Too hard, no interest?... like to point out it is still an issue
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: Issues with firebird blocking

Post by Max »

Hello,

I have replied in the original topic:
viewtopic.php?f=31&t=15817&p=74352#p74352
Maxim,
EPIM Team
Post Reply