select name, (flag & 0x10) = 0x10 as full_crc32 from information_schema.innodb_sys_tablespaces;

grep -i uring /boot/config-$(uname -r)

CONFIG_IO_URING=y

CONFIG_AIO=y

SQLSTATE[HY000]: General error: 1712 Index binaries is corrupted

Jan 30 19:50:18 SERVER_HOSTNAME mariadbd[962260]: 2023-01-30 19:50:18 328202837 [ERROR] Got error 180 when reading table './dbname/binaries.ibd'

Jan 30 19:50:33 SERVER_HOSTNAME mariadbd[962260]:  6: len 30; hex 616c742e62696e6172692023-01-30 19:50:33 328203835 [ERROR] Got error 180 when reading table './dbname/binaries.ibd'

Feb 09 20:30:54 SERVER_HOSTNAME mariadbd[3829372]: 2023-02-09 20:30:54 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_partcheck` in table `DBNAME`.`binaries` in purge

SET GLOBAL innodb_change_buffering=none;

--rebuilds the whole table, could be very I/O intensive

OPTIMIZE TABLE binaries;

--alternative

ALTER TABLE binaries DROP INDEX ix_binaries_binaryhash, DROP INDEX ux_collection_id_filenumber, DROP INDEX ix_binaries_collection, DROP INDEX ix_binaries_partcheck;

ALTER TABLE binaries ADD UNIQUE INDEX ix_binaries_binaryhash(binaryhash), ADD INDEX …;

SHOW GLOBAL VARIABLES LIKE 'innodb_change_buffering'

innodb_change_buffering = none

Duplicate entry '1721887-0' for key 'ux_collection_id_filenumber'

UNIQUE KEY `ux_collection_id_filenumber` (`collections_id`,`filenumber`)

[~marko]

select * from information_schema.innodb_sys_virtual;

check table binaries extended;

Mar 11 03:22:37 mariadbd[1656]: 2023-03-11  3:22:37 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_partcheck` of table `nntmux`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[1] (0x01),[8]       _(0x000000000000B45F)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[1] (0x01),[8]       _(0x000000000000B45F)}

Mar 11 03:22:37 mariadbd[1656]: 2023-03-11  3:22:37 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_partcheck` in table `nntmux`.`binaries` in purge

Mar 11 03:22:37 mariadbd[1656]: 2023-03-11  3:22:37 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_collection` of table `nntmux`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[4]  \ (0x00005CC0),[8]       _(0x000000000000B45F)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[4]  \ (0x00005CC0),[8]       _(0x000000000000B45F)}

