Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Heikki Linnakangas <heikki(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without
Date: 2010-02-01 08:40:57
Message-ID: 1265013657.13782.10934.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
I'm seeing these messages in the standby server log:

WARNING:  unlogged operation performed, data may be missing
HINT:  This can happen if you temporarily disable archive_mode without
taking a new base backup.
CONTEXT:  xlog redo unlogged operation: heap inserts on "pg_temp_65646"

which connected with operations on temp tables, probably as a result of
VACUUM FULL and CLUSTER.

I don't think those messages should be there.


On Wed, 2010-01-20 at 19:43 +0000, Heikki Linnakangas wrote:
> Log Message:
> -----------
> Write a WAL record whenever we perform an operation without WAL-logging
> that would've been WAL-logged if archiving was enabled. If we encounter
> such records in archive recovery anyway, we know that some data is
> missing from the log. A WARNING is emitted in that case.
> 
> Original patch by Fujii Masao, with changes by me.
> 
> Modified Files:
> --------------
>     pgsql/src/backend/access/heap:
>         heapam.c (r1.282 -> r1.283)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/heapam.c?r1=1.282&r2=1.283)
>     pgsql/src/backend/access/nbtree:
>         nbtsort.c (r1.122 -> r1.123)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/nbtree/nbtsort.c?r1=1.122&r2=1.123)
>     pgsql/src/backend/access/transam:
>         xlog.c (r1.358 -> r1.359)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.358&r2=1.359)
>     pgsql/src/backend/commands:
>         cluster.c (r1.193 -> r1.194)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c?r1=1.193&r2=1.194)
>         tablecmds.c (r1.316 -> r1.317)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.316&r2=1.317)
>     pgsql/src/include/access:
>         xlog.h (r1.97 -> r1.98)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/xlog.h?r1=1.97&r2=1.98)
>     pgsql/src/include/catalog:
>         pg_control.h (r1.48 -> r1.49)
>         (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_control.h?r1=1.48&r2=1.49)
> 
-- 
 Simon Riggs           www.2ndQuadrant.com


In response to

Responses

pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-02-01 08:45:40
Subject: Re: BUG #5304: psql using conninfo fails in connecting to the server
Previous:From: Heikki LinnakangasDate: 2010-02-01 08:31:03
Subject: Re: BUG #5304: psql using conninfo fails in connecting to the server

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2010-02-01 09:33:44
Subject: Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without
Previous:From: Takahiro ItagakiDate: 2010-02-01 03:14:45
Subject: pgsql: Add string_agg aggregate functions.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group