On Sun, 16 May 1999, Tom Lane wrote:
> gjerde@icebox.org wrote (a couple weeks ago):
> > While running postmaster at the command line like this:
> > /home/postgres/bin/postmaster -B 1024 -D/home/postgres/data -d 9 -o "-S
> > 4096 -s -d 9 -A"
> Are you still seeing this with current sources? I'm not able to
> replicate it here...
Yep..
It appears to die while making the index for serial.
Postmaster keeps running, but the current backend dies in pqReadData().
gdb and postmaster output below.
Ole Gjerde
gdb of core:
#0 0x4013a30a in _IO_default_xsputn (f=0xbf8006f4, data=0x81377e0, n=20) at genops.c:382
#1 0x40129980 in _IO_vfprintf (s=0xbf8006f4, format=0x81377e0 " COLUMNDEF :colname %s :typename ", ap=0xbf800c08)
atvfprintf.c:1048
#2 0x40137d16 in _IO_vsnprintf (string=0xbf8007f8 "", maxlen=1024, format=0x81377e0 " COLUMNDEF :colname %s
:typename", args=0xbf800c08) at vsnprintf.c:129
#3 0x809ccfb in appendStringInfo ()
#4 0x80b637b in _outColumnDef ()
#5 0x80b8107 in _outNode ()
#6 0x80b7d79 in _outNode ()
#7 0x80b7cab in _outConstraint ()
#8 0x80b84b7 in _outNode ()
#9 0x80b7d79 in _outNode ()
#10 0x80b63bb in _outColumnDef ()
#11 0x80b8107 in _outNode ()
#12 0x80b7d79 in _outNode ()
And this keeps going and going and going..
---------------------------------------------
postmaster log:
StartTransactionCommand
query: create table oletest (
id serial,
number int,
string varchar(255)
);
NOTICE: CREATE TABLE will create implicit sequence 'oletest_id_seq' for SERIAL column 'oletest.id'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'oletest_id_key' for table 'oletest'
parser outputs:
{ QUERY :command 5 :utility ? :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false
:unionall false :unique <> :sortClause <> :rtable <> :targetlist <> :qual <> :groupClause <> :havingQual
<> :hasAggs false :hasSubLinks false :unionClause <> :intersectClause <> :limitOffset <> :limitCount <>
:rowMark<> }
parser outputs:
bin/postmaster: reaping dead processes...
bin/postmaster: CleanupProc: pid 593 exited with status 139
bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
shmem_exit(0) [#0]
binding ShmemCreate(key=52e325, size=9343632)