Bug #90678 | dragnet logging: Document the fact that multi-line rules work | ||
---|---|---|---|
Submitted: | 29 Apr 2018 7:45 | Modified: | 20 Jun 2018 5:37 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S4 (Feature request) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | dragnet, logging |
[29 Apr 2018 7:45]
Simon Mudd
[29 Apr 2018 8:15]
Simon Mudd
Adjust synopsis
[19 Jun 2018 15:17]
Paul DuBois
Posted by developer: This is fragile. For example, it doesn't work in my.cnf files. [mysqld] dragnet.log_error_filter_rules= ' IF prio>=INFORMATION THEN drop. IF EXISTS source_line THEN unset source_line.' 2018-05-10T16:41:35.606869Z 0 [ERROR] [MY-013111] [Server] Variable 'dragnet.log_error_filter_rules' can't be set to the value of ''' 2018-05-10T16:41:35.606904Z 0 [Warning] [MY-011261] [Server] The log-filter component "dragnet" got confused at "'" (state: getting first token ...) ... 2018-05-10T16:41:35.607467Z 0 [ERROR] [MY-011071] [Server] unknown variable 'IF prio>=INFORMATION THEN drop.'
[20 Jun 2018 5:37]
Simon Mudd
Paul, I did not say that this would work from /etc/my.cnf so suggesting that is fragile I think is not appropriate. I think this probably would work for the new persistent storage configuration settings (potentially) as that uses JSON. In any case I expect to have several rules in my filters. Using a single line will make those rules really hard to read and follow which is why I suggested that you accept this from the command line (SQL interface) even if you can nnot use it from /etc/my.cnf.