Re: [firebird-support] Getting INET/inet_error: read errno = 10054

[Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]]

Thanks. Very usefull feedback.

27. aug. 2016 8.45 a.m. skrev "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" :

>
>
> 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 0023:0004
>
> 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
> 
>

Re: [firebird-support] Getting INET/inet_error: read errno = 10054

[monteropetronila...@yahoo.com [firebird-support]]

Great, Thanks! 

Sent from Yahoo Mail. Get the app 

On Saturday, August 27, 2016 7:45 AM, "Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support]"  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 0023:0004

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:#ff;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 

Re: [firebird-support] Getting INET/inet_error: read errno = 10054

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

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.489648583083   
> 648563078   649285961
> 2 -1  1   0   1   26  0023:0004

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

[firebird-support] Getting INET/inet_error: read errno = 10054

[Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]]

Hi

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?

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 0023:0004


Best regards

Jardar