The tool doesn't show any error if it can't connect to MySQL
Bug #1070824 reported by
Miguel Angel Nieto
This bug affects 4 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MOVED - Percona Playback |
Fix Released
|
High
|
Vlad Lesin | ||
Bug Description
If the user provides bad connection information (user, password, port, host) the tool doesn't show any error messages when trying to connect. It just shows error when trying to run all the queries:
Connection 39 Rows Sent: 0 != expected 1 for query: use sbtest;
Connection 39 Rows Sent: 0 != expected 1 for query: SHOW TABLE STATUS LIKE 'sbtest';
etc.
The tool should show an error message like "Unable to connect to the server" instead of trying to run queries against "nothing".
| Changed in percona-playback: | |
| importance: | Undecided → High |
| status: | New → Triaged |
Revision history for this message
| Gavin Towey (gtowey) wrote | #1 |
| Changed in percona-playback: | |
| status: | Triaged → Confirmed |
| Changed in percona-playback: | |
| status: | Confirmed → Triaged |
| Changed in percona-playback: | |
| status: | Triaged → Fix Committed |
| assignee: | nobody → Vlad Lesin (vlad-lesin) |
| milestone: | none → 0.6 |
| Changed in percona-playback: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Not only does it not show connection errors, when there is a error running the query of any sort, it doesn't show the error code or message. This makes troubleshooting difficult.
For example, I'm running percona-playback and seeing pretty high throughput of queries (about 5k/s) and that will continue for about 10 seconds or so, but then the throughput will drop to zero or close to it for a period of about 10 seconds, then I'll get high throughput again.
The results will report a lot of errors, but it's not clear if they are related to the inconsistant qps behavior. More information would help me determine that.