| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Pete Leonard <pete(at)hero(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: sick DB - ?? |
| Date: | 2001-07-18 21:51:04 |
| Message-ID: | 14361.995493064@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Pete Leonard <pete(at)hero(dot)com> writes:
> The reason this happened was that for whatever reason (we're still
> investigating), /tmp was writeable only by root.
Ah. Hadn't thought about it before, but the infinite-loop-on-
nonwritable-$PGDATA bug would also trigger for nonwritable /tmp.
(The bug was actually in CreateLockFile, which is used both to
create a lockfile in $PGDATA and one in /tmp. Sigh.)
This is fixed in current sources. If we were going to do a 7.1.3
then I'd backpatch the fix into the REL7_1 branch, but at this point
I suspect there won't be a 7.1.3 --- we'll probably go into 7.2 beta
in another five or six weeks, so there's not much point.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-07-18 22:03:26 | Re: psql -l |
| Previous Message | Tom Lane | 2001-07-18 21:44:23 | Re: slow SELECT ... LIMIT query |