Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    10.0.1, 5.5.30, 5.3.12
 - 
    None
 - 
    None
 - 
    RedHat EL 5.3 2.6.18-274.7.1.el5 x86_64 using bintar mariadb-5.3.12-Linux-x86_64.tar.gz
 
Description
Hello and thank you for mariadb-5.3.12-Linux-x86_64.tar.gz
Had a crash on a recently upgraded (from MySQL 5.1.48) today, wondering if the backtrace might look like a known issue. I do not have a reproducer at the moment. Thanks.
					 
			 | 
		
					130315  9:43:03 [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 http://kb.askmonty.org/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: 5.3.12-MariaDB-log
			 | 
		
					key_buffer_size=34359738368
			 | 
		
					read_buffer_size=8388608
			 | 
		
					max_used_connections=135
			 | 
		
					max_threads=501
			 | 
		
					thread_count=20
			 | 
		
					connection_count=20
			 | 
		
					It is possible that mysqld could use up to
			 | 
		
					key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 40230290 K  bytes of memory
			 | 
		
					Hope that's ok; if not, decrease some variables in the equation.
			 | 
		
					 
			 | 
		
					Thread pointer: 0x0x2abbac0c2a10
			 | 
		
					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 = 0x43e0f0f8 thread_stack 0x48000
			 | 
		
					./bin/mysqld(my_print_stacktrace+0x2e) [0x998a1e]
			 | 
		
					./bin/mysqld(handle_fatal_signal+0x3f9) [0x71ede9]
			 | 
		
					/lib64/libpthread.so.0 [0x399f40eb70]
			 | 
		
					./bin/mysqld(mi_killed_in_mariadb+0xb) [0x7b412b]
			 | 
		
					./bin/mysqld(mi_yield_and_check_if_killed+0x23) [0x7caba3]
			 | 
		
					./bin/mysqld(mi_rnext_same+0xdb) [0x7e19fb]
			 | 
		
					./bin/mysqld(myrg_rnext_same+0x33) [0x86eb33]
			 | 
		
					./bin/mysqld(ha_myisammrg::index_next_same(unsigned char*, unsigned char const*, unsigned int)+0x20) [0x86cd60]
			 | 
		
					./bin/mysqld(handler::read_range_next()+0x3f) [0x70fc9f]
			 | 
		
					./bin/mysqld(handler::multi_range_read_next(void**)+0xd2) [0x7a52a2]
			 | 
		
					./bin/mysqld(QUICK_RANGE_SELECT::get_next()+0x39) [0x6ecad9]
			 | 
		
					./bin/mysqld(QUICK_ROR_INTERSECT_SELECT::get_next()+0x3c) [0x6ededc]
			 | 
		
					./bin/mysqld [0x70ac7e]
			 | 
		
					./bin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xae) [0x678a1e]
			 | 
		
					./bin/mysqld [0x678f54]
			 | 
		
					./bin/mysqld(JOIN::exec()+0x856) [0x68afb6]
			 | 
		
					./bin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x199) [0x68d0f9]
			 | 
		
					./bin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x16f) [0x68dacf]
			 | 
		
					./bin/mysqld [0x601e9e]
			 | 
		
					./bin/mysqld(mysql_execute_command(THD*)+0x3a43) [0x607833]
			 | 
		
					./bin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x299) [0x60a629]
			 | 
		
					./bin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xdf9) [0x60b879]
			 | 
		
					./bin/mysqld(do_command(THD*)+0x101) [0x60c0b1]
			 | 
		
					./bin/mysqld(handle_one_connection+0xfd) [0x5fd7bd]
			 | 
		
					/lib64/libpthread.so.0 [0x399f40673d]
			 | 
		
					/lib64/libc.so.6(clone+0x6d) [0x399e8d44bd]
			 | 
		
					 
			 | 
		
					Trying to get some variables.
			 | 
		
					Some pointers may be invalid and cause the dump to abort.
			 | 
		
					Query (0x2abbc81173e8): select l.dttm as Date, l.usr as Username, l.serial as SN, l.lntype as Type, l.lntxt as Text from logh l  INNER JOIN session s  ON s.sessionid = l.sessionid where l.lntype in ('XXXXXXXXXXXXXXX')  and l.dt in ('2012-02-20')  and l.usr in ('YYYYYYYYYYY')  and l.serial in ('1234567')  and l.lntxt like '%Some text%' and s.speed != 'some_value' and s.inhouse = 'n' limit 1000
			 | 
		
					Connection ID (thread ID): 3806879
			 | 
		
					Status: NOT_KILLED
			 | 
		
					Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_conditio                                n_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,p                                artial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_increme                                ntal=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on
			 | 
		
					 
			 | 
		
					The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
			 | 
		
					information that should help you find out what is causing the crash.
			 |