Mar 11 03:22:37 mariadbd[1656]: 2023-03-11  3:22:37 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_collection` in table `nntmux`.`binaries` in purge  

innodb_undo_log_truncate = OFF

It started for me , if i remember correctly, with version 10.6.5 and every version after that. Unfortunately as that is a production server i cannot rollback to older version and test it.

CREATE TABLE parent(id int PRIMARY KEY) ENGINE=InnoDB;

CREATE TABLE child(

s tinyint unsigned NOT NULL,

id int unsigned NOT NULL,

o int NOT NULL,

PRIMARY KEY (id,s),

KEY (o),

CONSTRAINT FOREIGN KEY (id) REFERENCES parent(id) ON DELETE CASCADE

) ENGINE=InnoDB; 

CREATE TABLE `binaries` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(1000) NOT NULL DEFAULT '',

  `collections_id` int(11) unsigned NOT NULL DEFAULT 0,

  `filenumber` int(10) unsigned NOT NULL DEFAULT 0,

  `totalparts` int(11) unsigned NOT NULL DEFAULT 0,

  `currentparts` int(10) unsigned NOT NULL DEFAULT 0,

  `binaryhash` binary(16) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',

  `partcheck` tinyint(1) unsigned NOT NULL DEFAULT 0,

  `partsize` bigint(20) unsigned NOT NULL DEFAULT 0,

  PRIMARY KEY (`id`),

  UNIQUE KEY `ix_binary_binaryhash` (`binaryhash`),

  KEY `ix_binary_partcheck` (`partcheck`),

  KEY `ix_binary_collection` (`collections_id`),

  CONSTRAINT `FK_collections` FOREIGN KEY (`collections_id`) REFERENCES `collections` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED

CREATE TABLE `parts` (

  `binaries_id` bigint(20) unsigned NOT NULL DEFAULT 0',

  `messageid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',

  `number` bigint(20) unsigned NOT NULL DEFAULT 0,

  `partnumber` mediumint(10) unsigned NOT NULL DEFAULT 0,

  `size` mediumint(20) unsigned NOT NULL DEFAULT 0,

  PRIMARY KEY (`binaries_id`,`number`),

  CONSTRAINT `FK_binaries` FOREIGN KEY (`binaries_id`) REFERENCES `binaries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED

CREATE TABLE `collections` (

  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,

  `subject` varchar(255) NOT NULL DEFAULT '',

  `fromname` varchar(255) NOT NULL DEFAULT '',

  `date` datetime DEFAULT NULL,

  `xref` varchar(2000) NOT NULL DEFAULT '',

  `totalfiles` int(11) unsigned NOT NULL DEFAULT 0,

  `groups_id` int(11) unsigned NOT NULL DEFAULT 0 ,

  `collectionhash` varchar(255) NOT NULL DEFAULT '0',

  `collection_regexes_id` int(11) NOT NULL DEFAULT 0 ,

  `dateadded` datetime DEFAULT NULL,

  `filecheck` tinyint(3) unsigned NOT NULL DEFAULT 0,

  `filesize` bigint(20) unsigned NOT NULL DEFAULT 0,

  `releases_id` int(11) DEFAULT NULL,

  `noise` char(32) NOT NULL DEFAULT '',

  `added` timestamp NOT NULL DEFAULT current_timestamp(),

  PRIMARY KEY (`id`),

  UNIQUE KEY `ix_collection_collectionhash` (`collectionhash`),

  KEY `fromname` (`fromname`),

  KEY `DATE` (`date`),

  KEY `group_id` (`groups_id`),

  KEY `ix_collection_filecheck` (`filecheck`),

  KEY `ix_collection_dateadded` (`dateadded`),

  KEY `ix_collection_releaseid` (`releases_id`),

  KEY `ix_collection_added` (`added`)

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED

unsigned NOT NULL DEFAULT 0',

CREATE TABLE t3 (c1 int(11) unsigned NOT NULL AUTO_INCREMENT, c2 varchar(255) NOT NULL DEFAULT '', c3 varchar(255) NOT NULL DEFAULT '', c4 datetime DEFAULT NULL, c5 varchar(2000) NOT NULL DEFAULT '', c6 int(11) unsigned NOT NULL DEFAULT 0, c7 int(11) unsigned NOT NULL DEFAULT 0, c8 varchar(255) NOT NULL DEFAULT '0', c9 int(11) NOT NULL DEFAULT 0, c10 datetime DEFAULT NULL, c11 tinyint(3) unsigned NOT NULL DEFAULT 0, c12 bigint(20) unsigned NOT NULL DEFAULT 0, c13 int(11) DEFAULT NULL, c14 char(32) NOT NULL DEFAULT '', c15 timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (c1), UNIQUE KEY k8 (c8), KEY k1 (c3), KEY k2 (c4), KEY k3 (c7), KEY k4 (c11), KEY k5 (c10), KEY k6 (c13), KEY k7 (c15) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;

CREATE TABLE t1 (c1 bigint(20) unsigned NOT NULL AUTO_INCREMENT, c2 varchar(1000) NOT NULL DEFAULT '', c3 int(11) unsigned NOT NULL DEFAULT 0, c4 int(10) unsigned NOT NULL DEFAULT 0, c5 int(11) unsigned NOT NULL DEFAULT 0, c6 int(10) unsigned NOT NULL DEFAULT 0, c7 binary(16) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', c8 tinyint(1) unsigned NOT NULL DEFAULT 0, c9 bigint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (c1), UNIQUE KEY k1 (c7), KEY k2 (c8), KEY k3 (c3), CONSTRAINT fk3 FOREIGN KEY (c3) REFERENCES t3(c1) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;

CREATE TABLE t2 (c1 bigint(20) unsigned NOT NULL DEFAULT 0, c2 varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '', c3 bigint(20) unsigned NOT NULL DEFAULT 0, c4 mediumint(10) unsigned NOT NULL DEFAULT 0, c5 mediumint(20) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (c1,c3), CONSTRAINT fk1 FOREIGN KEY (c1) REFERENCES t1(c1) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED;

CREATE TABLE `binaries` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(1000) NOT NULL DEFAULT '',

  `collections_id` int(10) unsigned NOT NULL DEFAULT 0,

  `filenumber` int(10) unsigned NOT NULL DEFAULT 0,

  `totalparts` int(10) unsigned NOT NULL DEFAULT 0,

  `currentparts` int(10) unsigned NOT NULL DEFAULT 0,

  `partcheck` tinyint(1) NOT NULL DEFAULT 0,

  `partsize` bigint(20) unsigned NOT NULL DEFAULT 0,

  `binaryhash` binary(16) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',

  `fromname` varchar(500) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `ix_binaries_binaryhash` (`binaryhash`),

  UNIQUE KEY `ux_collection_id_filenumber` (`collections_id`,`filenumber`),

  KEY `ix_binaries_collection` (`collections_id`),

  KEY `ix_binaries_partcheck` (`partcheck`),

  CONSTRAINT `FK_Collections` FOREIGN KEY (`collections_id`) REFERENCES `collections` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=294495 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE `parts` (

  `binaries_id` bigint(20) unsigned NOT NULL DEFAULT 0,

  `messageid` varchar(255) NOT NULL DEFAULT '',

  `number` bigint(20) unsigned NOT NULL DEFAULT 0,

  `partnumber` int(10) unsigned NOT NULL DEFAULT 0,

  `size` int(10) unsigned NOT NULL DEFAULT 0,

  PRIMARY KEY (`binaries_id`,`number`),

  CONSTRAINT `FK_binaries` FOREIGN KEY (`binaries_id`) REFERENCES `binaries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci

CREATE TABLE `collections` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `subject` varchar(255) NOT NULL DEFAULT '',

  `fromname` varchar(255) NOT NULL DEFAULT '',

  `date` datetime DEFAULT NULL,

  `xref` varchar(2000) NOT NULL DEFAULT '',

  `totalfiles` int(10) unsigned NOT NULL DEFAULT 0,

  `groups_id` int(10) unsigned NOT NULL DEFAULT 0,

  `collectionhash` varchar(255) NOT NULL DEFAULT '0',

  `collection_regexes_id` int(11) NOT NULL DEFAULT 0 COMMENT 'FK to collection_regexes.id',

  `dateadded` datetime DEFAULT NULL,

  `added` timestamp NOT NULL DEFAULT current_timestamp(),

  `filecheck` tinyint(1) NOT NULL DEFAULT 0,

  `filesize` bigint(20) unsigned NOT NULL DEFAULT 0,

  `releases_id` int(11) DEFAULT NULL,

  `noise` char(32) NOT NULL DEFAULT '',

  PRIMARY KEY (`id`),

  UNIQUE KEY `ix_collection_collectionhash` (`collectionhash`),

  KEY `fromname` (`fromname`),

  KEY `date` (`date`),

  KEY `groups_id` (`groups_id`),

  KEY `ix_collection_dateadded` (`dateadded`),

  KEY `ix_collection_filecheck` (`filecheck`),

  KEY `ix_collection_releaseid` (`releases_id`)

) ENGINE=InnoDB AUTO_INCREMENT=61856 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci

!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")|SIGABRT|btr_node_ptr_max_size|btr_cur_t::search_leaf|row_ins_sec_index_entry_low|row_ins_sec_index_entry

