Thanks. Very usefull feedback. 27. aug. 2016 8.45 a.m. skrev "Mark Rotteveel [email protected] [firebird-support]" <[email protected]>:
> > > On 26-8-2016 22:27, Jardar Maatje [email protected] > [firebird-support] wrote: > > We are running fb 2.5.6 and are getting the INET erorr regularily. > > The error has been there before as well with earlier versions of fb. > > > > Is this something I should be conserned about and what can I do about it? > > Error 10054 is "Connection reset by peer", which means that the server > tried to do something with the network connection from a client, and it > was already closed. This can happen due to network problems, or the > application was terminated abruptly. However the usual main cause is > that connections aren't properly closed, either by your applications (eg > you never close connections, and they are eventually terminated by the > garbage collector), or maybe by the driver you use (eg because its > implementation of a connection close is wrong). > > > Another issue is that when I list transactions I have a transaction that > > is "stuck" back in time but that has no attachemnt associated with it. > > Is this normal? > > > > This is the row from the MON$TRANSACTIONS that have no corresponding > > MON$ATTACHMENTS row: > > 648583083 84322 0 26.08.2016, 19:11:47.489 648583083 648563078 649285961 > > 2 -1 1 0 1 26 00000023:00000004 > > Assuming the normal order of columns in MON$ATTACHMENTS: > This is transaction 648583083 of attachment 84322, in state 0 (active), > it has READ_COMMITTED_VERSION isolation, wait without timeout (AFAIK), > read-only, no autocommit, with autoundo. > > Maybe the associated attachment got terminated abruptly and Firebird > hasn't yet detected this and rolled back the transaction (or in this > case as it is read only: committed it). If you want to speed it up: a > restart of the Firebird server process would mark it as such IIRC. > > Mark > -- > Mark Rotteveel > >
