maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

hi dnaie, problem solved with elena at jira, thanks

2015-06-23 20:02 GMT-03:00 Daniel Black <daniel.black@xxxxxxxxxxxxxxxx>:

>
>
> ----- On 24 Jun, 2015, at 1:33 AM, roberto roberto@xxxxxxxxxxxxx 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     : maria-developers@xxxxxxxxxxxxxxxxxxx
> > 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