Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6774

slow_query_log broken for Last_errno: filed in percona server 8.0

Details

    Description

      slow_query_log broken for Last_errno: filed in percona server 8.0

      Even though my query ran successfully on mysql client without any error or warning,  in the slow log it showing Last_errno: 3554

      Percona server 8.0.17

      mysql [localhost] {msandbox} ((none)) > SELECT                     SCHEMA_NAME as XYZTest                  FROM information_schema.schemata                   WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');
      +---------+
      | XYZTest |
      +---------+
      | sys     |
      | test    |
      | test1   |
      +---------+
      3 rows in set (0.01 sec)  
      
      
       # Time: 2020-01-14T12:46:31.378334Z
      # User@Host: msandbox[msandbox] @ localhost []  Id:     8
      # Schema:   Last_errno: 3554  Killed: 0
      # Query_time: 0.007943  Lock_time: 0.002580  Rows_sent: 3  Rows_examined: 13  Rows_affected: 0
      # Bytes_sent: 108
      SET timestamp=1579005991;
      SELECT                     SCHEMA_NAME as XYZTest                  FROM information_schema.schemata                   WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');

       

      It's working fine and as expected in percona server 5.7:

      Percona Server 5.7

       

      master [localhost] {msandbox} ((none)) > SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');
      +---------+
      | XYZTest |
      +---------+
      | sys |
      | test |
      +---------+
      2 rows in set (0.00 sec)
      
      # Time: 2020-01-14T15:05:36.041846Z
      # User@Host: msandbox[msandbox] @ localhost [] Id: 16
      # Schema: Last_errno: 0 Killed: 0
      # Query_time: 0.001092 Lock_time: 0.000432 Rows_sent: 2 Rows_examined: 5 Rows_affected: 0
      # Bytes_sent: 111
      SET timestamp=1579014336;
      SELECT SCHEMA_NAME as XYZTest FROM information_schema.schemata WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema');
      

       

       

      Attachments

        Issue Links

          Activity

            People

              oleksandr.kachan Oleksandr Kachan
              lalit.choudhary Lalit Choudhary
              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 - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours, 30 minutes
                  2h 30m

                  Smart Checklist