Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.8
-
None
Description
my mariadb version :5.5.5-10.2.8
backend db:mysql-5.7.19
I used the spider engine to create eight db, 8 tables, partition type hash. When I import a billion data to a table, the implementation of select count (*) from history; will be an error. The error message is as follows:
mysql> select count (*) from history; |
ERROR 2013 (HY000): Lost connection to MySQL server during query |
Backend db mysql log
2017-09-19T19: 35: 45.405795Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4218ms. The settings might not be optimal. (Flushed = 1630 and evicted = 0, during the time.)
|
2017-09-19T19: 47: 35.882019Z 0 [Note] InnoDB: page_cleaner: 1000ms deploy loop took 5312ms. The settings might not be optimal. (Flushed = 200 and evicted = 0, during the time.)
|
2017-09-19T19: 47: 53.736353Z 0 [Note] InnoDB: page_cleaner: 1000ms deploy rack took 13651ms. The settings might not be optimal. (Flushed = 1017 and evicted = 0, during the time.)
|
2017-09-20T01: 16: 07.534076Z 507 [Note] Aborted connection 507 to db: 'bsbackend4' user: 'spider' host: 'localhost' (Got an error reading communication packets)
|
2017-09-20T01: 16: 07.534114Z 433 [Note] Aborted connection 433 to db: 'bsbackend4' user: 'spider' host: 'localhost' (Got an error reading communication packets)
|
2017-09-20T01: 28: 34.177313Z 508 [Note] Aborted connection 508 to db: 'bsbackend4' user: 'spider' host: 'localhost' (Got an error reading communication packets)
|
How to deal with this problem, thank you