<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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
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.text
{mso-style-name:text;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thanks Paul, that’s very interesting intel.<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">2048 seems a low number in this day and age. Did they hint that this may be bumped or configurable in a later release?<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>
<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" 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 12:06<br>
<b>To:</b> info-ingres@lists.planetingres.org<br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><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="text"><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"><br>
<br>
<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="text">The comment doesnt make sense because my daily auditdb sometimes records over 100k transactions.
</span><o:p></o:p></p>
<p><span class="text">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="text">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="text">Begin : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.75 Username ingres<o:p></o:p></span></pre>
<pre><span class="text"> Fcreate : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00<o:p></o:p></span></pre>
<pre><span class="text"> Modify : Transaction Id 00005ea5138c69af Id (225,0) Table [ii_vqtables ,$ingres ]<o:p></o:p></span></pre>
<pre><span class="text"> Update/Replace : Transaction Id 00005ea5138c69af Id (1,0) Table [iirelation,$ingres]<o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> 6|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables><o:p></o:p></span></pre>
<pre><span class="text"> 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|<o:p></o:p></span></pre>
<pre><span class="text"> 4|16|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables><o:p></o:p></span></pre>
<pre><span class="text"> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaaob.t00 to<o:p></o:p></span></pre>
<pre><span class="text"> rtf6zr.d00<o:p></o:p></span></pre>
<pre><span class="text"> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00 to<o:p></o:p></span></pre>
<pre><span class="text"> aaaaaaob.t00<o:p></o:p></span></pre>
<pre><span class="text">End : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.78<o:p></o:p></span></pre>
<pre><span class="text">Begin : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.79 Username ingres<o:p></o:p></span></pre>
<pre><span class="text"> Fcreate : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00<o:p></o:p></span></pre>
<pre><span class="text"> Modify : Transaction Id 00005ea5138c69b3 Id (219,0) Table [ii_stored_nstrings ,$ingres ]<o:p></o:p></span></pre>
<pre><span class="text"> Update/Replace : Transaction Id 00005ea5138c69b3 Id (1,0) Table [iirelation,$ingres]<o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> 6|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings><o:p></o:p></span></pre>
<pre><span class="text"> 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|<o:p></o:p></span></pre>
<pre><span class="text"> 4|16|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings><o:p></o:p></span></pre>
<pre><span class="text"> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaanl.t00 to<o:p></o:p></span></pre>
<pre><span class="text"> rtf628.d00<o:p></o:p></span></pre>
<pre><span class="text"> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00 to<o:p></o:p></span></pre>
<pre><span class="text"> aaaaaanl.t00<o:p></o:p></span></pre>
<pre><span class="text">End : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.85<o:p></o:p></span></pre>
<pre><span class="text"> Update/Replace : Transaction Id 00005ea51393a887 Id (1,0) Table [iirelation,$ingres]<o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1730560|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text">End Mini: Transaction Id 00005ea51393a887<o:p></o:p></span></pre>
<pre><span class="text"> Update/Replace : Transaction Id 00005ea51393b6de Id (1,0) Table [iirelation,$ingres]<o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text">End Mini: Transaction Id 00005ea51393b6de<o:p></o:p></span></pre>
<pre><span class="text"> Update/Replace : Transaction Id 00005ea51393bebc Id (1,0) Table [iirelation,$ingres]<o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text"> 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<o:p></o:p></span></pre>
<pre><span class="text"> |0|0|1733632|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><o:p></o:p></span></pre>
<pre><span class="text">End Mini: Transaction Id 00005ea51393bebc</span><o:p></o:p></pre>
<p><span class="text">(goes on for several hundred mini transactions)</span><o:p></o:p></p>
<p><span class="text">Paul</span><o:p></o:p></p>
<p><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>