[MDEV-17842] [Draft] Assertion `((copy & 0x00000003) == 0x02)' failed in pfs_lock::allocated_to_free Created: 2018-11-27  Updated: 2023-11-28  Resolved: 2023-11-28

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

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

Issue Links:
Duplicate
duplicates MDEV-17937 [Draft] Assertion `((copy & 0x0000000... Closed
is duplicated by MDEV-12330 [Draft] void pfs_lock::allocated_to_f... Closed

 Description   

https://travis-ci.org/elenst/travis-tests/jobs/459805365

10.4 7dcbc33db5bd5282f35266ead5d78095848ee0f5

 
mysqld: /home/travis/src/storage/perfschema/pfs_lock.h:199: void pfs_lock::allocated_to_free(): Assertion `((copy & 0x00000003) == 0x02)' failed.
 
181126 21:39:04 [ERROR] mysqld got signal 6 ;
 
 
 
#7  0x00007f524cc0ec82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
 
#8  0x000055b21a1315af in pfs_lock::allocated_to_free (this=0x7f524c83bd80) at /home/travis/src/storage/perfschema/pfs_lock.h:199
 
#9  0x000055b21a1407bc in drop_table_share (thread=0x7f524a200240, temporary=false, schema_name=0x55b21d921da8 "test", schema_name_length=4, table_name=0x55b21d921738 "AA", table_name_length=2) at /home/travis/src/storage/perfschema/pfs_instr_class.cc:1413
 
#10 0x000055b21a165b60 in drop_table_share_v1 (temporary=0 '\000', schema_name=0x55b21d921da8 "test", schema_name_length=4, table_name=0x55b21d921738 "AA", table_name_length=2) at /home/travis/src/storage/perfschema/pfs.cc:1606
 
#11 0x000055b2197d448c in mysql_rm_table_no_locks (thd=0x55b21d911660, tables=0x55b21d921770, if_exists=true, drop_temporary=true, drop_view=false, drop_sequence=false, dont_log_query=false, dont_free_locks=false) at /home/travis/src/sql/sql_table.cc:2564
 
#12 0x000055b2197d31ac in mysql_rm_table (thd=0x55b21d911660, tables=0x55b21d921770, if_exists=true, drop_temporary=true, drop_sequence=false) at /home/travis/src/sql/sql_table.cc:2123
 
#13 0x000055b21970baf4 in mysql_execute_command (thd=0x55b21d911660) at /home/travis/src/sql/sql_parse.cc:5057
 
#14 0x000055b2197154a8 in mysql_parse (thd=0x55b21d911660, rawbuf=0x55b21d921658 "DROP TEMPORARY TABLE IF EXISTS AA  /* QNO 6505 CON_ID 20 */", length=59, parser_state=0x7f5219929600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8092
 
#15 0x000055b219702466 in dispatch_command (command=COM_QUERY, thd=0x55b21d911660, packet=0x55b21d919521 " DROP TEMPORARY TABLE IF EXISTS AA  /* QNO 6505 CON_ID 20 */ ", packet_length=61, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1851
 
#16 0x000055b219700e83 in do_command (thd=0x55b21d911660) at /home/travis/src/sql/sql_parse.cc:1396
 
#17 0x000055b21986c208 in do_handle_one_connection (connect=0x55b21d8ecf70) at /home/travis/src/sql/sql_connect.cc:1402
 
#18 0x000055b21986bf59 in handle_one_connection (arg=0x55b21d8ecf70) at /home/travis/src/sql/sql_connect.cc:1308
 
#19 0x000055b21a16629e in pfs_spawn_thread (arg=0x55b21d8ed310) at /home/travis/src/storage/perfschema/pfs.cc:1862
 
#20 0x00007f524d8536ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
 
#21 0x00007f524cce841d in clone () from /lib/x86_64-linux-gnu/libc.so.6

elenst-jira-refs 33ad7f04959f76e6a6553f34ba131dd19884c4f4

 
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1543268185 --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 --mysqld=--loose-file-key-management-filename=/home/travis/rqg/conf/mariadb/encryption_keys.txt --engine=InnoDB --mysqld=--log-bin

Not reproducible right away

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

See also MDEV-17937 for a local occurrence.

Comment by Elena Stepanova [ 2019-01-15 ]

New occurrence: https://travis-ci.org/elenst/travis-tests/jobs/479014637

Comment by Elena Stepanova [ 2019-05-24 ]

On 10.3 592dc59: https://travis-ci.org/elenst/travis-tests/jobs/535487349 [3448 45 4]

elenst-jira-refs ca49dd1 Toolbox: 6cd775a

 
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1558693597 --reporters=Backtrace,ErrorLog,Deadlock --views --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/sp.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 --mysqld=--loose-file-key-management-filename=/home/travis/rqg/conf/mariadb/encryption_keys.txt --mysqld=--log-bin

Comment by Elena Stepanova [ 2019-05-25 ]

And on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/536320451 [3458 2 4]

elenst-jira-refs ca49dd1 Toolbox: 6cd775a

 
perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1558787685 --short-column-names --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUpdateDelete --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/modules/alter_table_columns.yy --redefine=conf/mariadb/modules/alter_table_indexes.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/modules/admin.yy --redefine=conf/mariadb/modules/foreign_keys.yy -redefine=conf/mariadb/modules/locks.yy --redefine=conf/mariadb/modules/sql_mode.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=15 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-buffer-pool-size=2G --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema --filter=/home/travis/mariadb-toolbox/travis/10.4-combo-filter.ff --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--server-id=222 --mysqld=--file-key-management --mysqld=--plugin-load-add=file_key_management --mysqld=--file-key-management-filename=/home/travis/mariadb-toolbox/data/keys.txt --mysqld=--innodb-encrypt-tables --mysqld=--innodb-encrypt-log --mysqld=--innodb-encryption-threads=4 --mysqld=--encrypt-tmp-disk-tables=1

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