| From: | Ed Loehr <ELOEHR(at)austin(dot)rr(dot)com> |
|---|---|
| To: | Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Index corruption |
| Date: | 1999-12-23 18:45:56 |
| Message-ID: | 38626DE4.980D4617@austin.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Were other queries occurring during your vacuum? There have been reports
in these mailing lists that concurrent queries cause vacuum failures...
Cheers,
Ed Loehr
Adriaan Joubert wrote:
> Hi,
>
> Something in my pg_proc table got corrupted and when trying to
> vacuum it, vacuum would create thousands of index files in the database
> directory. It would just go into an endless loop and all it seems to do
> is create files. Anybody else seen this before? I've tried everything
> and am now in the process of dumping all the data out table by table and
> rebuilding the database from scratch. Any ideas what I can do to avoid
> this or any idea how this could have happened? I'm running 6.5.2 on
> Digital Unix 4.0F.
>
> Cheers,
>
> Adriaan
>
> ************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-12-23 21:40:36 | Source code format votes |
| Previous Message | Lamar Owen | 1999-12-23 18:31:58 | Re: [HACKERS] --with-mb=SQL_ASCII for 6.5.3 RPMs. |