aria_read_log still skips my table
I tried a lot but haven't been able to achieve 1 single row of incremental update with aria logs. Steps:
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
Result:
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
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.