Re: Change "recycled transaction log" from LOG to DEBUG1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Change "recycled transaction log" from LOG to DEBUG1
Date: 2004-09-06 03:05:31
Message-ID: 4187.1094439931@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> May as well downgrade the CLOG message as well then.

Agreed. I've applied the attached extended patch.

regards, tom lane

*** src/backend/access/transam/slru.c.orig Sun Aug 29 09:54:52 2004
--- src/backend/access/transam/slru.c Sun Sep 5 23:01:57 2004
***************
*** 944,950 ****
if (doDeletions)
{
snprintf(path, MAXPGPATH, "%s/%s", ctl->Dir, clde->d_name);
! ereport(LOG,
(errmsg("removing file \"%s\"", path)));
unlink(path);
}
--- 944,950 ----
if (doDeletions)
{
snprintf(path, MAXPGPATH, "%s/%s", ctl->Dir, clde->d_name);
! ereport(DEBUG1,
(errmsg("removing file \"%s\"", path)));
unlink(path);
}
*** src/backend/access/transam/xlog.c.orig Sun Aug 29 22:57:29 2004
--- src/backend/access/transam/xlog.c Sun Sep 5 23:01:58 2004
***************
*** 2154,2167 ****
true, XLOGfileslop,
true))
{
! ereport(LOG,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
else
{
/* No need for any more future segments... */
! ereport(LOG,
(errmsg("removing transaction log file \"%s\"",
xlde->d_name)));
unlink(path);
--- 2154,2167 ----
true, XLOGfileslop,
true))
{
! ereport(DEBUG1,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
else
{
/* No need for any more future segments... */
! ereport(DEBUG1,
(errmsg("removing transaction log file \"%s\"",
xlde->d_name)));
unlink(path);

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Yoshiyuki Asaba 2004-09-06 08:31:40 pg_ctl restart failed on Win32
Previous Message Christopher Kings-Lynne 2004-09-06 01:46:47 Re: Change "recycled transaction log" from LOG to DEBUG1