Re: Insert fail: could not open relation with OID 3221204992 - Mailing list pgsql-general

From araza@esri.com
Subject Re: Insert fail: could not open relation with OID 3221204992
Date
Msg-id 7CAD6D9B7D16BC4A88795771E48650820543772D@pianowire.esri.com
Whole thread Raw
In response to Re: Insert fail: could not open relation with OID 3221204992  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Insert fail: could not open relation with OID 3221204992  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Same results with -O0 option.

Breakpoint 1, ST_Geometry_Recv (fcinfo=0xbfffd4d0) at binary.c:138
138     in binary.c
(gdb) bt
#0  ST_Geometry_Recv (fcinfo=0xbfffd4d0) at binary.c:138
#1  0x08209ebd in ReceiveFunctionCall ()
#2  0x08209fde in OidReceiveFunctionCall ()
#3  0x0819a5a0 in exec_bind_message ()
#4  0x0819c6e6 in PostgresMain ()
#5  0x0817a4d9 in BackendRun ()
#6  0x08179e03 in BackendStartup ()
#7  0x0817825f in ServerLoop ()
#8  0x0817785b in PostmasterMain ()
#9  0x0813fd1c in main ()
(gdb) p *src_buf
$3 = {data = 0xff0c8d8b <Address 0xff0c8d8b out of bounds>, len =
-1031143425, maxlen = -13595335, cursor = 158662655}
(gdb) n
0x0819c4f8 in PostgresMain ()
(gdb) p *src_buf
No symbol "src_buf" in current context.
(gdb) bt
#0  0x0819c4f8 in PostgresMain ()
#1  0x0817a4d9 in BackendRun ()
#2  0x08179e03 in BackendStartup ()
#3  0x0817825f in ServerLoop ()
#4  0x0817785b in PostmasterMain ()
#5  0x0813fd1c in main ()
(gdb) c

Ale.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, March 23, 2007 4:08 PM
To: Ale Raza
Cc: postgresql-general
Subject: Re: [GENERAL] Insert fail: could not open relation with OID
3221204992

"Ale Raza" <araza@esri.com> writes:
> Breakpoint 1, ST_Geometry_Recv (fcinfo=0xbfffcb90) at binary.c:138
> 138             StringInfo src_buf = (StringInfo)
PG_DETOAST_DATUM(PG_GETARG_DATUM(0));
> (gdb) p *src_buf
> $4 = {data = 0xff0c8d8b <Address 0xff0c8d8b out of bounds>, len =
-1031143425, maxlen = -13595335, cursor = 158662655}
> (gdb) n
> 0x0819c4f8 in PostgresMain ()
> (gdb) p *src_buf
> No symbol "src_buf" in current context.

Try recompiling with a lower optimization level (maybe even -O0) so you
can debug.  gdb sometimes gets confused by optimized code...

            regards, tom lane


pgsql-general by date:

Previous
From: "Yang"
Date:
Subject: Re: PG over NFS
Next
From: "Yang"
Date:
Subject: Re: PG over NFS