Dear vlad,

So about the bug in FB2.1.4 you can download the demo project on
ftp://ftp.arkadia.com/firebird/

the database is just come out from a restore (so it's frech and clean). you simply need to put the database on one computer and let it running for 2 or 3 days (wait that the database size grow around 11-12 GO) and after you will have some index in error ...

also the problem look like that is still present in Firebird 2.5 !

today i receive again this :


Thu Apr 15 12:28:27 2010
INET/inet_error: read errno = 10053


Thu Apr 15 13:36:26 2010
Fatal lock manager error: invalid lock id (2413696), errno: 0


Thu Apr 15 13:36:26 2010
INET/inet_error: select in packet_receive errno = 10093


Thu Apr 15 13:36:26 2010
INET/select_wait: select failed, errno = 10093


Thu Apr 15 13:36:26 2010
SRVR_multi_thread/RECEIVE: error on main_port, shutting down


after i decide to shuntdown all the client to copie the database to another harddrive to do some validation on it, but as soon as i restart the client i receive this on the server :

Thu Apr 15 18:25:23 2010
Access violation.
The code attempted to access a virtual
address without privilege to do so.
This exception will cause the Firebird server
to terminate abnormally.


Thu Apr 15 18:25:23 2010
INET/inet_error: select in packet_receive errno = 10093


Thu Apr 15 18:25:23 2010
INET/select_wait: select failed, errno = 10093


Thu Apr 15 18:25:23 2010
SRVR_multi_thread/RECEIVE: error on main_port, shutting down

after the server work again ok ...

so i finally launch the validation on the copie of the database and i receive this time this error :

Summary of validation errors

Number of record level errors : 1
Number of index page errors : 24
Number of database page errors : 54

:( :( :( :(

i need to say that this bug become to destroy my life :( i need a super hero :(


Thanks for all Vlad !!!!
stéphane

--- In firebird-support@yahoogroups.com, "hvlad" <hvlad@...> wrote:
>
> > First the demo application for fb2.1.4 will be available this afternoon...
>
> If it is ready i'll be glad to try it.
>
>
> > > What build do you use ? The preferable is to use most current snapshot build, as it contains many fixes since RC2.
> >
> > Hm, i use the build on firebirdsql.org (RC2)
> > where i can download the current snapshot?
>
> At the same site, see http://www.firebirdsql.org/download/snapshot_builds/
>
> > some time ago someone say me that the rc3 will be available very soon (in one or 2 weeks).. is it still so ?
>
> We still make some additional tests on it.
>
>
> > YES, their is all this file :
> >
> > 04/11/2010 08:50 AM 65,536 fb_event_0ae46cbc000003002a000000
> > 04/11/2010 08:50 AM 1,048,576 fb_lock_0ae46cbc000001002b000000
> > 04/12/2010 02:27 AM 6,291,456 fb_lock_0ae46cbc000003002a000000
> > 04/11/2010 08:50 AM 1,048,576 fb_lock_97bae51a0000020098e70000
> > 04/11/2010 08:50 AM 5,640,728 fb_lock_table.dump
> > 04/11/2010 09:47 AM 1,048,576 fb_monitor_0ae46cbc000003002a000000
> > 04/11/2010 08:50 AM 276 fb_trace
> > 04/10/2010 09:05 AM 0 fb_trace_m67kh4
> > 04/11/2010 08:50 AM 0 fb_trace_mjmhw5
> > 04/12/2010 10:19 AM 0 s
> >
> > it's can help you ?
>
> Very good. Can i look at fb_lock_table.dump (and firebird.log too) ?
> Also, i see you used events ? Just for info :)
>
>
> > > It is suspicious that this error happens at the same moment as "invalid lock id".
> >
> > yea ;) but the question is what cause the other
> > invalid lock id cause the WSANOTINITIALISED
> > or the WSANOTINITIALISED cause the invalid lock id ?
>
> There could be race condition in INET code at process shutdown. I.e. WSACleanup() was called before all existing connections disconnected.
> Process shutdown happens because of "invalid lock id" error.
> It (INET errors) seems for me as minor issue as it doesn't prevent process shutdown and hurts nothing. Anyway i'll investigate it.
>
>
> Regards,
> Vlad
>