Re: [BUGS] page corruption after moving tablespace

2010-07-26 Thread Jeff Davis
On Thu, 2010-07-22 at 23:50 -0700, Jeff Davis wrote: > I was investigating some strange page corruption today in which the page > was completely zeroed except for the LSN and TLI. > I see that this was added to the 9.0 open items list, but it affects versions 8.3 and later. I should have indicat

Re: [BUGS] page corruption after moving tablespace

2010-07-23 Thread Jeff Davis
On Thu, 2010-07-22 at 23:50 -0700, Jeff Davis wrote: > I think the simple fix would be to have copy_relation_data call > PageInit() if it's a new page. On second thought, why are PageSetLSN and PageSetTLI being called from log_newpage(), anyway? It says that all of the callers use smgr directly, r

[BUGS] page corruption after moving tablespace

2010-07-22 Thread Jeff Davis
I was investigating some strange page corruption today in which the page was completely zeroed except for the LSN and TLI. I found a sequence that can cause that problem even in 9.0: (wal_level must be set to "archive" or greater) 1. Create a tablespace "t1" 2. Create a table "foo" 3. Attach to