[Info-ingres] rollforwarddb error

[Martin Bowes]

Hi All.

I'm thanking my lucky stars I came across this one in a routine trial recovery...

And even more thankful its very patch specific: II 10.2.0 (a64.lnx/100) +p15162.

Take a journaled table and use 'alter table add column' twice. It must be at least twice.
Then do a recovery...
Fri Feb  2 11:01:06 2018 RFP: Start processing journal file sequence 1.
Fri Feb  2 11:01:06 2018 E_DM960C_DMVE_MODIFY   Error recovering table MODIFY operation.
Fri Feb  2 11:01:06 2018 E_DM1306_RFP_APPLY_RECORD  Error occurred attempting to apply rollforward record.
        LSN=(57440958,0324BCE3), COMP_LSN=(00000000,00000000), DBID=0x5A7444E5, XID=0x000057445B1F1EA1
        MODIFY       Length:  2496  Flags: JOURNAL,NONREDO
            TABLE: (243,0) NAME(test,ingres)
            STRUCTURE: BTREE STATUS: UNIQUE,DUPLICATES
            MINPAGES: 0 MAXPAGES: 0 IFILL: 80 DFILL: 80 LFILL: 70
            BUCKETS: 32589  RELTUPS: 4
            Alloc: 4  Extend: 16  Page size: 8192 Type: 6  Name: (2, 41509)
                LOCATION: ii_database
Open Transaction 0x000057445B1F1EA1 with BT time 02-Feb-2018 11:01:05.06 for database bowtest redo 3 undo 0

The recovery is cool on p 15268.

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180202/540f27a8/attachment.html>