cd /path/to/project/mariadb-corruption-for-mariadb-ticket

docker compose up

cd /path/to/project/mariadb-corruption-for-mariadb-ticket

./gradlew run

[ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

#!/bin/bash

# Start server with --max_connections=10000

# Set variables and ensure ramloc is a ramdisk or tmpfs (i.e. /dev/shm)

user="root"

socket="./socket.sock"

db="test"

client="./bin/mariadb"

errorlog="./log/master.err"

ramloc="/dev/shm"

threads=2000   # Number of concurrent threads

queries=100    # Number of t1/t2 INSERTs per thread/per test round

rounds=999999  # Number of max test rounds

# Setup

${client} -u ${user} -S ${socket} -D ${db} -e "

DROP TABLE IF EXISTS t1;

DROP TABLE IF EXISTS t2;

CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT, c2 INT NOT NULL, PRIMARY KEY (c1), UNIQUE KEY u1 (c1,c2)) ENGINE=InnoDB AUTO_INCREMENT=1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; 

CREATE TABLE t2 (c1 DATETIME NOT NULL, c2 DOUBLE NOT NULL, t1_c1 INT NOT NULL, PRIMARY KEY (t1_c1,c1)) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;

"

insert_rows(){

  SQL=

  for ((i=0;i<${queries};i++)); do

    SQL="${SQL}INSERT INTO t1 (c2) VALUES (0); INSERT INTO t2 VALUES (CURRENT_TIMESTAMP, 0, (SELECT LAST_INSERT_ID()));"

  done

  ${client} -u ${user} -S ${socket} -D ${db} -e "${SQL}"

  rm -f ${ramloc}/${prefix}_md_proc_${1}  # Thread done

}

abort(){ jobs -p | xargs -P100 kill >/dev/null 2>&1; rm -Rf ${ramloc}/${prefix}_md_proc_*; exit 1; }

trap abort SIGINT

count=0

prefix="$(echo "${RANDOM}${RANDOM}${RANDOM}" | cut -b1-5)"

rm -f ${ramloc}/${prefix}_md_proc_*

for ((i=0;i<${rounds};i++)); do

  for ((i=0;i<${threads};i++)); do

    if [ ! -r ${ramloc}/${prefix}_md_proc_${i} ]; then  # Thread idle

      touch ${ramloc}/${prefix}_md_proc_${i}  # Thread busy

      insert_rows ${i} &

      count=$[ ${count} + 1 ]

      if [ $[ ${count} % 100 ] -eq 0 ]; then  # Limit disk I/O, check once every new 100 threads

        echo "Count: ${count}" | tee lastcount.log

        TAIL="$(tail -n10 ${errorlog} | tr -d '\n')"

        if [[ "${TAIL}" == *"ERROR"* ]]; then

          echo '*** Error found:'

          grep -i 'ERROR' log/master.err

          abort

        elif [[ "${TAIL}" == *"down complete"* ]]; then

          echo '*** Server shutdown'

          abort

        elif ! ${client}-admin ping -u ${user} -S ${socket} > /dev/null 2>&1; then

          echo '*** Server gone (killed/crashed)'

          abort

        fi

      fi

    fi

  done

done

2023-07-15 15:41:26 0 [Note] /test/MD220623-mariadb-11.1.2-linux-x86_64-opt/bin/mariadbd: ready for connections.

Version: '11.1.2-MariaDB'  socket: '/test/MD220623-mariadb-11.1.2-linux-x86_64-opt/socket.sock'  port: 12801  MariaDB Server

2023-07-15 15:41:38 1509 [Note] InnoDB: Number of transaction pools: 2

2023-07-15 16:19:46 72616 [ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

2023-07-15 16:19:46 72616 [ERROR] mariadbd: Index for table 't2' is corrupt; try to repair it

2023-07-15 16:19:46 73218 [ERROR] mariadbd: Index for table 't2' is corrupt; try to repair it

2023-07-15 16:19:46 73195 [ERROR] mariadbd: Index for table 't2' is corrupt; try to repair it

2023-07-15 16:19:46 73187 [ERROR] mariadbd: Index for table 't2' is corrupt; try to repair it

... last message repeated ...

#3  0x000055904ab4d175 in btr_cur_t::pessimistic_search_leaf (

    this=this@entry=0x1482959e68b0, 

    tuple=tuple@entry=0x147ff807a020, mode=mode@entry=PAGE_CUR_LE, 

    mtr=mtr@entry=0x1482959e6e40)

    at /test/11.2_dbg/storage/innobase/btr/btr0cur.cc:1501

#4  0x000055904ab5f11b in btr_cur_t::search_leaf (

    this=this@entry=0x1482959e68b0, 

    tuple=tuple@entry=0x147ff807a020, mode=mode@entry=PAGE_CUR_LE, 

    latch_mode=<optimized out>, latch_mode@entry=BTR_MODIFY_TREE, 

    mtr=mtr@entry=0x1482959e6e40)

    at /test/11.2_dbg/storage/innobase/btr/btr0cur.cc:1437

#5  0x000055904aa3519f in btr_pcur_open (mtr=0x1482959e6e40, 

    cursor=0x1482959e68b0, latch_mode=BTR_MODIFY_TREE, 

    mode=PAGE_CUR_LE, tuple=0x147ff807a020)

    at /test/11.2_dbg/storage/innobase/include/btr0pcur.h:431

#6  row_ins_clust_index_entry_low (flags=flags@entry=0, 

    mode=mode@entry=BTR_MODIFY_TREE, 

    index=index@entry=0x1483b406a430, n_uniq=n_uniq@entry=2, 

    entry=entry@entry=0x147ff807a020, n_ext=n_ext@entry=0, 

    thr=0x1480881235f8)

    at /test/11.2_dbg/storage/innobase/row/row0ins.cc:2684

