<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>From case 1176237</p>
<blockquote>
<p><i><span class="text">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.</span></i></p>
</blockquote>
<br>
<blockquote type="cite"
cite="mid:b0ba38e93eac4667813dddca74a68c7b@ndph.ox.ac.uk">
<pre class="moz-quote-pre" wrap="">I too would be interested to hear what the transaction limit was!
Marty
Did they mention what the limit is?
Roy
</pre>
</blockquote>
<p><br>
</p>
<p><span class="text">The comment doesnt make sense because my daily
auditdb sometimes records over 100k transactions. <br>
</span></p>
<p><span class="text"><span class="text">I haven't returned to the
implications of the comment because </span>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. <br>
</span></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.<br>
</span></p>
<pre><font size="-1"><span class="text">Begin : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.75 Username ingres
Fcreate : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00
Modify : Transaction Id 00005ea5138c69af Id (225,0) Table [ii_vqtables ,$ingres ]
Update/Replace : Transaction Id 00005ea5138c69af Id (1,0) Table [iirelation,$ingres]
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
6|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables>
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|
4|16|0|70|1|0|84|84|84|84|68|0|0|0|0|||^A|$ingres|ii_vqtables>
Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaaob.t00 to
rtf6zr.d00
Frename : Transaction Id 00005ea5138c69af File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf6x1.m00 to
aaaaaaob.t00
End : Transaction Id 00005ea5138c69af 13-Feb-2021 02:52:13.78
Begin : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.79 Username ingres
Fcreate : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00
Modify : Transaction Id 00005ea5138c69b3 Id (219,0) Table [ii_stored_nstrings ,$ingres ]
Update/Replace : Transaction Id 00005ea5138c69b3 Id (1,0) Table [iirelation,$ingres]
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
6|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings>
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|
4|16|0|70|1|0|1800|1800|1800|1800|41|0|0|0|0|||^A|$ingres|ii_stored_nstrings>
Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ aaaaaanl.t00 to
rtf628.d00
Frename : Transaction Id 00005ea5138c69b3 File /data/ingresII/ingres/data/default/ctrust_docs_2021/ rtf61h.m00 to
aaaaaanl.t00
End : Transaction Id 00005ea5138c69b3 13-Feb-2021 02:52:13.85
Update/Replace : Transaction Id 00005ea51393a887 Id (1,0) Table [iirelation,$ingres]
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
|0|0|1730560|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
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
|0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
End Mini: Transaction Id 00005ea51393a887
Update/Replace : Transaction Id 00005ea51393b6de Id (1,0) Table [iirelation,$ingres]
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
|0|0|1731584|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
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
|0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
End Mini: Transaction Id 00005ea51393b6de
Update/Replace : Transaction Id 00005ea51393bebc Id (1,0) Table [iirelation,$ingres]
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
|0|0|1732608|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
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
|0|0|1733632|36|4|16|0|70|1|0|37|37|37|37|27|0|0|0|0|||^A|ingres|crm_doc2021>
End Mini: Transaction Id 00005ea51393bebc</span></font></pre>
<p><span class="text">(goes on for several hundred mini
transactions)</span></p>
<p><span class="text">Paul<br>
</span></p>
<p><span class="text"><br>
</span></p>
<br>
</body>
</html>