Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Incomplete
 - 
    10.4.13
 
Description
The following crash happened:
					200930 15:45:14 [ERROR] mysqld got signal 11 ;
			 | 
		
					This could be because you hit a bug. It is also possible that this binary
			 | 
		
					or one of the libraries it was linked against is corrupt, improperly built,
			 | 
		
					or misconfigured. This error can also be caused by malfunctioning hardware.
			 | 
		
| 
					 | 
		
					To report this bug, see https://mariadb.com/kb/en/reporting-bugs
			 | 
		
| 
					 | 
		
					We will try our best to scrape up some info that will hopefully help
			 | 
		
					diagnose the problem, but since we have already crashed,
			 | 
		
					something is definitely wrong and this may fail.
			 | 
		
| 
					 | 
		
					Server version: 10.4.13-MariaDB-log
			 | 
		
					key_buffer_size=10485760
			 | 
		
					read_buffer_size=262144
			 | 
		
					max_used_connections=595
			 | 
		
					max_threads=65537
			 | 
		
					thread_count=579
			 | 
		
					It is possible that mysqld could use up to
			 | 
		
					key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 151056887 K bytes of memory
			 | 
		
					Hope that's ok; if not, decrease some variables in the equation.
			 | 
		
| 
					 | 
		
					Thread pointer: 0x56277b0e6008
			 | 
		
					Attempting backtrace. You can use the following information to find out
			 | 
		
					where mysqld died. If you see no messages after this, something went
			 | 
		
					terribly wrong...
			 | 
		
					stack_bottom = 0x7f053cc25be0 thread_stack 0x49000
			 | 
		
					/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5625762666ce]
			 | 
		
					/usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x562575cfcf7f]
			 | 
		
					/lib64/libpthread.so.0(+0xf6d0)[0x7f055846b6d0]
			 | 
		
					/usr/sbin/mysqld(+0xc6f0f3)[0x5625760bc0f3]
			 | 
		
					/usr/sbin/mysqld(+0xc6f2a0)[0x5625760bc2a0]
			 | 
		
					/usr/sbin/mysqld(+0xbd0fae)[0x56257601dfae]
			 | 
		
					/usr/sbin/mysqld(+0xbaba2d)[0x562575ff8a2d]
			 | 
		
					/usr/sbin/mysqld(+0xbb8e32)[0x562576005e32]
			 | 
		
					/usr/sbin/mysqld(+0xbbf11d)[0x56257600c11d]
			 | 
		
					/usr/sbin/mysqld(+0xb46163)[0x562575f93163]
			 | 
		
					/usr/sbin/mysqld(+0xb4b2ae)[0x562575f982ae]
			 | 
		
					/usr/sbin/mysqld(+0xb4c084)[0x562575f99084]
			 | 
		
					/usr/sbin/mysqld(+0xb22c5b)[0x562575f6fc5b]
			 | 
		
					/usr/sbin/mysqld(+0xa66bbc)[0x562575eb3bbc]
			 | 
		
					/usr/sbin/mysqld(_ZN7handler13ha_update_rowEPKhS1_+0xc3)[0x562575d08723]
			 | 
		
					/usr/sbin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_orderybPySA_+0x21a2)[0x562575ba1cf2]
			 | 
		
					/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2ff5)[0x562575af8d15]
			 | 
		
					/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1fb)[0x562575afe8ab]
			 | 
		
					/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1957)[0x562575b00a37]
			 | 
		
					/usr/sbin/mysqld(_Z10do_commandP3THD+0x109)[0x562575b02049]
			 | 
		
					/usr/sbin/mysqld(_Z11tp_callbackP13TP_connection+0x1d8)[0x562575ccf4c8]
			 | 
		
					/usr/sbin/mysqld(+0xa3b190)[0x562575e88190]
			 | 
		
					/usr/sbin/mysqld(+0xdcb78d)[0x56257621878d]
			 | 
		
					/lib64/libpthread.so.0(+0x7e25)[0x7f0558463e25]
			 | 
		
					/lib64/libc.so.6(clone+0x6d)[0x7f0556806bad]
			 | 
		
