Great, Thanks! Sent from Yahoo Mail. Get the app
On Saturday, August 27, 2016 7:45 AM, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com> wrote: On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no [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 #yiv0999123258 #yiv0999123258 -- #yiv0999123258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0999123258 #yiv0999123258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0999123258 #yiv0999123258ygrp-mkp #yiv0999123258ads {margin-bottom:10px;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad {padding:0 0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad p {margin:0;}#yiv0999123258 #yiv0999123258ygrp-mkp .yiv0999123258ad a {color:#0000ff;text-decoration:none;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc {font-family:Arial;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc #yiv0999123258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ygrp-lc .yiv0999123258ad {margin-bottom:10px;padding:0 0;}#yiv0999123258 #yiv0999123258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0999123258 #yiv0999123258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0999123258 #yiv0999123258activity span {font-weight:700;}#yiv0999123258 #yiv0999123258activity span:first-child {text-transform:uppercase;}#yiv0999123258 #yiv0999123258activity span a {color:#5085b6;text-decoration:none;}#yiv0999123258 #yiv0999123258activity span span {color:#ff7900;}#yiv0999123258 #yiv0999123258activity span .yiv0999123258underline {text-decoration:underline;}#yiv0999123258 .yiv0999123258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0999123258 .yiv0999123258attach div a {text-decoration:none;}#yiv0999123258 .yiv0999123258attach img {border:none;padding-right:5px;}#yiv0999123258 .yiv0999123258attach label {display:block;margin-bottom:5px;}#yiv0999123258 .yiv0999123258attach label a {text-decoration:none;}#yiv0999123258 blockquote {margin:0 0 0 4px;}#yiv0999123258 .yiv0999123258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0999123258 .yiv0999123258bold a {text-decoration:none;}#yiv0999123258 dd.yiv0999123258last p a {font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0999123258 dd.yiv0999123258last p span.yiv0999123258yshortcuts {margin-right:0;}#yiv0999123258 div.yiv0999123258attach-table div div a {text-decoration:none;}#yiv0999123258 div.yiv0999123258attach-table {width:400px;}#yiv0999123258 div.yiv0999123258file-title a, #yiv0999123258 div.yiv0999123258file-title a:active, #yiv0999123258 div.yiv0999123258file-title a:hover, #yiv0999123258 div.yiv0999123258file-title a:visited {text-decoration:none;}#yiv0999123258 div.yiv0999123258photo-title a, #yiv0999123258 div.yiv0999123258photo-title a:active, #yiv0999123258 div.yiv0999123258photo-title a:hover, #yiv0999123258 div.yiv0999123258photo-title a:visited {text-decoration:none;}#yiv0999123258 div#yiv0999123258ygrp-mlmsg #yiv0999123258ygrp-msg p a span.yiv0999123258yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0999123258 .yiv0999123258green {color:#628c2a;}#yiv0999123258 .yiv0999123258MsoNormal {margin:0 0 0 0;}#yiv0999123258 o {font-size:0;}#yiv0999123258 #yiv0999123258photos div {float:left;width:72px;}#yiv0999123258 #yiv0999123258photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0999123258 #yiv0999123258photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0999123258 #yiv0999123258reco-category {font-size:77%;}#yiv0999123258 #yiv0999123258reco-desc {font-size:77%;}#yiv0999123258 .yiv0999123258replbq {margin:4px;}#yiv0999123258 #yiv0999123258ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0999123258 #yiv0999123258ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0999123258 #yiv0999123258ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0999123258 #yiv0999123258ygrp-mlmsg select, #yiv0999123258 input, #yiv0999123258 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0999123258 #yiv0999123258ygrp-mlmsg pre, #yiv0999123258 code {font:115% monospace;}#yiv0999123258 #yiv0999123258ygrp-mlmsg * {line-height:1.22em;}#yiv0999123258 #yiv0999123258ygrp-mlmsg #yiv0999123258logo {padding-bottom:10px;}#yiv0999123258 #yiv0999123258ygrp-msg p a {font-family:Verdana;}#yiv0999123258 #yiv0999123258ygrp-msg p#yiv0999123258attach-count span {color:#1E66AE;font-weight:700;}#yiv0999123258 #yiv0999123258ygrp-reco #yiv0999123258reco-head {color:#ff7900;font-weight:700;}#yiv0999123258 #yiv0999123258ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ov li a {font-size:130%;text-decoration:none;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0999123258 #yiv0999123258ygrp-sponsor #yiv0999123258ov ul {margin:0;padding:0 0 0 8px;}#yiv0999123258 #yiv0999123258ygrp-text {font-family:Georgia;}#yiv0999123258 #yiv0999123258ygrp-text p {margin:0 0 1em 0;}#yiv0999123258 #yiv0999123258ygrp-text tt {font-size:120%;}#yiv0999123258 #yiv0999123258ygrp-vital ul li:last-child {border-right:none !important;}#yiv0999123258