Fix bug of clearing of waitStart in ProcWakeup() - Mailing list pgsql-hackers

From Chao Li
Subject Fix bug of clearing of waitStart in ProcWakeup()
Date
Msg-id 537BD852-EC61-4D25-AB55-BE8BE46D07D7@gmail.com
Whole thread Raw
Responses Re: Fix bug of clearing of waitStart in ProcWakeup()
List pgsql-hackers
Hi,

I just noticed this while reviewing patch [1]. It looks like this is caused by a simple typo.

In ProcWakeup():
```
PGPROC *
ProcWakeup(PGPROC *proc, ProcWaitStatus waitStatus)
{
    PGPROC       *retProc;

    /* Proc should be sleeping ... */
    if (proc->links.prev == NULL ||
        proc->links.next == NULL)
        return NULL;
    Assert(proc->waitStatus == PROC_WAIT_STATUS_WAITING);

    /* Save next process before we zap the list link */
    retProc = (PGPROC *) proc->links.next;

    /* Remove process from wait queue */
    SHMQueueDelete(&(proc->links));
    (proc->waitLock->waitProcs.size)--;

    /* Clean up process' state and pass it the ok/fail signal */
    proc->waitLock = NULL;
    proc->waitProcLock = NULL;
    proc->waitStatus = waitStatus;
    pg_atomic_write_u64(&MyProc->waitStart, 0); <== Here, it should operate on proc

    /* And awaken it */
    SetLatch(&proc->procLatch);

    return retProc;
}
```

Since this function is clearly operating on the parameter proc, the only statement that touches MyProc looks
suspicious.It should reset proc->waitStart, not MyProc->waitStart. 

As written, it will incorrectly clear the caller’s waitStart instead of the awakened backend’s, potentially leaving a
stalewaitStart value in the target PGPROC. 

[1] https://postgr.es/m/CAHGQGwGw4LhNwOGQT3nbw3uWy8gL94_MB4T39Wfr4_Vgopuovg@mail.gmail.com

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/







pgsql-hackers by date:

Previous
From: "Daniel Westermann (DWE)"
Date:
Subject: Re: 2026-02-26 release announcement draft
Next
From: Shinya Kato
Date:
Subject: pg_stat_replication.*_lag sometimes shows NULL during active replication