[MDEV-6652] Improve Error Logging in SHOW SLAVE STATUS Output and for "Specified key was too long" case Created: 2014-08-28 Updated: 2015-10-30 |
|
| Status: | Stalled |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Chris Calender (Inactive) | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | None | ||
| Description |
|
This is a request to improve the error logging in SHOW SLAVE STATUS output. Specifically, the "Last_Error" and "Last_SQL_Error" have a size limit. So the first request is to extend the size of this. Depending on the error, the relevant part may be omitted, and thus hard to track down. Consider error 1071 (specified key is too long). If there a multiple keys, and the table definition is too long, then you don't even see any of the keys, such as the below: Replicate_Wild_Ignore_Table: Second, perhaps for the case of error 1071, the actual offending key could be listed. That would be much improved, and make trouble-shooting a breeze. For instance, something like "key ….. ( a, b, c ) was too long" would be ideal. |
| Comments |
| Comment by Sergei Golubchik [ 2014-09-10 ] |
|
backward incompatible changes to the errmsg.sys files — it's safer to do it in 10.1 |
| Comment by Sergei Golubchik [ 2014-09-10 ] |
|
Similarly many other error messages could be extended to include the key name |