[MDEV-12330] [Draft] void pfs_lock::allocated_to_free(): Assertion `((copy & 0x00000003) == 0x02)' failed Created: 2017-03-22  Updated: 2023-11-28  Resolved: 2023-11-28

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-17842 [Draft] Assertion `((copy & 0x0000000... Closed
duplicates MDEV-17937 [Draft] Assertion `((copy & 0x0000000... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-qa-linux/builds/1330/steps/rqg_10.2/logs/stdio

10.2 1ca8637ae35061d2567728a1c7aede11e68e5fff

mysqld: /home/buildbot/build/storage/perfschema/pfs_lock.h:199: void pfs_lock::allocated_to_free(): Assertion `((copy & 0x00000003) == 0x02)' failed.
170320 18:13:33 [ERROR] mysqld got signal 6 ;

# 2017-03-20T18:13:49 [1642] #7  0x00007f2041600312 in __GI___assert_fail (assertion=0x7f2044bae08f "((copy & 0x00000003) == 0x02)", file=0x7f2044bae040 "/home/buildbot/build/storage/perfschema/pfs_lock.h", line=199, function=0x7f2044bae360 <pfs_lock::allocated_to_free()::__PRETTY_FUNCTION__> "void pfs_lock::allocated_to_free()") at assert.c:101
# 2017-03-20T18:13:49 [1642] #8  0x00007f20446e7c4d in pfs_lock::allocated_to_free (this=0x7f204019ccc0) at /home/buildbot/build/storage/perfschema/pfs_lock.h:199
# 2017-03-20T18:13:49 [1642] #9  0x00007f20446f6926 in drop_table_share (thread=0x7f203f8a1680, temporary=false, schema_name=0x7f20199e47d8 "test", schema_name_length=4, table_name=0x7f20199e4188 "table10_int", table_name_length=11) at /home/buildbot/build/storage/perfschema/pfs_instr_class.cc:1420
# 2017-03-20T18:13:49 [1642] #10 0x00007f20447179a3 in drop_table_share_v1 (temporary=0 '\000', schema_name=0x7f20199e47d8 "test", schema_name_length=4, table_name=0x7f20199e4188 "table10_int", table_name_length=11) at /home/buildbot/build/storage/perfschema/pfs.cc:1606
# 2017-03-20T18:13:49 [1642] #11 0x00007f2043f9d3cd in mysql_rm_table_no_locks (thd=0x7f20141b2070, tables=0x7f20199e41d0, if_exists=true, drop_temporary=true, drop_view=false, dont_log_query=false, dont_free_locks=false) at /home/buildbot/build/sql/sql_table.cc:2519
# 2017-03-20T18:13:49 [1642] #12 0x00007f2043f9c382 in mysql_rm_table (thd=0x7f20141b2070, tables=0x7f20199e41d0, if_exists=1 '\001', drop_temporary=1 '\001') at /home/buildbot/build/sql/sql_table.cc:2090
# 2017-03-20T18:13:49 [1642] #13 0x00007f2043ee1790 in mysql_execute_command (thd=0x7f20141b2070) at /home/buildbot/build/sql/sql_parse.cc:4712
# 2017-03-20T18:13:49 [1642] #14 0x00007f2043eeb52c in mysql_parse (thd=0x7f20141b2070, rawbuf=0x7f20199e4088 "DROP TEMPORARY TABLE IF EXISTS table10_int  /* QNO 3784 CON_ID 16 */", length=68, parser_state=0x7f2041585ce0, is_com_multi=false, is_next_command=false) at /home/buildbot/build/sql/sql_parse.cc:7858
# 2017-03-20T18:13:49 [1642] #15 0x00007f2043ed95f2 in dispatch_command (command=COM_QUERY, thd=0x7f20141b2070, packet=0x7f2019a6d071 " DROP TEMPORARY TABLE IF EXISTS table10_int  /* QNO 3784 CON_ID 16 */ ", packet_length=70, is_com_multi=false, is_next_command=false) at /home/buildbot/build/sql/sql_parse.cc:1812
# 2017-03-20T18:13:49 [1642] #16 0x00007f2043ed7f62 in do_command (thd=0x7f20141b2070) at /home/buildbot/build/sql/sql_parse.cc:1362
# 2017-03-20T18:13:49 [1642] #17 0x00007f2044085e52 in threadpool_process_request (thd=0x7f20141b2070) at /home/buildbot/build/sql/threadpool_common.cc:346
# 2017-03-20T18:13:49 [1642] #18 0x00007f2044085a90 in tp_callback (c=0x7f2024f825b0) at /home/buildbot/build/sql/threadpool_common.cc:192
# 2017-03-20T18:13:49 [1642] #19 0x00007f2044107766 in worker_main (param=0x7f203b7a11b0) at /home/buildbot/build/sql/threadpool_generic.cc:1581
# 2017-03-20T18:13:49 [1642] #20 0x00007f20447180ae in pfs_spawn_thread (arg=0x7f2024f06ef0) at /home/buildbot/build/storage/perfschema/pfs.cc:1862
# 2017-03-20T18:13:49 [1642] #21 0x00007f2043502064 in start_thread (arg=0x7f2041587300) at pthread_create.c:309
# 2017-03-20T18:13:49 [1642] #22 0x00007f20416ba62d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Query (0x7f20199e4088): DROP TEMPORARY TABLE IF EXISTS table10_int  /* QNO 3784 CON_ID 16 */
Connection ID (thread ID): 77
Status: NOT_KILLED

Initial RQG command line (not reproducible):

perl /home/buildbot/rqg/runall-new.pl --no-mask --seed=1490047927 --threads=8 --duration=300 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock --validators=QueryProperties,TransformerNoComparator --transformers=ExecuteAsExecuteImmediate --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/redefine_multiple_triggers.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --use-gtid=current_pos --mysqld=--slave_parallel_threads=8 --mysqld=--performance_schema=1 --mysqld=--log_bin --mysqld=--binlog_format=MIXED --mysqld=--thread_handling=pool-of-threads --views --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --mtr-build-thread=300 --basedir1=/home/buildbot/build --vardir1=/home/buildbot/10.2-features/current1_1


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