Not the answer you need?
Register and ask your own question!

Mysql data archiving with percona getting Lost connection to MySQL server

sreenu1430sreenu1430 EntrantCurrent User Role Beginner
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.

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    What pt-archiver version do you use? Can you show the archived table definition?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.