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

>
>
> My firebird stops sometimes, with the next error (copied from the
> firebird.log):
> "
> AKHSQL (Server) Tue Jan 10 09:33:28 2006
> INET/select_wait: select failed, errno = 0
>
> AKHSQL (Server) Tue Jan 10 09:33:28 2006
> SRVR_multi_thread/RECEIVE: error on main_port, shutting down
>
> AKHSQL (Server) Tue Jan 10 09:47:56 2006
> Shutting down the Firebird service with 42 active connection
> (s) to 1 database(s)
>
> AKHSQL (Client) Tue Jan 10 09:47:56 2006
> C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe:
> normal shutdown
>
> AKHSQL (Server) Tue Jan 10 09:47:56 2006
> The database D:\ALFA\TIR\DAT\F2005\F2005.GDB was being
> accessed when the server was shutdown
>
> AKHSQL (Client) Tue Jan 10 09:47:56 2006
> Control services error 1061
>
> AKHSQL (Client) Tue Jan 10 09:47:57 2006
> Guardian starting: C:\Program Files\Firebird\Firebird_1_5
> \bin\fbserver.exe
>
> "
>
> I restart firebird guardian and everything works fine. It happens
> mostly once a day, when many user use the server the same time. I
> don't know what might be the reason, what routins are causing this.
> Can it happen when two or more user use the same part of the program?
> Maybe an error in the udf?

Could be.

UDFs MUST be made threadsafe with SuperServer. I don't believe this is
a problem with classic server. Perhaps you could try and use classic
server as a test. If this turns out to be correct, you need to locate
the UDF that is not threadsafe, and make it so.

Adam

>
> If someone needs the udf or the configuration, i can send it in
> private mail.
>