Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-50

mysql crash right after a startsystem completed - At least one DBRoot required for that query is offline

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • None
    • 1.0.0
    • ?
    • None
    • centos 6.4 regression test vm
    • MCOL Sprint 2 - Priority 2

    Description

      Nightly regression test log showed a lot of query failures.

      Log file showed the reason as :

      crit.log-20160510:May 9 21:10:51 srvregtest joblist[17423]: 51.234265 |2147483653|0|0| C 05 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.

      Logs files showed that a startsystem just completed and mysql crashed right after the system went active.

      debug.log-20160510:May 9 21:10:50 srvregtest ProcessManager[14143]: 50.030447 |0|0|0| D 17 CAL0000: Set System State = ACTIVE
      debug.log-20160510:May 9 21:10:50 srvregtest ProcessMonitor[14051]: 50.030996 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set System State = ACTIVE
      debug.log-20160510:May 9 21:10:50 srvregtest ProcessManager[14143]: 50.060952 |0|0|0| D 17 CAL0000: startSystemThread Exit
      debug.log-20160510:May 9 21:10:50 srvregtest ProcessMonitor[14051]: 50.348887 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Process pm1/mysqld State = MAN_OFFLINE
      debug.log-20160510:May 9 21:10:50 srvregtest ProcessMonitor[14051]: 50.349033 |0|0|0| D 18 CAL0000: statusControl: Set Process pm1/mysqld State = MAN_OFFLINE PID = 0
      debug.log-20160510:May 9 21:10:50 srvregtest ProcessMonitor[14051]: 50.350594 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Module pm1 State = DEGRADED
      debug.log-20160510:May 9 21:10:51 srvregtest ExeMgr[17423]: 51.073112 |2147483653|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpch1c' and tablename='datatypetestm' --columnRIDs/FE; ||

      crit.log-20160510:May 9 21:10:51 srvregtest joblist[17423]: 51.234265 |2147483653|0|0| C 05 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.
      crit.log-20160510:May 9 21:10:51 srvregtest joblist[17423]: 51.234535 |2147483653|0|0| C 05 CAL0000: IDB-2034: At least one DBRoot required for that query is offline.

      Server version: 10.1.10-MariaDB
      key_buffer_size=536870912
      read_buffer_size=4194304
      max_used_connections=2
      max_threads=153
      thread_count=1
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1780770 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.

      Thread pointer: 0x0x7f15baf95798
      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 = 0x7f15796c6d98 thread_stack 0x80000
      /usr/local/Calpont/mysql//sbin/mysqld(my_print_stacktrace+0x26)[0x7f15b7b4c9c6]
      /usr/local/Calpont/mysql//sbin/mysqld(handle_fatal_signal+0x465)[0x7f15b772cce5]
      /lib64/libpthread.so.0(+0x3c0dc0f500)[0x7f15b6d82500]
      /lib64/libc.so.6(strnlen+0x21)[0x7f15b5209451]
      /usr/local/Calpont/mysql//sbin/mysqld(+0x9ced77)[0x7f15b7b80d77]
      /usr/local/Calpont/mysql//sbin/mysqld(my_vsnprintf_ex+0x182)[0x7f15b7b81822]
      /usr/local/Calpont/mysql//sbin/mysqld(_ZN3THD18raise_error_printfEjz+0xd4)[0x7f15b75b1c54]
      /usr/local/Calpont/mysql/lib64/mysql/plugin/libcalmysql.so(_ZN11cal_impl_if8setErrorEP3THDjSs+0x53)[0x7f15b2eea1f3]
      /usr/local/Calpont/mysql/lib64/mysql/plugin/libcalmysql.so(_Z24ha_calpont_impl_rnd_initP5TABLE+0x5b53)[0x7f15b2ebdbe3]
      /usr/local/Calpont/mysql//sbin/mysqld(_ZN7handler22ha_rnd_init_with_errorEb+0x15)[0x7f15b7732265]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z16init_read_recordP11READ_RECORDP3THDP5TABLEP10SQL_SELECTibb+0x3e5)[0x7f15b7817425]
      /usr/local/Calpont/mysql//sbin/mysqld(Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_ordery15enum_duplicatesbPySB+0xc6f)[0x7f15b766b56f]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z21mysql_execute_commandP3THD+0x44c5)[0x7f15b75e03b5]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x23e)[0x7f15b75e313e]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1c7e)[0x7f15b75e831e]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z10do_commandP3THD+0xed)[0x7f15b75e85bd]
      /usr/local/Calpont/mysql//sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x18a)[0x7f15b769a9da]
      /usr/local/Calpont/mysql//sbin/mysqld(handle_one_connection+0x46)[0x7f15b769aab6]
      /lib64/libpthread.so.0(+0x3c0dc07851)[0x7f15b6d7a851]
      /lib64/libc.so.6(clone+0x6d)[0x7f15b527094d]

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.