Hi Vlad,

this bug I am looking in my log file since 2.04 version. I do not have that amount of data like Stephan but this bug is something that make my day every week or two and this is the only reason I am thinking about other database engine for my application.

Fatal lock manager error: invalid lock id (19936), errno: 107
INET/inet_error: connect errno = 111
/opt/firebird/bin/fbguard: guardian starting bin/fbserver


My user is very satisfy with performance but this occasionally server crashes make him mad.

Regards,

Djordje

----- Original Message -----
From: hvlad
To: firebird-support@yahoogroups.com
Sent: Sunday, April 11, 2010 19:09
Subject: [firebird-support] Re: FB2.5 crash



> Du to the problem we have with Firebird 2.1.4 (i will try to compile the demo project to simulate the problem monday), we decide to update the database to FB2.5 in ou production server (even if it a release, can not be worse than the actual FB2.1.4)

What build do you use ? The preferable is to use most current snapshot build, as it contains many fixes since RC2.

> it's run for one day and we receive this error :
>
> Sun Apr 11 08:50:47 2010
> Fatal lock manager error: invalid lock id (4550520), errno: 0

This is a bug. I never saw it by myself.

Do you have file "fb_lock_table.dump" at folder %ALLUSERSPROFILE%\Application Data\firebird ?

> Sun Apr 11 08:50:47 2010
> INET/inet_error: select in packet_receive errno = 10093
>
>
> Sun Apr 11 08:50:47 2010
> INET/select_wait: select failed, errno = 10093

WSANOTINITIALISED
10093

Successful WSAStartup not yet performed.
Either the application has not called WSAStartup or WSAStartup failed. The application may be accessing a socket that the current active task does not own (that is, trying to share a socket between tasks), or WSACleanup has been called too many times.

Of course, Firebird called WSAStartup. If this call is not successful, then even listener port will not be create and Firebird can't accept connections via TCP\IP.

It is suspicious that this error happens at the same moment as "invalid lock id".

> Sun Apr 11 08:50:47 2010
> SRVR_multi_thread/RECEIVE: error on main_port, shutting down

This is consequence of 10093 error.

> What do you thing can cause this error ? i never receice this error in FB2.1

Any chance you run second instance of Firebird ? It shouldn't lead to such errors but probably there is some unknown factor...

Regards,
Vlad





[Non-text portions of this message have been removed]