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_2.sql
          125 kB
        2. test.sql
          701 kB

        Activity

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

          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.