Horton

RE: BUG #15460: Error while creating index or constraint

Paul van der Linden <paul.vanderlinden@mapcreator.eu>

View thread View on postgr.es
From: Paul van der Linden <paul.vanderlinden@mapcreator.eu>
To: Peter Geoghegan <pg@bowt.ie>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>
Date: 2018-10-29T14:19:37Z
Lists: pgsql-bugs 
Directory is empty (when I check after the error occurred, no idea yet (will test) if there's something there during index creation.
And for some reason I'm not able to set the log_line_prefix in my pgAdmin session... ERROR:  parameter "log_line_prefix" cannot be changed now

-----Original Message-----
From: Peter Geoghegan <pg@bowt.ie> 
Sent: maandag 29 oktober 2018 15:13
To: Paul van der Linden <paul.vanderlinden@mapcreator.eu>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>; Heikki Linnakangas <hlinnaka@iki.fi>
Subject: Re: BUG #15460: Error while creating index or constraint

On Mon, Oct 29, 2018 at 2:11 PM Peter Geoghegan <pg@bowt.ie> wrote:
> I suppose that this could actually just be a result of the ERROR; the 
> exact order isn't a reliable indicator of the sequence of events 
> across processes (A useful log_line_prefix setting might clear this up 
> if you collect the trace_sort output again).

For example, this log_line_prefix will show process PID, and a timestamp:

log_line_prefix='%p/%t '

--
Peter Geoghegan

Commits

  1. Have BufFileSize() ereport() on FileSize() failure.

  2. Use 64 bit type for BufFileSize().

  3. Adjust trace_sort log messages.

  4. Fix some sloppiness in the new BufFileSize() and BufFileAppend() functions.