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

DO SLEEP() incorrect evaluation when running procedure for long time

Details

    Description

      When running long stored procedures with lots of DO SLEEP() (with variable argument), randomly the evaluation of the argument produces incorrect results, effectively returning from the SLEEP function much beforehand the intented time.

      Attachments

        1. test.sql
          701 kB
        2. test_2.sql
          125 kB

        Activity

          Descending order - Click to sort in ascending order
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 99330 ] MariaDB v4 [ 141498 ]
          julien.fritsch Julien Fritsch made changes -
          Labels need_verification
          alice Alice Sherepa made changes -
          Labels need_feedback
          emiliojazz Emiliano Paterlini made changes -
          Attachment test_2.sql [ 48988 ]
          emiliojazz Emiliano Paterlini made changes -
          Attachment test.sql [ 48987 ]
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Labels need_feedback
          emiliojazz Emiliano Paterlini created issue -

          People

            Unassigned Unassigned
            emiliojazz Emiliano Paterlini
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.