Thanks, I will try to take a look at the hardware.

With kind regards,

Olivier Olmer
--- In firebird-support@yahoogroups.com, Paul Schmidt
<wogsterca@y...> wrote:

> On Fri, 2003-08-08 at 03:11, olivier_olmer wrote:
> > 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.
>
> It's probably a network problem, Windows can be fairly oblivious to

such

> 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/

> >