#7  0x000055904aa37f70 in row_ins_clust_index_entry (

    index=index@entry=0x1483b406a430, 

    entry=entry@entry=0x147ff807a020, thr=thr@entry=0x1480881235f8, 

    n_ext=n_ext@entry=0)

    at /test/11.2_dbg/storage/innobase/row/row0ins.cc:3260

#8  0x000055904aa395c8 in row_ins_index_entry (thr=0x1480881235f8, 

    entry=0x147ff807a020, index=0x1483b406a430)

    at /test/11.2_dbg/storage/innobase/row/row0ins.cc:3375

--Type <RET> for more, q to quit, c to continue without paging--

#9  row_ins_index_entry_step (thr=0x1480881235f8, node=<optimized out>) at /test/11.2_dbg/storage/innobase/row/row0ins.cc:3543

#10 row_ins (thr=0x1480881235f8, node=<optimized out>) at /test/11.2_dbg/storage/innobase/row/row0ins.cc:3660

#11 row_ins_step (thr=thr@entry=0x1480881235f8) at /test/11.2_dbg/storage/innobase/row/row0ins.cc:3789

#12 0x000055904aa5bbe5 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x1480881127c8 "\377\231\260\246p\034", prebuilt=0x148088122e80, 

    ins_mode=ROW_INS_NORMAL) at /test/11.2_dbg/storage/innobase/row/row0mysql.cc:1317

#13 0x000055904a8f77c3 in ha_innobase::write_row (this=0x148088122620, record=0x1480881127c8 "\377\231\260\246p\034")

    at /test/11.2_dbg/storage/innobase/handler/ha_innodb.cc:7820

#14 0x000055904a5f46d5 in handler::ha_write_row (this=0x148088122620, buf=0x1480881127c8 "\377\231\260\246p\034")

    at /test/11.2_dbg/sql/handler.cc:7802

#15 0x000055904a2a365f in write_record (thd=thd@entry=0x148088000d48, table=table@entry=0x148334029198, info=info@entry=0x1482959e7bf0, 

    sink=sink@entry=0x0) at /test/11.2_dbg/sql/sql_insert.cc:2204

#16 0x000055904a2ad505 in mysql_insert (thd=thd@entry=0x148088000d48, table_list=<optimized out>, fields=..., values_list=..., 

    update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /test/11.2_dbg/sql/sql_insert.cc:1154

#17 0x000055904a2edf0f in mysql_execute_command (thd=thd@entry=0x148088000d48, 

    is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/11.2_dbg/sql/sql_parse.cc:4449

#18 0x000055904a2daaab in mysql_parse (thd=thd@entry=0x148088000d48, rawbuf=<optimized out>, length=<optimized out>, 

    parser_state=parser_state@entry=0x1482959e8300) at /test/11.2_dbg/sql/sql_parse.cc:7774

#19 0x000055904a2e8176 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148088000d48, 

    packet=packet@entry=0x14808800ae59 "INSERT INTO t2 VALUES (CURRENT_TIMESTAMP, 0, (SELECT LAST_INSERT_ID()))", 

    packet_length=packet_length@entry=71, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_class.h:1370

#20 0x000055904a2ea64d in do_command (thd=0x148088000d48, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1405

#21 0x000055904a45029b in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55904cde2df8, 

    put_in_cache=put_in_cache@entry=true) at /test/11.2_dbg/sql/sql_connect.cc:1416

#22 0x000055904a45076a in handle_one_connection (arg=0x55904cde2df8) at /test/11.2_dbg/sql/sql_connect.cc:1318

#23 0x000014840a282609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#24 0x0000148409e6e133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

$ podman pull quay.io/mariadb-foundation/mariadb-devel:10.10

$ podman inspect --format="{{json .Annotations}}" quay.io/mariadb-foundation/mariadb-devel:10.10 | jq

{

  "org.opencontainers.image.authors": "MariaDB Foundation",

  "org.opencontainers.image.base.digest": "sha256:4e64b60f60c9c58b5b8001158442cc8ef2fc0d5b60743c20c60c4136d5883cdf",

  "org.opencontainers.image.base.name": "localhost/mariadb-37004-amd64:latest",

  "org.opencontainers.image.description": "This is not a Release.\\nBuild of the MariaDB Server from CI as of commit b1b47264d2ef1fa80b90f308e81c49d9a1011d56",

  "org.opencontainers.image.documentation": "https://hub.docker.com/_/mariadb",

  "org.opencontainers.image.licenses": "GPL-2.0",

  "org.opencontainers.image.revision": "b1b47264d2ef1fa80b90f308e81c49d9a1011d56",

  "org.opencontainers.image.source": "https://github.com/MariaDB/mariadb-docker/tree/28adeb9071427d1e18aa9317f41d62fa4a0f3769/10.10",

  "org.opencontainers.image.title": "MariaDB Server 10.10 CI build",

  "org.opencontainers.image.version": "10.10.6+b1b47264d2ef1fa80b90f308e81c49d9a1011d56"

}

$ # Altnernately

$ podman run --rm  quay.io/mariadb-foundation/mariadb-devel:10.10 mariadbd --help --verbose | grep  version-source-revision

2023-07-26 22:51:17 0 [Warning] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some options may be missing from the help text

version-source-revision                                      b1b47264d2ef1fa80b90f308e81c49d9a1011d56

$ podman run --rm -ti quay.io/mariadb-foundation/mariadb-devel:10.10  bash

root@4300db4363e0:/# cat /etc/apt/sources.list.d/mariadb.list 

deb [trusted=yes] https://ci.mariadb.org/37004/amd64-ubuntu-2204-deb-autobake/debs ./

deb [trusted=yes] https://buildbot.mariadb.net/archive/builds/mariadb-4.x/latest/kvm-deb-jammy-amd64-gal/debs/ ./

commit 78a04a4c22d54dc4f67f067fc9b7a0bc717ebfdd

Author: Vlad Lesin

Date:   Wed Oct 26 11:58:22 2022 +0300

    MDEV-29869 mtr failure: innodb.deadlock_wait_thr_race

