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

Insert cache - Got an insert cache crashed error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 6.2.1
    • Fix Version/s: Icebox
    • Component/s: DMLProc
    • Labels:
      None

      Description

      Build tests: 6.2.1-1 (#3379)

      The test was to LDI 5 million rows 5 times, with a "select count" query after each iteration. The idea to make sure the insert cache is flushed before the each LDI. After the 2nd LDI, I received the follow error

      ERROR 127 (HY000) at line 5: Table 'Got error while trying to flush insert cache: %d' is marked as crashed and should be repaired

      The table was not usable after. The only way to get around is to drop the table and recreate it again.

      I could not reproduce the error on purpose again.

      What is the appropriate course of action when this error occurs? What and how should be repaired?

      [centos8:root~]# mysql mytest -vvv < t2.sql 
      --------------
      show variables like "%columnstore_cache%"
      --------------
       
      +-----------------------------------+--------+
      | Variable_name                     | Value  |
      +-----------------------------------+--------+
      | columnstore_cache_flush_threshold | 500000 |
      | columnstore_cache_inserts         | ON     |
      | columnstore_cache_use_import      | OFF    |
      +-----------------------------------+--------+
      3 rows in set (0.001 sec)
       
      --------------
      load data infile '/tmp/orders.tbl' into table orders fields terminated by "|"
      --------------
       
      Query OK, 5000000 rows affected (9.953 sec)
      Records: 5000000  Deleted: 0  Skipped: 0  Warnings: 0
       
      --------------
      select count(*) from orders
      --------------
       
      +----------+
      | count(*) |
      +----------+
      |  5000000 |
      +----------+
      1 row in set (2 min 46.348 sec)
       
      --------------
      load data infile '/tmp/orders.tbl' into table orders fields terminated by "|"
      --------------
       
      Query OK, 5000000 rows affected (9.537 sec)
      Records: 5000000  Deleted: 0  Skipped: 0  Warnings: 0
       
      --------------
      select count(*) from orders
      --------------
       
      ERROR 127 (HY000) at line 5: Table 'Got error while trying to flush insert cache: %d' is marked as crashed and should be repaired
      Bye
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              tntnatbry Gagan Goel
              Reporter:
              dleeyh Daniel Lee
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.