| 
					 | 
		
					Trying to get some variables.
			 | 
		
					Some pointers may be invalid and cause the dump to abort.
			 | 
		
					Query (0x56277b0ec820): update db.USER_LOCK set SESSION_KEY=_binary 'm ^ \
			 | 
		
					Connection ID (thread ID): 18613
			 | 
		
					Status: NOT_KILLED
			 | 
		
In the gdb backtrace from the core we see the following crashing thread:
					Thread 1 (Thread 0x7f053cc26700 (LWP 36992)):
			 | 
		
					#0 0x00007f0558468a01 in pthread_sigmask () from /lib64/libpthread.so.0
			 | 
		
					#1 0x0000562575cfcffe in handle_fatal_signal (sig=11) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/signal_handler.cc:343
			 | 
		
					#2 0x00007f055846b6d0 in __libc_sigaction () from /lib64/libpthread.so.0
			 | 
		
					#3 0x0000000000087007 in ?? ()
			 | 
		
					#4 0x0000000000000008 in ?? ()
			 | 
		
					#5 0x00007f053cc212c0 in ?? ()
			 | 
		
					#6 0x0000562575ee98db in pfs_end (this=0x2aca40d34000, ret=0, locker=0xb751230ca3b2a847) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/include/ib0mutex.h:742
			 | 
		
					#7 PolicyMutex<TTASEventMutex<GenericPolicy> >::enter (this=0x2aca40d34000, n_spins=17, n_delay=10954, line=1993551968,
			 | 
		
					name=0x56257646c480 "/home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.13/storage/innobase/lock/lock0lock.cc")
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/include/ib0mutex.h:598
			 | 
		
					#8 0x000056257601dfae in btr_search_drop_page_hash_index (block=<optimized out>) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/btr/btr0sea.cc:1248
			 | 
		
					#9 0x0000562575ff8a2d in btr_page_reorganize_low (recovery=recovery@entry=false, z_level=6, cursor=cursor@entry=0x562751d1b908, index=0x562750233668,
			 | 
		
					mtr=mtr@entry=0x7f053cc226e0) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/btr/btr0btr.cc:1472
			 | 
		
					#10 0x0000562575ff8d7e in btr_page_reorganize (cursor=cursor@entry=0x562751d1b908, index=<optimized out>, mtr=mtr@entry=0x7f053cc226e0)
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/btr/btr0btr.cc:1715
			 | 
		
					#11 0x0000562576005e32 in btr_cur_insert_if_possible (cursor=cursor@entry=0x562751d1b900, tuple=tuple@entry=0x56276224d4f8, offsets=offsets@entry=0x7f053cc21bb8,
			 | 
		
					heap=heap@entry=0x7f053cc21c80, n_ext=n_ext@entry=0, mtr=mtr@entry=0x7f053cc226e0) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/btr/btr0cur.cc:3246
			 | 
		
					#12 0x000056257600c11d in btr_cur_optimistic_update (flags=flags@entry=2, cursor=cursor@entry=0x562751d1b900, offsets=offsets@entry=0x7f053cc21bb8,
			 | 
		
					heap=heap@entry=0x7f053cc21c80, update=0x56276cb78b90, cmpl_info=0, thr=thr@entry=0x56276cb78fd8, trx_id=1257564648, mtr=mtr@entry=0x7f053cc226e0)
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/btr/btr0cur.cc:4740
			 | 
		
					#13 0x0000562575f93163 in row_upd_clust_rec (flags=flags@entry=0, node=node@entry=0x56276cb78a70, index=index@entry=0x562750233668, offsets=offsets@entry=0x7f053cc22220,
			 | 
		
					offsets_heap=offsets_heap@entry=0x7f053cc21c80, thr=thr@entry=0x56276cb78fd8, mtr=mtr@entry=0x7f053cc226e0)
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/row/row0upd.cc:2868
			 | 
		
					#14 0x0000562575f982ae in row_upd_clust_step (node=node@entry=0x56276cb78a70, thr=thr@entry=0x56276cb78fd8)
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/row/row0upd.cc:3233
			 | 
		
					#15 0x0000562575f99084 in row_upd (thr=0x56276cb78fd8, node=0x56276cb78a70) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/row/row0upd.cc:3298
			 | 
		
					#16 row_upd_step (thr=thr@entry=0x56276cb78fd8) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/row/row0upd.cc:3442
			 | 
		
					#17 0x0000562575f6fc5b in row_update_for_mysql (prebuilt=0x56276cb78068) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/row/row0mysql.cc:1889
			 | 
		
					#18 0x0000562575eb3bbc in ha_innobase::update_row (this=0x562769e6c020, old_row=0x562765916220 "\036\377n\216\317^\a", new_row=0x562765916020 "\002\377n\216\317^\a")
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/storage/innobase/handler/ha_innodb.cc:8823
			 | 
		
					#19 0x0000562575d08723 in handler::ha_update_row (this=0x562769e6c020, old_data=0x562765916220 "\036\377n\216\317^\a", new_data=0x562765916020 "\002\377n\216\317^\a")
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/sql/handler.cc:6751
			 | 
		
					#20 0x0000562575ba1cf2 in mysql_update (thd=thd@entry=0x56277b0e6008, table_list=0x56277b0ecac8, fields=..., values=..., conds=0x56277b0edbf8, order_num=<optimized out>,
			 | 
		
					order=<optimized out>, limit=18446744073709551615, ignore=false, found_return=found_return@entry=0x7f053cc23500, updated_return=updated_return@entry=0x7f053cc235c0)
			 | 
		
					at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_update.cc:1057
			 | 
		
					#21 0x0000562575af8d15 in mysql_execute_command (thd=thd@entry=0x56277b0e6008) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:4376
			 | 
		
					#22 0x0000562575afe8ab in mysql_parse (thd=thd@entry=0x56277b0e6008, rawbuf=<optimized out>, length=213, parser_state=parser_state@entry=0x7f053cc25260,
			 | 
		
					is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:7900
			 | 
		
					#23 0x0000562575b00a37 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x56277b0e6008,
			 | 
		
					packet=packet@entry=0x562779568009 "update db.USER_LOCK set SESSION_KEY=_binary 'm\216\317^\a\\", packet_length=packet_length@entry=213,
			 | 
		
					is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:1842
			 | 
		
					#24 0x0000562575b02049 in do_command (thd=thd@entry=0x56277b0e6008) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/sql_parse.cc:1360
			 | 
		
					#25 0x0000562575ccf4c8 in threadpool_process_request (thd=0x56277b0e6008) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/threadpool_common.cc:365
			 | 
		
					#26 tp_callback (c=0x5627606b5f80) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/threadpool_common.cc:192
			 | 
		
					#27 0x0000562575e88190 in worker_main (param=param@entry=0x56274db6e3c8) at /usr/src/debug/MariaDB-10.4.13/src_0/sql/threadpool_generic.cc:1597
			 | 
		
					#28 0x000056257621878d in pfs_spawn_thread (arg=0x5627905c4a08) at /usr/src/debug/MariaDB-10.4.13/src_0/storage/perfschema/pfs.cc:1869
			 | 
		
					#29 0x00007f0558463e25 in start_thread () from /lib64/libpthread.so.0
			 | 
		
					#30 0x00007f0556806bad in __opensock () from /lib64/libc.so.6
			 | 
		
					#31 0x0000000000000000 in ?? ()
			 | 
		
					
			 | 
		
Attachments
Issue Links
- relates to
 - 
                    
MDEV-20203 assert_block_ahi_valid(block) fails in btr_search_update_hash_ref()
-         
 - Closed
 
 -