Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6.20
-
None
Description
Scenario:
1. Start a server and load some initial data.
2. Several connections run random SQL in concurrent
3. During 2. is ongoing run cycles consisting of
3.1 mariabackup --backup <to location A>
3.2 mariabackup --prepare <on location A>
3.3 Start a server on the data on location A
3.4 Run certain checks on the data of that server
3.5 Shutdown that server
At some point of time the shutdown failed with
2024-08-29 14:23:12 0 [Note] /data/Server_bin/10.6-MDEV-34830_debug_Og/bin/mariadbd (initiated by: root[root] @ localhost [127.0.0.1]): Normal shutdown
2024-08-29 14:23:12 0 [Warning] Aborted connection 6 to db: 'mysql' user: 'root' host: 'localhost' (KILLED)
2024-08-29 14:23:13 0 [Note] InnoDB: FTS optimize thread exiting.
2024-08-29 14:23:13 0 [Note] InnoDB: Starting shutdown...
2024-08-29 14:23:13 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/rqg/1724928849/197/1_clone/data/ib_buffer_pool
2024-08-29 14:23:13 0 [Note] InnoDB: Restricted to 126 pages due to innodb_buf_pool_dump_pct=25
2024-08-29 14:23:13 0 [Note] InnoDB: Buffer pool(s) dump completed at 240829 14:23:13
- 2024-08-29T14:23:14 [3420387] | [rr 3472874 110589]mariadbd: /data/Server/10.6-MDEV-34830/storage/innobase/buf/buf0flu.cc:2591: void buf_flush_buffer_pool(): Assertion `!os_aio_pending_reads()' failed.
RQG
|
===
|
# git clone https://github.com/mleich1/rqg --branch <pick the right branch> RQG
|
#
|
# GIT_SHOW: HEAD -> master, origin/master, origin/HEAD de161f09647823897338538e4f146ea6350eac29 2024-08-28T14:46:53+02:00
|
# rqg.pl : Version 4.5.0 (2023-12)
|
#
|
# $RQG_HOME/rqg.pl \
|
# --grammar=conf/mariadb/innodb_compression_encryption.yy \
|
# --gendata=conf/mariadb/innodb_compression_encryption.zz \
|
# --max_gd_duration=1800 \
|
# --mysqld=--innodb-encrypt-log \
|
# --mysqld=--innodb-encrypt-tables \
|
# --reporters=Mariabackup_linux \
|
# --mysqld=--loose-innodb-log-file-size=200M \
|
# --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
|
# --mysqld=--loose-idle_write_transaction_timeout=0 \
|
# --mysqld=--loose-idle_transaction_timeout=0 \
|
# --mysqld=--loose-idle_readonly_transaction_timeout=0 \
|
# --mysqld=--connect_timeout=60 \
|
# --mysqld=--interactive_timeout=28800 \
|
# --mysqld=--slave_net_timeout=60 \
|
# --mysqld=--net_read_timeout=30 \
|
# --mysqld=--net_write_timeout=60 \
|
# --mysqld=--loose-table_lock_wait_timeout=50 \
|
# --mysqld=--wait_timeout=28800 \
|
# --no_mask \
|
# --queries=10000000 \
|
# --seed=random \
|
# --reporters=None \
|
# --reporters=ErrorLog \
|
# --reporters=Deadlock \
|
# --validators=None \
|
# --mysqld=--log_output=none \
|
# --mysqld=--log_bin_trust_function_creators=1 \
|
# --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
|
# --engine=InnoDB \
|
# --restart_timeout=240 \
|
# --mysqld=--plugin-load-add=file_key_management.so \
|
# --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
|
# --mysqld=--plugin-load-add=provider_lzo.so \
|
# --mysqld=--plugin-load-add=provider_bzip2.so \
|
# --mysqld=--plugin-load-add=provider_lzma.so \
|
# --mysqld=--plugin-load-add=provider_snappy.so \
|
# --mysqld=--plugin-load-add=provider_lz4.so \
|
# --mysqld=--loose-innodb_compression_level=1 \
|
# --duration=300 \
|
# --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
|
# --mysqld=--loose-innodb_data_file_path=ibdata1:1M:autoextend:autoshrink \
|
# --redefine=conf/mariadb/redefine_innodb_log_write_ahead_size.yy \
|
# --mysqld=--lock-wait-timeout=15 \
|
# --mysqld=--innodb-lock-wait-timeout=10 \
|
# --mysqld=--sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION \
|
# --mysqld=--innodb_file_per_table=0 \
|
# --mysqld=--loose-innodb_read_only_compressed=OFF \
|
# --mysqld=--loose-innodb-sync-debug \
|
# --mysqld=--innodb_stats_persistent=off \
|
# --mysqld=--innodb_adaptive_hash_index=off \
|
# --mysqld=--innodb_random_read_ahead=OFF \
|
# --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
|
# --threads=1 \
|
# --rr=Extended \
|
# --rr_options=--chaos --wait \
|
# --mysqld=--innodb_undo_log_truncate=OFF \
|
# --mysqld=--loose_innodb_change_buffering=none \
|
# --mysqld=--innodb_undo_tablespaces=0 \
|
# --mysqld=--innodb_rollback_on_timeout=OFF \
|
# --mysqld=--innodb_page_size=16K \
|
# --mysqld=--innodb-buffer-pool-size=8M \
|
# --vardir_type=fast \
|
# <local settings>
|
 |
Error pattern:
|
[ 'TBR-2011', '(mariadbd|mysqld): .{1,300}buf0flu.cc:.{1,10}: void buf_flush_buffer_pool\(\): Assertion \`\!os_aio_pending_reads\(\)\' failed' ],
|