| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marc Munro <marc(at)bloodnok(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Index corruption |
| Date: | 2006-06-28 17:20:36 |
| Message-ID: | 28056.1151515236@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Marc Munro <marc(at)bloodnok(dot)com> writes:
> We have now experienced index corruption on two separate but identical
> slony clusters. In each case the slony subscriber failed after
> attempting to insert a duplicate record. In each case reindexing the
> sl_log_1 table on the provider fixed the problem.
Please be more specific about what you mean by "index corruption"
... what were the exact symptoms?
> postgresql-8.0.3-1PGDG
The *first* thing you should do is update to 8.0.8 and see if the
problem is still there.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-06-28 17:38:50 | Re: Fixed length datatypes. WAS [GENERAL] UUID's as |
| Previous Message | A.M. | 2006-06-28 17:18:39 | Re: Fixed length datatypes. WAS [GENERAL] UUID's as |