<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Alex,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">This now appears to be related to crossing a network domain.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The target I’ve been using is in a different network domain, but if I switch to a target in the same domain as the source then all is fine. Note that this new target is running the same Ingres version as the
old target. There may be some configuration differences between them, but I suspect it would be minor.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ve asked our network people for their opinions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Marty<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Martin Bowes [mailto:martin.bowes@ndph.ox.ac.uk]
<br>
<b>Sent:</b> 14 September 2017 15:37<br>
<b>To:</b> Alex Hanshaw; info-ingres@lists.planetingres.org<br>
<b>Subject:</b> Re: [Info-ingres] Weird copy timeout error E_LC0030_WRITE_SEND_FAIL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Alex,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’m going to have to do some more testing to flesh this out in detail.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">What I have at the moment is some weird combination of the delay and the filesize.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">At the moment with a 1000s pause a 175million row file fails the copy as indicated, a 150million row file does not fail.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">With a 10 second pause the 175million row file succeeds.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ll play with like to like versions tomorrow, and when that’s done I’ll raise an issue. I have a simple means of generating random data and a simple ESQL program which does the deed.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Marty<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Alex Hanshaw [<a href="mailto:Alex.Hanshaw@actian.com">mailto:Alex.Hanshaw@actian.com</a>]
<br>
<b>Sent:</b> 14 September 2017 14:47<br>
<b>To:</b> Martin Bowes; <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br>
<b>Subject:</b> RE: [Info-ingres] Weird copy timeout error E_LC0030_WRITE_SEND_FAIL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi Marty<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">The code check are looking for message types and these are all going to be established by looking at structures derived from message pointers.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Is this only happening when these two patch levels are used? Does the problem go away if both sides are at the same patch level?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I’m wondering if something changed a related structure and has cause an incompatibility that is not being correctly handled.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Alex<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> <a href="mailto:info-ingres-bounces@lists.planetingres.org">
info-ingres-bounces@lists.planetingres.org</a> [<a href="mailto:info-ingres-bounces@lists.planetingres.org">mailto:info-ingres-bounces@lists.planetingres.org</a>]
<b>On Behalf Of </b>Martin Bowes<br>
<b>Sent:</b> 14 September 2017 14:09<br>
<b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org">info-ingres@lists.planetingres.org</a><br>
<b>Subject:</b> [Info-ingres] Weird copy timeout error E_LC0030_WRITE_SEND_FAIL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have a job which runs on a host with ingres version II 10.2.0 (a64.lnx/100) + 15162.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It uses a vnode to connect to a database on another host which runs ingres version II 10.2.0 (a64.lnx/100) + 15151.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Having established the connection to the remote database it does some initial work and then must pause activity on that connection while work is being performed on other hosts/databases. After that work is completed the connection then
gets to do as follows:<o:p></o:p></p>
<p class="MsoNormal">drop table if exists targetable; /* Which works with no error */<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">create table targetable(<o:p></o:p></p>
<p class="MsoNormal"> a integer4 not null not default,<o:p></o:p></p>
<p class="MsoNormal"> b integer4 not null not default,<o:p></o:p></p>
<p class="MsoNormal"> c integer4 not null not default<o:p></o:p></p>
<p class="MsoNormal">) with nojournaling;<o:p></o:p></p>
<p class="MsoNormal">/* And this too works with no error. Note that the columns are all just plain old integers. Nothing fancy No blobs No nvarchar.<o:p></o:p></p>
<p class="MsoNormal">*/<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">copy table targetable(a=c0tab, b=c0tab, c=c0nl) from ‘a/raging/great/data/file’;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And on that last step we have recently started getting an error:
<o:p></o:p></p>
<p class="MsoNormal">E_LC0030_WRITE_SEND_FAIL GCA protocol service (GCA_SEND) failure with message type GCA_CDATA.<o:p></o:p></p>
<p class="MsoNormal">Internal service status E_GCfe06 -- Write to peer process failed; it may have exited. - System communication error: Connection reset by peer..Exiting session because of communications failure.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In the errlog on the target installation we see:<o:p></o:p></p>
<p class="MsoNormal">biota ::[39831 IIGCC, 13193 , 0000000000000002]: Thu Sep 14 13:15:24 2017 E_GC2820_CONN_FAIL_INFO Connection to node '::ffff:10.131.0.3', port '59824' for user 'ingres' failed: reason follows.<o:p></o:p></p>
<p class="MsoNormal">biota ::[39831 IIGCC, 13193 , 0000000000000002]: Thu Sep 14 13:15:24 2017 E_CLFE07_BS_READ_ERR Read from peer process failed; it may have exited.<o:p></o:p></p>
<p class="MsoNormal">biota ::[39831 IIGCC, 13193 , 0000000000000002]: System communication error: Connection reset by peer.<o:p></o:p></p>
<p class="MsoNormal">BIOTA ::[39278 , 13088 , 00007f4eacc6f180, scscopy.c:613 ]: Thu Sep 14 13:15:24 2017 E_SC022E_WRONG_BLOCK_TYPE Internal Protocol Error: SCF received block type 00000005 (5.) when expecting type 00000019
(25.).<o:p></o:p></p>
<p class="MsoNormal">BIOTA ::[39278 , 13088 , 00007f4eacc6f180, scscopy.c:614 ]: Thu Sep 14 13:15:24 2017 E_SC0250_COPY_OUT_OF_SEQUENCE A COPY data block was received when one was not expected (or not received when expected).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have managed to show that this is a weird ass timeout. The jobs pause has now breached 15minutes (where have I seen that number before). The really curious thing is that the connection is perfectly fine with anything other than a copy.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m working on a test case at the moment, but as it relies on a very large data file it’s a bit of a nuisance.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyone seen anything like this before?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Marty<o:p></o:p></p>
</div>
</body>
</html>