RE: WHY index can corrupted???
Hi, everybody,
The last time I saw index corruption was when
I created index with PDQ on multi-CPU system for a huge table that
was being actively modified just few seconds before index
creation was started (may be, some buffers were not
flushed to disk). That happened with IDS 9.21uc4
Non of Madison's (1) (2) (3) took place in our case.
Formally, we did everything correctly. It was a pure IDS
problem.
I think that IDS shared memory was corrupted by the
time index creation was started. Memory corruption could be caused
by some problematic query, not related to this index creation task.
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Madison Pruet [mailto:mpruet@comcast.net]
> Sent: Wednesday, August 13, 2003 12:54 PM
> To: informix-list@iiug.org
> Subject: Re: WHY index can corrupted???
>
> There is absolutely no reason for index corruption. If the index should
> become corrupt, then it means that a bug has been encountered. Please
> open
> a case with tech support to try to discover the root cause of the
> corruption.
>
> The only exception to this would be the case where either something
> outside
> of the engine induced the corruption. This might include
>
> 1) the hardware did not do a physical IO that the os(software) thought had
> been done
> 2) the user did somthing wrong such as having two instances using the same
> chunk
> 3) the customer ran into some kind of problem and the logical logs were
> patched so that the normal recovery could not successfully complete
>
>
> M.Pruet
>
> "miyaki" <lcib@yahoo.com> wrote in message
> news:bhc6qc$vu9$1@terabinaries.xmission.com...
> >
> > Hi all,
> >
> > OS : Sun Solaris 2.7
> > IDS : 7.31.UD5
> >
> > Recently my database engine was crashed due to the
> > index corruption. The engine was back up after
> > repairing the index by using the oncheck command. I'm
> > wondering why the index can be corrupted? In fact, I
> > just performed the database re-org by using the
> > dbexport-import at 3 months ago.
> >
> > Anybody knows the reason that may cause the index
> > corruption???
> >
> > Appreciate for the comments.
> >
> > TIA,
> > MIyaki
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> > sending to informix-list
sending to informix-list