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

[Draft] Assertion `((copy & 0x00000003) == 0x02)' failed in pfs_lock::allocated_to_free

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4
    • N/A
    • Server
    • None

    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.

      Attachments

        1. mysql.err
          10 kB
        2. mysql.log
          6.11 MB
        3. threads1
          53 kB

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.