[MDEV-32352] binlog.flashback-largebinlog crashes server on Debian CI arm64 runner Created: 2023-10-05  Updated: 2023-10-07

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Otto Kekäläinen Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19764 binlog.flashback-largebinlog fails in... Closed

 Description   

After uploading MariaDB 1:10.11.5-1 to Debian I noticed that the Debian CI that runs the autopkgtests failed on arm64 runners with:

6114s binlog.flashback-largebinlog 'row'       [ fail ]
 
6114s         Test ended at 2023-10-04 16:13:55
 
6114s 
6114s CURRENT_TEST: binlog.flashback-largebinlog
 
6114s mysqltest: At line 79: query 'INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 67108864))' failed: <Unknown> (2013): Lost connection to server during query
 
6114s 
6114s The result from queries just before the failure was:
 
6114s < snip >
 
6114s connect  default, localhost,root,,;
 
6114s #
 
6114s # Delete all existing binary logs.
 
6114s #
 
6114s RESET MASTER;
 
6114s #
 
6114s # Create a test table.
 
6114s #
 
6114s use mysqltest;
 
6114s CREATE TABLE t1 (
 
6114s c1 LONGTEXT
 
6114s ) DEFAULT CHARSET latin1;
 
6114s #
 
6114s # Show how many rows are affected by each statement.
 
6114s #
 
6114s #
 
6114s # Insert some big rows.
 
6114s #
 
6114s insert 1024MB data twice
 
6114s INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 67108864));
 
6114s 
6114s More results from queries before failure can be found in /tmp/tmp.NtzFV4mDaK/var/log/flashback-largebinlog.log
 
6114s 
6114s 
6114s Server [mysqld.1 - pid: 169773, winpid: 169773, exit: 256] failed during test run
 
6114s Server log from this test:
 
6114s ----------SERVER LOG START-----------
 
6114s $ /usr/sbin/mariadbd --defaults-group-suffix=.1 --defaults-file=/tmp/tmp.NtzFV4mDaK/var/my.cnf --log-output=file --log-bin=master-bin --binlog-format=row --log-bin=master-bin --core-file --loose-debug-sync-timeout=300
 
6114s 2023-10-04 16:13:36 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
 
6114s 2023-10-04 16:13:36 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
 
6114s 2023-10-04 16:13:36 0 [Warning] setrlimit could not change the size of core files to 'infinity';  We may not be able to generate a core file on signals
 
6114s 2023-10-04 16:13:36 0 [Note] Starting MariaDB 10.11.5-MariaDB-1-log source revision  as process 169774
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'partition' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'SEQUENCE' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'InnoDB' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMP' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'FEEDBACK' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'user_variables' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Note] Plugin 'unix_socket' is disabled.
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
 
6114s 2023-10-04 16:13:36 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
 
6114s 2023-10-04 16:13:36 0 [Note] Server socket created on IP: '127.0.0.1'.
 
6114s 2023-10-04 16:13:36 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
6114s Version: '10.11.5-MariaDB-1-log'  socket: '/tmp/tmp.NtzFV4mDaK/tmp/mysqld.1.sock'  port: 16000  Debian n/a

Full log at https://ci.debian.net/data/autopkgtest/testing/arm64/m/mariadb/38568533/log.gz

This was seen only on arm64, so it could be specific to architecture or the runner that runs arm64 CI jobs.

 Comments   
Comment by Otto Kekäläinen [ 2023-10-07 ]

This was passing in https://launchpadlibrarian.net/690729954/buildlog_ubuntu-mantic-arm64.mariadb_1%3A10.11.5-2~bpo23.10.1~1696620362.87d091ed5f9+feature.re.enable.all.tests_BUILDING.txt.gz

binlog.flashback-largebinlog 'row'       w2 [ pass ]  26119

Generated at Thu Feb 08 10:30:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.