[MDEV-34480] mariadb 10.11.5 bulk insert: crash, errorlog: InnoDB: Assertion failure - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.11.5
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB
Labels:
None
Environment:
system: CentOS 8.1 aarch64
kernel: 4.18.0-147.el8.aarch64
gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10)

Description

Compile mariadb 10.11.5 in cengos 8.1 aarch64 environment and run it, then use sysbench to perform stress test. When importing data, an error message appears:

2024-06-27 20:53:43 0xffff5b4d7f10  InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122

InnoDB: Failing assertion: addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA

1. Environmental Check

[root@dbtestarm08v logs]# cat /etc/os-release

NAME="CentOS Linux"

VERSION="8 (Core)"

ID="centos"

ID_LIKE="rhel fedora"

VERSION_ID="8"

PLATFORM_ID="platform:el8"

PRETTY_NAME="CentOS Linux 8 (Core)"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:centos:centos:8"

HOME_URL="https://www.centos.org/"

BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-8"

CENTOS_MANTISBT_PROJECT_VERSION="8"

REDHAT_SUPPORT_PRODUCT="centos"

REDHAT_SUPPORT_PRODUCT_VERSION="8"

[root@dbtestarm08v logs]# cat /etc/redhat-release

CentOS Linux release 8.1.1911 (Core)

[root@dbtestarm08v logs]# uname -r

4.18.0-147.el8.aarch64

[root@dbtestarm08v logs]# gcc --version

gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10)

Copyright (C) 2018 Free Software Foundation, Inc.

This is free software; see the source for copying conditions.  There is NO

warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

2. Prepare

yum install git gcc gcc-c++ tar make cmake bison ncurses-devel openssl openssl-devel

yum install valgrind libcurl-devel gzip zlib-devel lz4-devel lzo-devel bzip2-devel libxml2-devel libevent-devel libaio-devel boost pcre2-devel systemd-devel rpm-build libaio-devel zstd pam-devel checkpolicy galera

yum install gnutls-devel

rpm -ivh snappy-devel-1.1.7-5.el8.aarch64.rpm

policycoreutils-python  Not installed

3. Compile

cmake -DCMAKE_INSTALL_PREFIX=/opt/mariadb3306 -DMYSQL_DATADIR=/opt/mariadb3306/data -DSYSCONFDIR=/opt/mariadb3306/config -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITHOUT_TOKUDB=1 .

make -j4

make install

4. start up

/opt/mariadb3306/scripts/mysql_install_db --defaults-file=/opt/mariadb3306/config/my.cnf --basedir=/opt/mariadb3306 --datadir=/opt/mariadb3306/data --user=mariadb --verbos

systemctl start mariadb3306

/opt/mariadb3306/bin/mysql -S /tmp/.mariadb3306.sock

mysql> create database sysbench;

5. sysbench

sysbench /usr/share/sysbench/oltp_read_write.lua --time=300 --mysql-socket=/tmp/.mariadb3306.sock --mysql-user=root --mysql-password='' --mysql-db=sysbench --table-size=10000000 --tables=30 --threads=30 prepare

6. error

Inserting 10000000 records into 'sbtest25'

Inserting 10000000 records into 'sbtest10'

Inserting 10000000 records into 'sbtest29'

Inserting 10000000 records into 'sbtest26'

Inserting 10000000 records into 'sbtest12'

Inserting 10000000 records into 'sbtest27'

FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest18(k, c, pad) VALUES(4982450, '27333409089-41466003646-46305396567-64653676251-73297592377-79150034613-19809050393-20250424742-70385308637-05921926330', '12137946057-85181373915-11633449864-06171602338-56287162609')......

7. error.log file

2024-06-27 20:53:43 0xffff5b4d7f10  InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122

InnoDB: Failing assertion: addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA

InnoDB: We intentionally generate a memory trap.

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

InnoDB: If you get repeated assertion failures or crashes, even

InnoDB: immediately after the mariadbd startup, there may be

InnoDB: corruption in the InnoDB tablespace. Please refer to

InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/

InnoDB: about forcing recovery.

coredump file exceeds the size limit set by your administrator (10.00 MB). If necessary, I will try to provide

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

error.log
82 kB
2024-06-27 14:09
my.cnf
7 kB
2024-06-27 14:09
图片_lx_clip1719558292963.png
580 kB
2024-06-28 07:39

Issue Links

is duplicated by

