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

Server crashes in my_hash_insert on PPC64

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: None
    • Labels:
    • Environment:
      PPC64 RHEL 6.5 export PATH=/opt/at7.0/bin:$PATH && cmake -DCMAKE_BUILD_TYPE=Debug && make -j3

      Description

      #2  0x000000001050aa5c in handle_fatal_signal (sig=11) at 10.0/sql/signal_handler.cc:262
      #3  <signal handler called>
      #4  0x0000000010ce1974 in my_hash_insert (info=0x0, record=0xffef01b9e70 "") at 10.0/mysys/hash.c:387
      #5  0x0000000010d1d940 in add_to_locked_mutex (locked_mutex=0xffefc01f6f0, current_mutex=0xffef01b9e70) at 10.0/mysys/thr_mutex.c:746
      #6  0x0000000010ce2abc in my_hash_iterate (hash=0xffef019d350, action=@0x1145ae78: 0x10d1d848 <add_to_locked_mutex>, argument=0xffef01b9e70) at 10.0/mysys/hash.c:762
      #7  0x0000000010d1d810 in add_used_to_locked_mutex (used_mutex=0xffef01b9e70, locked_mutex=0xfff080371b0) at 10.0/mysys/thr_mutex.c:719
      #8  0x0000000010d1c930 in safe_mutex_lock (mp=0xffef01b9cd8, my_flags=0, file=0x10eec788 "10.0/storage/maria/ma_close.c", line=67) at 10.0/mysys/thr_mutex.c:388
      #9  0x000000001081a9c8 in inline_mysql_mutex_lock (that=0xffef01b9cd8, src_file=0x10eec788 "10.0/storage/maria/ma_close.c", src_line=67) at 10.0/include/mysql/psi/mysql_thread.h:689
      #10 0x000000001081b16c in maria_close (info=0xffef019f970) at 10.0/storage/maria/ma_close.c:67
      #11 0x0000000010773198 in ha_maria::close (this=0xffef016b2e8) at 10.0/storage/maria/ha_maria.cc:1249
      #12 0x0000000010512b48 in handler::ha_close (this=0xffef016b2e8) at 10.0/sql/handler.cc:2530
      #13 0x0000000010cc94b0 in ha_partition::close (this=0xffef01611e8) at 10.0/sql/ha_partition.cc:3691
      #14 0x0000000010512b48 in handler::ha_close (this=0xffef01611e8) at 10.0/sql/handler.cc:2530
      #15 0x000000001039f58c in closefrm (table=0xffef01607c0, free_share=true) at 10.0/sql/table.cc:2941
      #16 0x0000000010200624 in intern_close_table (table=0xffef01607c0) at 10.0/sql/sql_base.cc:342
      #17 0x00000000104781c8 in tdc_remove_table (thd=0x100307ca580, remove_type=TDC_RT_REMOVE_NOT_OWN, db=0xffef015f620 "test", table_name=0xffef015f625 "D", kill_delayed_threads=false) at 10.0/sql/table_cache.cc:1025
      #18 0x0000000010203f94 in wait_while_table_is_used (thd=0x100307ca580, table=0xffeec03a630, function=HA_EXTRA_PREPARE_FOR_RENAME) at 10.0/sql/sql_base.cc:1786
      #19 0x0000000010370bdc in mysql_alter_table (thd=0x100307ca580, new_db=0xfff08006190 "test", new_name=0x0, create_info=0xfff695a50d8, table_list=0xfff08005bb8, alter_info=0xfff695a5208, order_num=0, order=0x0, ignore=false) at 10.0/sql/sql_table.cc:8978
      #20 0x00000000103f5288 in Sql_cmd_alter_table::execute (this=0xfff080063e8, thd=0x100307ca580) at 10.0/sql/sql_alter.cc:312
      #21 0x000000001028d7c8 in mysql_execute_command (thd=0x100307ca580) at 10.0/sql/sql_parse.cc:5080
      #22 0x00000000102910e0 in mysql_parse (thd=0x100307ca580, rawbuf=0xfff08005aa8 "ALTER TABLE `D` PARTITION BY KEY() PARTITIONS 6", length=47, parser_state=0xfff695a5f28) at 10.0/sql/sql_parse.cc:6409
      #23 0x0000000010282be4 in dispatch_command (command=COM_QUERY, thd=0x100307ca580, packet=0x100307d1081 "ALTER TABLE `D` PARTITION BY KEY() PARTITIONS 6", packet_length=47) at 10.0/sql/sql_parse.cc:1309
      #24 0x0000000010281db4 in do_command (thd=0x100307ca580) at 10.0/sql/sql_parse.cc:1006
      #25 0x00000000103eef48 in do_handle_one_connection (thd_arg=0x100307ca580) at 10.0/sql/sql_connect.cc:1379
      #26 0x00000000103eebac in handle_one_connection (arg=0x100307ca580) at 10.0/sql/sql_connect.cc:1293
      #27 0x00000fff922bc548 in start_thread (arg=0xfff695a7190) at pthread_create.c:311
      #28 0x00000fff91b93c90 in .__clone () at ../sysdeps/unix/sysv/linux/powerpc/powerpc64/clone.S:106
      

      Stack trace from

      revision-id: holyfoot@askmonty.org-20140722102815-y27a18djzjbpnchf
      revno: 4301
      branch-nick: 10.0-for-stress-tests
      

      RQG command line that triggered the bug (it does not do it every time, so it's just information, not a way to reproduce):

      perl ./runall-new.pl \
      --queries=100000000 \
      --no-mask \
      --seed=1406056211 \
      --threads=8 \
      --duration=600 \
      --queries=100M \
      --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock \
      --validators=TransformerNoComparator \
      --transformers=ExecuteAsDeleteReturning,ExecuteAsPreparedTwice,DisableOptimizations,EnableOptimizations,OrderBy \
      --redefine=conf/mariadb/general-workarounds.yy \
      --redefine=conf/mariadb/10.0-features-redefine.yy \
      --mysqld=--log_output=FILE \
      --mysqld=--query_cache_size=64M \
      --mysqld=--slow_query_log \
      --mysqld=--long_query_time=0.000001 \
      --mysqld=--log_bin_trust_function_creators=1 \
      --views \
      --grammar=conf/runtime/information_schema.yy \
      --engine=Aria \
      --rpl_mode=mixed \
      --mysqld=--slave-skip-errors=1049,1305,1539,1505,1317 \
      --use-gtid=current_pos \
      --mysqld=--optimizer_switch=extended_keys=on,exists_to_in=on \
      --mysqld=--use_stat_tables=PREFERABLY \
      --mysqld=--optimizer_selectivity_sampling_limit=100 \
      --mysqld=--optimizer_use_condition_selectivity=5 \
      --mysqld=--histogram_size=100 \
      --mysqld=--histogram_type=DOUBLE_PREC_HB \
      --mysqld=--log_slow_verbosity=query_plan,explain \
      --mysqld=--slave_parallel_threads=8 \
      --mtr-build-thread=300 \
      --mask=20623 \
      --basedir1=<basedir> --vardir1=<vardir>
      

      randgen/mariadb-patches:

      revision-id: elenst@montyprogram.com-20140716103317-2my8cfdk323poca3
      revno: 945
      branch-nick: randgen-mariadb-patches
      

        Attachments

          Issue links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: