Re: [BUGS] Issue with range types and casts?

2013-03-29 Thread Jeff Davis
On Fri, 2013-03-08 at 15:27 -0800, Josh Berkus wrote: > create table tenmin as select * from sampledata where collect_ts <@ > '[2013-01-01 00:00:00,2013-01-01 00:10:00)'; > ERROR: could not find range type for data type timestamp with time zone > Time: 0.189 ms > > This seems like it ought to be

Re: [BUGS] Completely broken replica after PANIC: WAL contains references to invalid pages

2013-03-29 Thread anara...@anarazel.de
Hi Sergey Konoplev schrieb: >Hi all, > >A couple of days ago I found the replica stopped after the PANIC >message: > >PANIC: WAL contains references to invalid pages > >When I tried to restart it I got this FATAL: > >FATAL: could not access status of transaction 280557568 > >Below is the descr

Re: [BUGS] Completely broken replica after PANIC: WAL contains references to invalid pages

2013-03-29 Thread Sergey Konoplev
On Fri, Mar 29, 2013 at 1:52 PM, anara...@anarazel.de wrote: > I think I See whats going on. Do you still have the datadir available? If so, > could you send the pg_controldata output? I have already rebuilt the replica, however below is the output if it is useful: pg_control version number:

Re: [BUGS] Completely broken replica after PANIC: WAL contains references to invalid pages

2013-03-29 Thread Andres Freund
On 2013-03-29 14:19:59 -0700, Sergey Konoplev wrote: > On Fri, Mar 29, 2013 at 1:52 PM, anara...@anarazel.de > wrote: > > I think I See whats going on. Do you still have the datadir available? If > > so, could you send the pg_controldata output? > > I have already rebuilt the replica, however be

Re: [BUGS] Completely broken replica after PANIC: WAL contains references to invalid pages

2013-03-29 Thread Sergey Konoplev
On Fri, Mar 29, 2013 at 2:38 PM, Andres Freund wrote: > I have to admit, I find it a bit confusing that so many people report a > bug and then immediately destroy all evidence of the bug. Just seems to > a happen a bit too frequently. You see, businesses usually need it up ASAP again. Sorry, I mu