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

Rows_sent: 6148914691236517205

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.11
    • None
    • None
    • None
    • CentOS 7

    Description

      I'm investigating some oddities in the slow query log on a client's server. I've come across this:

      1. Query_time: 649.534444 Lock_time: 0.000133 Rows_sent: 6148914691236517205 Rows_examined: 5263394
      2. Rows_affected: 0 Bytes_sent: 1154461212

      This oddly high Rows_sent value is happening over and over again within their logs.

      6148914691236517205 = 0x5555555555555555

      This looks to be some sort of either debug value or default initialization value that isn't being set properly before being read.

      Any thoughts? When I get more time later this afternoon, I'll try to filter out some stuff from the logs to hopefully share schema and query information (need to ensure no NDA stuff is shared)

      Attachments

        Activity

          People

            Unassigned Unassigned
            darkain Vincent Milum Jr
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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