Re: Various intermittent bugs/instability - how to debug?

Frederik Ramm wrote:
> Dear PostgreSQL community,

> Every other night, the process aborts with some strange error message,
> and never at the same position:
>
> ERROR: invalid page header in block 166406 of relation "node_tags"
>
> ERROR: could not open segment 2 of relation 1663/24253056/24253895
> (target block 1421295656): No such file or directory

> What could I do to have a better chance of reproducing the error and
> ultimately identifying the component responsible? Is there some kind of
> "PostgresSQL load test", something like "cpuburn" for PostgreSQL?
>
> Have there been other reports of intermittent problems like mine, and
> does anybody have any blind guesses...?

Hard drives. You said you replaced the machines and ran cpu burn etc...
You didn't say you checked the hard drives (or replaced them).

Joshua D. Drake

>
> Thanks
> Frederik
>