--source include/have_innodb.inc

CREATE TABLE collections (

  id int(11) unsigned NOT NULL AUTO_INCREMENT,

  collectionhash varchar(255) NOT NULL DEFAULT '0',

  PRIMARY KEY (id),

  UNIQUE KEY ix_collection_collectionhash (collectionhash)

) ENGINE=InnoDB;

CREATE TABLE binaries (

  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  collections_id int(11) unsigned NOT NULL DEFAULT 0,

  binaryhash binary(16) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',

  PRIMARY KEY (id),

  UNIQUE KEY ix_binary_binaryhash (binaryhash),

  CONSTRAINT FK_collections FOREIGN KEY (collections_id) REFERENCES collections (id) ON DELETE CASCADE

) ENGINE=InnoDB;

INSERT INTO collections (id) VALUES (NULL);

--connect (con1,localhost,root,,)

INSERT INTO binaries (id,collections_id) VALUES (NULL,1);

--send

  REPLACE INTO collections (id) VALUES (NULL);

--connection default

--error 0,ER_LOCK_DEADLOCK,ER_NO_REFERENCED_ROW_2

REPLACE INTO binaries (id) VALUES (NULL);

--source include/restart_mysqld.inc

CHECK TABLE binaries, collections EXTENDED;

# Cleanup

DROP TABLE binaries, collections;

CHECK TABLE binaries, collections EXTENDED;

Table	Op	Msg_type	Msg_text

test.binaries	check	Warning	InnoDB: Index ix_binary_binaryhash is marked as corrupted

test.binaries	check	Warning	InnoDB: Index FK_collections is marked as corrupted

test.binaries	check	error	Corrupt

test.collections	check	status	OK

2023-09-02 18:21:47 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_binaryhash` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}

2023-09-02 18:21:47 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_binaryhash` in table `test`.`binaries` in purge

2023-09-02 18:21:47 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `FK_collections` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}

2023-09-02 18:21:47 0 [ERROR] InnoDB: Flagged corruption of `FK_collections` in table `test`.`binaries` in purge

2023-09-02 18:21:24 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_collection` in table `test`.`binaries` in purge

mysqld: /data/src/10.6/storage/innobase/btr/btr0cur.cc:1011: dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*): Assertion `index()->is_btree() || index()->is_ibuf()' failed.

230902 18:21:24 [ERROR] mysqld got signal 6 ;

#9  0x00007f7c54253df2 in __GI___assert_fail (assertion=0x55f694f1fd80 "index()->is_btree() || index()->is_ibuf()", file=0x55f694f1ee00 "/data/src/10.6/storage/innobase/btr/btr0cur.cc", line=1011, function=0x55f694f1fde0 "dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*)") at ./assert/assert.c:101

#10 0x000055f693a9610b in btr_cur_t::search_leaf (this=0x7f7c27ae58f0, tuple=0x6170002cbd40, mode=PAGE_CUR_GE, latch_mode=BTR_SEARCH_LEAF, mtr=0x7f7c27ae5cf0) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:1011

#11 0x000055f693554aad in btr_pcur_open (tuple=0x6170002cbd40, mode=PAGE_CUR_GE, latch_mode=BTR_SEARCH_LEAF, cursor=0x7f7c27ae58f0, mtr=0x7f7c27ae5cf0) at /data/src/10.6/storage/innobase/include/btr0pcur.h:431

#12 0x000055f693869045 in row_ins_check_foreign_constraint (check_ref=0, foreign=0x6160004eeb20, table=0x618000010520, entry=0x6170002cbd40, thr=0x620000023c90) at /data/src/10.6/storage/innobase/row/row0ins.cc:1627

#13 0x000055f693958803 in row_upd_check_references_constraints (node=0x6200000238a0, pcur=0x6200000239d0, table=0x618000010520, index=0x6160004e5220, offsets=0x7f7c27ae6370, thr=0x620000023c90, mtr=0x7f7c27ae6a10) at /data/src/10.6/storage/innobase/row/row0upd.cc:252

#14 0x000055f6939651d3 in row_upd_clust_rec_by_insert (node=0x6200000238a0, index=0x6160004e5220, thr=0x620000023c90, referenced=true, foreign=false, mtr=0x7f7c27ae6a10) at /data/src/10.6/storage/innobase/row/row0upd.cc:2281

#15 0x000055f693967ba2 in row_upd_clust_step (node=0x6200000238a0, thr=0x620000023c90) at /data/src/10.6/storage/innobase/row/row0upd.cc:2682

#16 0x000055f6939684d2 in row_upd (node=0x6200000238a0, thr=0x620000023c90) at /data/src/10.6/storage/innobase/row/row0upd.cc:2758

#17 0x000055f69396941e in row_upd_step (thr=0x620000023c90) at /data/src/10.6/storage/innobase/row/row0upd.cc:2900

#18 0x000055f6938bc3aa in row_update_for_mysql (prebuilt=0x620000023120) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1688

#19 0x000055f693506747 in ha_innobase::update_row (this=0x61d0001e28b8, old_row=0x61d0001e36c0 "\304\001", new_row=0x61d0001e32b8 "") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:8688

#20 0x000055f692af3a4d in handler::ha_update_row (this=0x61d0001e28b8, old_data=0x61d0001e36c0 "\304\001", new_data=0x61d0001e32b8 "") at /data/src/10.6/sql/handler.cc:7699

#21 0x000055f6925789c4 in mysql_update (thd=0x62b0000af218, table_list=0x62b0000b6400, fields=..., values=..., conds=0x0, order_num=1, order=0x62b0000b6eb8, limit=1, ignore=false, found_return=0x7f7c27ae7f40, updated_return=0x7f7c27ae7f60) at /data/src/10.6/sql/sql_update.cc:1092

#22 0x000055f692250d26 in mysql_execute_command (thd=0x62b0000af218, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:4423

