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

          Ascending order - Click to sort in descending order
          emiliojazz Emiliano Paterlini created issue -
          alice Alice Sherepa added a comment -

          Could you please add the test case to demonstrate the problem?

          alice Alice Sherepa added a comment - Could you please add the test case to demonstrate the problem?
          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 ]
          emiliojazz Emiliano Paterlini added a comment -

          Hello Alice,
          I attached two SQL files to this bug.
          The files represents two databases that I use in my system.
          You can import both of them in your MariaDB server to test.
          One database will be called "solaris_1_control" and the other "solaris_server"
          In "solaris_1_control" there is a stored procedure called "logic_procedure_1",
          it is very complex but basically do some sleeps and some updates on "solaris_1_control".
          After some hours of running (not always) the SLEEP functions inside the procedure starts to return
          much beforehand, approximately the wait time lasts 5 seconds (instead of some hours...).

          Please let me know, I think that maybe this can be a bug with the interpretation of the argument or
          with threads interruption...scratching my head

          emiliojazz Emiliano Paterlini added a comment - Hello Alice, I attached two SQL files to this bug. The files represents two databases that I use in my system. You can import both of them in your MariaDB server to test. One database will be called "solaris_1_control" and the other "solaris_server" In "solaris_1_control" there is a stored procedure called "logic_procedure_1", it is very complex but basically do some sleeps and some updates on "solaris_1_control". After some hours of running (not always) the SLEEP functions inside the procedure starts to return much beforehand, approximately the wait time lasts 5 seconds (instead of some hours...). Please let me know, I think that maybe this can be a bug with the interpretation of the argument or with threads interruption... scratching my head
          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.