| Subject | Re: [firebird-support] Re: ReadFile end-of-file errno = 109 and read errno = 10054 |
|---|---|
| Author | Paul Schmidt |
| Post date | 2003-08-08T12:48:58Z |
On Fri, 2003-08-08 at 03:11, olivier_olmer wrote:
things, but the software isn't.
In each of the following cases, you want to swap with a part that you
know works, there is nothing worse then swapping a part with a bad one,
swapping directly with another machine is always helpful, in that if
that machine then stops working, then you have a known bad part, which
should be replaced with a new part. I always mark the bad ones or
discard them completely. Once you have determined a part is good, then
put it back.
Network cable, don't trust cable inside walls, mice have been known to
chew through cables buried inside walls. Switch the box to machine
cables, with known good ones, if that doesn't fix it, dig out your 20m
emergency cable, and route it to another jack that you know is working.
Swap that jack (the one that works) on the hub/router/port with the one
that was causing problems, to make sure it isn't a dead port.
Router/Hub/Switch port, try a different port, in that the
router/hub/switch may have a dying port.
Network card drivers, try reloading the drivers, also check to see if
there are newer drivers for that card.
Network card, cards sometimes die.
One of these four should eliminate the problem.
Paul
> Hi,It's probably a network problem, Windows can be fairly oblivious to such
>
> 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.
things, but the software isn't.
In each of the following cases, you want to swap with a part that you
know works, there is nothing worse then swapping a part with a bad one,
swapping directly with another machine is always helpful, in that if
that machine then stops working, then you have a known bad part, which
should be replaced with a new part. I always mark the bad ones or
discard them completely. Once you have determined a part is good, then
put it back.
Network cable, don't trust cable inside walls, mice have been known to
chew through cables buried inside walls. Switch the box to machine
cables, with known good ones, if that doesn't fix it, dig out your 20m
emergency cable, and route it to another jack that you know is working.
Swap that jack (the one that works) on the hub/router/port with the one
that was causing problems, to make sure it isn't a dead port.
Router/Hub/Switch port, try a different port, in that the
router/hub/switch may have a dying port.
Network card drivers, try reloading the drivers, also check to see if
there are newer drivers for that card.
Network card, cards sometimes die.
One of these four should eliminate the problem.
Paul
>
> 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.
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>