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

SEGV in my_atomic_loadlint storage/innobase/include/sync0types.h:1131

    XMLWordPrintable

    Details

      Description

      Thread 3 received signal SIGSEGV, Segmentation fault.
      [Switching to Thread 1968947.1970639]
      0x000055ed4289732f in my_atomic_loadlint (A=0x2d8b3ed5dca0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0types.h:1131
      1131      return ulint(my_atomic_loadlong(A));
      (rr) bt
      #0  0x000055ed4289732f in my_atomic_loadlint (A=0x2d8b3ed5dca0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0types.h:1131
      #1  MutexDebug<TTASEventMutex<BlockMutexPolicy> >::is_owned (this=0x2d8b3ed5dc68) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/sync0policy.h:200
      #2  PolicyMutex<TTASEventMutex<BlockMutexPolicy> >::is_owned (this=0x2d8b3ed5dc58) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/ib0mutex.h:639
      #3  buf_flush_or_remove_page (buf_pool=buf_pool@entry=0x61b000001580, bpage=<optimized out>, flush=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0lru.cc:387
      #4  0x000055ed4289adb2 in buf_flush_or_remove_pages (buf_pool=buf_pool@entry=0x61b000001580, id=id@entry=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/buf0flu.h:355
      #5  0x000055ed4289b4de in buf_flush_dirty_pages (buf_pool=0x61b000001580, id=id@entry=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0lru.cc:529
      #6  0x000055ed4289bcc6 in buf_LRU_flush_or_remove_pages (id=922, observer=observer@entry=0x6040000899d0, first=first@entry=0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/include/buf0buf.ic:1097
      #7  0x000055ed42879b89 in FlushObserver::flush (this=this@entry=0x6040000899d0) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/buf/buf0flu.cc:3802
      #8  0x000055ed4246d0f2 in row_merge_build_indexes (trx=<optimized out>, old_table=<optimized out>, new_table=new_table@entry=0x618000104908, online=<optimized out>, indexes=0x61d000384b58, key_numbers=<optimized out>, n_indexes=<optimized out>, 
          table=<optimized out>, defaults=<optimized out>, col_map=<optimized out>, add_autoinc=<optimized out>, sequence=..., skip_pk_sort=<optimized out>, stage=<optimized out>, add_v=<optimized out>, eval_table=<optimized out>, 
          allow_not_null=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/row/row0merge.cc:5044
      #9  0x000055ed42161605 in ha_innobase::inplace_alter_table (this=0x61c00032b0a8, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/storage/innobase/handler/handler0alter.cc:7154
      #10 0x000055ed414455ea in handler::ha_inplace_alter_table (ha_alter_info=0x73fb0c09d920, altered_table=0x61f0003a3e88, this=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/handler.h:4207
      #11 mysql_inplace_alter_table (thd=thd@entry=0x62a00024c208, table_list=<optimized out>, table=table@entry=0x61f0003a2288, altered_table=altered_table@entry=0x61f0003a3e88, ha_alter_info=ha_alter_info@entry=0x73fb0c09d920, 
          inplace_supported=inplace_supported@entry=HA_ALTER_INPLACE_COPY_LOCK, target_mdl_request=<optimized out>, alter_ctx=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_table.cc:7654
      #12 0x000055ed41468297 in mysql_alter_table (thd=thd@entry=0x62a00024c208, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x73fb0c09f460, table_list=table_list@entry=0x62b00013b3f8, 
          alter_info=alter_info@entry=0x73fb0c09f360, order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_table.cc:9946
      #13 0x000055ed415ddeee in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_alter.cc:512
      #14 0x000055ed411f1944 in mysql_execute_command (thd=thd@entry=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:6022
      #15 0x000055ed411f617f in mysql_parse (thd=thd@entry=0x62a00024c208, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x73fb0c0a1f40, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
          at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:7810
      #16 0x000055ed411fd8bf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62a00024c208, 
          packet=packet@entry=0x629000a8c209 " ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */ ", packet_length=packet_length@entry=123, is_com_multi=is_com_multi@entry=false, 
          is_next_command=is_next_command@entry=false) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_class.h:1134
      #17 0x000055ed412071d6 in do_command (thd=0x62a00024c208) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_parse.cc:1393
      #18 0x000055ed415d09d0 in do_handle_one_connection (connect=connect@entry=0x608000001328) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1403
      #19 0x000055ed415d10de in handle_one_connection (arg=0x608000001328) at /home/mleich/Server/bb-10.3-MDEV-23072/sql/sql_connect.cc:1308
      #20 0x00007fff8d9bd609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #21 0x0000000067f30103 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      (rr)
       
      Query (0x62b00013b228): ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */
      # 2020-10-15T12:52:08 [1967283] | [rr 1968947 779414]
      # 2020-10-15T12:52:08 [1967283] | Connection ID (thread ID): 66
      # 2020-10-15T12:52:08 [1967283] | [rr 1968947 779416]Status: KILL_TIMEOUT[rr 1968947 764251]201015 12:43:46 [rr 1968947 764254][ERROR] mysqld got signal 11 ;
      ...
      Query (0x62b00013b228): ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx2` ( col_text ), LOCK = SHARED  /* E_R Thread2 QNO 295 CON_ID 66 */
      Connection ID (thread ID): 66
      Status: KILL_TIMEOUT    <== Maybe important
       
       
      origin/bb-10.3-MDEV-23072 8ebfe9811e805a9b508199bc0224a82f7fa69eb3 2020-10-15T13:26:18+05:30  compiled with debug + ASAN + Og
       
      RQG
      ====
      git clone https://github.com/mleich1/rqg --branch experimental RQG
          origin/experimental e95247cfe20eb07f11c81bfa551e45571dd3637d 
       
      perl rqg.pl \
      --grammar=conf/mariadb/table_stress_innodb.yy \
      --gendata=conf/mariadb/table_stress.zz \
      --gendata_sql=conf/mariadb/table_stress.sql \
      --mysqld=--innodb_use_native_aio=1 \
      --mysqld=--innodb_lock_schedule_algorithm=fcfs \
      --mysqld=--loose-idle_write_transaction_timeout=0 \
      --mysqld=--loose-idle_transaction_timeout=0 \
      --mysqld=--loose-idle_readonly_transaction_timeout=0 \
      --mysqld=--connect_timeout=60 \
      --mysqld=--interactive_timeout=28800 \
      --mysqld=--slave_net_timeout=60 \
      --mysqld=--net_read_timeout=30 \
      --mysqld=--net_write_timeout=60 \
      --mysqld=--loose-table_lock_wait_timeout=50 \
      --mysqld=--wait_timeout=28800 \
      --mysqld=--lock-wait-timeout=86400 \
      --mysqld=--innodb-lock-wait-timeout=50 \
      --no-mask \
      --queries=10000000 \
      --seed=random \
      --reporters=Backtrace \
      --reporters=ErrorLog \
      --reporters=Deadlock1 \
      --validators=None \
      --mysqld=--log_output=none \
      --mysqld=--log-bin \
      --mysqld=--log_bin_trust_function_creators=1 \
      --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
      --engine=InnoDB \
      --restart_timeout=120 \
      --duration=400 \
      --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=400 \
      --mysqld=--innodb_stats_persistent=on \
      --mysqld=--loose-max-statement-time=30 \
      --threads=33 \
      --mysqld=--innodb_page_size=64K \
      --mysqld=--innodb-buffer-pool-size=256M \
      --duration=400 \
      --no_mask \
      --workdir=<local settings> \
      --vardir=<local settings> \
      --mtr-build-thread=<local settings> \
      --basedir1=<local settings> \
      --script_debug=_nix_ \
      --rr=Server \
      --rr_options=--chaos
       
      I hit this SEGV once on > 2500 RQG tests.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration