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: