hi dnaie, problem solved with elena at jira, thanks 2015-06-23 20:02 GMT-03:00 Daniel Black <[email protected]>:
> > > ----- On 24 Jun, 2015, at 1:33 AM, roberto [email protected] wrote: > > > Hi guys, i got a crash, could someone help? > > > > --- > > queries: > > set histogram_size=255,histogram_type=SINGLE_PREC_HB; > > ANALYZE TABLE 19_org.estoque_itens PERSISTENT FOR ALL; > > /* Erro SQL (2013): Lost connection to MySQL server during query */ > > > > If its anything like https://mariadb.atlassian.net/browse/MDEV-7362 it > will be a value in one of the rows in that table. > > Eliminate column by column until you find the one that caused it. > > Then find the row (or just include the whole column in the bug report). > > > > --- > > log: > > > > 150623 12:31:47 [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.0.20-MariaDB-log > > key_buffer_size=2097152000 > > read_buffer_size=6291456 > > max_used_connections=22 > > max_threads=92 > > thread_count=9 > > It is possible that mysqld could use up to > > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = > > 3180295 K bytes of memory > > Hope that's ok; if not, decrease some variables in the equation. > > > > Thread pointer: 0x0x7f523b81c008 > > 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 = 0x4b1410a0 thread_stack 0x48000 > > mysys/stacktrace.c:247(my_print_stacktrace)[0xbcb2ee] > > sql/signal_handler.cc:153(handle_fatal_signal)[0x71fa8c] > > /lib/libpthread.so.0[0x7f52ccbe98f0] > > sql/field.h:703(Field::set_notnull(long long))[0x610c70] > > sql/sql_statistics.cc:533(Stat_table::update_stat())[0x60dd68] > > sql/sql_admin.cc:759(mysql_admin_table)[0x67adc1] > > sql/sql_admin.cc:1183(Sql_cmd_analyze_table::execute(THD*))[0x67c66c] > > sql/sql_parse.cc:5095(mysql_execute_command(THD*))[0x5986c2] > > sql/sql_parse.cc:6529(mysql_parse(THD*, char*, unsigned int, > > Parser_state*))[0x59fc86] > > sql/sql_parse.cc:1310(dispatch_command(enum_server_command, THD*, > > char*, unsigned int))[0x5a1bb7] > > sql/sql_parse.cc:999(do_command(THD*))[0x5a22f9] > > sql/sql_connect.cc:1378(do_handle_one_connection(THD*))[0x66c7d4] > > sql/sql_connect.cc:1295(handle_one_connection)[0x66c912] > > /lib/libpthread.so.0[0x7f52ccbe1fe7] > > /lib/libc.so.6(clone+0x6d)[0x7f52cbb822bd] > > > > Trying to get some variables. > > Some pointers may be invalid and cause the dump to abort. > > Query (0x7f5190884020): is an invalid pointer > > Connection ID (thread ID): 304 > > 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. > > > > > > -- > > Roberto Spadim > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-developers > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~maria-developers > > More help : https://help.launchpad.net/ListHelp > > -- > -- > Daniel Black, Engineer @ Open Query (http://openquery.com.au) > Remote expertise & maintenance for MySQL/MariaDB server environments. > -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
