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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.1
    • Fix Version/s: None
    • Component/s: Stored routines
    • Labels:
      None
    • Environment:
      Linux

      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

            People

            Assignee:
            Unassigned
            Reporter:
            emiliojazz Emiliano Paterlini
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: