From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Gaetano Mendola <mendola(at)bigfoot(dot)com>, freecontact(at)freenet(dot)de |
Cc: | PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #1242: Major bug in pgSQL |
Date: | 2004-09-07 14:05:01 |
Message-ID: | 29873.1094565901@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> When you are experiencing this show us the result of this query:
> select cmax, cmin, xmax, xmin, * from <table> where <your condition>;
Also, please, the ctid and oid columns (but leave out oid if you made
the table WITHOUT OIDS).
Also, if the condition is one that will normally use an index, try
the same query with and without "set enable_indexscan = off". It
could be that a corrupted index would cause the query to visit the
same rows multiple times (or miss rows!).
It might be a good idea to REINDEX the primary-key index on the table,
but I would counsel not doing so until we have more data on what's
happening. If the problem is index corruption then REINDEX would
destroy all the evidence ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-09-07 14:32:33 | Re: [PATCHES] [pgsql-hackers-win32] Win32 deadlock detection not working for Postgres8beta1 |
Previous Message | Gaetano Mendola | 2004-09-07 13:35:58 | Re: BUG #1242: Major bug in pgSQL |