pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
REINDEX needed because of index corruption need help ASAP
3+ messages / 3 participants
[nested] [flat]

* REINDEX needed because of index corruption need help ASAP
@ 2004-08-13 21:40 borajetta <borajetta@hotmail.com>
  2004-08-13 22:18 ` Re: REINDEX needed because of index corruption need help ASAP Josh Berkus <josh@agliodbs.com>
  2004-08-13 22:23 ` Re: REINDEX needed because of index corruption need help ASAP Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: borajetta @ 2004-08-13 21:40 UTC (permalink / raw)
  To: pgsql-performance

select count(*) FROM items_2004_07_29 as items WHERE true AND index @@ to_tsquery('default', '( audiovox)') ;
 count 
-------
     4
(1 row)

aers=# reindex index idx_title_2004_07_29;
REINDEX
aers=# select count(*) FROM items_2004_07_29 as items WHERE true AND index @@ to_tsquery('default', '( audiovox)') ;
 count 
-------
  2342
(1 row)


Here are 2 searches using a gist index, the first one has a gist index which is not properly created but does not though an error in creation.  After doing a few searches I noticed the numbers were way off so I reindexed.  The problem was fixed and the search works properly.

Is there a problem with indexing?  Do you know of this problem?
Is there a way to fix it?

We are getting this error for other index's including primary key indexs where we get OID page not found errors and the index corruption as posted above.
Sometimes when the index is broken it will cause run away searches which eat up all the memory and the server needs to be restarted.

Anyways this all looks to be in index problem, vacuum/analyze does not fix it only reindexing does.

Thank you,

Aaron

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: REINDEX needed because of index corruption need help ASAP
  2004-08-13 21:40 REINDEX needed because of index corruption need help ASAP borajetta <borajetta@hotmail.com>
@ 2004-08-13 22:18 ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Josh Berkus @ 2004-08-13 22:18 UTC (permalink / raw)
  To: borajetta <borajetta@hotmail.com>; pgsql-performance

Aaron,

> We are getting this error for other index's including primary key indexs 
where we get OID page not found errors and the index corruption as posted 
above.
> Sometimes when the index is broken it will cause run away searches which eat 
up all the memory and the server needs to be restarted.

What version of PostgreSQL are you using?
Do you have frequent power-outs on the machine?
Have you tested for bad hard drive, controller, or memory?

Corruption of any kind on PostgreSQL is not normal.  It's usually indicative 
of a hardware problem.

-- 
-Josh Berkus
 "A developer of Very Little Brain"
 Aglio Database Solutions
 San Francisco




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: REINDEX needed because of index corruption need help ASAP
  2004-08-13 21:40 REINDEX needed because of index corruption need help ASAP borajetta <borajetta@hotmail.com>
@ 2004-08-13 22:23 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-08-13 22:23 UTC (permalink / raw)
  To: borajetta <borajetta@hotmail.com>; +Cc: pgsql-performance

"borajetta" <borajetta@hotmail.com> writes:
> We are getting this error for other index's including primary key indexs wh=
> ere we get OID page not found errors and the index corruption as posted abo=
> ve.
> Sometimes when the index is broken it will cause run away searches which ea=
> t up all the memory and the server needs to be restarted.

It sounds to me like you have got hardware problems.  Get out your
memory and disk tests ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-08-13 22:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-13 21:40 REINDEX needed because of index corruption need help ASAP borajetta <borajetta@hotmail.com>
2004-08-13 22:18 ` Josh Berkus <josh@agliodbs.com>
2004-08-13 22:23 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox