Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-2504

LP #1704267: Spurious lock_wait_timeout_thread wakeup in lock_wait_suspend_thread()

    Details

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 18-07-2017 03:38:59

      This is a copy of https://bugs.mysql.com/bug.php?id=72123:

      "When a query thread has to wait on a rec or table lock it goes to sleep by calling lock_wait_suspend_thread(). In this function before starting the wait we do the following:

      /* Wake the lock timeout monitor thread, if it is suspended */

      os_event_set(lock_sys->timeout_event);

      This is totally unnecessary because lock timeout monitor thread wakes up every second to release waiting threads. There is no need to wake it up when we are going to start a wait."

      and

      "On a related note, there are various other wakeup calls for lock_monitor thread in the code. These calls are actually meant for srv_monitor_thread as they relate to printing monitor output and lock monitor has nothing to do with printing stuff."

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: