Re: Curious buildfarm failures

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@2ndquadrant.com>, math@sai.msu.ru, pgsql-hackers@postgreSQL.org
Date: 2013-01-15T17:07:02Z
Lists: pgsql-hackers
On 01/15/2013 11:57 AM, Tom Lane wrote:
> Well, it could be quite reproducible, if for example what's happening is
> that the DROP is failing to wait for the checkpointer at all.
>
> Is there a way to enable log_checkpoints during a buildfarm run?
> It'd be good to get timestamps added to the postmaster log entries, too.
>
> 			


Yes, it's very easy. In the config file, do something like:

          extra_config =>
          {
              DEFAULT => [
                       q(log_line_prefix = '%t [%c:%l] '),
                       "log_checkpoints = 'true',
                       ],
          },



cheers

andrew


Commits

  1. Prevent very-low-probability PANIC during PREPARE TRANSACTION.