psql core dump - Mailing list pgsql-bugs

Postgres Support,


I have been trying to start psql demodb database that I created and every
time I get a core dump..

initdb and createdb worked just fine.

When I attempt   psql demodb  I get a core dump .. ( NOT GOOD )
Please review output below.

I have also included a core dump using gdb.

I'm using solaris 8 update 5

  Solaris 8 7/01 s28s_u5wos_08 SPARC

  Trying to run on a 4500 and 3500 servers.


$
$ ps -ef | grep postgres
postgres  1365  1133  0 15:39:36 pts/1    0:00 grep postgres
postgres   817   796  0 11:44:10 pts/3    0:00 -sh
postgres  1133   411  0 14:43:44 pts/1    0:00 -sh
$
$
$
$ /pgsql/bin/postmaster -D /homedir/postgres/data &
1367
$ DEBUG:  database system was shut down at 2001-10-15 15:35:31 MDT
DEBUG:  CheckPoint record at (0, 1571800)
DEBUG:  Redo record at (0, 1571800); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 623; NextOid: 18721
DEBUG:  database system is in production state

$
$ psql demodb
Welcome to psql, 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

Segmentation Fault - core dumped
$ pq_recvbuf: unexpected EOF on client connection

$
$ /opt/cbe/SUPPORT-PKGS/gnu/usr/local/bin/gdb psql core
GNU gdb 5.0
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "sparc-sun-solaris2.8"...
Core was generated by `psql demodb'.
Program terminated with signal 11, Segmentation Fault.
Reading symbols from /pgsql/lib/libpq.so.2...done.
Loaded symbols for /pgsql/lib/libpq.so.2
Reading symbols from /usr/local/lib/libz.so...done.
Loaded symbols for /usr/local/lib/libz.so
Reading symbols from /usr/lib/libresolv.so.2...done.
Loaded symbols for /usr/lib/libresolv.so.2
Reading symbols from /usr/lib/libgen.so.1...done.
Loaded symbols for /usr/lib/libgen.so.1
Reading symbols from /usr/lib/libnsl.so.1...done.
Loaded symbols for /usr/lib/libnsl.so.1
Reading symbols from /usr/lib/libsocket.so.1...done.
Loaded symbols for /usr/lib/libsocket.so.1
Reading symbols from /usr/lib/libdl.so.1...done.
Loaded symbols for /usr/lib/libdl.so.1
Reading symbols from /usr/lib/libm.so.1...done.
Loaded symbols for /usr/lib/libm.so.1
Reading symbols from /usr/lib/libcurses.so.1...done.
Loaded symbols for /usr/lib/libcurses.so.1
Reading symbols from /usr/lib/libc.so.1...done.
Loaded symbols for /usr/lib/libc.so.1
Reading symbols from /usr/lib/libmp.so.2...done.
Loaded symbols for /usr/lib/libmp.so.2
Reading symbols from
/usr/platform/SUNW,Ultra-Enterprise/lib/libc_psr.so.1...done.
Loaded symbols for /usr/platform/SUNW,Ultra-Enterprise/lib/libc_psr.so.1
#0  0xff0b343c in strncmp () from /usr/lib/libc.so.1
/pgsql/bin/postmaster: dumpstatus:
/pgsql/bin/postmaster: dumpstatus:
(gdb) where
#0  0xff0b343c in strncmp () from /usr/lib/libc.so.1
#1  0xff177620 in _tcsearch () from /usr/lib/libcurses.so.1
#2  0xff177988 in tgetstr () from /usr/lib/libcurses.so.1
#3  0x39494 in get_term_capabilities (bp=0xffbefa84) at terminal.c:283
#4  0x39618 in _rl_init_terminal_io (terminal_name=0x5c000 "") at terminal.c:349
#5  0x2b0d4 in readline_initialize_everything () at readline.c:733
#6  0x2afdc in rl_initialize () at readline.c:649
#7  0x2a954 in readline (prompt=0x5b700 "demodb=# ") at readline.c:342
#8  0x191e0 in gets_interactive ()
#9  0x1a110 in MainLoop ()
#10 0x1d22c in main ()
/pgsql/bin/postmaster: dumpstatus:
(gdb) quit
$


Kris Houghton
Sun Microsystems Inc.
Phone: 303-272-7166
Email: kris.houghton@sun.com