> Hello,
>
> My server is again crached ! everthing on the server was frozen (all
> the fb_inet_server.exe was without any activity at all). no other
> choice than restart the server ! also some index was corrupted. this is
> a serious bug as it's appear regularly and especially we don't do
> anything extraordinary on our database !
>
> when all the connection froze the activity was :
>
> * FB 2.1.4 (vlad) classic server
>
> * Windows 2008 R2 dedicated to firebird, 32 go of memory (10Go free
> on the task manager).
>
> * the database is around 20GO, paze size 8ko
>
> * around 30 fb_inet_server connection. most of them doing only some
> select
>
> * some index update intensive Insert/update SQLs was just (really just)
> committed (with success, the api return ok) when the server crash.
> around 2000 row was updated on some table with lot of index in it
>
> * 28 hours before the crash, more than 12 000 000 row was deleted and
> inserted in somes tables with lot of index in it (same table as
> before).
>
> * one process was doing for more than severals hours a sweep of the
> database
>

you mention API.. what language are you using? what connection components?
What UDF library?

Alan