Re: Insert fail: could not open relation with OID 3221204992

From: araza(at)esri(dot)com
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgresql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert fail: could not open relation with OID 3221204992
Date: 2007-03-26 23:44:05
Message-ID: 7CAD6D9B7D16BC4A88795771E48650820543772D@pianowire.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)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(at)esri(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yang 2007-03-27 00:19:25 Re: PG over NFS
Previous Message Yang 2007-03-26 23:29:42 Re: PG over NFS