Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11.5
-
None
-
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
Issue Links
- is duplicated by
-
-
- Closed
-
- relates to
-
-
- Closed
-