I'm trying to help a client team diagnose a problem with an Interbase 6.01
server running on a Windows 2000 server. The app uses
Interclient/interserver from JSP pages via JRUN. I don't know any of the
specific versions/builds yet.

The log excerpt below shows several internal gds consistency checks. In
looking at the databases we noticed that forced writes was NOT turned on.
My questions are:

1) Could the fact that forced writes was not on alone be the root cause of
these types of problems?

2) At the end of the log there are several TCP/IP 10054 errors all with the
exact same timestamp. It is no likely at this time that there were several
concurrent sessions. Could the repeat of these log entries come from just
one connection?

Finally, We have also noticed nine interserver.exe processes running at the
same time, which looks like one is started for each session/connection. I
don't know interserver at all so my question is: Is this normal? Does
interserver create a new process for each JDBC connection/session?

KSGBUDSVR (Server) Mon Jan 07 15:59:40 2002
INET/inet_error: select in packet_receive errno = 10038

KSGBUDSVR (Server) Mon Jan 07 15:59:40 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Client) Mon Jan 07 16:02:46 2002
Guardian starting: C:\Program Files\Borland\InterBase\bin\ibserver.exe


KSGBUDSVR (Server) Mon Jan 07 16:05:26 2002
Database: D:\INTERB~1\DATABASE\KSGBUD06.GDB
internal gds software consistency check (cannot find record back version
(291))

KSGBUDSVR (Server) Mon Jan 07 16:05:26 2002
Database: D:\INTERB~1\DATABASE\KSGBUD06.GDB
internal gds software consistency check (cannot find record back version
(291))

KSGBUDSVR (Client) Mon Jan 07 16:28:05 2002
C:\Program Files\Borland\InterBase\bin\ibserver.exe: normal shutdown


KSGBUDSVR (Client) Mon Jan 07 16:30:09 2002
Guardian starting: C:\Program Files\Borland\InterBase\bin\ibserver.exe


KSGBUDSVR (Server) Mon Jan 07 16:33:19 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Mon Jan 07 17:01:43 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Mon Jan 07 18:57:23 2002
INET/inet_error: read errno = 10038

KSGBUDSVR (Server) Mon Jan 07 22:57:50 2002
INET/inet_error: read errno = 10038

KSGBUDSVR (Server) Tue Jan 08 10:31:33 2002
Database: D:\INTERB~1\DATABASE\KSGBUD06.GDB
Operation violates CHECK constraint BUDDATA_BUDGROUP_CC on view or table
BUDDATA
internal gds software consistency check (record disappeared (186))

KSGBUDSVR (Server) Tue Jan 08 14:31:51 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Tue Jan 08 14:31:51 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Tue Jan 08 14:31:51 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Tue Jan 08 14:31:51 2002
INET/inet_error: read errno = 10054

KSGBUDSVR (Server) Tue Jan 08 14:31:51 2002
INET/inet_error: read errno = 10054