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

[Draft] Deadlock on concurrent DML / DDL / admin statements

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.2.7
    • N/A
    • Locking
    • None

    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.

      Attachments

        1. mysql.err
          39 kB
        2. threads
          199 kB
        3. threads_full
          811 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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