| Subject | Re: [firebird-support] Repeated database corruption |
|---|---|
| Author | Gustavo |
| Post date | 2009-10-23T13:56:51Z |
Well, yesterday I uninstalled FB 2.1 Super Server and installed FB 2.1 Client Server.
But unfortunately, today the problem is still there. So this change is not the solution. :-(
At the end of this message I will copy firebird.log from today. Yesterday at night I repaired the database and a gfix -v -full said it was OK.
The only other suggestion was to see if there is a network card failing. If this is like that, then... is there a way of detecting which one without replacing them one by one? In other words, when in firebird.log there is a message like "INET/inet_error: read errno = 10054", is there something I can configure somewhere so this message indicates the name of the client or the IP or some data indicating which client generates the error?
Any other idea of what may be causing this?
Thanks in advance
Gustavo
-----------------------
firebird.log 23/10/2009
-----------------------
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:08:35 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:08:35 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:28 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:28 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:36 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:36 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:16:41 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:16:41 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:18:10 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:10 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
But unfortunately, today the problem is still there. So this change is not the solution. :-(
At the end of this message I will copy firebird.log from today. Yesterday at night I repaired the database and a gfix -v -full said it was OK.
The only other suggestion was to see if there is a network card failing. If this is like that, then... is there a way of detecting which one without replacing them one by one? In other words, when in firebird.log there is a message like "INET/inet_error: read errno = 10054", is there something I can configure somewhere so this message indicates the name of the client or the IP or some data indicating which client generates the error?
Any other idea of what may be causing this?
Thanks in advance
Gustavo
-----------------------
firebird.log 23/10/2009
-----------------------
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:02:37 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:08:35 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:08:35 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:09:33 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:28 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:28 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:11:39 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:36 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:36 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:14:47 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:16:41 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:16:41 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:17:44 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:18:10 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:10 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: EGMMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 10:19:54 2009
INET/inet_error: read errno = 10054
----- Original Message -----
From: "Gustavo" <gusm@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, October 22, 2009 9:56 PM
Subject: Re: [firebird-support] Repeated database corruption
> Well, I have just uninstalled FB 2.1 SS and installed FB 2.1 CS. I did this
> connected to the server using terminal server.
>
> First it did not work, but I found in
> http://tracker.firebirdsql.org/browse/CORE-1406 that the problem was NOD32.
> I did what Dmitry said there: add fb_inet_server.exe to the exclusions of
> IMON in NOD32, I restart the server and now it works. But now the problem is
> that when I connect to the server I see a message from NOD32 saying it is
> not possible to start AMON.
>
> What should I do with this?
>
> ----- Original Message -----
> From: "Dimitry Sibiryakov" <sd@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, October 22, 2009 4:41 PM
> Subject: Re: [firebird-support] Repeated database corruption
>
>
>>> I did gstat -h with one database and I got the following. I don?t find
>>> anything called "data page cache" but I guess perhaps what I have to
>>> check is "Page buffers", which is 0. Is it right what I am saying?
>>
>> I'm not good in exact words. Yes, this is the same. 0 means that
>> value from firebird.conf will be used. That's good.
>>
>> SY, SD.
>>
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> 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
>>
>>
>>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
[Non-text portions of this message have been removed]