This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

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.