#23 0x000055f69226a6fb in mysql_parse (thd=0x62b0000af218, rawbuf=0x62b0000b6238 "/* WRK-2 QNO 1037 */ UPDATE test.collections SET `id` = 0 ORDER BY `collectionhash` LIMIT 1", length=91, parser_state=0x7f7c27ae89f0) at /data/src/10.6/sql/sql_parse.cc:8048

#24 0x000055f6922403bc in dispatch_command (command=COM_QUERY, thd=0x62b0000af218, packet=0x62900012c219 "/* WRK-2 QNO 1037 */ UPDATE test.collections SET `id` = 0 ORDER BY `collectionhash` LIMIT 1", packet_length=91, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896

#25 0x000055f69223d0f0 in do_command (thd=0x62b0000af218, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1409

#26 0x000055f6926a951e in do_handle_one_connection (connect=0x608000002638, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1416

#27 0x000055f6926a8edf in handle_one_connection (arg=0x608000002638) at /data/src/10.6/sql/sql_connect.cc:1318

#28 0x000055f693305c50 in pfs_spawn_thread (arg=0x617000006998) at /data/src/10.6/storage/perfschema/pfs.cc:2201

#29 0x00007f7c542a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#30 0x00007f7c543285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

set sql_mode="";

drop table if exists t;

create table t (

  `a` int,

  `b` int not null,

  `c` char(2) generated always as ('aa') virtual,

  unique key(`b`),

  unique key(`c`(1))

) engine=innodb default charset=utf8 row_format=compact;

drop procedure if exists p;

delimiter $

create procedure p()

begin

  declare continue handler for sqlexception begin end;

  repeat

    if rand()>0.5 then insert into t(a,b) values(floor(rand()*10),floor(rand()*10)); end if;

    if rand()>0.5 then delete from t where a<floor(rand()*10); end if;

    if rand()>0.5 then update t set b=concat(a,a); end if;

    if rand()>0.5 then replace into t(a,b) values(floor(rand()*10),floor(rand()*10)); end if;

  until 1=2 end repeat;

end $

delimiter ;

call p();

11.3 (dbg) @ 7ba9c7fb84b5f28e4736656b57d9508b70ca6369 (Build date 2 Sep)

10.6 (dbg) @ d794d3484b2cbd069d68dc8d017a6f18e9a3090e (Build date 1 Aug)

10.6 (opt) @ d794d3484b2cbd069d68dc8d017a6f18e9a3090e (Build date 1 Aug)

Version: '11.3.0-MariaDB-debug'  socket: '/test/MD020923-mariadb-11.3.0-linux-x86_64-dbg/socket.sock'  port: 11670  MariaDB Server

2023-09-04  9:24:51 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `c` of table `test`.`t`: tuple: TUPLE (info_bits=0, 2 fields): {[1]a(0x61),[4]    (0x80000006)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[1]a(0x61),[4]    (0x80000006)}

2023-09-04  9:24:51 0 [ERROR] InnoDB: Flagged corruption of `c` in table `test`.`t` in purge

mariadbd: /test/git-bisect/11.3_dbg/storage/innobase/btr/btr0cur.cc:1001: dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*): Assertion `index()->is_btree()' failed.

Core was generated by `/test/MD020923-mariadb-11.3.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22585690433088)

    at ./nptl/pthread_kill.c:44

[Current thread is 1 (Thread 0x148aa40e2640 (LWP 2650661))]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22585690433088) at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=22585690433088) at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=22585690433088, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

#3  0x0000148ad6042476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#4  0x0000148ad60287f3 in __GI_abort () at ./stdlib/abort.c:79

#5  0x0000148ad602871b in __assert_fail_base (fmt=0x148ad61dd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5638ce17b509 "index()->is_btree()", file=0x5638ce17b7a8 "/test/git-bisect/11.3_dbg/storage/innobase/btr/btr0cur.cc", line=1001, function=<optimized out>) at ./assert/assert.c:92

#6  0x0000148ad6039e96 in __GI___assert_fail (assertion=0x5638ce17b509 "index()->is_btree()", file=0x5638ce17b7a8 "/test/git-bisect/11.3_dbg/storage/innobase/btr/btr0cur.cc", line=1001, function=0x5638ce17e2c0 "dberr_t btr_cur_t::search_leaf(const dtuple_t*, page_cur_mode_t, btr_latch_mode, mtr_t*)") at ./assert/assert.c:101

#7  0x00005638cdbdb0a0 in btr_cur_t::search_leaf (this=this@entry=0x148aa40dd850, tuple=tuple@entry=0x148a300de030, mode=mode@entry=PAGE_CUR_LE, latch_mode=latch_mode@entry=BTR_MODIFY_LEAF, mtr=mtr@entry=0x148aa40de100) at /test/git-bisect/11.3_dbg/storage/innobase/btr/btr0cur.cc:1001

#8  0x00005638cdad2626 in row_ins_sec_index_entry_low (flags=flags@entry=0, mode=mode@entry=BTR_MODIFY_LEAF, index=index@entry=0x148a30067da0, offsets_heap=<optimized out>, offsets_heap@entry=0x148a300de440, heap=heap@entry=0x148a300de8d0, entry=entry@entry=0x148a300de030, trx_id=0, thr=0x148a300c7910) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0ins.cc:3026

#9  0x00005638cdad4c08 in row_ins_sec_index_entry (index=index@entry=0x148a30067da0, entry=entry@entry=0x148a300de030, thr=thr@entry=0x148a300c7910, check_foreign=<optimized out>) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0ins.cc:3323

#10 0x00005638cdb4c0e4 in row_upd_sec_index_entry (node=node@entry=0x148a300b4608, thr=thr@entry=0x148a300c7910) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0upd.cc:2011

#11 0x00005638cdb4e164 in row_upd_sec_step (thr=0x148a300c7910, node=0x148a300b4608) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0upd.cc:2038

#12 row_upd (thr=0x148a300c7910, node=0x148a300b4608) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0upd.cc:2762

