Обсуждение: Bug #856: coredump

Mike Pechkin (mpech@openbsd.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@postgresql.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@postgresql.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