Data base is MYSQL and enabled constraints while arching the data . archiving is going smooth and after some time getting error at some table
" DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement “SELECT …”" .
I increased the following mysql properties and tried but no luck getting same error,
connect_timeout=31536000;
interactive_timeout=31536000;
wait_timeout=31536000;
max_allowed_packet=1073741824;
DBD::mysql::st execute failed: Lost connection to MySQL server during query [for Statement "SELECT /*!40001 SQL_NO_CACHE */ …'] at /usr/bin/pt-archiver line 6773.
TIME ELAPSED COUNT
2018-07-12T03:49:24 0 0
2018-07-12T04:08:21 1136 1000
.
.
.
2018-07-12T04:09:54 1229 55000
2018-07-12T04:19:21 1797 56000
real 150m2.297s
user 0m4.776s
sys 0m1.296s
but no luck . can anybody help on this ? in advance i appreciate you.