[Info-ingres] Error from auditdb

Wed May 5 11:06:24 UTC 2021

 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/4b9470ff/attachment-0001.html>