Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2.9, 10.2.10, 10.2.12
-
RHEL 6.5 x64 on physical server.
Last error on 10.2.12.
-
10.2.14
Description
Problem started after an upgrade 10.0.22 -> 10.2.9 and continues with 10.2.12
error log for 10.2.12 |
2018-01-10 0:15:13 139882323265280 [ERROR] [FATAL] InnoDB: Trying to read page number 376886 in space 4294967294, space name innodb_temporary, which is outside the tablespace bounds. Byte offset 0, len 16384
|
180110 0:15:13 [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.2.12-MariaDB-log
|
key_buffer_size=33554432
|
read_buffer_size=2097152
|
max_used_connections=421
|
max_threads=401
|
thread_count=401
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1700897 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f36d0f4d878
|
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 = 0x7f38e4303cc8 thread_stack 0x30000
|
(my_addr_resolve failure: fork)
|
/usr/sbin/mysqld(my_print_stacktrace+0x2b) [0x7f4373fb2a2b]
|
/usr/sbin/mysqld(handle_fatal_signal+0x535) [0x7f4373a7f915]
|
/lib64/libpthread.so.0(+0x3e5260f7e0) [0x7f4372fa67e0]
|
/lib64/libc.so.6(gsignal+0x35) [0x7f43716005e5]
|
/lib64/libc.so.6(abort+0x175) [0x7f4371601dc5]
|
/usr/sbin/mysqld(+0x9addca) [0x7f4373d83dca]
|
/usr/sbin/mysqld(+0xa56b0d) [0x7f4373e2cb0d]
|
/usr/sbin/mysqld(+0xa5f3bc) [0x7f4373e353bc]
|
/usr/sbin/mysqld(+0xa12b3b) [0x7f4373de8b3b]
|
/usr/sbin/mysqld(+0xa141e6) [0x7f4373dea1e6]
|
/usr/sbin/mysqld(+0x9f1b2b) [0x7f4373dc7b2b]
|
/usr/sbin/mysqld(+0x98ae6c) [0x7f4373d60e6c]
|
/usr/sbin/mysqld(+0x947263) [0x7f4373d1d263]
|
/usr/sbin/mysqld(+0x8ea2a7) [0x7f4373cc02a7]
|
/usr/sbin/mysqld(+0x98bde5) [0x7f4373d61de5]
|
/usr/sbin/mysqld(+0x98c80b) [0x7f4373d6280b]
|
/usr/sbin/mysqld(+0x98cec0) [0x7f4373d62ec0]
|
/usr/sbin/mysqld(+0x857c44) [0x7f4373c2dc44]
|
/usr/sbin/mysqld(ha_rollback_trans(THD*, bool)+0xe2) [0x7f4373a825c2]
|
/usr/sbin/mysqld(trans_rollback(THD*)+0x5a) [0x7f43739d3c3a]
|
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x127c) [0x7f43738fee9c]
|
/usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool)+0x29a) [0x7f437390617a]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0x1cde) [0x7f43739084ee]
|
/usr/sbin/mysqld(do_command(THD*)+0x14e) [0x7f4373908a9e]
|
/usr/sbin/mysqld(tp_callback(TP_connection*)+0x67) [0x7f43739ff917]
|
/usr/sbin/mysqld(+0x682b20) [0x7f4373a58b20]
|
/lib64/libpthread.so.0(+0x3e52607aa1) [0x7f4372f9eaa1]
|
/lib64/libc.so.6(clone+0x6d) [0x7f43716b6aad]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f36d05987f0): rollback
|
Connection ID (thread ID): 64393
|
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,engine_condition_pushdown=off,index_condition_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,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=on,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
similar error from 10.2.9 |
:
|
2017-11-19 17:30:46 139866819159808 [ERROR] [FATAL] InnoDB: Trying to read page number 1755915 in space 4294967294, space name innodb_temporary, which is outside the tablespace bounds. Byte offset 0, len 16384
|
171119 17:30:46 [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.2.9-MariaDB-log
|
key_buffer_size=33554432
|
read_buffer_size=2097152
|
max_used_connections=263
|
max_threads=401
|
thread_count=125
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1700682 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f28bd04ba58
|
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 = 0x7f3548125cc8 thread_stack 0x30000
|
(my_addr_resolve failure: fork)
|
/usr/sbin/mysqld(my_print_stacktrace+0x2b) [0x7f35507b3d8b]
|
/usr/sbin/mysqld(handle_fatal_signal+0x4d5) [0x7f355027e425]
|
/lib64/libpthread.so.0(+0x3e5260f7e0) [0x7f354f7a67e0]
|
/lib64/libc.so.6(gsignal+0x35) [0x7f354de005e5]
|
/lib64/libc.so.6(abort+0x175) [0x7f354de01dc5]
|
/usr/sbin/mysqld(+0x9a7dfa) [0x7f355057ddfa]
|
/usr/sbin/mysqld(+0xa5771d) [0x7f355062d71d]
|
/usr/sbin/mysqld(+0xa5c96f) [0x7f355063296f]
|
/usr/sbin/mysqld(+0xa1231b) [0x7f35505e831b]
|
/usr/sbin/mysqld(+0xa139c6) [0x7f35505e99c6]
|
/usr/sbin/mysqld(+0x9ebb71) [0x7f35505c1b71]
|
/usr/sbin/mysqld(+0x984f3c) [0x7f355055af3c]
|
/usr/sbin/mysqld(+0x9425bb) [0x7f35505185bb]
|
/usr/sbin/mysqld(+0x8e5837) [0x7f35504bb837]
|
/usr/sbin/mysqld(+0x985f85) [0x7f355055bf85]
|
/usr/sbin/mysqld(+0x98627b) [0x7f355055c27b]
|
/usr/sbin/mysqld(+0x91276a) [0x7f35504e876a]
|
/usr/sbin/mysqld(+0x914931) [0x7f35504ea931]
|
/usr/sbin/mysqld(+0x8490b0) [0x7f355041f0b0]
|
/usr/sbin/mysqld(+0x8583f0) [0x7f355042e3f0]
|
/usr/sbin/mysqld(handler::ha_write_row(unsigned char*)+0x177) [0x7f3550287d77]
|
/usr/sbin/mysqld(write_record(THD*, TABLE*, st_copy_info*)+0x71) [0x7f35500e5f21]
|
/usr/sbin/mysqld(select_insert::send_data(List<Item>&)+0xd2) [0x7f35500e6882]
|
/usr/sbin/mysqld(+0x5684bf) [0x7f355013e4bf]
|
/usr/sbin/mysqld(+0x555381) [0x7f355012b381]
|
/usr/sbin/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x17e) [0x7f35501336fe]
|
/usr/sbin/mysqld(JOIN::exec_inner()+0x9f9) [0x7f35501516c9]
|
/usr/sbin/mysqld(JOIN::exec()+0x3c) [0x7f35501518fc]
|
/usr/sbin/mysqld(mysql_select(THD*, 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*)+0x12a) [0x7f355015080a]
|
/usr/sbin/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x1d4) [0x7f3550151b14]
|
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x78d6) [0x7f3550105076]
|
/usr/sbin/mysqld(Prepared_statement::execute(String*, bool)+0x4de) [0x7f355011677e]
|
/usr/sbin/mysqld(+0x543dbb) [0x7f3550119dbb]
|
/usr/sbin/mysqld(+0x544a32) [0x7f355011aa32]
|
/usr/sbin/mysqld(mysqld_stmt_execute(THD*, char*, unsigned int)+0x27) [0x7f355011ab77]
|
/usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool)+0xefa) [0x7f355010739a]
|
/usr/sbin/mysqld(do_command(THD*)+0x14e) [0x7f35501087be]
|
/usr/sbin/mysqld(tp_callback(TP_connection*)+0x67) [0x7f35501fe967]
|
/usr/sbin/mysqld(+0x6816c0) [0x7f35502576c0]
|
/lib64/libpthread.so.0(+0x3e52607aa1) [0x7f354f79eaa1]
|
/lib64/libc.so.6(clone+0x6d) [0x7f354deb6aad]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f28c8014d08): insert ignore into asset_lite select * from asset_lite_temp order by asset_id
|
|
Connection ID (thread ID): 327798
|
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,engine_condition_pushdown=off,index_condition_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,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=on,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
Attachments
Issue Links
- relates to
-
MDEV-15524 Do not write garbage or disable page checksums for temporary tables
- Closed