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) Zhao||Date: 2012-07-30 03:49:55|
|Subject: Error on pg_settings.bytea_output for pg9.1|
|Previous:||From: hubert depesz lubaczewski||Date: 2012-07-27 16:03:24|
|Subject: Re: BUG #6774: FOR IN SELECT LOOP ignores ORDER BY|