Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.5
-
None
Description
- we need to run out of table_open_cache to enter this code branch
- there were ~5 active + N stale connections, though low connection number should be fine
if they can simulate out of table cache (e.g. one connection locks/unlocks table_open_cache
table instances, while other connections accessing other tables) - number of tables is not known
- table_definition_cache may (or may not) relate to this problem
- there should be no DDL/admin statements involved (though they're not excluded)
- there should be no difference which DML statements are involved, so plain SELECT-s should be fine
2015-06-17 14:01:32 140497706510080 [Note] WSREP: Stop replication
|
2015-06-17 14:01:32 140497706510080 [Note] Event Scheduler: Purging the
|
queue. 0 events
|
2015-06-17 14:01:32 140497706510080 [Note]
|
/usr/mariadb/mariadb/bin//mysqld: Shutdown complete
|
|
150617 14:01:32 mysqld_safe mysqld from pid file /home/mysql/pid/local.pid
|
ended
|
150617 14:02:38 mysqld_safe Starting mysqld daemon with databases from
|
/home/mysql/data/local/
|
2015-06-17 14:02:38 140260849645440 [Warning] 'THREAD_CONCURRENCY' is
|
deprecated and will be removed in a future release.
|
2015-06-17 14:02:38 140260849645440 [Note] /usr/mariadb/mariadb/bin//mysqld
|
(mysqld 10.1.5-MariaDB-log) starting as process 2321 ...
|
2015-06-17 14:02:38 140260849645440 [Note] Plugin 'InnoDB' is disabled.
|
2015-06-17 14:02:38 140260849645440 [Note] Plugin 'FEEDBACK' is disabled.
|
2015-06-17 14:02:38 140260849645440 [Note] Server socket created on IP:
|
'::'.
|
2015-06-17 14:02:38 140260849645440 [Note] Event Scheduler: Loaded 0 events
|
2015-06-17 14:02:38 140260849645440 [Note] WSREP: Read nil XID from storage
|
engines, skipping position init
|
2015-06-17 14:02:38 140260849645440 [Note] WSREP: wsrep_load(): loading
|
provider library 'none'
|
2015-06-17 14:02:38 140260849645440 [Note]
|
/usr/mariadb/mariadb/bin//mysqld: ready for connections.
|
Version: '10.1.5-MariaDB-log' socket: '/tmp/mysql.BH.sock' port: 3307
|
MariaDB Server
|
150617 17:02: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 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: 10.1.5-MariaDB-log
|
key_buffer_size=629145600
|
read_buffer_size=4194304
|
max_used_connections=23
|
max_threads=102
|
thread_count=16
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads =
|
1452041 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7f90d0353008
|
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 = 0x7f9103539e80 thread_stack 0x48000
|
mysys/stacktrace.c:247(my_print_stacktrace)[0x7f9106c50b0b]
|
sql/signal_handler.cc:153(handle_fatal_signal)[0x7f91067eadb5]
|
/lib64/libpthread.so.0(+0x10d00)[0x7f910537dd00]
|
sql/sql_plist.h:181(I_P_List_iterator)[0x7f910679cf03]
|
mysys/lf_hash.c:125(lfind)[0x7f9106c5a1a0]
|
sql/table_cache.cc:1084(tdc_iterate(THD*, char (*)(void*, void*), void*,
|
bool))[0x7f910679e4e3]
|
sql/table_cache.cc:267(tc_add_table(THD*, TABLE*))[0x7f910679e808]
|
sql/sql_base.cc:2572(open_table(THD*, TABLE_LIST*,
|
Open_table_context*))[0x7f9106633272]
|
sql/sql_base.cc:4016(open_and_process_table)[0x7f91066370c8]
|
sql/sql_base.cc:5184(open_and_lock_tables(THD*, DDL_options_st const&,
|
TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x7f9106637394]
|
sql/sql_parse.cc:5718(execute_sqlcom_select)[0x7f910666f083]
|
sql/sql_parse.cc:2938(mysql_execute_command(THD*))[0x7f910667a9ce]
|
sql/sql_parse.cc:7173(mysql_parse)[0x7f910667dc3d]
|
sql/sql_parse.cc:1470(dispatch_command(enum_server_command, THD*, char*,
|
unsigned int))[0x7f91066802a8]
|
sql/sql_parse.cc:1095(do_command(THD*))[0x7f910668083b]
|
sql/sql_connect.cc:1347(do_handle_one_connection(THD*))[0x7f91067435ef]
|
sql/sql_connect.cc:1260(handle_one_connection)[0x7f9106743747]
|
/lib64/libpthread.so.0(+0x7654)[0x7f9105374654]
|
/lib64/libc.so.6(clone+0x6d)[0x7f9104a987dd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f90c8424020): is an invalid pointer
|
Connection ID (thread ID): 516
|
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=off,mrr_cost_based=off,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=off,table_elimination=on,extended_keys=on,exists_to_in=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.
|
150617 17:02:14 mysqld_safe Number of processes running now: 0
|
150617 17:02:14 mysqld_safe mysqld restarted
|
2015-06-17 17:02:15 140086665152384 [Warning] 'THREAD_CONCURRENCY' is
|
deprecated and will be removed in a future release.
|
2015-06-17 17:02:15 140086665152384 [Note] /usr/mariadb/mariadb/bin//mysqld
|
(mysqld 10.1.5-MariaDB-log) starting as process 9785 ...
|
2015-06-17 17:02:15 140086665152384 [Note] mysqld: Aria engine: starting
|
recovery
|
recovered pages: 0% 10% 21% 31% 41% 51% 78% 90% 100% (0.0 seconds); tables
|
to flush: 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18
|
17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 (0.3 seconds);
|
2015-06-17 17:02:15 140086665152384 [Note] mysqld: Aria engine: recovery
|
done
|
2015-06-17 17:02:15 140086665152384 [Note] Plugin 'InnoDB' is disabled.
|
2015-06-17 17:02:15 140086665152384 [Note] Plugin 'FEEDBACK' is disabled.
|
2015-06-17 17:02:15 140086665152384 [Note] Recovering after a crash using
|
tc.log
|
2015-06-17 17:02:15 140086665152384 [Note] Starting crash recovery...
|
2015-06-17 17:02:15 140086665152384 [Note] Crash recovery finished.
|
2015-06-17 17:02:15 140086665152384 [Note] Server socket created on IP:
|
'::'.
|
2015-06-17 17:02:15 140086665152384 [Note] Event Scheduler: Loaded 0 events
|
2015-06-17 17:02:15 140086665152384 [Note] WSREP: Read nil XID from storage
|
engines, skipping position init
|
2015-06-17 17:02:15 140086665152384 [Note] WSREP: wsrep_load(): loading
|
provider library 'none'
|
2015-06-17 17:02:15 140086665152384 [Note]
|
/usr/mariadb/mariadb/bin//mysqld: ready for connections.
|
Version: '10.1.5-MariaDB-log' socket: '/tmp/mysql.BH.sock' port: 3307
|
MariaDB Server
|
2015-06-17 17:02:19 140086617798400 [ERROR] mysqld: Table
|
'./conquista_comercial/est_atu' is marked as crashed and should be repaired
|
2015-06-17 17:02:19 140086617798400 [Warning] Checking table:
|
'./conquista_comercial/est_atu'
|
2015-06-17 17:02:19 140086617798400 [ERROR] mysqld: Table
|
'./conquista_comercial/est_spa' is marked as crashed and should be repaired
|
2015-06-17 17:02:19 140086617798400 [Warning] Checking table:
|
'./conquista_comercial/est_spa'
|
2015-06-17 17:02:51 140086617798400 [ERROR] mysqld: Table
|
'./conquista_comercial/est_dia' is marked as crashed and should be repaired
|
2015-06-17 17:02:51 140086617798400 [Warning] Checking table:
|
'./conquista_comercial/est_dia'
|
2015-06-17 17:02:52 140086617798400 [ERROR] mysqld: Table
|
'./conquista_comercial/rastreabilidade_impressao' is marked as crashed and
|
should be repaired
|
2015-06-17 17:02:52 140086617798400 [Warning] Checking table:
|
'./conquista_comercial/rastreabilidade_impressao'
|
2015-06-17 17:29:58 140086663948032 [ERROR] mysqld: Table
|
'./conquista_comercial/est_atu_erros' is marked as crashed and should be
|
repaired
|
2015-06-17 17:29:58 140086663948032 [Warning] Checking table:
|
'./conquista_comercial/est_atu_erros'
|
2015-06-17 19:24:04 140086538364672 [Note]
|
/usr/mariadb/mariadb/bin//mysqld: Normal shutdown
|
|
2015-06-17 19:24:04 140086538364672 [Note] WSREP: Stop replication
|
2015-06-17 19:24:06 140086538364672 [Note] Event Scheduler: Purging the
|
queue. 0 events
|
2015-06-17 19:24:07 140086538364672 [Note]
|
/usr/mariadb/mariadb/bin//mysqld: Shutdown complete
|
|
150617 19:24:07 mysqld_safe mysqld from pid file /home/mysql/pid/local.pid
|
ended
|