Re: Unexpected crash

Mikko Partio wrote:
> Hello all,
>
> I installed the latest version from rpms and everythings ok, except when I
> connect to a db with psql and press shift+return the backend crashes with
> "Segmentation fault"! I guess the problem is with my installation but I
> don't know how to debug. It's not a very disconcerning thing per se, but I
> wonder what other surprises might be hiding behind the scenes.

Hmm. Very odd.

> test2=> select version();
> version
> --------------------------------------------------------------------------------------------------------------
>
> PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 3.2.320030502 (Red Hat Linux
> 3.2.3-58)
> (1 row)

OK. This is RH Enterprise Server, then?

> relevant log line:
>
> Jul 19 08:33:36 mihin postgres[24584]: [2-1] LOG: unexpected EOF on client
> connection

That's not a backend crash, that's just saying the client disconnected
unexpectedly. That implies a client (psql) crash. Is there a server
log-line saying you have a sig-11 crash?

What's puzzling me is why shift+return is different from just plain
return (which presumably works). I'd suspect readline or similar. Try
something like "rpm -q --requires postgresql-client" (you'll need to
check the details, haven't used rpm much recently) to see what packages
psql is depending on. Then just check they look OK for your installation.

--
Richard Huxton
Archonet Ltd