From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Marshall, Steve" <smarshall(at)wsi(dot)com> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: PL/TCL Patch to prevent postgres from becoming multithreaded |
Date: | 2007-09-21 00:32:57 |
Message-ID: | 17334.1190334777@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
"Marshall, Steve" <smarshall(at)wsi(dot)com> writes:
> There is a problem in PL/TCL that can cause the postgres backend to
> become multithreaded. Postgres is not designed to be multithreaded, so
> this causes downstream errors in signal handling. We have seen this
> cause a number of "unexpected state" errors associated with notification
> handling; however, unpredictable signal handling would be likely to
> cause other errors as well.
I've applied this patch to CVS HEAD (8.3-to-be). I'm a bit hesitant
to back-patch it however, at least not till it gets through some beta
testing.
Thanks for the detailed explanation, test case, and patch!
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2007-09-21 00:34:32 | Re: stored procedure stats in collector |
Previous Message | Tom Raney | 2007-09-21 00:12:45 | Re: Hash index todo list item |
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-09-21 00:42:10 | Patch to update log levels |
Previous Message | Andrew Dunstan | 2007-09-20 19:11:51 | Re: Various fixes for syslogger |