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:18:22Z
Lists: pgsql-hackers
On 01/15/2013 12:07 PM, Andrew Dunstan wrote:
>
> 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:

I had a missing quote. should be:

    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.