Re: [COMMITTERS] pgsql: Write a WAL record whenever we perform an operation without - Mailing list pgsql-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