Re: corrupted table?

Hi Guyon,

I would not trust the hardware if I would run into the problem several times on the same system. If you are sure that the hardware is ok, I have a question: Have you or your customer installed a patch or a new software release without running the upgrade scripts?

I have seen on a customer system oddly behavior when he run 8.0.x data files with 8.1.5 software. This problem occurs when he restore older data files without noticing that there was an upgrade in the meantime. The real problem was, that you do not got immediately errors. But over the time he run into more an more problems. But his problems couldn't be solved by exporting and importing the data.

Regards
Ralph

"Gumuz" <gumuz_at_looze.net> wrote in message news:3dbfb69d$0$227$4d4ebb8e_at_news.nl.uu.net...
> hi all,
>
> i have this strange problem. my guess is that it's a bad-installation, but
i
> want to be sure, before i have to re-install a customers database. so here
> is my problem...
>
> so once in a while, i've this strange behavior in 'some' tables,
> 'sometimes'. sometimes a simple 'select *' doesn't even work. recently i
got
> the problem that a select was working fine. but when i used one of the
> columns in a join, it messed up, got stuck, had to cancel.
>
> now in all these cases i could solve the problem by dropping and
recreating
> the table with the original data put back in. then it works.... for a
while.
> it seems that some tables have the tendencie to give this error more then
> others, but then again... not always.
>
> ok guys/girls... i know it's a pretty vague story what i'm putting up
here,
> i hope you know something i can do about this, besides making a new
> installation.
>
>
> thanks,
>
> Guyon
>
>
Received on Wed Oct 30 2002 - 12:23:34 CST