[MDEV-20832] Don't print "row size too large" warnings in error log if innodb_strict_mode=OFF and log_warnings<=2 Created: 2019-10-15 Updated: 2020-08-25 Resolved: 2019-11-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.2.27, 10.3.18, 10.4.8 |
| Fix Version/s: | 10.2.30, 10.3.21, 10.4.11 |
| Type: | Bug | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Eugene Kosov (Inactive) |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||||||
| Description |
|
If a user executes DDL that effects a table which has too large rows, then the error log will contain a message like the following:
(I believe the specific message may change in the patch for With the default value of innodb_strict_mode=ON, it will be an error. If the user sets innodb_strict_mode=OFF, then it will be a warning. https://mariadb.com/kb/en/library/troubleshooting-row-size-too-large-errors-with-innodb/ Some users think that it should be possible to suppress this warning in the error log if the user sets innodb_strict_mode=OFF. By default, log_warnings is set to 2. https://mariadb.com/kb/en/library/server-system-variables/#log_warnings Maybe this warning should only be printed when innodb_strict_mode=OFF if log_warnings > 2, so that it doesn't get printed to the error log by default. |