off topic:
------------
I like it how on this newsgroup the first assumption is always user
error :) I mean no disrespect to the very experienced and helpful
proffesionals that take their time to patrol this group.
-------------

on topic:
--------------
I have had a similar issue.

I filed a reproducible test-case into the Firebird tracker:
http://tracker.firebirdsql.org/browse/CORE-5

Here is how I got around my issue:

1. Make sure that you are not updating the same record more than once
in a single transaction.

2. Make sure that you dont have triggers and/or stored procedures
that call one another, creating a "deep" stack of procedure calls.
These "deep" call-stacks mixed with a lot of concurrent load, is
how my test-case duplicates this issue.


let us know if these suggestions fixed your problem.


thanks,

stan

--- In firebird-support@yahoogroups.com, "gstegehuis" <gstegehuis@...>
wrote:

>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@> wrote:
> >
> > At 08:56 PM 19/10/2006, you wrote:
> >
> > > >
> > > > At 06:47 PM 19/10/2006, you wrote:
> > > > >Maybe once a month I find this message in the log file:
> > > > >
> > > > >C093 (Server) Thu Oct 19 08:15:48 2006
> > > > > Database: E:\DATABASE\CBSFUNGI.FDB
> > > > > internal gds software consistency check (invalid SEND
> > >request (167))
> > > > >
> > > > >After that all accesses to the database fail, because the

database

> > > > >file 'is locked by another process'.
> > > >
> >
> > --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@>

wrote:

> >
> > > > Two possibilities are the following:
> > > >
> > > > 1)
> >
> > > > 2)
> >
> > 3) Are you using the Named Pipes protocol by any chance? It's
> > limited to 10 connections total in XP. Solution here would be to use
> > TCP/IP instead and see whether the problem goes away.
> >
>
> TCP/IP is used
>
> > 4) Anti-virus program or other security watchdog utility (such as
> > Nessus) or a filesystem backup utility that has extraordinary rights
> > to override file locks?
> >
> Nothing special I think, but I will check all processes running on the
> server.
> > Can't think of any others.
> >
> > ./heLen
> >
> Thanks,
> Gerrit
>