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
        • 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'

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                holyfoot Alexey Botchkov added a comment -

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

                Show
                holyfoot Alexey Botchkov added a comment - Proposed fix: http://lists.askmonty.org/pipermail/commits/2014-January/005843.html
                Hide
                Permalink
                holyfoot Alexey Botchkov added a comment -

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

                Show
                holyfoot Alexey Botchkov added a comment - New fix proposal: http://lists.askmonty.org/pipermail/commits/2014-January/005848.html
                Hide
                Permalink
                holyfoot Alexey Botchkov added a comment -

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

                Show
                holyfoot Alexey Botchkov added a comment - Yet another fix: http://lists.askmonty.org/pipermail/commits/2014-February/005931.html
                Hide
                Permalink
                holyfoot Alexey Botchkov added a comment -

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

                Show
                holyfoot Alexey Botchkov added a comment - Final fix: http://lists.askmonty.org/pipermail/commits/2014-April/006096.html

                  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:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 week, 3 days
                      1w 3d