#13 row_upd_step (thr=thr@entry=0x148a300c7910) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0upd.cc:2877

#14 0x00005638cdafa36d in row_update_for_mysql (prebuilt=0x148a300b3bd0) at /test/git-bisect/11.3_dbg/storage/innobase/row/row0mysql.cc:1684

#15 0x00005638cd9b5962 in ha_innobase::update_row (this=0x148a300b1fa0, old_row=0x148a300b1b98 "\371\004", new_row=0x148a300b1b88 "\371\004") at /test/git-bisect/11.3_dbg/storage/innobase/handler/ha_innodb.cc:8611

#16 0x00005638cd6ca25f in handler::ha_update_row (this=0x148a300b1fa0, old_data=0x148a300b1b98 "\371\004", new_data=0x148a300b1b88 "\371\004") at /test/git-bisect/11.3_dbg/sql/handler.cc:7882

#17 0x00005638cd4d78fd in Sql_cmd_update::update_single_table (this=<optimized out>, thd=0x148a30000d58) at /test/git-bisect/11.3_dbg/sql/sql_update.cc:987

#18 0x00005638cd4d8756 in Sql_cmd_update::execute_inner (this=0x148a30095728, thd=0x148a30000d58) at /test/git-bisect/11.3_dbg/sql/sql_update.cc:3059

#19 0x00005638cd40e6fc in Sql_cmd_dml::execute (this=0x148a30095728, thd=0x148a30000d58) at /test/git-bisect/11.3_dbg/sql/sql_select.cc:33344

#20 0x00005638cd3ce977 in mysql_execute_command (thd=0x148a30000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:4371

#21 0x00005638cd5cd148 in sp_instr_stmt::exec_core (this=0x148a30099168, thd=<optimized out>, nextp=0x148aa40e0184) at /test/git-bisect/11.3_dbg/sql/sp_instr.cc:956

#22 0x00005638cd5d13f2 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x148a300991a0, thd=thd@entry=0x148a30000d58, nextp=nextp@entry=0x148aa40e0184, open_tables=open_tables@entry=false, instr=instr@entry=0x148a30099168, rerun_the_same_instr=rerun_the_same_instr@entry=false) at /test/git-bisect/11.3_dbg/sql/sp_instr.cc:296

#23 0x00005638cd5d1e25 in sp_lex_keeper::validate_lex_and_exec_core (this=this@entry=0x148a300991a0, thd=thd@entry=0x148a30000d58, nextp=nextp@entry=0x148aa40e0184, open_tables=open_tables@entry=false, instr=instr@entry=0x148a30099168) at /test/git-bisect/11.3_dbg/sql/sp_instr.cc:475

#24 0x00005638cd5d2759 in sp_instr_stmt::execute (this=0x148a30099168, thd=0x148a30000d58, nextp=0x148aa40e0184) at /test/git-bisect/11.3_dbg/sql/sp_instr.cc:862

#25 0x00005638cd314382 in sp_head::execute (this=this@entry=0x148a30085908, thd=thd@entry=0x148a30000d58, merge_da_on_success=merge_da_on_success@entry=true) at /test/git-bisect/11.3_dbg/sql/sp_head.cc:1280

#26 0x00005638cd316726 in sp_head::execute_procedure (this=0x148a30085908, thd=thd@entry=0x148a30000d58, args=0x148a30005fb8) at /test/git-bisect/11.3_dbg/sql/sp_head.cc:2267

#27 0x00005638cd3c1976 in do_execute_sp (thd=thd@entry=0x148a30000d58, sp=sp@entry=0x148a30085908) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:3025

#28 0x00005638cd3c60a8 in Sql_cmd_call::execute (this=0x148a30013348, thd=0x148a30000d58) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:3252

#29 0x00005638cd3d2b19 in mysql_execute_command (thd=thd@entry=0x148a30000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:5733

#30 0x00005638cd3d43a8 in mysql_parse (thd=thd@entry=0x148a30000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x148aa40e1200) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:7760

#31 0x00005638cd3d653c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x148a30000d58, packet=packet@entry=0x148a3000af69 "call p()", packet_length=packet_length@entry=8, blocking=blocking@entry=true) at /test/git-bisect/11.3_dbg/sql/sql_class.h:247

#32 0x00005638cd3d8417 in do_command (thd=0x148a30000d58, blocking=blocking@entry=true) at /test/git-bisect/11.3_dbg/sql/sql_parse.cc:1406

#33 0x00005638cd52f2ae in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5638d0ed5028, put_in_cache=put_in_cache@entry=true) at /test/git-bisect/11.3_dbg/sql/sql_connect.cc:1445

#34 0x00005638cd52f50d in handle_one_connection (arg=0x5638d0ed5028) at /test/git-bisect/11.3_dbg/sql/sql_connect.cc:1347

#35 0x0000148ad6094b43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#36 0x0000148ad6126a00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

2023-09-04  8:56:39 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_binaryhash` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}

2023-09-04  8:56:39 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_binaryhash` in table `test`.`binaries` in purge

2023-09-04  8:56:39 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `FK_collections` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}

2023-09-04  8:56:39 0 [ERROR] InnoDB: Flagged corruption of `FK_collections` in table `test`.`binaries` in purge

2023-09-04  9:00:19 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_binaryhash` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}

2023-09-04  9:00:19 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_binaryhash` in table `test`.`binaries` in purge

2023-09-04  9:00:19 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `FK_collections` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}

2023-09-04  9:00:19 0 [ERROR] InnoDB: Flagged corruption of `FK_collections` in table `test`.`binaries` in purge

--source include/have_innodb.inc

SET @freq=@@GLOBAL.innodb_purge_rseg_truncate_frequency;

SET GLOBAL innodb_purge_rseg_truncate_frequency=1;

CREATE TABLE collections (

  id int(11) unsigned NOT NULL AUTO_INCREMENT,

  collectionhash varchar(255) NOT NULL DEFAULT '0',

  PRIMARY KEY (id),

  UNIQUE KEY ix_collection_collectionhash (collectionhash)

) ENGINE=InnoDB;

