<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
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:12.0pt;
font-family:"Times New Roman",serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-GB;}
span.m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text
{mso-style-name:m_-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Paul,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I think you’re onto something here.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I extended the search to include ‘End Mini’ and looked for odd numbers in the counts. I took the odd numbers to mean we had an open
transaction of some type.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">The E_DM errors start once the number of open transactions crosses a boundary between 2046 and 2060.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I’ll see if I can generate these things at will.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Marty
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Paul White <paul.white@shift7solutions.com.au>
<br>
<b>Sent:</b> 05 May 2021 13:46<br>
<b>To:</b> Martin Bowes <martin.bowes@ndph.ox.ac.uk><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thanks. I will check back tomorrow.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Wed, 5 May 2021, 10:41 pm Martin Bowes, <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi Paul,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">No Mini found. But I suspect I’m going to have to identify a specific time at which we start tripping
these errors and then try to sneak up on it.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Marty
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Paul
White <<a href="mailto:paul.white@shift7solutions.com.au" target="_blank">paul.white@shift7solutions.com.au</a>>
<br>
<b>Sent:</b> 05 May 2021 13:29<br>
<b>To:</b> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Sorry this is brief. In the audit i have these<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<pre style="white-space:pre-wrap">End Mini: Transaction Id 00005ea51393b6de<o:p></o:p></pre>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Each has a unique txn id<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">My audit has about 450 before the -e time.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">One begin, 450 mini no end<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
<div>
<pre style="white-space:pre-wrap"> <o:p></o:p></pre>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Wed, 5 May 2021, 10:17 pm Martin Bowes, <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Yes all 2s. So all Begins had an End.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Define a minitransaction.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Marty</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Paul
White <<a href="mailto:paul.white@shift7solutions.com.au" target="_blank">paul.white@shift7solutions.com.au</a>>
<br>
<b>Sent:</b> 05 May 2021 13:12<br>
<b>To:</b> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Did they all have a 2 at the front? How about mini transactions?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Wed, 5 May 2021, 10:05 pm Martin Bowes, <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">On an auditdb run which succeeded as it was limited using a –e flag, your bit of egrep produced a file
with </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">20220 entries.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Which is comfortingly a lot more than 2048.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Marty
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Paul
White <<a href="mailto:paul.white@shift7solutions.com.au" target="_blank">paul.white@shift7solutions.com.au</a>>
<br>
<b>Sent:</b> 05 May 2021 12:56<br>
<b>To:</b> Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>><br>
<b>Cc:</b> Ingres and related product discussion forum <<a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.planetingres.org</a>><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">I would be interested in seeing results from:<o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> egrep 'End : |Begin :' auditfile | awk '{print $5}' | sort | uniq -c | sort | more<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> It should have all the open transactions at the top if i did this right on my phone.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">On Wed, 5 May 2021, 9:13 pm Martin Bowes, <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank">martin.bowes@ndph.ox.ac.uk</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks Paul, that’s very interesting intel.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">2048 seems a low number in this day and age. Did they hint that this may be bumped or configurable
in a later release?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Marty</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Paul
White <<a href="mailto:paul.white@shift7solutions.com.au" target="_blank">paul.white@shift7solutions.com.au</a>>
<br>
<b>Sent:</b> 05 May 2021 12:06<br>
<b>To:</b> <a href="mailto:info-ingres@lists.planetingres.org" target="_blank">info-ingres@lists.planetingres.org</a><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p>From case 1176237<o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"><i>Actually, it is not strictly "simultaneous" transactions in terms of transactions that were running at the same time and not committed (as I initially
thought and tried to build with a test case). The 2048 limitation is rather transactions to be processed in one auditdb run which is also why the message disappears when using -e/-b limiting the data to be processed.</i></span><o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt"> <o:p></o:p></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>I too would be interested to hear what the transaction limit was!<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Marty<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Did they mention what the limit is? <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Roy<o:p></o:p></pre>
</blockquote>
<p> <o:p></o:p></p>
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">The comment doesnt make sense because my daily auditdb sometimes records over 100k transactions.
</span><o:p></o:p></p>
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">I haven't returned to the implications of the comment because in my case the problem started on the DR server running incremental rollforward on journals
I had collected from two different instances. It was SIGSEGV TUPLE_MISMATCH and all sorts of errors, errlog filled the disk yada yada. At the root of the problem was a table which was originally created unjournalled and was not replicating properly.
</span><o:p></o:p></p>
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">As part of the issue, I found auditdb had stopped recording the Begin of transactions. I think it is in the middle of sysmod.</span><o:p></o:p></p>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">Begin : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.75 Username ingres</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Fcreate : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Modify : Transaction Id 00005ea5138c69af Id (225,0) Table [ii_vqtables ,$ingres ]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Update/Replace : Transaction Id 00005ea5138c69af Id (1,0) Table [iirelation,$ingres]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Old: <225|0|8|0|2|11|2445317|0|0|5|1|1|0|1611125819|1612538207|1612538207|104786|100000|0|0|0|80|80|70|0|0|8192|0|0|0|0|3|4|1</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> 6|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> New: <225|0|8|0|2|11|2445317|2048|0|5|1|1|0|1611125819|1613145133|1613145133|771094|100000|0|0|0|80|80|70|0|0|8192|0|0|0|0|3|</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> 4|16|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaaob.t00 to</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> rtf6zr.d00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00 to</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> aaaaaaob.t00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">End : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.78</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">Begin : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.79 Username ingres</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Fcreate : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Modify : Transaction Id 00005ea5138c69b3 Id (219,0) Table [ii_stored_nstrings ,$ingres ]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Update/Replace : Transaction Id 00005ea5138c69b3 Id (1,0) Table [iirelation,$ingres]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Old: <219|0|4|0|2|11|2379781|0|0|5|1|1|0|1611125817|1612538207|1612538207|158487|100000|0|0|0|80|80|70|0|0|8192|0|0|0|0|3|4|1</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> 6|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> New: <219|0|4|0|2|11|2379781|2048|0|5|1|1|0|1611125817|1613145133|1613145133|836549|100000|0|0|0|80|80|70|0|0|8192|0|0|0|0|3|</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> 4|16|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaanl.t00 to</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> rtf628.d00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00 to</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> aaaaaanl.t00</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">End : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.85</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Update/Replace : Transaction Id 00005ea51393a887 Id (1,0) Table [iirelation,$ingres]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Old: <247|0|2|0|1|11|3215364|67110914|4172|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1730560|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> New: <247|0|2|0|1|11|3215364|67110914|4172|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">End Mini: Transaction Id 00005ea51393a887</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Update/Replace : Transaction Id 00005ea51393b6de Id (1,0) Table [iirelation,$ingres]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Old: <247|0|2|0|1|11|3215364|67110914|4173|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> New: <247|0|2|0|1|11|3215364|67110914|4173|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">End Mini: Transaction Id 00005ea51393b6de</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Update/Replace : Transaction Id 00005ea51393bebc Id (1,0) Table [iirelation,$ingres]</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> Old: <247|0|2|0|1|11|3215364|67110914|4174|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> New: <247|0|2|0|1|11|3215364|67110914|4174|38|1|1|0|1611319122|1613142939|1613143751|441340|100000|0|0|0|80|80|70|0|0|16384|0</span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text"> |0|0|1733632|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021></span><o:p></o:p></pre>
<pre><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">End Mini: Transaction Id 00005ea51393bebc</span><o:p></o:p></pre>
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">(goes on for several hundred mini transactions)</span><o:p></o:p></p>
<p><span class="m-508627984822818421m-6814047840558963686m-8898691294288586363m7267909865363537385text">Paul</span><o:p></o:p></p>
<p> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</body>
</html>