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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Emcisc (JinWei) Zhao | 2012-07-30 03:49:55 | Error on pg_settings.bytea_output for pg9.1 |
Previous Message | hubert depesz lubaczewski | 2012-07-27 16:03:24 | Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY |