[MDEV-20786] MariaDB server writes warnings into errorlog although 'log_warnings=0' Created: 2019-10-09 Updated: 2020-05-16 Resolved: 2019-12-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation, Storage Engine - InnoDB |
| Affects Version/s: | 10.3.18 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Michael Graf | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 7 |
||
| Attachments: |
|
||||||||||||||||||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||
| Description |
|
The global variable is set to log_warnings=0. If the following SQL statement is executed a warning is still written into the errorlog:
The MariaDB documentation says to log_warning = 0:
https://mariadb.com/kb/en/library/error-log/#verbosity-level-0 https://mariadb.com/kb/en/library/server-system-variables/#log_warnings |
| Comments |
| Comment by Elena Stepanova [ 2019-10-12 ] | ||||||
|
What warning are you getting? I'm not getting any, regardless log_warnings. | ||||||
| Comment by Michael Graf [ 2019-10-14 ] | ||||||
|
>What warning are you getting? In the attachment is errorlog of the last 20 minutes to show you how many warnings are written since 10.3.x into the errorlog. | ||||||
| Comment by Geoff Montee (Inactive) [ 2019-10-15 ] | ||||||
This was an inaccuracy in the documentation that has already been fixed. I've requested a way to suppress those warnings in the error log in In the mean time, you can already suppress these warnings if you are willing to fix the tables involved. You may be able to do so by converting them to the DYNAMIC row format and by making sure that all varchar columns are at least as long as 256 bytes. See the following page for details: https://mariadb.com/kb/en/library/troubleshooting-row-size-too-large-errors-with-innodb/ | ||||||
| Comment by Geoff Montee (Inactive) [ 2019-10-15 ] | ||||||
|
For the case of the test_pending table schema in the issue description, it is sufficient to convert the table to the DYNAMIC row format. For example:
You may want to try the same fix for other affected tables as well. For example:
| ||||||
| Comment by Geoff Montee (Inactive) [ 2019-11-04 ] | ||||||
|
These warnings can be inappropriately logged due to | ||||||
| Comment by Sergei Golubchik [ 2019-12-09 ] | ||||||
|
It was a incorrect documentation that was fixed. |