firebird-devel

[Firebird-devel] database terminated abnormally

[lmf <lm...@yg...>]

  These days the abnormally terminated database annoyed me greatly, how can
I solve the problem?what produce the problem?

  The following is the firebird.log:


IBM1 (Client) Tue Jan 04 07:51:36 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Wed Jan 05 08:28:14 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Wed Jan 05 08:28:15 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Wed Jan 05 16:30:29 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Wed Jan 05 16:30:31 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Server) Thu Jan 06 10:47:42 2005
 SERVER/process_packet: don't understand packet type 66

IBM1 (Client) Fri Jan 07 08:00:18 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Fri Jan 07 08:00:19 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Fri Jan 07 09:07:49 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Fri Jan 07 09:07:50 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Server) Sat Jan 08 12:41:01 2005
 SERVER/process_packet: don't understand packet type 66

IBM1 (Client) Sat Jan 08 16:54:53 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Sat Jan 08 16:54:53 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Sun Jan 09 11:43:36 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Sun Jan 09 11:43:37 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Server) Mon Jan 10 09:22:35 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Server) Mon Jan 10 09:22:37 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Server) Mon Jan 10 09:24:09 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Server) Mon Jan 10 09:24:11 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Server) Mon Jan 10 09:25:35 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Server) Mon Jan 10 09:25:37 2005
 INET/INET_connect: getservbyname failed, error code = 0

IBM1 (Client) Mon Jan 10 14:11:01 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Mon Jan 10 14:11:02 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Tue Jan 11 07:57:07 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Tue Jan 11 07:57:08 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe


IBM1 (Client) Thu Jan 13 10:06:11 2005
 C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)


IBM1 (Client) Thu Jan 13 10:06:12 2005
 Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe

Re: [Firebird-devel] database terminated abnormally

[Marco K. <Mar...@Tf...>]

Hi
Can you be more specific?
OS, Firebird version, ecc..


Marco Kregar

mar...@Fi...
www.FirebirdSQL.it
"over the bench the goat sings, under the bench the goat dies"

Re: [Firebird-devel] database terminated abnormally

[lmf <lm...@yg...>]

> Hi
> Can you be more specific?
> OS, Firebird version, ecc..
>
>
> Marco Kregar
WIN2000 ADV SERVER
FB1.52
Four databases, two frequently used and is big(file size of one database is
more than 4G)

Re: [Firebird-devel] database terminated abnormally

[lmf <lm...@yg...>]

  My reply has sent for nearly two days, but I still cannot see it, maybe
because I am not registered user and cannot send my message directly.

  Now I repeat it as follows:
  OS:Windows2000 advanced server
  FB version:FB1.52 SuperServer
  Machine:IBM 7100, 2CPU 1GRAM
  Database:four database file, one file size is larger than 4G

  Who can help me? Everyday include today the FB server terminated
abnormally. There are more than one hundred client connected, I don not know
which database file is relative to the disaster.
  Please help me!!
""Marco Kregar"" <Mar...@Tf...> wrote in message
news:cs8i1f$mft$1...@ne......
> Hi
> Can you be more specific?
> OS, Firebird version, ecc..
>
>
> Marco Kregar
>
> mar...@Fi...
> www.FirebirdSQL.it
> "over the bench the goat sings, under the bench the goat dies"
>
>
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
>

Re: [Firebird-devel] database terminated abnormally

[Helen B. <he...@tp...>]

At 01:29 PM 17/01/2005 +0800, you wrote:
>   My reply has sent for nearly two days, but I still cannot see it, maybe
>because I am not registered user and cannot send my message directly.

Did you know that this is not a support list?

Post your question to firebird-support and someone will try to help you.

Helen
(Mail admin)

Re: [Firebird-devel] database terminated abnormally

[Alex P. <pe...@in...>]

lmf wrote:
>   My reply has sent for nearly two days, but I still cannot see it, maybe
> because I am not registered user and cannot send my message directly.
> 
>   Now I repeat it as follows:
>   OS:Windows2000 advanced server
>   FB version:FB1.52 SuperServer
>   Machine:IBM 7100, 2CPU 1GRAM
>   Database:four database file, one file size is larger than 4G
> 
>   Who can help me? Everyday include today the FB server terminated
> abnormally. There are more than one hundred client connected, I don not know
> which database file is relative to the disaster.
>   Please help me!!

I don't know who asked for specific CPU/RAM values. Anyway - such box 
must be able to serve 4G database w/o problems.
1. Try to run: gfix -v -f for all 4 databases (users must be 
disconnected for this to be done). You must fix any errors if they present.
2. Sometimes problems like described by you happen due to buggy UDFs. Do 
you use UDFs? Standard or your own?
3. Try Classic instead of Super. This will be useful at least because 
this will not drop all users connection (only one that causes firebird 
to AV) when single process dies, and help you troubleshoot which 
database causes problems and at what particular place in your client 
software.
4. Try linux instead of w2k.

A.

Re: [Firebird-devel] database terminated abnormally

[Marco K. <Mar...@Tf...>]

This is an support question, plz follow-up to firebird support list.
-- 
Marco