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

Impossible Values in Slow Log

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.5(EOL)
    • N/A
    • Server
    • None
    • Linux x86_64

    Description

      Slow query log ends up with impossible values in it:

      # Time: 700101  0:00:00
      # User@Host: scheduled[scheduled] @  [10.0.0.25]
      # Thread_id: 27991  Schema: scheduled  QC_hit: No
      # Query_time: 0.025318  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
      # Rows_affected: 0  Bytes_sent: 18446744073709448586
      SET timestamp=0;
      # administrator command: Change user;

      These is obviously bogus and impossible:

      • SET timestamp=0 == 1970-01-01 00:00:00
      • Bytes_sent: 18446744073709448586 (a little under unsigned 2^64)

      This wreaks havoc with some slow log analysis tools.

      Attachments

        Activity

          People

            Unassigned Unassigned
            gbobic Gordan Bobic
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.