Quoting Tom Lane <tgl@sss.pgh.pa.us>:
> jao@geophile.com writes:
>> mydb=> insert into test values(11);
>> *** buffer overflow detected ***: psql terminated
>
> You seem to have a rather badly broken build there :-(. What's the
> platform exactly, and what compiler did you use? Can you rebuild
> with debug support enabled so you can get a stack trace that's
> actually useful?
>
> If it just started happening, I'd speculate about a corrupt executable
> file for psql or libpq. I doubt it's got anything to do with the server
> side.
But this doesn't explain the data I posted previously:
psql host postgres host result
--------------------------------------
X X crash
X Y OK
Y X crash
Y Y OK
Nodes X and Y are in a cluster and have the same software installed
(OS, Postgres, application).
- If the problem is with our build of psql or postgres, then I'd
expect crashes in all four cases.
- If we have a good build but a corrupt psql executable, then I'd
expect the crash to correlate with the psql host.
- If we have a corrupt postgres executable or a corrupt database then
I'd expect the crash to correlate with the postgres host, which is
what I observed. The disk checking we've done (fsck, badblocks)
indicates that the database is OK. I'm in the process of checking the
disks on X and Y with the database executables.
Jack