Lee Joramo <lee.list@joramo.com> writes:
> And the solution is:
> DELETE INDEX classifieds_adcopy
> By deleteing the index, everything started to work correctly. Even after
> recreating the index, everyting worked after multiple tests.
So that index had gotten corrupted at some time in the past, and just
emptying and refilling the table didn't fix it. Doesn't surprise me
a whole lot. (I had assumed you were destroying and rebuilding the
whole database, else I'd have suggested this sooner...)
It's possible that the index corruption was triggered by having inserted
an overlength adcopy value at some time in the past. Or maybe it's just
a garden-variety bug; 6.5 has its share of 'em. I do urge you to update
to 7.0.3 as soon as possible. (BTW, there are LinuxPPC RPMs of 7.0.3
available from our FTP server, so if it's having to compile from source
that's scaring you, you don't need to.)
regards, tom lane