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

Insert cache - Got an insert cache crashed error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 6.2.1
    • Icebox
    • DMLProc
    • 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

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