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

Re: primary and hot standby database don' work now

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: leo xu <leoxu8703(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: primary and hot standby database don' work now
Date: 2012-07-29 19:50:58
Message-ID: CA+U5nMK5qNrWFwi4MgS1sYJvFxmdu9QOmDbaB0HctjYzb4XX3Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 22 July 2012 07:00, leo xu <leoxu8703(at)gmail(dot)com> wrote:
> hello everyone:
>               my pg version is 9.1.2 running on red hat 5.4 x64 servers.one
> day,i found all database indexes can't work,reindex database,it can work,but
> some table has primary key,found exists the same two records in table.
>              primary database error:

> 2012-07-19 21:18:36.133 CST,,,476,,4fde7dd3.1dc,22,,2012-06-18 09:01:07
> CST,1/0,0,WARNING,01000,"specified item offset is too large",,,,,"xlog redo
> insert: rel 17673/16386/16780; tid 409/151",,,,""

There's something badly wrong with your WAL records.

I'd suggest you move to a later version of 9.1 and retry.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

pgsql-bugs by date

Next:From: Emcisc (JinWei) ZhaoDate: 2012-07-30 03:49:55
Subject: Error on pg_settings.bytea_output for pg9.1
Previous:From: hubert depesz lubaczewskiDate: 2012-07-27 16:03:24
Subject: Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY

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