firebird-support - Re: ReadFile end-of-file errno = 109 and read errno = 10054

Subject	Re: ReadFile end-of-file errno = 109 and read errno = 10054
Author	olivier_olmer
Post date	2003-08-08T07:11:30Z

Hi,

The weird part about it is that this server is a backup server with
only a replication application running on the same machine. It
connection string is ib6backup:e:\database\trenthistory.gdb so I
assume it is using the tcp protocol.

So far as I can see it is the only user besides connecting via the
ibconsole.

If you look in the logfile you will see loosing a connection every
second once it occurs. It seems to me that the replication
application in combination with the dbms is causing the problem.

Once a month the replication application failed to insert one record.
When this occurs I see also this happening in the logfile. (About
150000 records are inserted and 100000 records are updated a day by
the replication program).

In the replication application we use ibx components and
transactions. We commit after 1000 records or when there is less work
to do at the end. Rollback is also used when exceptions are raised.
The insert fails some where in the middle. It not the last record
which is processed by the replication. And we do not get a exception
in this process in the replication application.

with kind regards,

Olivier Olmer

See part of the logfile below:
IB6BACKUP (Server) Thu Aug 07 08:34:49 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:50 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:51 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:51 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:51 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:52 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:52 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:52 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:53 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:54 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:54 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:54 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:54 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:54 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:55 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:55 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:55 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:55 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:55 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:56 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:57 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:57 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:57 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:58 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:58 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:59 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:34:59 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:00 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:01 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:01 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:01 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:01 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:01 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:02 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:03 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:03 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:03 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:04 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:04 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:05 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

IB6BACKUP (Server) Thu Aug 07 08:35:05 2003
WNET/wnet_error: ReadFile end-of-file errno = 109

looking in this newsgroup I found out that 109 has to do with loosing
named pipe connections and 10054 tcp connections. As you can see
--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:

> --- In firebird-support@yahoogroups.com, "olivier_olmer"
> <olivier_olmer@y...> wrote:
> > Hi,
> >
> > I see in the interbase.log file a lot of the same type of errors.
> > What could cause these errors? Can these errors cause a problem
> > writing an insert to the database? I am using firebird 1.02.
>
> Olivier, this error mean client machine did'nt close connection

but

> break it. Usually this is network problem or user aborted

application

> or pressed famous MS 3 buttons or something like this. It can

became

> performance problem if it is badly configured network, but it can't
> corrupt data if application properly use transactions (changes

which

> are valid only together are made in context of one transaction).
>
> Best regards, Alexander.