Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Incomplete
 - 
    10.4.17
 - 
    None
 - 
    Linux
 
Description
We have weird crash, that seems to be simple SELECT query, but every time server fails to recover from crash, because Cannot rename './db/catalog_product_index_eav_replica.ibd' to './db/catalog_product_index_eav.ibd' etc errors. (these rename errors are not in same database)
					2020-12-28 17:33:34 0x7fc2f18ee700 InnoDB: Assertion failure in file /build/amd64-usr/var/tmp/portage/dev-db/mariadb-10.4.17/work/mariadb-10.4.17/storage/innobase/include/ut0lst.h line 334  | 
		
					InnoDB: Failing assertion: list.count > 0  | 
		
					InnoDB: We intentionally generate a memory trap.
			 | 
		
					InnoDB: Submit a detailed bug report to https://jira.mariadb.org/  | 
		
					InnoDB: If you get repeated assertion failures or crashes, even
			 | 
		
					InnoDB: immediately after the mysqld startup, there may be
			 | 
		
					InnoDB: corruption in the InnoDB tablespace. Please refer to
			 | 
		
					InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/  | 
		
					InnoDB: about forcing recovery.
			 | 
		
					201228 17:33:34 [ERROR] mysqld got signal 6 ;  | 
		
					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.17-MariaDB-log  | 
		
					key_buffer_size=4294967296  | 
		
					read_buffer_size=2097152  | 
		
					max_used_connections=260  | 
		
					max_threads=1502  | 
		
					thread_count=89  | 
		
					It is possible that mysqld could use up to
			 | 
		
					key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 19611898 K bytes of memory  | 
		
					Hope that's ok; if not, decrease some variables in the equation.  | 
		
					Thread pointer: 0x7fc13c000c48  | 
		
					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 = 0x7fc2f18edd98 thread_stack 0x49000  | 
		
					/opt/zse/sbin/mysqld(my_print_stacktrace+0x29)[0x556134be9319]  | 
		
					/opt/zse/sbin/mysqld(handle_fatal_signal+0x53d)[0x55613472878d]  | 
		
					sigaction.c:0(__restore_rt)[0x7fc6454722b0]  | 
		
					/lib64/libc.so.6(gsignal+0x141)[0x7fc644adfe41]  | 
		
					/lib64/libc.so.6(abort+0x127)[0x7fc644ac955d]  | 
		
					/opt/zse/sbin/mysqld(+0x54e2cd)[0x55613442c2cd]  | 
		
					/opt/zse/sbin/mysqld(+0x532d87)[0x556134410d87]  | 
		
					/opt/zse/sbin/mysqld(+0xb7e387)[0x556134a5c387]  | 
		
					/opt/zse/sbin/mysqld(+0x552d2c)[0x556134430d2c]  | 
		
					/opt/zse/sbin/mysqld(+0xb54796)[0x556134a32796]  | 
		
					/opt/zse/sbin/mysqld(+0xb557b9)[0x556134a337b9]  | 
		
					/opt/zse/sbin/mysqld(+0xb55da1)[0x556134a33da1]  | 
		
					/opt/zse/sbin/mysqld(+0xb3931e)[0x556134a1731e]  | 
		
					/opt/zse/sbin/mysqld(+0xb2d808)[0x556134a0b808]  | 
		
					/opt/zse/sbin/mysqld(+0xb320f8)[0x556134a100f8]  | 
		
					/opt/zse/sbin/mysqld(+0xb26f88)[0x556134a04f88]  | 
		
					/opt/zse/sbin/mysqld(+0xabdef9)[0x55613499bef9]  | 
		
					/opt/zse/sbin/mysqld(+0xac0325)[0x55613499e325]  | 
		
					/opt/zse/sbin/mysqld(+0x9f3809)[0x5561348d1809]  | 
		
					/opt/zse/sbin/mysqld(_ZN7handler18ha_index_next_sameEPhPKhj+0x1c8)[0x55613472e688]  | 
		
					/opt/zse/sbin/mysqld(_ZN7handler21multi_range_read_nextEPPv+0x2b)[0x556134640adb]  | 
		
					/opt/zse/sbin/mysqld(_ZN23Mrr_simple_index_reader8get_nextEPPv+0x40)[0x556134640bd0]  | 
		
					/opt/zse/sbin/mysqld(_ZN10DsMrr_impl10dsmrr_nextEPPv+0x42)[0x556134642042]  | 
		
					/opt/zse/sbin/mysqld(_ZN18QUICK_RANGE_SELECT8get_nextEv+0x23)[0x55613483b4a3]  | 
		
					/opt/zse/sbin/mysqld(_Z8filesortP3THDP5TABLEP8FilesortP16Filesort_trackerP4JOINy+0xabf)[0x556134726f3f]  | 
		
					/opt/zse/sbin/mysqld(_Z17create_sort_indexP3THDP4JOINP13st_join_tableP8Filesort+0xd0)[0x556134574980]  | 
		
					/opt/zse/sbin/mysqld(_ZN13st_join_table10sort_tableEv+0x71)[0x556134574cd1]  | 
		
					/opt/zse/sbin/mysqld(_Z21join_init_read_recordP13st_join_table+0x39)[0x556134574d59]  | 
		
					/opt/zse/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x173)[0x556134560283]  | 
		
					/opt/zse/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xd43)[0x55613458b8c3]  | 
		
					/opt/zse/sbin/mysqld(_ZN4JOIN4execEv+0x2b)[0x55613458baeb]  | 
		
					/opt/zse/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x133)[0x556134589c63]  | 
		
					/opt/zse/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x152)[0x55613458a712]  | 
		
					/opt/zse/sbin/mysqld(+0x63d539)[0x55613451b539]  | 
		
					/opt/zse/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6802)[0x556134529be2]  | 
		
					/opt/zse/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1c4)[0x55613452c474]  | 
		
					/opt/zse/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1cd0)[0x55613452f2f0]  | 
		
					/opt/zse/sbin/mysqld(_Z10do_commandP3THD+0x101)[0x556134530a41]  | 
		
					/opt/zse/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1c4)[0x556134615844]  | 
		
					/opt/zse/sbin/mysqld(handle_one_connection+0x32)[0x556134615982]  | 
		
					/opt/zse/sbin/mysqld(+0xccaa63)[0x556134ba8a63]  | 
		
					nptl/pthread_create.c:480(start_thread)[0x7fc645466f87]  | 
		
					/lib64/libc.so.6(clone+0x3f)[0x7fc644ba317f]  | 
		
					Trying to get some variables.
			 | 
		
					Some pointers may be invalid and cause the dump to abort.
			 | 
		
					Query (0x7fc13c010050): SELECT t.*, tt.* FROM re_terms AS t INNER JOIN re_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 300  | 
		
					Connection ID (thread ID): 6797144  | 
		
Attachments
Issue Links
- relates to
 - 
                    
MDEV-22956 rpl.rpl_old_master failed in buildbot with InnoDB: Failing assertion: list.count > 0
-         
 - Closed
 
 -         
 - 
                    
MDEV-24489 Server crashes: double free or corruption
-         
 - Closed
 
 -