pt-heartbeat --check should not write to the heartbeat table
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Undecided
|
Unassigned |
Bug Description
% pt-heartbeat --host localhost -D heartbeat --check
DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement "INSERT INTO `heartbeat`
pt-heartbeat still tries to write to the table when --check-read-only is added
% pt-heartbeat --host localhost -D heartbeat --check --check-read-only
DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement "INSERT INTO `heartbeat`
The same is true for --monitor
% pt-heartbeat --host localhost -D heartbeat --monitor
DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement "INSERT INTO `heartbeat` .`heartbeat` (server_id, ts) VALUES ('639407132', UTC_TIMESTAMP())"] at /usr/bin/ pt-heartbeat line 5953.
% pt-heartbeat --host localhost -D heartbeat --monitor --check-read-only
DBD::mysql::db do failed: The MySQL server is running with the --read-only option so it cannot execute this statement [for Statement "INSERT INTO `heartbeat` .`heartbeat` (server_id, ts) VALUES ('639407132', UTC_TIMESTAMP())"] at /usr/bin/ pt-heartbeat line 5953.