Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3
-
None
-
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.