Re: Problem with PITR Past Particular WAL File

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Craig McElroy <craig.mcelroy@xxxxxxxxxxxx> 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
	version.

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux