Hi,
> Yeah, that does look like a corrupted-data problem. If you wanted to
> rebuild with debugging symbols turned on, it might be possible to
> extract the location of the bad tuple directly from the corefile.
> Short of that, what I'd do is find out what query the backend is
> crashing on (turn on debug query logging), and then investigate the
> tables involved using queries like "select ctid,* from foo limit N".
> By varying the limit you can home in on just where the bad tuple is.
I tried the "select ctid,* from table limit N"-way and found some possible
corrupted ctid. I then deleted all tuples in this ctid manually.
It all looked good, but no, the problem persists.
5 minutes ago I did a
"select ctid,* from table order by id limit 82000"
and it worked flawlessly.
Then I did a
"select ctid,* from table order by id limit 200000"
and it crashed again.
I again tried
"select ctid,* from table order by id limit 82000"
and it crashed here also.
What do you suspect here? Hardware failure? I ran a badblocks read-only test
and it was fine. I tested memory with memtester and it was fine...
How can this kind of corruption happen at all? And what can I do next?
greetings,
Bjoern