Subject | Re: [firebird-support] Problems with the service of FireBird Server |
---|---|
Author | Gustavo |
Post date | 2009-04-02T14:25:35Z |
Thanks Anderson and Gabor for your tips!
I copy some portions of firebird.log. They are of three times when the
problem occured yesterday. I don´t understand exactly the meaning of the
log, but in each portion I see that first there is a "select failed", then
the next (inmediatly) says "error on main_port, shutting down" and then, a
few minutes later, when it says "Shutting down the Firebird service" I guess
that is the moment when I shut down the service to restart it.
Perhaps with this information any of you can tell me what may be causing the
"shutting down".
TBASNT02 (Server) Wed Apr 01 09:14:00 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 09:14:00 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 09:20:38 2009
Shutting down the Firebird service with 63 active connection(s) to 6
database(s)
.........................
TBASNT02 (Server) Wed Apr 01 14:31:01 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 14:31:01 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 14:52:37 2009
Shutting down the Firebird service with 62 active connection(s) to 9
database(s)
.........................
TBASNT02 (Server) Wed Apr 01 15:55:20 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 15:55:20 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 16:04:00 2009
Shutting down the Firebird service with 63 active connection(s) to 6
database(s)
I copy some portions of firebird.log. They are of three times when the
problem occured yesterday. I don´t understand exactly the meaning of the
log, but in each portion I see that first there is a "select failed", then
the next (inmediatly) says "error on main_port, shutting down" and then, a
few minutes later, when it says "Shutting down the Firebird service" I guess
that is the moment when I shut down the service to restart it.
Perhaps with this information any of you can tell me what may be causing the
"shutting down".
TBASNT02 (Server) Wed Apr 01 09:14:00 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 09:14:00 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 09:20:38 2009
Shutting down the Firebird service with 63 active connection(s) to 6
database(s)
.........................
TBASNT02 (Server) Wed Apr 01 14:31:01 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 14:31:01 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 14:52:37 2009
Shutting down the Firebird service with 62 active connection(s) to 9
database(s)
.........................
TBASNT02 (Server) Wed Apr 01 15:55:20 2009
INET/select_wait: select failed, errno = 0
TBASNT02 (Server) Wed Apr 01 15:55:20 2009
SRVR_multi_thread/RECEIVE: error on main_port, shutting down
TBASNT02 (Server) Wed Apr 01 16:04:00 2009
Shutting down the Firebird service with 63 active connection(s) to 6
database(s)
----- Original Message -----
From: "Gabor Boros" <gaborboros@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, April 02, 2009 10:16 AM
Subject: Re: [firebird-support] Problems with the service of FireBird Server
> Hi,
>
> What you see in firebird.log and eventlog when the problem happens?
> Every network hardware working perfectly? E.g. NIC in the server or
> a switch without an UPS(or switch with a not working UPS).
> I don't know the source of your problem. I just have tips.
>
> Gabor
>
> Gustavo írta:
>> Nobody answers this message. Perhaps it didn´t arrive to the group. So I
>> resend it.
>>
>> Does anyone have any idea of which may be the reason of the problem I
>> tell
>> you?
>>
>> ----- Original Message -----
>> From: "Gustavo" <gusm@...>
>> To: <firebird-support@yahoogroups.com>
>> Sent: Wednesday, April 01, 2009 4:44 PM
>> Subject: [firebird-support] Problems with the service of FireBird Server
>>
>>
>> Hello:
>>
>> I have an application in Delphi which uses FireBird 2.0.1 Superserver.
>>
>> It is installed in an enterprise which has 8 users in a local network and
>> 5
>> users in another building. These 5 users, use the application accesing
>> via
>> Terminal Server to the PC where the application is installed since 2
>> years
>> ago.
>>
>> The application and the FDB files are in a PC which, till 2 months ago
>> had
>> Windows 2003 Server. Then they changed this to Windows XP (¡don´t ask why
>> please!). This worked fine during 2 months, but this week it started a
>> problem: 5, 6 or 7 times a day, every user (in the local network or by
>> terminal server) looses contact with the database at the same time. When
>> this happens, I check the Service Control Manager and I see that the
>> service
>> "Firebird Server - DefaultInstance" is started. Then, I stopped it (I get
>> an
>> error 1067 but it stops), I started it again, and then every user can
>> connect again to the database... till the next time it fails.
>>
>> Does anyone knows what may be happening?
>>
>> Thanks in advance
>>
>> Gustavo
>>
>> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>