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

[Draft] Assertion `pfs_rwlock == sanitize_rwlock(pfs_rwlock)' failed in unlock_rwlock_v1

    XMLWordPrintable

Details

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

    Description

      10.3 560743198604

      mysqld: /data/src/10.3/storage/perfschema/pfs.cc:3214: void unlock_rwlock_v1(PSI_rwlock*): Assertion `pfs_rwlock == sanitize_rwlock(pfs_rwlock)' failed.
      180417  5:50:21 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f1441e7eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055d679832c8a in unlock_rwlock_v1 (rwlock=0x7f1443e9de55) at /data/src/10.3/storage/perfschema/pfs.cc:3214
      #9  0x000055d679c5679d in inline_mysql_rwlock_unlock (that=0x7f13b0194d18) at /data/src/10.3/include/mysql/psi/mysql_thread.h:1082
      #10 0x000055d679c56a7e in mi_records_in_range (info=0x7f13b0194f20, inx=1, min_key=0x7f142409b790, max_key=0x7f142409b7b0) at /data/src/10.3/storage/myisam/mi_range.c:110
      #11 0x000055d679c215b5 in ha_myisam::records_in_range (this=0x7f13b014e648, inx=1, min_key=0x7f142409b790, max_key=0x7f142409b7b0) at /data/src/10.3/storage/myisam/ha_myisam.cc:2281
      #12 0x000055d6793f9591 in handler::multi_range_read_info_const (this=0x7f13b014e648, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges_arg=2, bufsz=0x7f142409b834, flags=0x7f142409b830, cost=0x7f142409c010) at /data/src/10.3/sql/multi_range_read.cc:95
      #13 0x000055d6793fc9da in DsMrr_impl::dsmrr_info_const (this=0x7f13b014eab8, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges=2, bufsz=0x7f13b01428f8, flags=0x7f142409b8e0, cost=0x7f142409c010) at /data/src/10.3/sql/multi_range_read.cc:1458
      #14 0x000055d679c21e63 in ha_myisam::multi_range_read_info_const (this=0x7f13b014e648, keyno=1, seq=0x7f13b01985d0, seq_init_param=0x7f13b01429d8, n_ranges=2, bufsz=0x7f13b01428f8, flags=0x7f142409b8e0, cost=0x7f142409c010) at /data/src/10.3/storage/myisam/ha_myisam.cc:2506
      #15 0x000055d679ca0508 in ha_partition::multi_range_read_info_const (this=0x7f13b0197de8, keyno=1, seq=0x7f142409b9e0, seq_init_param=0x7f142409ba10, n_ranges=0, bufsz=0x7f142409bfa0, mrr_mode=0x7f142409bf9c, cost=0x7f142409c010) at /data/src/10.3/sql/ha_partition.cc:6279
      #16 0x000055d6796a0582 in check_quick_select (param=0x7f142409c1d0, idx=0, index_only=false, tree=0x7f13b41367b8, update_tbl_stats=true, mrr_flags=0x7f142409bf9c, bufsize=0x7f142409bfa0, cost=0x7f142409c010) at /data/src/10.3/sql/opt_range.cc:10370
      #17 0x000055d679697cb6 in get_key_scans_params (param=0x7f142409c1d0, tree=0x7f13b4136730, index_read_must_be_used=false, update_tbl_stats=true, read_time=21.142968750000001) at /data/src/10.3/sql/opt_range.cc:6784
      #18 0x000055d67968e531 in SQL_SELECT::test_quick_select (this=0x7f13b4017ff8, thd=0x7f13b4000b00, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true) at /data/src/10.3/sql/opt_range.cc:2591
      #19 0x000055d67929c899 in get_quick_record_count (thd=0x7f13b4000b00, select=0x7f13b4017ff8, table=0x7f13b01971a0, keys=0x7f13b4016f30, limit=18446744073709551615) at /data/src/10.3/sql/sql_select.cc:4189
      #20 0x000055d67929ed6f in make_join_statistics (join=0x7f13b4015570, tables_list=..., keyuse_array=0x7f13b4015860) at /data/src/10.3/sql/sql_select.cc:4816
      #21 0x000055d6792945bd in JOIN::optimize_inner (this=0x7f13b4015570) at /data/src/10.3/sql/sql_select.cc:1846
      #22 0x000055d679292e89 in JOIN::optimize (this=0x7f13b4015570) at /data/src/10.3/sql/sql_select.cc:1431
      #23 0x000055d67929c5e2 in mysql_select (thd=0x7f13b4000b00, tables=0x7f13b4013de0, wild_num=1, fields=..., conds=0x7f13b4014d40, og_num=1, order=0x7f13b40153a0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f13b4015550, unit=0x7f13b4004948, select_lex=0x7f13b40050c0) at /data/src/10.3/sql/sql_select.cc:4138
      #24 0x000055d67928ebcf in handle_select (thd=0x7f13b4000b00, lex=0x7f13b4004880, result=0x7f13b4015550, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382
      #25 0x000055d67925a0c7 in execute_sqlcom_select (thd=0x7f13b4000b00, all_tables=0x7f13b4013de0) at /data/src/10.3/sql/sql_parse.cc:6539
      #26 0x000055d679250828 in mysql_execute_command (thd=0x7f13b4000b00) at /data/src/10.3/sql/sql_parse.cc:3768
      #27 0x000055d67925dad8 in mysql_parse (thd=0x7f13b4000b00, rawbuf=0x7f13b4013a28 "SELECT * FROM test.`BB` AS table1 WHERE ( ( table1.`col_int_key` IN ( 6, 5, 6 ) AND table1.`pk` <> table1.`col_varchar_nokey`) AND table1.`col_time_nokey` LIKE 'wait/synch%') ORDER BY table1.`pk` LIMI"..., length=229, parser_state=0x7f142409e5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001
      #28 0x000055d67924b2bb in dispatch_command (command=COM_QUERY, thd=0x7f13b4000b00, packet=0x7f13b400b261 " SELECT * FROM test.`BB` AS table1 WHERE ( ( table1.`col_int_key` IN ( 6, 5, 6 ) AND table1.`pk` <> table1.`col_varchar_nokey`) AND table1.`col_time_nokey` LIKE 'wait/synch%') ORDER BY table1.`pk` LIM"..., packet_length=231, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
      #29 0x000055d679249cfa in do_command (thd=0x7f13b4000b00) at /data/src/10.3/sql/sql_parse.cc:1391
      #30 0x000055d6793ac78b in do_handle_one_connection (connect=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1402
      #31 0x000055d6793ac518 in handle_one_connection (arg=0x55d67da352a0) at /data/src/10.3/sql/sql_connect.cc:1308
      #32 0x000055d67982fb43 in pfs_spawn_thread (arg=0x55d67d9d2240) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #33 0x00007f1443b55494 in start_thread (arg=0x7f142409f700) at pthread_create.c:333
      #34 0x00007f1441f3b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      experimental 75de94b07db420

      perl ./runall-trials.pl --trials=3 --duration=350 --threads=6 --seed=1522444189 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/data/bld/10.3 --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/dev/shm/vardir > /data/logs/mdev15801_shm.log
      

      Can't reproduce, too many open bugs to hit on the way.

      Attachments

        1. mysql.err
          8 kB
        2. mysql.log
          1.81 MB
        3. threads
          62 kB

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.