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

query start_time not reset when going to sleep.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.3, 5.5.31
    • 10.0.4, 5.5.32
    • None
    • None

    Description

      After executing a query when entering sleep the start time is not reset. So processlist show the time since the last query started not since the start of the sleep.

      Attachments

        1. fix-sleep.patch
          2 kB
          Alex Light
        2. fix-sleep.patch
          2 kB
          Alex Light

        Activity

          Ascending order - Click to sort in descending order
          allight Alex Light added a comment -

          a fix

          allight Alex Light added a comment - a fix
          allight Alex Light added a comment -

          updated patch to remove unnessecary second call to set_time

          allight Alex Light added a comment - updated patch to remove unnessecary second call to set_time
          jeremycole Jeremy Cole added a comment -

          This is a pretty good bug and seems to have existed for a very very long time. It does not seem to affect wait_timeout as that is set completely separately as part of vio. This would primarily affect DBAs (visibility) and idle-connection killers that many sites have deployed.

          jeremycole Jeremy Cole added a comment - This is a pretty good bug and seems to have existed for a very very long time. It does not seem to affect wait_timeout as that is set completely separately as part of vio. This would primarily affect DBAs (visibility) and idle-connection killers that many sites have deployed.
          allight Alex Light added a comment -

          final version of the patch. Does this look right to all of you?

          allight Alex Light added a comment - final version of the patch. Does this look right to all of you?

          People

            serg Sergei Golubchik
            allight Alex Light
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.