pt-query-digest does not reconnect to MySQL when connection is lost
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Triaged
|
Undecided
|
Unassigned |
Bug Description
When running with large slow log files and the server timedout or got disconnected somewhere along the way i.e. restarted, ptqd does not attempt to reconnect. For the purpose of testing I run ptqd on one session and killed mysql on the other.
<session #1>
[revin@forge msb_5_5_25]$ pt-query-digest --version
pt-query-digest 2.1.2
[revin@forge msb_5_5_25]$ pt-query-digest --review h=localhost,
/wok/dta/
...
...
/wok/dta/
/wok/dta/
/wok/dta/
Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT `first_seen`, `last_seen`, `reviewed_by`, `reviewed_on`, `comments`, CONV(checksum, 10, 16) AS checksum_conv FROM `percona`.`ptqd_r` WHERE checksum=CONV(?, 16, 10)" with ParamValues: 0='0EE57D0F76A9
Will retry pipeline process 4 (iteration) 2 more times.
Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT `first_seen`, `last_seen`, `reviewed_by`, `reviewed_on`, `comments`, CONV(checksum, 10, 16) AS checksum_conv FROM `percona`.`ptqd_r` WHERE checksum=CONV(?, 16, 10)" with ParamValues: 0='0EE57D0F76A9
Will retry pipeline process 4 (iteration) 1 more time.
Pipeline process 2 (input) caused an error: tell() on closed filehandle at /home/revin/
The pipeline caused an error: Pipeline process 5 (iteration) caused an error: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT `first_seen`, `last_seen`, `reviewed_by`, `reviewed_on`, `comments`, CONV(checksum, 10, 16) AS checksum_conv FROM `percona`.`ptqd_r` WHERE checksum=CONV(?, 16, 10)" with ParamValues: 0='0EE57D0F76A9
Terminating pipeline because process 4 (iteration) caused too many errors.
[revin@forge msb_5_5_25]$ ^C
[revin@forge msb_5_5_25]$
<session #2>
[revin@forge share]$ cd ~
[revin@forge ~]$ ps aux|grep 5_5_25
revin 9606 0.0 0.2 488552 40504 ? Sl 01:43 0:00 /wok/bin/
revin 9653 0.0 0.0 103340 1024 pts/33 S+ 01:46 0:00 grep 5_5_25
revin 31225 0.0 0.0 106328 1552 ? S Jun25 0:00 /bin/sh /wok/bin/
[revin@forge ~]$ kill -9 9606
[revin@forge ~]$
tags: | added: connection pt-query-digest |
Changed in percona-toolkit: | |
status: | New → Triaged |
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
Changed in percona-toolkit: | |
assignee: | Brian Fraser (fraserbn) → nobody |
Similar behavior to https:/ /bugs.launchpad .net/percona- toolkit/ +bug/941469