[MDEV-13824] [Draft] Deadlock on concurrent DML / DDL / admin statements Created: 2017-09-16  Updated: 2022-05-16  Resolved: 2022-05-16

Status: Closed
Project: MariaDB Server
Component/s: Locking
Affects Version/s: 10.2.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: None

Attachments: File mysql.err     HTML File threads     HTML File threads_full    

 Description   

perl /data/src/rqg-clean/runall-new.pl --no-mask --seed=1505521297 --threads=32 --duration=1200 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --redefine=conf/mariadb/general-workarounds.yy --redefine=kill.yy --redefine=conf/mariadb/10.0-features-redefine.yy --mysqld=--log_output=FILE --views --grammar=conf/runtime/information_schema.yy --mysqld=--log_bin_trust_function_creators=1 --mysqld=--max_allowed_packet=1073741824 --mysqld=--connect_timeout=30 --mysqld=--server_id=1102 --mysqld=--character_set_server=utf8 --mysqld=--collation_server=utf8_general_ci --mysqld=--default_storage_engine=InnoDB --mysqld=--performance_schema --mysqld=--skip_name_resolve --mysqld=--sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_VALUE_ON_ZERO,ORACLE --mysqld=--lower_case_table_names=1 --mysqld=--autocommit=0 --mysqld=--transaction-isolation=READ-COMMITTED --mysqld=--table_definition_cache=2400 --mysqld=--max_connections=2000 --mysqld=--slow_query_log=1 --mysqld=--long_query_time=3 --mysqld=--expire_logs_days=3 --mysqld=--binlog_format=ROW --mysqld=--binlog_row_image=FULL --mysqld=--log_bin=mariadb-bin --mysqld=--log_bin_index=mariadb-bin.index --mysqld=--sync_binlog=1 --mysqld=--innodb_large_prefix=1 --mysqld=--innodb_file_per_table=1 --mysqld=--innodb_buffer_pool_size=8G --mysqld=--innodb_buffer_pool_instances=35 --mysqld=--innodb_rollback_on_timeout=ON --mysqld=--innodb_buffer_pool_dump_at_shutdown=ON --mysqld=--innodb_buffer_pool_load_at_startup=ON --mysqld=--innodb_lru_scan_depth=2048 --mysqld=--innodb_io_capacity=2000 --mysqld=--innodb_thread_concurrency=64 --mysqld=--query_cache_size=0 --mysqld=--query_cache_type=0 --mysqld=--thread_cache_size=50 --mysqld=--thread_handling=pool-of-threads --mysqld=--net_read_timeout=120 --mysqld=--net_write_timeout=120 --mysqld=--wait_timeout=300 --mysqld=--interactive_timeout=300 --mysqld=--max_heap_table_size=128M --mysqld=--tmp_table_size=128M --mysqld=--optimizer_search_depth=0 --mysqld=--optimizer_switch=index_merge=on --mysqld=--optimizer_switch=index_merge_union=on --mysqld=--optimizer_switch=index_merge_sort_union=on --mysqld=--optimizer_switch=index_merge_intersection=on --mysqld=--optimizer_switch=index_merge_sort_intersection=off --mysqld=--optimizer_switch=index_condition_pushdown=on --mysqld=--optimizer_switch=derived_merge=on --mysqld=--optimizer_switch=derived_with_keys=on --mysqld=--optimizer_switch=firstmatch=on --mysqld=--optimizer_switch=loosescan=on --mysqld=--optimizer_switch=materialization=on --mysqld=--optimizer_switch=in_to_exists=on --mysqld=--optimizer_switch=semijoin=on --mysqld=--optimizer_switch=partial_match_rowid_merge=on --mysqld=--optimizer_switch=partial_match_table_scan=on --mysqld=--optimizer_switch=subquery_cache=on,mrr=on --mysqld=--optimizer_switch=mrr_cost_based=on --mysqld=--optimizer_switch=mrr_sort_keys=off --mysqld=--optimizer_switch=outer_join_with_cache=on --mysqld=--optimizer_switch=semijoin_with_cache=on --mysqld=--optimizer_switch=join_cache_incremental=on --mysqld=--optimizer_switch=join_cache_hashed=on --mysqld=--optimizer_switch=join_cache_bka=on --mysqld=--optimizer_switch=optimize_join_buffer_size=on --mysqld=--optimizer_switch=table_elimination=on --mysqld=--optimizer_switch=extended_keys=on --mtr-build-thread=300 --basedir1=/data/src/10.2-bug --vardir1=/data/logs/mdev13800-1/current1_1

All threads' stack trace is attached.
Can't get process list or locking info because can't connect to the server anymore.

No information yet whether it's reproducible.


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