Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
3.2.0
-
None
-
None
-
Yes
-
2
Description
pt-heartbeat doesn't reconnect and exiting with rc=2 after killing connection. Similar to PT-1829.
Steps to reproduce:
non-root user
MySQL started with read_only=1
pt-heartbeat started as
pt-heartbeat --update --database=percona --host=127.0.0.1 --port=5534 --user=msandbox --password=msandbox --replace --check-read-only --no-version-check
After killing the connection pt-heatbeat will exit with exit code = 2
# pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds # pt_heartbeat:5969 19725 Sleeping for 1.0 seconds DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query [for Statement "SELECT @@global.read_only"] at ./pt line 6469.
