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
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 |