[MDEV-11844] Useless or duplicate error messages on log_warnings level 2 Created: 2017-01-19 Updated: 2017-01-19 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication, Server |
| Affects Version/s: | 5.5, 10.0, 10.1, 10.2 |
| Fix Version/s: | 10.2 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Description |
|
On level log_warnings=2 server can produce these error messages:
I know it to happen when a slave doesn't find records referenced in a row event; not sure if there are other scenarios when it's produced. It is an ERROR, which assumes the user is expected to do something about it, but the message itself is useless – it doesn't specify the query or even that caused it, or the record that wasn't found, or the connection that caused the error, or the action that can be taken. When it comes with replication, the slave would also produce an error (or warning, depending on slave_exec_mode ). This message contains more information and can be used to identify the problem:
Thus, at least in replication scenario the error is redundant. Since in 10.2 we are switching to log_warnings=2 by default, there will be many more users to encounter these messages and raise questions about them. So, I think it might be a good time to sort them out:
Same is true for
This message exists on level 1, I suppose it's not needed on level 2:
|
| Comments |
| Comment by Elena Stepanova [ 2017-01-19 ] | |
|
Here is an example of a helpful message, also produced on the level 2:
|