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

binlog.flashback-largebinlog crashes server on Debian CI arm64 runner

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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