[MDEV-6524] Server crashes in my_hash_delete on PPC64 Created: 2014-08-03  Updated: 2014-09-03  Resolved: 2014-09-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: N/A
Fix Version/s: N/A

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

PPC64 RHEL 6.5 export PATH=/opt/at7.0/bin:$PATH && cmake -DCMAKE_BUILD_TYPE=Debug && make -j3


Issue Links:
PartOf
is part of MDEV-6478 MariaDB on Power8 Closed

 Description   

It might be the same problem as MDEV-6476, but I will file it separately just in case.

#3  <signal handler called>
#4  0x0000000010ce44bc in my_hash_delete (hash=0xffef80691a80000, record=0xffef8344f90 "") at 10.0/mysys/hash.c:534
#5  0x0000000010d2024c in remove_from_used_mutex (locked_mutex=0xffecc0653a0, mutex=0xffef8344f90) at 10.0/mysys/thr_mutex.c:797
#6  0x0000000010ce5064 in my_hash_iterate (hash=0xffef8349d80, action=@0x1145dc68: 0x10d201a8 <remove_from_used_mutex>, argument=0xffef8344f90) at 10.0/mysys/hash.c:762
#7  0x0000000010d1fd34 in safe_mutex_free_deadlock_data (mp=0xffef8344f90) at 10.0/mysys/thr_mutex.c:661
#8  0x0000000010d1fbd4 in safe_mutex_destroy (mp=0xffef8344f90, file=0x10eecf08 "10.0/storage/maria/ma_bitmap.c", line=330) at 10.0/mysys/thr_mutex.c:605
#9  0x0000000010802af0 in inline_mysql_mutex_destroy (that=0xffef8344f90, src_file=0x10eecf08 "10.0/storage/maria/ma_bitmap.c", src_line=330) at 10.0/include/mysql/psi/mysql_thread.h:644
#10 0x0000000010803be8 in _ma_bitmap_end (share=0xffef8344480) at 10.0/storage/maria/ma_bitmap.c:330
#11 0x00000000107ecab0 in _ma_once_end_block_record (share=0xffef8344480) at 10.0/storage/maria/ma_blockrec.c:445
#12 0x000000001081b924 in maria_close (info=0xffef811d090) at 10.0/storage/maria/ma_close.c:102
#13 0x000000001077375c in ha_maria::close (this=0xffef80f9ec8) at 10.0/storage/maria/ha_maria.cc:1264
#14 0x00000000105131e8 in handler::ha_close (this=0xffef80f9ec8) at 10.0/sql/handler.cc:2530
#15 0x0000000010ccba58 in ha_partition::close (this=0xffef80f9778) at 10.0/sql/ha_partition.cc:3691
#16 0x00000000105131e8 in handler::ha_close (this=0xffef80f9778) at 10.0/sql/handler.cc:2530
#17 0x000000001039fb60 in closefrm (table=0xffef80455b0, free_share=true) at 10.0/sql/table.cc:2941
#18 0x00000000102008a4 in intern_close_table (table=0xffef80455b0) at 10.0/sql/sql_base.cc:342
#19 0x0000000010476a94 in tc_release_table (table=0xffef80455b0) at 10.0/sql/table_cache.cc:408
#20 0x0000000010202314 in close_thread_table (thd=0x10005ab1cc0, table_ptr=0x10005ab1d80) at 10.0/sql/sql_base.cc:1056
#21 0x00000000102019a4 in close_open_tables (thd=0x10005ab1cc0) at 10.0/sql/sql_base.cc:779
#22 0x0000000010201ff4 in close_thread_tables (thd=0x10005ab1cc0) at 10.0/sql/sql_base.cc:1003
#23 0x00000000102060b8 in Locked_tables_list::unlock_locked_tables (this=0x10005ab5838, thd=0x10005ab1cc0) at 10.0/sql/sql_base.cc:2729
#24 0x0000000010289a98 in mysql_execute_command (thd=0x10005ab1cc0) at 10.0/sql/sql_parse.cc:3777
#25 0x00000000102914b4 in mysql_parse (thd=0x10005ab1cc0, rawbuf=0xffecc0052b8 "UNLOCK TABLES", length=13, parser_state=0xfff3d435f28) at 10.0/sql/sql_parse.cc:6411
#26 0x0000000010282f6c in dispatch_command (command=COM_QUERY, thd=0x10005ab1cc0, packet=0x10005ab7a41 " UNLOCK TABLES", packet_length=14) at 10.0/sql/sql_parse.cc:1307
#27 0x000000001028213c in do_command (thd=0x10005ab1cc0) at 10.0/sql/sql_parse.cc:1004
#28 0x00000000103ef520 in do_handle_one_connection (thd_arg=0x10005ab1cc0) at 10.0/sql/sql_connect.cc:1379
#29 0x00000000103ef184 in handle_one_connection (arg=0x10005ab1cc0) at 10.0/sql/sql_connect.cc:1293
#30 0x00000fff7899c548 in start_thread (arg=0xfff3d437190) at pthread_create.c:311
#31 0x00000fff78243c90 in .__clone () at ../sysdeps/unix/sysv/linux/powerpc/powerpc64/clone.S:106

Stack trace from:

revision-id: sergii@pisem.net-20140731161437-oxyzqaskmptm5ssv
revno: 4318
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=1407019341 \
--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-20140802215142-gjrh8ps8d6l58e0e
revno: 952
branch-nick: randgen-mariadb-patches



 Comments   
Comment by Elena Stepanova [ 2014-09-03 ]

Couldn't reproduce it any longer after the merge 5.5=>10.0 that included some Monty's fixes, even though the fixes were not supposed to be related to it.

Generated at Thu Feb 08 07:12:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.