diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-07-20 16:29:53 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-07-20 16:29:53 +0000 |
| commit | 04fbe29a8369d44c25002a398098a4dc41b233ae (patch) | |
| tree | 21d9237e2c651ae3accd1219eaab5ca595aea145 | |
| parent | ebb5436d702be3a4b8c28b0f36241e37fc1a3dc8 (diff) | |
| download | postgresql-04fbe29a8369d44c25002a398098a4dc41b233ae.tar.gz postgresql-04fbe29a8369d44c25002a398098a4dc41b233ae.zip | |
Fix WAL replay of truncate operations to cope with the possibility that the
truncated relation was deleted later in the WAL sequence. Since replay
normally auto-creates a relation upon its first reference by a WAL log entry,
failure is seen only if the truncate entry happens to be the first reference
after the checkpoint we're restarting from; which is a pretty unusual case but
of course not impossible. Fix by making truncate entries auto-create like
the other ones do. Per report and test case from Dharmendra Goyal.
| -rw-r--r-- | src/backend/storage/smgr/smgr.c | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/src/backend/storage/smgr/smgr.c b/src/backend/storage/smgr/smgr.c index 240329ae66d..7137d2dc08c 100644 --- a/src/backend/storage/smgr/smgr.c +++ b/src/backend/storage/smgr/smgr.c @@ -11,7 +11,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/storage/smgr/smgr.c,v 1.104 2007/07/08 22:23:16 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/storage/smgr/smgr.c,v 1.105 2007/07/20 16:29:53 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -811,6 +811,14 @@ smgr_redo(XLogRecPtr lsn, XLogRecord *record) reln = smgropen(xlrec->rnode); + /* + * Forcibly create relation if it doesn't exist (which suggests that + * it was dropped somewhere later in the WAL sequence). As in + * XLogOpenRelation, we prefer to recreate the rel and replay the + * log as best we can until the drop is seen. + */ + smgrcreate(reln, false, true); + /* Can't use smgrtruncate because it would try to xlog */ /* |