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

[Draft] Locking-related assertion failures

    XMLWordPrintable

Details

    Description

      bb-10.11-release a9e353e84f15c8386e756ef1a49ccde227d2d48b

      Thread 2 received signal SIGSEGV, Segmentation fault.
      [Switching to Thread 4035559.4035609]
      0x000055a3402172a2 in ha_innobase::store_lock (this=0x55a328893fc0, thd=0x23b268000d58, to=0x23b2680143e0, lock_type=TL_IGNORE)
          at /data/MDEV-x-1/bb-10.11-release/storage/innobase/handler/ha_innodb.cc:16718
      16718		m_prebuilt->skip_locked= (lock_type == TL_WRITE_SKIP_LOCKED ||
      (rr) bt
      #0  0x000055a3402172a2 in ha_innobase::store_lock (this=0x55a328893fc0, thd=0x23b268000d58, to=0x23b2680143e0, lock_type=TL_IGNORE)
          at /data/MDEV-x-1/bb-10.11-release/storage/innobase/handler/ha_innodb.cc:16718
      #1  0x000055a3400e7d2e in ha_partition::store_lock (this=0x55a32889c010, thd=0x23b268000d58, to=0x23b2680143e0, lock_type=TL_IGNORE)
          at /data/MDEV-x-1/bb-10.11-release/sql/ha_partition.cc:4437
      #2  0x000055a33ff81443 in get_lock_data (thd=0x23b268000d58, table_ptr=0x1c9532bb4e60, count=1, flags=2) at /data/MDEV-x-1/bb-10.11-release/sql/lock.cc:826
      #3  0x000055a33ff80cc6 in mysql_lock_abort_for_thread (thd=0x23b268000d58, table=0x2fc308377bf8) at /data/MDEV-x-1/bb-10.11-release/sql/lock.cc:634
      #4  0x000055a33f9835cf in THD::notify_shared_lock (this=0x23b268000d58, ctx_in_use=0x55a328000e40, needs_thr_lock_abort=true) at /data/MDEV-x-1/bb-10.11-release/sql/sql_class.cc:2140
      #5  0x000055a33fbfcf77 in MDL_lock::notify_conflicting_locks (this=0x55a3245ee7f8, ctx=0x23b268000eb8) at /data/MDEV-x-1/bb-10.11-release/sql/mdl.cc:626
      #6  0x000055a33fbf9faa in MDL_context::acquire_lock (this=0x23b268000eb8, mdl_request=0x1c9532bb5060, lock_wait_timeout=15) at /data/MDEV-x-1/bb-10.11-release/sql/mdl.cc:2429
      #7  0x000055a33fbfa66a in MDL_context::upgrade_shared_lock (this=0x23b268000eb8, mdl_ticket=0x23b268a2ea40, new_type=MDL_EXCLUSIVE, lock_wait_timeout=15)
          at /data/MDEV-x-1/bb-10.11-release/sql/mdl.cc:2619
      #8  0x000055a33f958da9 in wait_while_table_is_used (thd=0x23b268000d58, table=0x6cf7809fea8, function=HA_EXTRA_PREPARE_FOR_RENAME)
          at /data/MDEV-x-1/bb-10.11-release/sql/sql_base.cc:1451
      #9  0x000055a33fb4c2fe in mysql_create_or_drop_trigger (thd=0x23b268000d58, tables=0x23b268013ab0, create=true) at /data/MDEV-x-1/bb-10.11-release/sql/sql_trigger.cc:634
      #10 0x000055a33fa14d0c in mysql_execute_command (thd=0x23b268000d58, is_called_from_prepared_stmt=false) at /data/MDEV-x-1/bb-10.11-release/sql/sql_parse.cc:6025
      #11 0x000055a33fa1b489 in mysql_parse (thd=0x23b268000d58, 
          rawbuf=0x23b2680137e0 "/* WRK-6 QNO 166 */ CREATE /* TRANSFORM_SETUP */ OR REPLACE TRIGGER tr_Execute_AsTrigger_4035608 AFTER DELETE ON t1 FOR EACH ROW  UPDATE IGNORE `partition_db`.`trange_1_3` SET `col_ts` = '21:41:21.002"..., length=230, parser_state=0x1c9532bb6270) at /data/MDEV-x-1/bb-10.11-release/sql/sql_parse.cc:8223
      #12 0x000055a33fa06fdf in dispatch_command (command=COM_QUERY, thd=0x23b268000d58, 
          packet=0x23b26800b269 "/* WRK-6 QNO 166 */ CREATE /* TRANSFORM_SETUP */ OR REPLACE TRIGGER tr_Execute_AsTrigger_4035608 AFTER DELETE ON t1 FOR EACH ROW  UPDATE IGNORE `partition_db`.`trange_1_3` SET `col_ts` = '21:41:21.002"..., packet_length=230, blocking=true) at /data/MDEV-x-1/bb-10.11-release/sql/sql_parse.cc:1924
      #13 0x000055a33fa05b00 in do_command (thd=0x23b268000d58, blocking=true) at /data/MDEV-x-1/bb-10.11-release/sql/sql_parse.cc:1434
      #14 0x000055a33fbe83bc in do_handle_one_connection (connect=0x55a34b1c03f8, put_in_cache=true) at /data/MDEV-x-1/bb-10.11-release/sql/sql_connect.cc:1475
      #15 0x000055a33fbe8162 in handle_one_connection (arg=0x55a34b1c03f8) at /data/MDEV-x-1/bb-10.11-release/sql/sql_connect.cc:1387
      #16 0x000055a3400fcabe in pfs_spawn_thread (arg=0x55a34b1c0468) at /data/MDEV-x-1/bb-10.11-release/storage/perfschema/pfs.cc:2201
      #17 0x00000b9960d0eaa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #18 0x00000b9960d9ba34 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

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