Hi there,


I am attempting to create a replica from a MariaDB 10.3.31 master.  The replicate is running MariaDB 10.3.39 on the same OS (Ubuntu 20.04) and like hardware with identical MariaDB configuration.

The strategy I'm using to create the replica is one that I have done before using earlier version of MariaDB and MySQL.  But this time it is failing.  It roughly looks like this:

  1. rsync /var/lib/mysql from master to replica
  2. On master: FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS;
  3. On master: Shutdown
  4. rerun rsync from master to replica; then restart master
  5. Start mariadb on replica
  6. CHANGE MASTER on replica
  7. Celebrate and have a nap

When starting the replica which now has all the master data rsynced over, I am getting the following error repeated over and over again:

2023-12-26 22:14:54 0 [ERROR] InnoDB: Page [page id: space=43077, page number=3] log sequence number 19989139444854 is in the future! Current system log sequence number 19246539202516.
2023-12-26 22:14:54 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.


Then I get the following errors for many (but not all) tables:

2023-12-26 22:16:32 0 [ERROR] InnoDB: Expected tablespace id 3986547 but found 3986540 in the file ./ddx_practice_91804/alerts.ibd
2023-12-26 22:16:32 0 [Note] InnoDB: trying to read page [page id: space=3986547, page number=0] in the background in a non-existing or being-dropped tablespace

The replica is totally useless, even though it is an exact copy, running on like hardware, same OS and similar major version of MariaDB.

I've in the past used innodb_fast_shutdown = 0 on the master before final rsync, but I was told by MariaDB engineers that should not matter.


I'm unclear why I'm seeing this corruption.  Any ideas?


Thanks,

Mike



Confidentiality Notice: The information contained in this electronic message and any attachments to this message are intended only for the individual(s) addressed in the message and may contain proprietary and confidential information. If you are not the intended recipient, you should not disseminate, distribute, or copy this e-mail. Please notify the sender and destroy this message. WARNING: Computer viruses can be transmitted via email. The recipient should scan this email before opening it. The company accepts no liability for any damage caused by any virus transmitted by this email.