psql core dump

From: Kris Houghton <Kris(dot)Houghton(at)Sun(dot)COM>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: psql core dump
Date: 2001-10-15 22:06:13
Message-ID: 200110152206.QAA08421@bakha.Central.Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-ports


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(dot)houghton(at)sun(dot)com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message And. Andruikhanov 2001-10-15 23:37:32 reclaim database storage
Previous Message Peter Eisentraut 2001-10-15 19:28:52 Re: probably a bug of data-type serial

Browse pgsql-ports by date

  From Date Subject
Next Message Tom Lane 2001-10-16 23:41:48 Re: psql core dump
Previous Message Don Swett 2001-10-15 00:11:06 Cobalt Raq 2