Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.1.10, 10.1.14
-
CentOS7 image on Google Compute Engine
Description
MariaDB server crashes at times, apparently with root cause somewhere in the CONNECT engine. Log info below:
 |
Jun 22 09:13:24 si-mariadb-3 mysqld: 160622 9:13:24 [ERROR] mysqld got signal 7 ; |
Jun 22 09:13:24 si-mariadb-3 mysqld: This could be because you hit a bug. It is also possible that this binary |
Jun 22 09:13:24 si-mariadb-3 mysqld: or one of the libraries it was linked against is corrupt, improperly built, |
Jun 22 09:13:24 si-mariadb-3 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. |
Jun 22 09:13:24 si-mariadb-3 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs |
Jun 22 09:13:24 si-mariadb-3 mysqld: We will try our best to scrape up some info that will hopefully help |
Jun 22 09:13:24 si-mariadb-3 mysqld: diagnose the problem, but since we have already crashed, |
Jun 22 09:13:24 si-mariadb-3 mysqld: something is definitely wrong and this may fail. |
Jun 22 09:13:24 si-mariadb-3 mysqld: Server version: 10.1.10-MariaDB-log |
Jun 22 09:13:24 si-mariadb-3 mysqld: key_buffer_size=134217728 |
Jun 22 09:13:24 si-mariadb-3 mysqld: read_buffer_size=131072 |
Jun 22 09:13:24 si-mariadb-3 mysqld: max_used_connections=2 |
Jun 22 09:13:24 si-mariadb-3 mysqld: max_threads=153 |
Jun 22 09:13:24 si-mariadb-3 mysqld: thread_count=2 |
Jun 22 09:13:24 si-mariadb-3 mysqld: It is possible that mysqld could use up to |
Jun 22 09:13:24 si-mariadb-3 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467105 K bytes of memory |
Jun 22 09:13:24 si-mariadb-3 mysqld: Hope that's ok; if not, decrease some variables in the equation. |
Jun 22 09:13:24 si-mariadb-3 mysqld: Thread pointer: 0x0x7fcda8f5b008 |
Jun 22 09:13:24 si-mariadb-3 mysqld: Attempting backtrace. You can use the following information to find out |
Jun 22 09:13:24 si-mariadb-3 mysqld: where mysqld died. If you see no messages after this, something went |
Jun 22 09:13:24 si-mariadb-3 mysqld: terribly wrong... |
Jun 22 09:13:24 si-mariadb-3 mysqld: stack_bottom = 0x7fce39146d30 thread_stack 0x48000 |
Jun 22 09:13:24 si-mariadb-3 mysqld: mysys/stacktrace.c:247(my_print_stacktrace)[0x7fce39d4736e] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/signal_handler.cc:160(handle_fatal_signal)[0x7fce398756ad] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libpthread.so.0(+0xf100)[0x7fce38e97100] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libodbc.so.2(+0xc3cc)[0x7fce2ae3b3cc] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libodbc.so.2(+0xc7b9)[0x7fce2ae3b7b9] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libodbc.so.2(+0xec28)[0x7fce2ae3dc28] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libodbc.so.2(SQLDriverConnect+0x88b)[0x7fce2ae4273b] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_ZN7ODBConn13DriverConnectEj+0x5c)[0x7fce339ac57c] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_ZN7ODBConn4OpenEPcP10odbc_parmsj+0x58)[0x7fce339ac648] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_ZN7TDBODBC6OpenDBEP7_global+0x66)[0x7fce339a7b86] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_Z12CntOpenTableP7_globalP3TDB4MODEPcS4_bP10ha_connect+0x3bd)[0x7fce33920fed] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_ZN10ha_connect9OpenTableEP7_globalb+0x1ac)[0x7fce33914a4c] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /usr/lib64/mysql/plugin/ha_connect.so(_ZN10ha_connect8rnd_initEb+0x1d6)[0x7fce33915196] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/handler.h:2768(handler::ha_rnd_init(bool))[0x7fce3987b067] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/records.cc:281(init_read_record(READ_RECORD*, THD*, TABLE*, SQL_SELECT*, int, bool, bool))[0x7fce3997ca36] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:19179(join_init_read_record(st_join_table*))[0x7fce3972f150] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_join_cache.cc:2255(JOIN_CACHE::join_matching_records(bool))[0x7fce397ed8e6] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_join_cache.cc:2093(JOIN_CACHE::join_records(bool))[0x7fce397ed3f4] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:18064(sub_select_cache(JOIN*, st_join_table*, bool))[0x7fce3972f7ea] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:17939(do_select)[0x7fce3973cdee] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:2773(JOIN::exec_inner())[0x7fce3974ca26] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:2519(JOIN::exec())[0x7fce3974ed54] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:3453(mysql_select(THD*, Item***, 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*))[0x7fce3974b3f2] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_select.cc:384(handle_select(THD*, LEX*, select_result*, unsigned long))[0x7fce3974bed5] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_parse.cc:5903(execute_sqlcom_select)[0x7fce396ee9b1] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_parse.cc:2961(mysql_execute_command(THD*))[0x7fce396fac31] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_prepare.cc:4019(Prepared_statement::execute(String*, bool))[0x7fce397113f6] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_prepare.cc:3650(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x7fce39711563] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_prepare.cc:2730(mysqld_stmt_execute(THD*, char*, unsigned int))[0x7fce39711a5e] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_parse.cc:1431(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x7fce39700627] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_parse.cc:1111(do_command(THD*))[0x7fce397020a9] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_connect.cc:1349(do_handle_one_connection(THD*))[0x7fce397c4dda] |
Jun 22 09:13:24 si-mariadb-3 mysqld: sql/sql_connect.cc:1263(handle_one_connection)[0x7fce397c4fb0] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libpthread.so.0(+0x7dc5)[0x7fce38e8fdc5] |
Jun 22 09:13:24 si-mariadb-3 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fce372b321d] |
Jun 22 09:13:24 si-mariadb-3 mysqld: Trying to get some variables. |
Jun 22 09:13:24 si-mariadb-3 mysqld: Some pointers may be invalid and cause the dump to abort. |
Jun 22 09:13:24 si-mariadb-3 mysqld: Query (0x7fcdadbf8468): SELECT `SiteVisits`.`SiteVisit_ID`, `SiteVisits`.`VisitType`, `SiteVisits`.`VisitStatus`, `SiteVisits`.`Account_ID`, `SiteVisits`.`Location_ID`, `rmt_Account`.`Name`, `rmt_Account`.`IsDeleted`, `SiteVisits`.`EndTime`, `SiteVisits`.`LeadEngineer_ID`, `SiteVisits`.`OtherEngineers_ID`, `SiteVisits`.`Contact_ID`, `SiteVisits`.`Owner_ID`, `SiteVisits`.`ServiceDeskEngineer_ID`, `SiteVisits`.`CustomerContactName`, `SiteVisits`.`CustomerContactMobile`, `rmt_Account`.`Id`, `SiteVisits`.`VisitDate`, `SiteVisits`.`StartTime`, `rmt_Account`.`BillingStreet`, `rmt_Account`.`BillingCity`, `rmt_Account`.`BillingCountry`, `rmt_Account`.`Phone`, `rmt_Account`.`OwnerId`, `rmt_Account`.`Principle_Contact__c`, `rmt_Account`.`Principle_Contact_Title__c`, `SiteVisitEngineers`.`SiteVisitEngineer_ID`, `SiteVisitEngineers`.`Mobile`, `SiteVisitEngineers`.`Email`, `SiteVisitEngineers`.`Active` FROM `SiteVisits` LEFT JOIN `rmt_Account` ON ( `rmt_Account`.`Id` = `SiteVisits`.`Account_ID` ) LEFT JOIN `SiteVisitEngineers` ON ( `SiteVisitEngineers`.`SiteVisitEngineer_ID` = `SiteVisits`.`LeadEngineer_ID` ) WHERE ( ( `SiteVisitEngineers`.`Email` = 'hutzeflutz@gmail.com' AND `SiteVisits`.`VisitStatus` = 'Open' ) AND ( TRUE ) ) ORDER BY `SiteVisits`.`VisitDate` ASC LIMIT 0,50 |
Jun 22 09:13:24 si-mariadb-3 mysqld: Connection ID (thread ID): 1292 |
Jun 22 09:13:24 si-mariadb-3 mysqld: Status: NOT_KILLED |
Jun 22 09:13:24 si-mariadb-3 mysqld: 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 |
Jun 22 09:13:24 si-mariadb-3 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains |
Jun 22 09:13:24 si-mariadb-3 mysqld: information that should help you find out what is causing the crash. |
|