Thread: Change "recycled transaction log" from LOG to DEBUG1
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
On August 9, Tom Lane wrote regarding "recycled transaction log file"
messages appearing in the server logs:
> This is normal behavior. At some point we'll probably knock down the
> priority of those messages from LOG to DEBUG...
I'm all for it, for I am tired of seeing those messages in my logs
as well. I'd make a link to Tom's original post, but once again
archives.postgresql.org is not working.
Index: xlog.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/backend/access/transam/xlog.c,v
retrieving revision 1.168
diff -c -r1.168 xlog.c
*** xlog.c 30 Aug 2004 02:54:38 -0000 1.168
--- xlog.c 5 Sep 2004 15:26:43 -0000
***************
*** 2154,2160 ****
true, XLOGfileslop,
true))
{
! ereport(LOG,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
--- 2154,2160 ----
true, XLOGfileslop,
true))
{
! ereport(DEBUG1,
(errmsg("recycled transaction log file \"%s\"",
xlde->d_name)));
}
--
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200409051137
-----BEGIN PGP SIGNATURE-----
iD8DBQFBOzNBvJuQZxSWSsgRApOvAKCPoVcSR29wft9RIxk4bi3R5SkahQCg0yKr
ISROl8QXPuh8g16O+zRCeus=
=dFk7
-----END PGP SIGNATURE-----
May as well downgrade the CLOG message as well then.
Chris
Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> NotDashEscaped: You need GnuPG to verify this message
>
>
> On August 9, Tom Lane wrote regarding "recycled transaction log file"
> messages appearing in the server logs:
>
>
>>This is normal behavior. At some point we'll probably knock down the
>>priority of those messages from LOG to DEBUG...
>
>
> I'm all for it, for I am tired of seeing those messages in my logs
> as well. I'd make a link to Tom's original post, but once again
> archives.postgresql.org is not working.
>
> Index: xlog.c
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/src/backend/access/transam/xlog.c,v
> retrieving revision 1.168
> diff -c -r1.168 xlog.c
> *** xlog.c 30 Aug 2004 02:54:38 -0000 1.168
> --- xlog.c 5 Sep 2004 15:26:43 -0000
> ***************
> *** 2154,2160 ****
> true, XLOGfileslop,
> true))
> {
> ! ereport(LOG,
> (errmsg("recycled transaction log file \"%s\"",
> xlde->d_name)));
> }
> --- 2154,2160 ----
> true, XLOGfileslop,
> true))
> {
> ! ereport(DEBUG1,
> (errmsg("recycled transaction log file \"%s\"",
> xlde->d_name)));
> }
>
>
>
>
> --
> Greg Sabino Mullane greg@turnstep.com
> PGP Key: 0x14964AC8 200409051137
>
> -----BEGIN PGP SIGNATURE-----
>
> iD8DBQFBOzNBvJuQZxSWSsgRApOvAKCPoVcSR29wft9RIxk4bi3R5SkahQCg0yKr
> ISROl8QXPuh8g16O+zRCeus=
> =dFk7
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Christopher Kings-Lynne <chriskl@familyhealth.com.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);