Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Hio,
crash during an insert.
Server version: 10.3.7-MariaDB-log |
key_buffer_size=1073741824 |
read_buffer_size=1073741824 |
max_used_connections=0 |
max_threads=65537 |
thread_count=28 |
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3148659 K bytes of memory |
Hope that's ok; if not, decrease some variables in the equation. |
|
Thread pointer: 0xa7ffe81fd8 |
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...
|
mysqld.exe!ha_sequence::table_flags()[ha_sequence.cc:283] |
mysqld.exe!get_new_handler()[handler.cc:268] |
mysqld.exe!ha_partition::create_handlers()[ha_partition.cc:2878] |
mysqld.exe!ha_partition::setup_engine_array()[ha_partition.cc:3121] |
mysqld.exe!ha_partition::get_from_handler_file()[ha_partition.cc:3162] |
mysqld.exe!ha_partition::initialize_partition()[ha_partition.cc:512] |
mysqld.exe!partition_create_handler()[ha_partition.cc:185] |
mysqld.exe!get_new_handler()[handler.cc:267] |
mysqld.exe!TABLE_SHARE::init_from_binary_frm_image()[table.cc:1710] |
mysqld.exe!open_table_def()[table.cc:672] |
mysqld.exe!tdc_acquire_share()[table_cache.cc:841] |
mysqld.exe!open_table()[sql_base.cc:1793] |
mysqld.exe!open_and_process_table()[sql_base.cc:3536] |
mysqld.exe!open_tables()[sql_base.cc:4054] |
mysqld.exe!open_and_lock_tables()[sql_base.cc:4931] |
mysqld.exe!mysql_insert()[sql_insert.cc:766] |
mysqld.exe!mysql_execute_command()[sql_parse.cc:4723] |
mysqld.exe!mysql_parse()[sql_parse.cc:8025] |
mysqld.exe!Query_log_event::do_apply_event()[log_event.cc:5648] |
mysqld.exe!apply_event_and_update_pos_apply()[slave.cc:3917] |
mysqld.exe!apply_event_and_update_pos()[slave.cc:4066] |
mysqld.exe!exec_relay_log_event()[slave.cc:4358] |
mysqld.exe!handle_slave_sql()[slave.cc:5515] |
mysqld.exe!pthread_start()[my_winthread.c:62] |
mysqld.exe!thread_start<unsigned int (__cdecl*)(void * __ptr64)>()[thread.cpp:115] |
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0xa7ffe4bffb): insert into bi_daten (BI_ID,time,I,P,U_diode,U_Endstufe,U_Photo,Status,Durchfluss,Temperatur,Temp_Endstufe,I_Bias) values(1185188,5536690,1.1909543138E+1,9.782E+1,0E+0,1.1909543138E+1,3.3741264077E+0,'dsp',1.5E+2,2.02E+1,0E+0,0E+0) |
Connection ID (thread ID): 30 |
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=on,engine_condition_pushdown=on,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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off,condition_pushdown_for_derived=on,split_materialized=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.
|