SIGSEGV in 'select * from pg_user'

From: Jeroen van Vianen <jeroenv(at)design(dot)nl>
To: pgsql-hackers(at)hub(dot)org
Subject: SIGSEGV in 'select * from pg_user'
Date: 1998-09-06 15:45:28
Message-ID: 35F2AE18.B46A0B1A@design.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Metin Ozsavran 1998-09-06 21:00:41 Field Level Locking Help???
Previous Message Tatsuo Ishii 1998-09-06 14:06:29 Re: [HACKERS] my office cam