Subject | Re: [firebird-support] Repeated database corruption |
---|---|
Author | Gustavo |
Post date | 2009-10-23T22:47:45Z |
I have just connected to this enterprise via terminal server to uninstall FB 2.1 CS and install FB 2.1 SS again. Before doing that I copied the database and checked it doing gfix -v -full and... I had the surprise that it was perfect. No errors! I repeated it many times and did it with different copies of the database. I also made a backup doing gbak -v -ignore -garbage -limbo and it did without any problem.
So I didn?t change FB and I left CS.
But, as you can see in the firebird.log of today at the end of this message, today they had many errors. Most of them were "INET/inet_error: read errno = 10054" and many were "internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)".
At approx. 10:30hs they had to restart the server to can access the database.
How can it be possible that firebird.log has this errors and now the database is good?
-----------------------
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:08:35 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:28 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:36 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:16:41 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:10 2009
Database: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: MMGESCOMEMPRESA
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
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:40 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
[Non-text portions of this message have been removed]
So I didn?t change FB and I left CS.
But, as you can see in the firebird.log of today at the end of this message, today they had many errors. Most of them were "INET/inet_error: read errno = 10054" and many were "internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)".
At approx. 10:30hs they had to restart the server to can access the database.
How can it be possible that firebird.log has this errors and now the database is good?
-----------------------
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:08:35 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:11:28 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:14:36 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:16:41 2009
Database: MMGESCOMEMPRESA
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: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:10 2009
Database: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: MMGESCOMEMPRESA
internal gds software consistency check (wrong record length (183), file: vio.cpp line: 1121)
SERVIDOR Fri Oct 23 10:18:37 2009
Database: MMGESCOMEMPRESA
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
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 13:13:49 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:47:45 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:49:00 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 15:56:16 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:40 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
SERVIDOR Fri Oct 23 17:51:48 2009
INET/inet_error: read errno = 10054
[Non-text portions of this message have been removed]