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

reporting queries causing CS to use up significant memory until mariadb service restarts

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.2.3
    • Icebox
    • MariaDB Server
    • None

    Description

      Client is running large reports on the weekends (and occasionally during the week. Sometimes when these reports run, the columnstore instance appears to use up all available memory in the system and the mariadb instance shuts down with a sig 11 and restarts. Here is the stacktrace discovered:

      /usr/local/mariadb/columnstore/mysql//bin/mysqld(handle_fatal_signal+0x33f)[0x55987f6b06ff]
      /lib64/libpthread.so.0(+0xf5d0)[0x7f66903fb5d0]
      /usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_Z32ha_calpont_impl_write_batch_row_PhP5TABLERN11cal_impl_if19cal_connection_infoE+0x11e9)[0x7f6667d516b9]
      /usr/local/mariadb/columnstore/mysql/lib/plugin/libcalmysql.so(_Z25ha_calpont_impl_write_rowPhP5TABLE+0x1c8)[0x7f6667d2a948]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN7handler12ha_write_rowEPh+0x1a7)[0x55987f6bafd7]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x66)[0x55987f4d7f26]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN13select_insert9send_dataER4ListI4ItemE+0xe5)[0x55987f4d8aa5]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x5d40af)[0x55987f5490af]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x5b9917)[0x55987f52e917]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x17e)[0x55987f53827e]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN10exec_innerEv+0xa86)[0x55987f558856]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_ZN4JOIN4execEv+0x29)[0x55987f558a79]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1ce)[0x55987f558c8e]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1bb)[0x55987f55983b]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z21mysql_execute_commandP3THD+0x6c04)[0x55987f509154]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x1d2)[0x55987f509fa2]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z18idb_vtable_processP3THDyP9Statement+0x231a)[0x55987f50ceba]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x12c5)[0x55987f50e905]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z10do_commandP3THD+0xd8)[0x55987f50ff28]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(_Z11tp_callbackP13TP_connection+0xbf)[0x55987f60a8cf]
      /usr/local/mariadb/columnstore/mysql//bin/mysqld(+0x7137be)[0x55987f6887be]
      /lib64/libpthread.so.0(+0x7dd5)[0x7f66903f3dd5]
      /lib64/libc.so.6(clone+0x6d)[0x7f668e39fead]

      Attachments

        Activity

          People

            Unassigned Unassigned
            ivenn Isaac Venn
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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