<div dir="auto">Ps no hint</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 5 May 2021, 9:56 pm Paul White, <<a href="mailto:paul.white@shift7solutions.com.au">paul.white@shift7solutions.com.au</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>I would be interested in seeing results from:<div dir="auto"> egrep 'End : |Begin :' auditfile | awk '{print $5}' | sort | uniq -c | sort | more</div><div dir="auto"> It should have all the open transactions at the top if i did this right on my phone.</div><div dir="auto"><br><div dir="auto"><br style="font-family:sans-serif"></div></div><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 5 May 2021, 9:13 pm Martin Bowes, <<a href="mailto:martin.bowes@ndph.ox.ac.uk" target="_blank" rel="noreferrer">martin.bowes@ndph.ox.ac.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks Paul, that’s very interesting intel.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><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?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Marty<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></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 <<a href="mailto:paul.white@shift7solutions.com.au" rel="noreferrer noreferrer" 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" rel="noreferrer noreferrer" target="_blank">info-ingres@lists.planetingres.org</a><br>
<b>Subject:</b> Re: [Info-ingres] Error from auditdb<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p>From case 1176237<u></u><u></u></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p><span><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><u></u><u></u></p>
</blockquote>
<p class="MsoNormal"><br>
<br>
<u></u><u></u></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>I too would be interested to hear what the transaction limit was!<u></u><u></u></pre>
<pre><u></u> <u></u></pre>
<pre>Marty<u></u><u></u></pre>
<pre><u></u> <u></u></pre>
<pre><u></u> <u></u></pre>
<pre>Did they mention what the limit is? <u></u><u></u></pre>
<pre><u></u> <u></u></pre>
<pre><u></u> <u></u></pre>
<pre>Roy<u></u><u></u></pre>
</blockquote>
<p><u></u> <u></u></p>
<p><span>The comment doesnt make sense because my daily auditdb sometimes records over 100k transactions.
</span><u></u><u></u></p>
<p><span>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><u></u><u></u></p>
<p><span>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><u></u><u></u></p>
<pre><span>Begin : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.75 Username ingres<u></u><u></u></span></pre>
<pre><span> Fcreate : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00<u></u><u></u></span></pre>
<pre><span> Modify : Transaction Id 00005ea5138c69af Id (225,0) Table [ii_vqtables ,$ingres ]<u></u><u></u></span></pre>
<pre><span> Update/Replace : Transaction Id 00005ea5138c69af Id (1,0) Table [iirelation,$ingres]<u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> 6|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables><u></u><u></u></span></pre>
<pre><span> 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|<u></u><u></u></span></pre>
<pre><span> 4|16|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables><u></u><u></u></span></pre>
<pre><span> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaaob.t00 to<u></u><u></u></span></pre>
<pre><span> rtf6zr.d00<u></u><u></u></span></pre>
<pre><span> Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00 to<u></u><u></u></span></pre>
<pre><span> aaaaaaob.t00<u></u><u></u></span></pre>
<pre><span>End : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.78<u></u><u></u></span></pre>
<pre><span>Begin : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.79 Username ingres<u></u><u></u></span></pre>
<pre><span> Fcreate : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00<u></u><u></u></span></pre>
<pre><span> Modify : Transaction Id 00005ea5138c69b3 Id (219,0) Table [ii_stored_nstrings ,$ingres ]<u></u><u></u></span></pre>
<pre><span> Update/Replace : Transaction Id 00005ea5138c69b3 Id (1,0) Table [iirelation,$ingres]<u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> 6|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings><u></u><u></u></span></pre>
<pre><span> 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|<u></u><u></u></span></pre>
<pre><span> 4|16|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings><u></u><u></u></span></pre>
<pre><span> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaanl.t00 to<u></u><u></u></span></pre>
<pre><span> rtf628.d00<u></u><u></u></span></pre>
<pre><span> Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00 to<u></u><u></u></span></pre>
<pre><span> aaaaaanl.t00<u></u><u></u></span></pre>
<pre><span>End : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.85<u></u><u></u></span></pre>
<pre><span> Update/Replace : Transaction Id 00005ea51393a887 Id (1,0) Table [iirelation,$ingres]<u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1730560|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span>End Mini: Transaction Id 00005ea51393a887<u></u><u></u></span></pre>
<pre><span> Update/Replace : Transaction Id 00005ea51393b6de Id (1,0) Table [iirelation,$ingres]<u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span>End Mini: Transaction Id 00005ea51393b6de<u></u><u></u></span></pre>
<pre><span> Update/Replace : Transaction Id 00005ea51393bebc Id (1,0) Table [iirelation,$ingres]<u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span> 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<u></u><u></u></span></pre>
<pre><span> |0|0|1733632|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021><u></u><u></u></span></pre>
<pre><span>End Mini: Transaction Id 00005ea51393bebc</span><u></u><u></u></pre>
<p><span>(goes on for several hundred mini transactions)</span><u></u><u></u></p>
<p><span>Paul</span><u></u><u></u></p>
<p><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" rel="noreferrer noreferrer" target="_blank">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
</blockquote></div></div></div>
</blockquote></div>