Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10273

mariadb server crashes after CONNECT engine operation

    XMLWordPrintable

Details

    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.
      
      

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.