Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4856

SQL_ERROR_LOG shows 1146 errors which didnt appear in mysql client

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.3, 5.5.35
    • Fix Version/s: 5.5.38, 10.0.12
    • Component/s: None
    • Labels:

      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'

        Attachments

          Activity

            People

            • Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              f_razzoli Federico Razzoli
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: