SIGSEGV in 'select * from pg_user' - Mailing list pgsql-hackers

From Jeroen van Vianen
Subject SIGSEGV in 'select * from pg_user'
Date
Msg-id 35F2AE18.B46A0B1A@design.nl
Whole thread Raw
List pgsql-hackers
Hi,

I've found the following SISGEV while playing around with a snapshot of
September 3rd.

I did a make all (with -g); make install; rm -rf data; initdb

Here's what I've done in gdb:

[postgres@jeroenv bin]$ gdb postgres
GDB is free software and you are welcome to 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.
GDB 4.16 (i586-unknown-linux), Copyright 1996 Free Software Foundation,
Inc...
(gdb) run -D /usr/local/pgsql/data template1
Starting program: /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
template1

POSTGRES backend interactive interface
$Revision: 1.89 $ $Date: 1998/09/01 04:32:13 $
> select * from pg_shadow
blank
         1: usename     (typeid = 19, len = 32, typmod = -1, byval = f)
         2: usesysid    (typeid = 23, len = 4, typmod = -1, byval = t)
         3: usecreatedb (typeid = 16, len = 1, typmod = -1, byval = t)
         4: usetrace    (typeid = 16, len = 1, typmod = -1, byval = t)
         5: usesuper    (typeid = 16, len = 1, typmod = -1, byval = t)
         6: usecatupd   (typeid = 16, len = 1, typmod = -1, byval = t)
         7: passwd      (typeid = 25, len = -1, typmod = -1, byval = f)
         8: valuntil    (typeid = 702, len = 4, typmod = -1, byval = t)
        ----
         1: usename = "postgres"        (typeid = 19, len = 32, typmod =
-1, byval = f)
         2: usesysid = "203"    (typeid = 23, len = 4, typmod = -1,
byval = t)
         3: usecreatedb = "t"   (typeid = 16, len = 1, typmod = -1,
byval = t)
         4: usetrace = "t"      (typeid = 16, len = 1, typmod = -1,
byval = t)
         5: usesuper = "t"      (typeid = 16, len = 1, typmod = -1,
byval = t)
         6: usecatupd = "t"     (typeid = 16, len = 1, typmod = -1,
byval = t)
         8: valuntil = "Sat Jan 31 07:00:00 2037 MET"   (typeid = 702,
len = 4, typmod = -1, byval = t)
        ----

[So far, no problems]

> select * from pg_user
blank
         1: usename     (typeid = 19, len = 32, typmod = -1, byval = f)
         2: usesysid    (typeid = 23, len = 4, typmod = -1, byval = t)
         3: usecreatedb (typeid = 16, len = 1, typmod = -1, byval = t)
         4: usetrace    (typeid = 16, len = 1, typmod = -1, byval = t)
         5: usesuper    (typeid = 16, len = 1, typmod = -1, byval = t)
         6: usecatupd   (typeid = 16, len = 1, typmod = -1, byval = t)
         7: passwd      (typeid = 25, len = -1, typmod = -1, byval = f)
         8: valuntil    (typeid = 702, len = 4, typmod = -1, byval = t)
        ----
         1: usename = "postgres"        (typeid = 19, len = 32, typmod =
-1, byval = f)
         2: usesysid = "203"    (typeid = 23, len = 4, typmod = -1,
byval = t)
         3: usecreatedb = "t"   (typeid = 16, len = 1, typmod = -1,
byval = t)
         4: usetrace = "t"      (typeid = 16, len = 1, typmod = -1,
byval = t)
         5: usesuper = "t"      (typeid = 16, len = 1, typmod = -1,
byval = t)
         6: usecatupd = "t"     (typeid = 16, len = 1, typmod = -1,
byval = t)
         7: passwd = "********" (typeid = 25, len = -1, typmod = -1,
byval = f)
         8: valuntil = "Sat Jan 31 07:00:00 2037 MET"   (typeid = 702,
len = 4, typmod = -1, byval = t)
        ----

Program received signal SIGSEGV, Segmentation fault.
0x400e90eb in __libc_free (mem=0x400f9740)
(gdb) bt
#0  0x400e90eb in __libc_free (mem=0x400f9740)
#1  0x81cf188 in ?? ()


As the backtrace shows no clues, I've no idea where this goes wrong.
Note that the view pg_shadow goes OK.

select version() returns:
PostgreSQL 6.4.0 on i586-pc-linux-gnu, compiled by gcc 2.8.1

Anybody know what's going wrong (and where)?

Thanks,

Jeroen van Vianen

pgsql-hackers by date:

Previous
From: t-ishii@sra.co.jp (Tatsuo Ishii)
Date:
Subject: Re: [HACKERS] my office cam
Next
From: Metin Ozsavran
Date:
Subject: Field Level Locking Help???