[MDEV-28100] reiserfs O_DIRECT unsupported: Assertion `p == pages.end() || p->first > page_id' failed in recv_sys_t::apply - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.6, 10.7, 10.8
Fix Version/s: 10.6
Component/s: None
Labels:
- not-10.5
Environment:
reiserfs, ubuntu 20.04 + fc35 (5.17.0-0.rc6.109.fc37.x86_64)

Description

innodb.log_file_name test fails on reiserfs file system

10.8 8575d2fb396d576f4e54d58
/10.8/mysql-test$ ./mtr innodb.log_file_name

innodb.log_file_name 'innodb' [ fail ]
Test ended at 2022-03-16 11:09:35

CURRENT_TEST: innodb.log_file_name


Server [mysqld.1 - pid: 183172, winpid: 183172, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:10 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 182968 ...
2022-03-16 11:09:10 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:10 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:10 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:10 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:10 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:10 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:10 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:10 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:10 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:10 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:10 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-16 11:09:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2022-03-16 11:09:14 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-03-16 11:09:14 0 [Note] InnoDB: log sequence number 48591; transaction id 17
2022-03-16 11:09:14 0 [Note] InnoDB: Loading buffer pool(s) from /10.8/mysql-test/var/mysqld.1/data/ib_buffer_pool
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:14 0 [Note] InnoDB: Buffer pool(s) load completed at 220316 11:09:14
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:14 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:14 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:14 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:14 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:14 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:14 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:14 0 [Note] InnoDB: FTS optimize thread exiting.
2022-03-16 11:09:14 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:14 0 [Note] InnoDB: Dumping buffer pool(s) to /10.8/mysql-test/var/mysqld.1/data/ib_buffer_pool
2022-03-16 11:09:14 0 [Note] InnoDB: Restricted to 124 pages due to innodb_buf_pool_dump_pct=25
2022-03-16 11:09:14 0 [Note] InnoDB: Buffer pool(s) dump completed at 220316 11:09:14
2022-03-16 11:09:15 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-03-16 11:09:15 0 [Note] InnoDB: Shutdown completed; log sequence number 50367; transaction id 21
2022-03-16 11:09:15 0 [Note] Debug sync points hit: 1164
2022-03-16 11:09:15 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:15 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:15 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:15 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 182992 ...
2022-03-16 11:09:15 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:15 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:15 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:15 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:15 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:15 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:15 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:15 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:15 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:15 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:15 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:15 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:16 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-16 11:09:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2022-03-16 11:09:19 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-03-16 11:09:19 0 [Note] InnoDB: log sequence number 50367; transaction id 22
2022-03-16 11:09:19 0 [Note] InnoDB: Loading buffer pool(s) from /10.8/mysql-test/var/mysqld.1/data/ib_buffer_pool
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:19 0 [Note] InnoDB: Buffer pool(s) load completed at 220316 11:09:19
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:19 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:19 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:19 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:19 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:19 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183012 ...
2022-03-16 11:09:19 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:19 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:19 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:19 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:19 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:19 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:19 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:19 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:20 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:20 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:20 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:20 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:20 0 [Note] InnoDB: Ignoring data file './test/t2.ibd' with space ID 5. Another data file called ./test/t1.ibd exists with the same space ID.
2022-03-16 11:09:20 0 [ERROR] InnoDB: Cannot replay rename of tablespace 5 from './test/t1.ibd' to './test/t2.ibd' because the target file exists
2022-03-16 11:09:20 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Tablespace already exists
2022-03-16 11:09:20 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:20 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:20 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:20 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:20 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:20 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:20 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:20 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:20 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:20 0 [Note] Debug sync points hit: 309
2022-03-16 11:09:20 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:20 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:20 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:21 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183026 ...
2022-03-16 11:09:21 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:21 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:21 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:21 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:21 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:21 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:21 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:21 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:21 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:21 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:21 0 [ERROR] InnoDB: Tablespace 6 was not found at ./test/t3.ibd.
2022-03-16 11:09:21 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2022-03-16 11:09:21 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Tablespace not found
2022-03-16 11:09:21 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:21 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:21 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:21 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:21 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:21 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:21 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:21 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:21 0 [Note] Debug sync points hit: 308
2022-03-16 11:09:21 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:21 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:21 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:23 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183040 ...
2022-03-16 11:09:23 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:23 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:23 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:23 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:23 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:23 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:23 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:23 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:23 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:23 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:23 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:23 0 [ERROR] InnoDB: Tablespace 6 was not found at ./test/t3.ibd.
2022-03-16 11:09:23 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2022-03-16 11:09:23 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Tablespace not found
2022-03-16 11:09:23 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:23 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:23 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:23 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:23 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:23 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:23 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:23 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:23 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:23 0 [Note] Debug sync points hit: 308
2022-03-16 11:09:23 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:23 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:23 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:24 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183062 ...
2022-03-16 11:09:24 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:24 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:24 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:24 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:24 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:24 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:24 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:24 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:24 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:24 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:24 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:24 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:24 0 [ERROR] InnoDB: Tablespace 5 was not found at ./test/t1.ibd.
2022-03-16 11:09:24 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2022-03-16 11:09:24 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Tablespace not found
2022-03-16 11:09:24 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:25 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:25 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:25 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:25 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:25 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:25 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:25 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:25 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:25 0 [Note] Debug sync points hit: 308
2022-03-16 11:09:25 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:25 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:25 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:26 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183078 ...
2022-03-16 11:09:26 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:26 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:26 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:26 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:26 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:26 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:26 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:26 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:26 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:26 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:26 0 [ERROR] InnoDB: Operating system error number 21 in a file operation.
2022-03-16 11:09:26 0 [ERROR] InnoDB: Error number 21 means 'Is a directory'
2022-03-16 11:09:26 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-03-16 11:09:26 0 [ERROR] InnoDB: Cannot open datafile for read-write: './test/t2.ibd'
2022-03-16 11:09:26 0 [ERROR] InnoDB: Tablespace 5 was not found at ./test/t1.ibd.
2022-03-16 11:09:26 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2022-03-16 11:09:26 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Tablespace not found
2022-03-16 11:09:26 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:26 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:26 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:26 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:26 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:26 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:26 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:26 0 [Note] Debug sync points hit: 308
2022-03-16 11:09:26 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:26 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:26 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:28 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183090 ...
2022-03-16 11:09:28 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:28 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:28 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:28 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:28 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:28 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:28 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:28 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:28 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:28 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:28 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:28 0 [ERROR] InnoDB: Cannot apply log to [page id: space=5, page number=3] of corrupted file './test/t2.ibd'
2022-03-16 11:09:28 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1193] with error Data structure corruption
2022-03-16 11:09:28 0 [Note] InnoDB: Starting shutdown...
2022-03-16 11:09:28 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-03-16 11:09:28 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:28 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:28 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:28 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:28 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:28 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:28 0 [Note] /10.8/sql/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
2022-03-16 11:09:28 0 [Note] Debug sync points hit: 308
2022-03-16 11:09:28 0 [Note] Debug sync points executed: 0
2022-03-16 11:09:28 0 [Note] Debug sync points max active per thread: 0
2022-03-16 11:09:28 0 [Note] /10.8/sql/mariadbd: Shutdown complete

$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:29 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183149 ...
2022-03-16 11:09:29 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:29 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:29 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:29 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:29 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:29 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:29 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:29 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:29 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:29 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:29 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:29 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50351
2022-03-16 11:09:29 0 [Note] InnoDB: Starting final batch to recover 9 pages from redo log.
2022-03-16 11:09:29 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-16 11:09:29 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2022-03-16 11:09:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2022-03-16 11:09:33 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-03-16 11:09:33 0 [Note] InnoDB: log sequence number 55857; transaction id 40
2022-03-16 11:09:33 0 [Note] InnoDB: Loading buffer pool(s) from /10.8/mysql-test/var/mysqld.1/data/ib_buffer_pool
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_CMP' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
2022-03-16 11:09:33 0 [Note] InnoDB: Buffer pool(s) load completed at 220316 11:09:33
2022-03-16 11:09:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'user_variables' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
2022-03-16 11:09:33 0 [Note] Plugin 'unix_socket' is disabled.
2022-03-16 11:09:33 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-pam-debug'
2022-03-16 11:09:33 0 [Warning] /10.8/sql/mariadbd: unknown option '--loose-aria'
2022-03-16 11:09:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-03-16 11:09:33 0 [Note] /10.8/sql/mariadbd: ready for connections.
Version: '10.8.3-MariaDB-debug-log' socket: '/10.8/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
2022-03-16 11:09:33 3 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2022-03-16 11:09:33 3 [ERROR] InnoDB: Error number 17 means 'File exists'
2022-03-16 11:09:33 3 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-03-16 11:09:33 3 [Note] InnoDB: The file './test/t0.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. You can resolve the problem by removing the file.
2022-03-16 11:09:33 3 [ERROR] InnoDB: Cannot create file './test/t0.ibd'
2022-03-16 11:09:33 3 [ERROR] InnoDB: Operating system error number 17 in a file operation.
2022-03-16 11:09:33 3 [ERROR] InnoDB: Error number 17 means 'File exists'
2022-03-16 11:09:33 3 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-03-16 11:09:33 3 [Note] InnoDB: The file './test/t0.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. You can resolve the problem by removing the file.
2022-03-16 11:09:33 3 [ERROR] InnoDB: Cannot create file './test/t0.ibd'
$ /10.8/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/10.8/mysql-test/var/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb-force-recovery=1 --core-file --loose-debug-sync-timeout=300
2022-03-16 11:09:34 0 [Note] /10.8/sql/mariadbd (server 10.8.3-MariaDB-debug-log) starting as process 183173 ...
2022-03-16 11:09:34 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190)
2022-03-16 11:09:34 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2022-03-16 11:09:34 0 [Note] Plugin 'partition' is disabled.
2022-03-16 11:09:34 0 [Note] Plugin 'SEQUENCE' is disabled.
2022-03-16 11:09:34 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2022-03-16 11:09:34 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-03-16 11:09:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-16 11:09:34 0 [Note] InnoDB: Number of transaction pools: 1
2022-03-16 11:09:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-16 11:09:34 0 [Note] mariadbd: O_TMPFILE is not supported on /10.8/mysql-test/var/tmp/mysqld.1 (disabling future attempts)
2022-03-16 11:09:34 0 [Note] InnoDB: Using Linux native AIO
2022-03-16 11:09:34 0 [Note] InnoDB: Initializing buffer pool, total size = 8.000MiB, chunk size = 1.000MiB
2022-03-16 11:09:34 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-16 11:09:34 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 56076: unable to open file ./test/t2.ibd for tablespace 5
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 56076: unable to open file ./test/t3.ibd for tablespace 6
2022-03-16 11:09:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=50367
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 52376: unable to open file ./test/t1.ibd for tablespace 5
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 53635: unable to open file ./test/t1.ibd for tablespace 5
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 58598: unable to open file ./test/t0.ibd for tablespace 8
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 59099: unable to open file ./test/t0.ibd for tablespace 9
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 59602: unable to open file ./test/t0.ibd for tablespace 10
2022-03-16 11:09:34 0 [Note] InnoDB: Cannot read first page of './test/u2.ibd': I/O error
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 65854: unable to open file ./test/u3.ibd for tablespace 13
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 69820: unable to open file ./test/u5.ibd for tablespace 14
2022-03-16 11:09:34 0 [Note] InnoDB: At LSN: 71107: unable to open file ./test/u5.ibd for tablespace 14
2022-03-16 11:09:34 0 [Warning] InnoDB: Tablespace 13 was not found at ./test/u3.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!
2022-03-16 11:09:34 0 [Warning] InnoDB: Tablespace 8 was not found at ./test/t0.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!
2022-03-16 11:09:34 0 [Warning] InnoDB: Tablespace 9 was not found at ./test/t0.ibd, and innodb_force_recovery was set. All redo log for this tablespace will be ignored!
2022-03-16 11:09:34 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2022-03-16 11:09:34 0 [ERROR] InnoDB: Write to file ./test/u2.ibd failed at offset 0, 98304 bytes should have been written, only 0 were written. Operating system error number 22. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2022-03-16 11:09:34 0 [ERROR] InnoDB: Error number 22 means 'Invalid argument'
2022-03-16 11:09:34 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-03-16 11:09:34 0 [ERROR] InnoDB: Cannot apply log to [page id: space=12, page number=0] of corrupted file './test/u2.ibd'
2022-03-16 11:09:34 0 [Note] InnoDB: Starting final batch to recover 16 pages from redo log.
mariadbd: /10.8/storage/innobase/log/log0recv.cc:3399: void recv_sys_t::apply(bool): Assertion `p == pages.end() \|\| p->first > page_id' failed.
220316 11:09:34 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.8.3-MariaDB-debug-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63896 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
mysys/stacktrace.c:212(my_print_stacktrace)[0x55c95074f5ee]
sql/signal_handler.cc:226(handle_fatal_signal)[0x55c94fe5d7be]
sigaction.c:0(__restore_rt)[0x7f879853a3c0]
??:0(gsignal)[0x7f879802303b]
??:0(abort)[0x7f8798002859]
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f8798002729]
??:0(__assert_fail)[0x7f8798014006]
log/log0recv.cc:3402(recv_sys_t::apply(bool))[0x55c950379984]
srv/srv0start.cc:1235(srv_start(bool))[0x55c9504d060d]
handler/ha_innodb.cc:4178(innodb_init(void*))[0x55c950295c19]
sql/handler.cc:649(ha_initialize_handlerton(st_plugin_int*))[0x55c94fe61591]
sql/sql_plugin.cc:1463(plugin_initialize(st_mem_root, st_plugin_int, int, char*, bool))[0x55c94fad0632]
sql/sql_plugin.cc:1756(plugin_init(int, char*, int))[0x55c94fad1497]
sql/mysqld.cc:5091(init_server_components())[0x55c94f90bdfd]
sql/mysqld.cc:5705(mysqld_main(int, char**))[0x55c94f90d176]
sql/main.cc:34(main)[0x55c94f90178d]
??:0(__libc_start_main)[0x7f87980040b3]
??:0(_start)[0x55c94f9016ae]
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /10.8/mysql-test/var/mysqld.1/data
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size unlimited unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 126857 126857 processes
Max open files 1024 1024 files
Max locked memory 67108864 67108864 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 126857 126857 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: /tmp/cores/core.%e.%p.%t

----------SERVER LOG END-------------
mysqltest failed but provided no output
The result from queries just before the failure was:
< snip >
t2
t3
DROP TABLE t2,t3;
CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
ERROR HY000: Can't create table `test`.`t0` (errno: 184 "Tablespace already exists")
CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
ERROR HY000: Can't create table `test`.`t0` (errno: 184 "Tablespace already exists")
CREATE TABLE t0(a INT PRIMARY KEY) ENGINE=InnoDB;
DROP TABLE t0;
CREATE TABLE u1(a INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE u2(a INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE u3(a INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE u4(a INT PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO u4 VALUES(1);
RENAME TABLE u4 TO u5;
RENAME TABLE u5 TO u6;
INSERT INTO u6 VALUES(2);
# Kill the server
# Fault 6: All-zero data file and innodb_force_recovery
# restart: --innodb-force-recovery=1

Attachments

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

MDEV-28100.c
0.6 kB
2022-06-12 05:00

Issue Links

relates to

MDEV-28751 mariadb-install-db fails writing ibdata1 on overlayfs

Open

Activity

People

Assignee:: Unassigned

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2022-03-16 11:54

Updated:: 2023-09-19 04:12

Git Integration

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