aria_read_log still skips my table - Source

Revision: 116107
User: Jochen Schüttler
Date: 2022-05-13 07:57

I tried a lot but haven't been able to achieve 1 single row of incremental update with aria logs. Steps:

<<code>>
cd <datadir>
mysql
-> USE demo
-> CREATE TABLE demo (id CHAR(17), c1 TINYINT UNSIGNED, c2 TINYINT UNSIGNED, c3 INT, c4 INT, PRIMARY KEY(id)) ENGINE=aria; exit;
systemctl stop mariadb
rm aria_log*
systemctl start mariadb
cp -r * <backup_folder>
mysql
-> USE demo
-> INSERT INTO demo VALUES ('aaaaaaaaaaaaaaaa',0,0,1,1); exit;
cp aria_log* <incremental_folder>
systemctl stop mariadb
cp -r <backup_folder>/* .
cp <incremental_folder>/* .
aria_read_log -a
<</code>>

Result:
<<code>>
CHECKPOINT found
Rec#21 LSN (1,0x221b) short_trid 39411 long_transaction_id(num_type:36) len 6
Transaction long_trid 57 short_trid 39411 starts, undo_lsn (0,0x0) first_undo_lsn (0,0x0)
Rec#22 LSN (1,0x2224) short_trid 39411 file_id(num_type:35) len 20
Table './demo/demo', id 47, has create_rename_lsn (1,0x63cfc) more recent than LOGREC_FILE_ID's LSN (1,0x2224), ignoring
<</code>>

What am I doing wrong ?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

aria_read_log still skips my table - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB