> Hello
>
> I have Firebird SuperServer 1.5 installed in a dual processor machine
> with Windows 2000 Server. The CPU affinity is set to 1.
>
> I have two separated processes accessing the database and sometimes
> when one of the processes crashs the database file grows from 150Mb to
> 1Gb and the result file is corrupted. Each process has 16 connections
> opened to the database in different threads.
> This problem does not happen in all machines.
>
> Do you have any ideia why this happen? Because each time this happens
> I loose all data.
>
> Thanks in advanced.
>
> Elisabete

do you have forced writes on this db set to ON? if not then do it and see if
you get the same result. I would think not.
IF you do have forced writes set to ON, then I think you will need to tell
us more about whta these processes are doing. If it's always the same
process which crashes, then let's talk more about that one.
When it crashes, do you still see CPU activity running on that
process/thread?
The process whcih crashes, is it dealing with inserts? or are all processes
only selects?
You can see there are is a lot more info to provide.
Alan