Home > mailing lists

Re: infinite loop in an update statement - Mailing list pgsql-general

From	Greg Sabino Mullane
Subject	Re: infinite loop in an update statement
Date	September 11 18:29:40
Msg-id	CAKAnmmKyoo3WB1-j4gz8Si11OGcgSfCCVbu+N=rmzyBHJ8=GSQ@mail.gmail.com Whole thread Raw
In response to	Re: infinite loop in an update statement (Fabrice Chapuis <fabrice636861@gmail.com>)
List	pgsql-general

Tree view

On Wed, Sep 11, 2024 at 6:14 AM Fabrice Chapuis <fabrice636861@gmail.com> wrote:

status = active
wait event = NULL
wait event type = NULL

That seems quite unlikely. Perhaps you are seeing the pg_stat_activity query itself? Try this:

select state, now()-state_change, wait_event_type, wait_event, query

from pg_stat_activity where query ~ 'SELECT MIN' and pg_backend_pid() <> pid;

Cheers,

Greg

pgsql-general by date:

From: Pecsök Ján
Date: 11 September, 16:48:43
Subject: RE: Error:could not extend file " with FileFallocate(): No space left on device

From: Alvaro Herrera
Date: 11 September, 18:39:05
Subject: Re: Error:could not extend file " with FileFallocate(): No space left on device

Re: infinite loop in an update statement - Mailing list pgsql-general

Previous

Next