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
|