[Info-ingres] Error from auditdb
Martin Bowes
martin.bowes at ndph.ox.ac.uk
Wed May 5 11:12:47 UTC 2021
Thanks Paul, that’s very interesting intel.
2048 seems a low number in this day and age. Did they hint that this may be bumped or configurable in a later release?
Marty
From: Paul White <paul.white at shift7solutions.com.au>
Sent: 05 May 2021 12:06
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Error from auditdb
From case 1176237
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 too would be interested to hear what the transaction limit was!
Marty
Did they mention what the limit is?
Roy
The comment doesnt make sense because my daily auditdb sometimes records over 100k transactions.
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.
As part of the issue, I found auditdb had stopped recording the Begin of transactions. I think it is in the middle of sysmod.
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
(goes on for several hundred mini transactions)
Paul
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20210505/2f9a4b51/attachment-0001.html>
More information about the Info-ingres
mailing list