Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25795

INSERT_REUSE_REDUNDANT still happening in 10.5.10

    XMLWordPrintable

    Details

      Description

      We are running into an issue very similar to MDEV-25031, even though we have upgraded all nodes to 10.5.10.

      This is the exact error:

      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [Note] InnoDB: Starting a batch to recover 4940 pages from redo log.
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Not applying INSERT_REUSE_REDUNDANT due to corruption on [page id: space=0, page number=4]
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Not applying DELETE_ROW_FORMAT_REDUNDANT due to corruption on [page id: space=0, page number=4]
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Not applying INSERT_HEAP_REDUNDANT due to corruption on [page id: space=0, page number=4]
      May 27 10:06:45 db1 -innobackupex-apply: 2021-05-27 12:06:45 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
      May 27 10:06:47 db1 -innobackupex-apply: 2021-05-27 12:06:47 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
      May 27 10:06:47 db1 -innobackupex-apply: [00] FATAL ERROR: 2021-05-27 12:06:47 mariabackup: innodb_init() returned 11 (Generic error).
      

      Things I have tried:

      • First of all, upgrade all nodes to 10.5.10
      • Created a full new cluster with 2 nodes, set it up as the slave of the old cluster, used mysqldump to create a dump and imported it, set the master pos / file correctly and waited for the slave to catch up. Destroyed and recreated the old nodes and linked them to the new cluster.

      Both these things did nothing.

      It does seem this only happens as soon as we try to add a third node. That is to say the second thing from above worked for the two nodes I created, but when I wanted to add a third node it broke down.

      I am completely lost as what do now, since I really would like a 3+ node cluster.

      I am more than willing to help debug stuff if that would help.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              nickygerritsen Nicky Gerritsen
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration