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

Re: Problem with PITR Past Particular WAL File

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com>
Cc: PostgreSQL Admin List <pgsql-admin(at)postgresql(dot)org>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Problem with PITR Past Particular WAL File
Date: 2007-10-25 15:59:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Craig McElroy <craig(dot)mcelroy(at)contegix(dot)com> writes:
> Core was generated by `/usr/local/pgsql/bin/postgres -D /pgdata01/data'.
> Program terminated with signal 11, Segmentation fault.

> #0  0x080b8ee0 in entrySplitPage ()
> #1  0x080baccf in ginInsertValue ()
> #2  0x080b81b7 in gin_xlog_cleanup ()
> #3  0x080af4ce in StartupXLOG ()
> #4  0x080c04ca in BootstrapMain ()
> #5  0x08186b2f in StartChildProcess ()
> #6  0x081889eb in PostmasterMain ()
> #7  0x0814ee9e in main ()

Hm, I wonder if this is explained by a bug already fixed in 8.2.5:

2007-06-04 11:59  teodor

	* src/backend/access/gin/: gindatapage.c, ginentrypage.c, ginget.c,
	ginvacuum.c, ginxlog.c (REL8_2_STABLE): Fix bundle bugs of GIN: -
	Fix possible deadlock between UPDATE and VACUUM queries. Bug never
	was   observed in 8.2, but it still exist there. HEAD is more
	sensitive to   bug after recent "ring" of buffer improvements.	-
	Fix WAL creation: if parent page is stored as is after split then  
	incomplete split isn't removed during replay. This happens rather
	rare, only   on large tables with a lot of updates/inserts.  - Fix
	WAL replay: there was wrong test of XLR_BKP_BLOCK_* for left   page
	after deletion of page. That causes wrong rightlink field: it
	pointed   to deleted page.  - add checking of match of clearing
	incomplete split - cleanup incomplete split list after proceeding
	All of this chages doesn't change on-disk storage, so backpatch... 
	But second point may be an issue for replaying logs from previous

Teodor, can you comment on whether this stack trace looks like it could
be related to that fix?

Craig, can you retry your test scenario on 8.2.5?

			regards, tom lane

In response to


pgsql-admin by date

Next:From: Teodor SigaevDate: 2007-10-25 18:05:45
Subject: Re: Problem with PITR Past Particular WAL File
Previous:From: Scott MarloweDate: 2007-10-25 15:33:03
Subject: Re: Suse Linux Postgres

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