[Info-ingres] [EXTERNAL] Is Ingres supposed to rollback in case of the connection dropping?

[Allan Biggs]

Nikos,

I have just remembered something Putty lets you do this 
Sending Null packets - until I set this my sessions were closing whether 
connected to Ingres or not . 

notice I have ticked the TCP_keepalive option 

Set at 600 it very rarely loses connection over Putty - remember I am over 
Aventail  VPN connecting into the company network
It would be nice if IngresNet had an option like this. 

maybe this will help 
Allan 




From:   Nikos Vaggalis <nikos.vaggalis at gmail.com>
To:     Allan Biggs <Allan.Biggs at GBR.dupont.com>
Date:   16/10/2018 18:33
Subject:        Re: [EXTERNAL] [Info-ingres] Is Ingres supposed to 
rollback in case of the connection dropping?



I connect from my PC to the local Linux server through a terminal 
application and from there I ssh to another Linux machine where I run the 
abf application

On Tue, 16 Oct 2018, 11:56 Allan Biggs, <Allan.Biggs at gbr.dupont.com> 
wrote:
As a matter of interest are you connected over VPN when these 'drops' 
occur? 
Allan 



From:        nikosv <nikos.vaggalis at gmail.com> 
To:        info-ingres at lists.planetingres.org 
Date:        04/10/2018 11:05 
Subject:        [EXTERNAL] [Info-ingres] Is Ingres supposed to rollback in 
case of the        connection dropping? 
Sent by:        info-ingres-bounces at lists.planetingres.org 



In an ABF application I sometimes see transactions being half-done.For an 
insert to one table and then an insert to another table within the same 
ABF session, having the connection dropped (I guess in between), or some 
other Ingres internal exception happening, I find that the first insert 
completed successfully but the second not (as it should,since this point 
was never reached).Should Ingres had rolled back so that both the 
statements fail?

The session is run with autocommit off, the commit submitted only after 
both of the inserts.Also there's checking iierror with 
inquire_ingres (h_rowcount = rowcount, h_errorno = errorno), after each 
sql statement but I guess that only has an effect as long as there's no 
out of the ordinary exceptions ?
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.planetingres.org_mailman_listinfo_info-2Dingres&d=DwICAg&c=zRqMG_fghhK--2M6Q5UUdA&r=NR3Ih16COg3iVzf1V6AnysHgZxJHe-pkPnBl5lbRPSY&m=pqrvPh4_rNY40V3eR29m8OKsNjzdSmirEwQB-WRGtdU&s=jIlBaDw4ARMgUsfUo76B6ctSCr4sNjxmEjU9auPsQ4w&e=




This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.
Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean
          http://www.DuPont.com/corp/email_disclaimer.html
--------------------------------------
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean
------------------------------------
http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181022/feb58f81/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 22429 bytes
Desc: not available
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20181022/feb58f81/attachment.gif>