| From: | Jeremy Drake <pgsql(at)jdrake(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: catalog corruption bug |
| Date: | 2006-01-06 17:11:12 |
| Message-ID: | Pine.LNX.4.63.0601060908300.15097@garibaldi.apptechsys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 6 Jan 2006, Tom Lane wrote:
> Jeremy Drake <pgsql(at)jdrake(dot)com> writes:
> > Well, I applied that patch that you sent me the link to (the bufmgr.c
> > one), and rebuilt (PORTDIR_OVERLAY is cool...)
>
> > I ran my nine processes which hammer things overnight, and in the
> > morning one of them was dead.
>
> > DBD::Pg::st execute failed: ERROR: duplicate key violates unique
> > constraint "pg_type_typname_nsp_index"
>
> Hm, did you REINDEX things beforehand? This could be leftover corruption...
Yes. I ran that VACUUM FULL ANALYZE VERBOSE which I emailed part of the
excerpt from, and then I started a standalone backend (postgres -D data
-P) and ran REINDEX SYSTEM dbname on the database in question.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Kreen | 2006-01-06 17:11:27 | Re: [HACKERS] Inconsistent syntax in GRANT |
| Previous Message | Tom Lane | 2006-01-06 16:59:31 | Re: catalog corruption bug |