[MDEV-17937] [Draft] Assertion `((copy & 0x00000003) == 0x02)' failed in pfs_lock::allocated_to_free Created: 2018-12-08  Updated: 2019-10-30  Resolved: 2019-01-13

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

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

Attachments: File mysql.err     File mysql.log     HTML File threads1    
Issue Links:
Duplicate
is duplicated by MDEV-12330 [Draft] void pfs_lock::allocated_to_f... Closed
is duplicated by MDEV-17842 [Draft] Assertion `((copy & 0x0000000... Closed

 Description   

10.4 24a45d3bd73

mysqld: /data/src/10.4/storage/perfschema/pfs_lock.h:199: void pfs_lock::allocated_to_free(): Assertion `((copy & 0x00000003) == 0x02)' failed.
181208 14:39:58 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fa7f2de0ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055599be9dcfd in pfs_lock::allocated_to_free (this=0x7fa7f2718c80) at /data/src/10.4/storage/perfschema/pfs_lock.h:199
#9  0x000055599beace94 in drop_table_share (thread=0x7fa7f03d1cc0, temporary=false, schema_name=0x7fa7700140e8 "test", schema_name_length=4, table_name=0x7fa770013a78 "D", table_name_length=1) at /data/src/10.4/storage/perfschema/pfs_instr_class.cc:1413
#10 0x000055599bed212d in drop_table_share_v1 (temporary=0 '\000', schema_name=0x7fa7700140e8 "test", schema_name_length=4, table_name=0x7fa770013a78 "D", table_name_length=1) at /data/src/10.4/storage/perfschema/pfs.cc:1606
#11 0x000055599b9839b9 in mysql_rm_table_no_locks (thd=0x7fa770000b00, tables=0x7fa770013ab0, if_exists=true, drop_temporary=true, drop_view=false, drop_sequence=false, dont_log_query=false, dont_free_locks=false) at /data/src/10.4/sql/sql_table.cc:2563
#12 0x000055599b9826d0 in mysql_rm_table (thd=0x7fa770000b00, tables=0x7fa770013ab0, if_exists=true, drop_temporary=true, drop_sequence=false) at /data/src/10.4/sql/sql_table.cc:2123
#13 0x000055599b8bab3d in mysql_execute_command (thd=0x7fa770000b00) at /data/src/10.4/sql/sql_parse.cc:5058
#14 0x000055599b8c4216 in mysql_parse (thd=0x7fa770000b00, rawbuf=0x7fa770013998 "DROP TEMPORARY TABLE IF EXISTS D  /* QNO 5880 CON_ID 17 */", length=58, parser_state=0x7fa7e8ec1600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8092
#15 0x000055599b8b14f4 in dispatch_command (command=COM_QUERY, thd=0x7fa770000b00, packet=0x7fa77000b311 " DROP TEMPORARY TABLE IF EXISTS D  /* QNO 5880 CON_ID 17 */ ", packet_length=60, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#16 0x000055599b8aff18 in do_command (thd=0x7fa770000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#17 0x000055599ba1bb12 in do_handle_one_connection (connect=0x55599f3ee960) at /data/src/10.4/sql/sql_connect.cc:1402
#18 0x000055599ba1b896 in handle_one_connection (arg=0x55599f3ee960) at /data/src/10.4/sql/sql_connect.cc:1308
#19 0x000055599bed2862 in pfs_spawn_thread (arg=0x5559a003df50) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#20 0x00007fa7f489c494 in start_thread (arg=0x7fa7e8ec2700) at pthread_create.c:333
#21 0x00007fa7f2e9d93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Happened once so far in local tests while trying to reproduce MDEV-17896, with the test below, but not reproducible by just re-running it.

elenst-dev b1facb036

perl ./runall-trials.pl --trials=5 --basedir=/data/bld/10.4 --vardir=/dev/shm/vardir2 --duration=350 --threads=6 --seed=1543872820 --reporters=Backtrace,ErrorLog,Deadlock --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=5 --mysqld=--loose-innodb-lock-wait-timeout=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema  --engine=InnoDB

There should have been no problems with memory/disk space during the test run, but it's not 100%-guaranteed.



 Comments   
Comment by Elena Stepanova [ 2019-01-13 ]

Same as MDEV-17842 which, in turn, is same as MDEV-12330.

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