|From:||Sandro Santilli <strk(at)keybit(dot)net>|
|Subject:||uninterruptable loop: concurrent delete in progress within table|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
The attached script shows a plpgsql function that enters
an infinite loop which is not interrupted by statement_timeout.
Looping message is:
WARNING: concurrent delete in progress within table "crash9", xid is 4458893, self is 4458894/4458889
CONTEXT: SQL statement "CREATE INDEX ON crash9 USING GIST ( the_geom)"
PL/pgSQL function crash(regclass) line 148 at EXECUTE statement
Note that the xid and self parts of the WARNING message were added by myself
on request by "andres" (on the freenode IRC channel).
I could reproduce with both 9.3.0 and 9.3.4 (current 9.3 stable branch).
Sounds like a PostgreSQL bug to me, what do you think ?
Is there anything I can do from the plpgsql function to workaround it ?
() ASCII ribbon campaign -- Keep it simple !
|Next Message||Alvaro Herrera||2014-05-30 14:43:27||Re: uninterruptable loop: concurrent delete in progress within table|
|Previous Message||Andres Freund||2014-05-30 13:32:44||Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts|