On 10 Jun 2009, at 08:32, Richard Wesley wrote:

> We have been seeing an intermittent problem with embedded Firebird
> 2.1.1 trying to open a local read-only database under Windows XP. The
> database has been opened read-only by multiple processes and
> periodically we get the following in our logs:
>
> --- FB Error
> ---------------------------------------------------------------
> File: db\FirebirdProtocol.cpp, Line: 2381
> Status: 335544373
> operating system directive CreateFile failed
> -The system cannot find the file specified.
> ----------------------------------------------------------------------------
>
> The line referenced is just calling isc_attach_database. Usually the
> call succeeds and the file is definitely there.
>
> The strange thing is that the Windows logging for the CreateFile call
> shows two calls, one failing and then one succeeding, but Firebird
> seems to not notice the second success!
>
> Does anyone know what might cause this?

After a little digging, it looks like the error is being generated in
ISC_map_file. I am suspicious now of gds__prefix_lock's ability to
come up with unique name in this situation...

Best regards,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html