CREATE TABLE binaries (

  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  collections_id int(11) unsigned NOT NULL DEFAULT 0,

  binaryhash binary(16) NOT NULL DEFAULT '0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',

  PRIMARY KEY (id),

  UNIQUE KEY ix_binary_binaryhash (binaryhash),

  CONSTRAINT FK_collections FOREIGN KEY (collections_id) REFERENCES collections (id) ON DELETE CASCADE

) ENGINE=InnoDB;

INSERT INTO collections (id) VALUES (NULL);

--connect (con1,localhost,root,,)

INSERT INTO binaries (id,collections_id) VALUES (NULL,1);

--send

  REPLACE INTO collections (id) VALUES (NULL);

--connection default

--error 0,ER_LOCK_DEADLOCK,ER_NO_REFERENCED_ROW_2

REPLACE INTO binaries (id) VALUES (NULL);

SET GLOBAL innodb_max_purge_lag_wait=0;

CHECK TABLE binaries, collections EXTENDED;

SET GLOBAL innodb_purge_rseg_truncate_frequency=@freq;

# Cleanup

DROP TABLE binaries, collections;

2023-09-04  9:19:09 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `ix_binary_binaryhash` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[16]0               (0x30000000000000000000000000000000),[8]        (0x0000000000000001)}

2023-09-04  9:19:09 0 [ERROR] InnoDB: Flagged corruption of `ix_binary_binaryhash` in table `test`.`binaries` in purge

2023-09-04  9:19:09 0 [ERROR] InnoDB: tried to purge non-delete-marked record in index `FK_collections` of table `test`.`binaries`: tuple: TUPLE (info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[4]    (0x00000001),[8]        (0x0000000000000001)}

2023-09-04  9:19:09 0 [ERROR] InnoDB: Flagged corruption of `FK_collections` in table `test`.`binaries` in purge

^ Found warnings in /dev/shm/10.6/mysql-test/var/18/log/mysqld.1.err

#1  0x00005574e4fd0459 in btr_rec_set_deleted<true> (block=..., rec=..., mtr=...)

    at /mariadb/10.6/storage/innobase/btr/btr0cur.cc:4352

#2  0x00005574e4fc3269 in btr_cur_del_mark_set_clust_rec (block=..., rec=..., index=..., offsets=..., 

    thr=..., entry=..., mtr=...) at /mariadb/10.6/storage/innobase/btr/btr0cur.cc:4417

#3  0x00005574e515cdca in row_upd_del_mark_clust_rec (node=..., index=..., offsets=..., thr=..., 

    referenced=..., foreign=..., mtr=...) at /mariadb/10.6/storage/innobase/row/row0upd.cc:2494

#4  0x00005574e515e6ef in row_upd_clust_step (node=..., thr=...)

    at /mariadb/10.6/storage/innobase/row/row0upd.cc:2636

#5  0x00005574e515ea98 in row_upd (node=..., thr=...)

    at /mariadb/10.6/storage/innobase/row/row0upd.cc:2758

#6  0x00005574e515ed88 in row_upd_step (thr=...) at /mariadb/10.6/storage/innobase/row/row0upd.cc:2900

#7  0x00005574e511ffd1 in row_update_cascade_for_mysql (thr=..., node=..., table=...)

    at /mariadb/10.6/storage/innobase/row/row0mysql.cc:2015

#8  0x00005574e5106bd8 in row_ins_foreign_check_on_constraint (thr=..., foreign=..., pcur=..., 

    entry=..., mtr=...) at /mariadb/10.6/storage/innobase/row/row0ins.cc:1351

#9  0x00005574e5107752 in row_ins_check_foreign_constraint (check_ref=..., foreign=..., table=..., 

    entry=..., thr=...) at /mariadb/10.6/storage/innobase/row/row0ins.cc:1744

#10 0x00005574e515cb1a in row_upd_check_references_constraints (node=..., pcur=..., table=..., 

    index=..., offsets=..., thr=..., mtr=...) at /mariadb/10.6/storage/innobase/row/row0upd.cc:252

#11 0x00005574e515cf2f in row_upd_del_mark_clust_rec (node=..., index=..., offsets=..., thr=..., 

    referenced=..., foreign=..., mtr=...) at /mariadb/10.6/storage/innobase/row/row0upd.cc:2502

#12 0x00005574e515e6ef in row_upd_clust_step (node=..., thr=...)

    at /mariadb/10.6/storage/innobase/row/row0upd.cc:2636

#13 0x00005574e515ea98 in row_upd (node=..., thr=...)

    at /mariadb/10.6/storage/innobase/row/row0upd.cc:2758

#14 0x00005574e515ed88 in row_upd_step (thr=...) at /mariadb/10.6/storage/innobase/row/row0upd.cc:2900

#15 0x00005574e511ebe7 in row_update_for_mysql (prebuilt=...)

    at /mariadb/10.6/storage/innobase/row/row0mysql.cc:1688

#16 0x00005574e4f2a66a in ha_innobase::delete_row (this=..., record=...)

    at /mariadb/10.6/storage/innobase/handler/ha_innodb.cc:8809

		switch (trx->error_state) {

		case DB_LOCK_WAIT:

			if (lock_wait(thr) == DB_SUCCESS) {

				continue;

			}

			/* fall through */

		default:

			/* Other errors are handled for the parent node. */

			thr->fk_cascade_depth = 0;

			return trx->error_state;

origin/bb-10.6-MDEV-30531 40061be1bdfb4c13afe39dae151764e4afd0a3df 2023-09-06T13:48:20+03:00

performed well in RQG testing. No not yet known bad effects.

Please be aware that I do not have some test which replays exact what is mentioned on top.

But there are on bb-10.6-MDEV-30531 and many other source trees many RQG tests using ddl and dml with foreign keys failing.

Hence I am unable to tell if MDEV-30531 is really fixed.