Re: Bug #856: coredump

Mike Pechkin (mpech(at)openbsd(dot)org) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
coredump

Long Description
$ psql
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

postgresql=# CREATE USER mpech777;
CREATE USER
postgresql=# alter USER mpech777 password 'dddd';
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

Sample Code

No file was uploaded with this report

pgsql-bugs(at)postgresql(dot)org writes:
> postgresql=# CREATE USER mpech777;
> CREATE USER
> postgresql=# alter USER mpech777 password 'dddd';
> server closed the connection unexpectedly

Hm, it works fine here. You'll need to give more details about
platform, configuration options, any nondefault settings in
postgresql.conf, etc. A stack trace from the core dump would be
helpful as well, in case we still can't reproduce it.

regards, tom lane

On Thu, Dec 26, 2002 at 12:01:02PM -0500, Tom Lane wrote:

> pgsql-bugs(at)postgresql(dot)org writes:
> > postgresql=# CREATE USER mpech777;
> > CREATE USER
> > postgresql=# alter USER mpech777 password 'dddd';
> > server closed the connection unexpectedly
>
> Hm, it works fine here. You'll need to give more details about
Cool. I knew it.

> platform, configuration options, any nondefault settings in
> postgresql.conf, etc. A stack trace from the core dump would be
> helpful as well, in case we still can't reproduce it.
It was OpenBSD 3.2-CURRENT with propolice.
With patches for gcc from 25/12/2002 i can't reproduce coredump anymore.
So, it was OpenBSD related bug.

--mpech