MDEV-34479 mariadb 10.11.5 bulk insert: Index for table 'sbtest24' is corrupt; try to repair it

Closed

relates to

MDEV-32817 在最近将版本升级到10.11.5后，针对表进行频繁的读写操作不久后，出现index for table xxxx is corrupt，随后此表tablespace xxxxxx corrupted，最后Tablespace is missing for a table，此表已完全不可用

Closed

Activity

Ascending order - Click to sort in descending order

ls created issue - 2024-06-27 14:11

ls made changes - 2024-06-27 14:15

Field	Original Value	New Value
Description	Compile mariadb 10.11.5 in cengos 8.1 aarch64 environment and run it, then use sysbench to perform stress test. When importing data, an error message appears: {code:java} 2024-06-27 20:53:43 0xffff5b4d7f10 InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122 InnoDB: Failing assertion: addr.page == FIL_NULL \|\| addr.boffset >= FIL_PAGE_DATA {code} 1. Environmental Check {code:java} [root@dbtestarm08v logs]# cat /etc/os-release NAME="CentOS Linux" VERSION="8 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="8" PLATFORM_ID="platform:el8" PRETTY_NAME="CentOS Linux 8 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:8" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-8" CENTOS_MANTISBT_PROJECT_VERSION="8" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="8" {code} {code:java} [root@dbtestarm08v logs]# uname -r 4.18.0-147.el8.aarch64 [root@dbtestarm08v logs]# [root@dbtestarm08v logs]# gcc --version gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10) Copyright (C) 2018 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. {code} 2. Prepare {code:java} yum install git gcc gcc-c++ tar make cmake bison ncurses-devel openssl openssl-devel yum install valgrind libcurl-devel gzip zlib-devel lz4-devel lzo-devel bzip2-devel libxml2-devel libevent-devel libaio-devel boost pcre2-devel systemd-devel rpm-build libaio-devel zstd pam-devel checkpolicy galera yum install gnutls-devel rpm -ivh snappy-devel-1.1.7-5.el8.aarch64.rpm policycoreutils-python Not installed {code} 3. Compile {code:java} cmake -DCMAKE_INSTALL_PREFIX=/opt/mariadb3306 -DMYSQL_DATADIR=/opt/mariadb3306/data -DSYSCONFDIR=/opt/mariadb3306/config -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITHOUT_TOKUDB=1 . make -j4 make install {code} 4. start up {code:java} /opt/mariadb3306/scripts/mysql_install_db --defaults-file=/opt/mariadb3306/config/my.cnf --basedir=/opt/mariadb3306 --datadir=/opt/mariadb3306/data --user=mariadb --verbos systemctl start mariadb3306 /opt/mariadb3306/bin/mysql -S /tmp/.mariadb3306.sock mysql> create database sysbench; {code} 5. sysbench {code:java} sysbench /usr/share/sysbench/oltp_read_write.lua --time=300 --mysql-socket=/tmp/.mariadb3306.sock --mysql-user=root --mysql-password='' --mysql-db=sysbench --table-size=10000000 --tables=30 --threads=30 prepare {code} 6. error {code:java} Inserting 10000000 records into 'sbtest25' Inserting 10000000 records into 'sbtest10' Inserting 10000000 records into 'sbtest29' Inserting 10000000 records into 'sbtest26' Inserting 10000000 records into 'sbtest12' Inserting 10000000 records into 'sbtest27' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest18(k, c, pad) VALUES(4982450, '27333409089-41466003646-46305396567-64653676251-73297592377-79150034613-19809050393-20250424742-70385308637-05921926330', '12137946057-85181373915-11633449864-06171602338-56287162609')...... {code} 7. error.log file {code:java} 2024-06-27 20:53:43 0xffff5b4d7f10 InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122 InnoDB: Failing assertion: addr.page == FIL_NULL \|\| addr.boffset >= FIL_PAGE_DATA InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mariadbd startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. {code} coredump file exceeds the size limit set by your administrator (10.00 MB). If necessary, I will try to provide	Compile mariadb 10.11.5 in cengos 8.1 aarch64 environment and run it, then use sysbench to perform stress test. When importing data, an error message appears: {code:java} 2024-06-27 20:53:43 0xffff5b4d7f10 InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122 InnoDB: Failing assertion: addr.page == FIL_NULL \|\| addr.boffset >= FIL_PAGE_DATA {code} 1. Environmental Check {code:java} [root@dbtestarm08v logs]# cat /etc/os-release NAME="CentOS Linux" VERSION="8 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="8" PLATFORM_ID="platform:el8" PRETTY_NAME="CentOS Linux 8 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:8" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-8" CENTOS_MANTISBT_PROJECT_VERSION="8" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="8" {code} {code:java} [root@dbtestarm08v logs]# cat /etc/redhat-release CentOS Linux release 8.1.1911 (Core) [root@dbtestarm08v logs]# uname -r 4.18.0-147.el8.aarch64 [root@dbtestarm08v logs]# gcc --version gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10) Copyright (C) 2018 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. {code} 2. Prepare {code:java} yum install git gcc gcc-c++ tar make cmake bison ncurses-devel openssl openssl-devel yum install valgrind libcurl-devel gzip zlib-devel lz4-devel lzo-devel bzip2-devel libxml2-devel libevent-devel libaio-devel boost pcre2-devel systemd-devel rpm-build libaio-devel zstd pam-devel checkpolicy galera yum install gnutls-devel rpm -ivh snappy-devel-1.1.7-5.el8.aarch64.rpm policycoreutils-python Not installed {code} 3. Compile {code:java} cmake -DCMAKE_INSTALL_PREFIX=/opt/mariadb3306 -DMYSQL_DATADIR=/opt/mariadb3306/data -DSYSCONFDIR=/opt/mariadb3306/config -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITHOUT_TOKUDB=1 . make -j4 make install {code} 4. start up {code:java} /opt/mariadb3306/scripts/mysql_install_db --defaults-file=/opt/mariadb3306/config/my.cnf --basedir=/opt/mariadb3306 --datadir=/opt/mariadb3306/data --user=mariadb --verbos systemctl start mariadb3306 /opt/mariadb3306/bin/mysql -S /tmp/.mariadb3306.sock mysql> create database sysbench; {code} 5. sysbench {code:java} sysbench /usr/share/sysbench/oltp_read_write.lua --time=300 --mysql-socket=/tmp/.mariadb3306.sock --mysql-user=root --mysql-password='' --mysql-db=sysbench --table-size=10000000 --tables=30 --threads=30 prepare {code} 6. error {code:java} Inserting 10000000 records into 'sbtest25' Inserting 10000000 records into 'sbtest10' Inserting 10000000 records into 'sbtest29' Inserting 10000000 records into 'sbtest26' Inserting 10000000 records into 'sbtest12' Inserting 10000000 records into 'sbtest27' FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'INSERT INTO sbtest18(k, c, pad) VALUES(4982450, '27333409089-41466003646-46305396567-64653676251-73297592377-79150034613-19809050393-20250424742-70385308637-05921926330', '12137946057-85181373915-11633449864-06171602338-56287162609')...... {code} 7. error.log file {code:java} 2024-06-27 20:53:43 0xffff5b4d7f10 InnoDB: Assertion failure in file /opt/build-mariadb/mariadb-10.11.5/storage/innobase/include/fut0lst.h line 122 InnoDB: Failing assertion: addr.page == FIL_NULL \|\| addr.boffset >= FIL_PAGE_DATA InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mariadbd startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. {code} coredump file exceeds the size limit set by your administrator (10.00 MB). If necessary, I will try to provide

Marko Mäkelä made changes - 2024-06-27 15:04

Status

Open [ 1 ]

Needs Feedback [ 10501 ]

ls made changes - 2024-06-28 07:39

Attachment

图片_lx_clip1719558292963.png [ 73715 ]

Ralf Gebhardt made changes - 2024-06-28 07:42

Link

This issue is duplicated by ~~MDEV-34479~~ [ ~~MDEV-34479~~ ]

Marko Mäkelä made changes - 2024-06-28 07:44

Link

This issue relates to ~~MDEV-32817~~ [ ~~MDEV-32817~~ ]

Sergei Golubchik made changes - 2024-07-29 12:30

Status

Needs Feedback [ 10501 ]

Open [ 1 ]

Sergei Golubchik made changes - 2024-07-29 12:30

Component/s		Storage Engine - InnoDB [ 10129 ]
Fix Version/s		N/A [ 14700 ]
Resolution		Duplicate [ 3 ]
Status	Open [ 1 ]	Closed [ 6 ]

People

Assignee:: Unassigned

Reporter:: ls

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2024-06-27 14:11

Updated:: 2024-07-29 12:30

Resolved:: 2024-07-29 12:30

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration