[MDEV-4856] SQL_ERROR_LOG shows 1146 errors which didnt appear in mysql client Created: 2013-08-08  Updated: 2014-04-15  Resolved: 2014-04-15

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3, 5.5.35
Fix Version/s: 5.5.38, 10.0.12

Type: Bug Priority: Major
Reporter: Federico Razzoli Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: audit


 Description   

With SQL_ERROR_LOGS plugin activated, 1146 errors appear in sql_errors.log (but NOT in the client) when I query INFORMATION_SCHEMA.TABLES, VIEWS or COLUMNS and the results are empty.

In the client:

MariaDB [(none)]> SELECT `TABLE_NAME` FROM `information_schema`.`TABLES` WHERE `
 
TABLE_SCHEMA` = 'not_exists' AND `TABLE_NAME` = 'not_exists';
 
Empty set (0.18 sec)
 
 
 
MariaDB [(none)]> SHOW WARNINGS;
 
Empty set (0.02 sec)
 
 
 
MariaDB [(none)]>

In sql_error.log:

2013-08-08 11:58:42 root[root] @ localhost [127.0.0.1] ERROR 1146: Table 'not_exists.not_exists' doesn't exist : SELECT `TABLE_NAME` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'not_exists' AND `TABLE_NAME` = 'not_exists'



 Comments   
Comment by Alexey Botchkov [ 2014-01-30 ]

Proposed fix:
http://lists.askmonty.org/pipermail/commits/2014-January/005843.html

Comment by Alexey Botchkov [ 2014-01-31 ]

New fix proposal:
http://lists.askmonty.org/pipermail/commits/2014-January/005848.html

Comment by Alexey Botchkov [ 2014-02-22 ]

Yet another fix:
http://lists.askmonty.org/pipermail/commits/2014-February/005931.html

Comment by Alexey Botchkov [ 2014-04-15 ]

Final fix:
http://lists.askmonty.org/pipermail/commits/2014-April/006096.html

Generated at Thu Feb 08 06:59:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.