Thread: easy crash on HEAD

I am pretty sure this is an easily-reproducible crash on git head
(well, as of a2a480af889b5), helpfully confirmed on IRC by wulczer and
deko. I reproduced the crash myself on OS X and 64-bit Debian.

---
create table foo (a int);
CREATE RULE notify_foo_updates AS ON UPDATE TO foo DO NOTIFY foo;
\d foo
---

Backtrace looks like this:
(gdb) bt
#0  0x00007fff837ce954 in recvfrom ()
#1  0x0000000100188fe3 in secure_read (port=0x100802280,
ptr=0x10055d340, len=8192) at be-secure.c:304
#2  0x0000000100191bdc in pq_recvbuf () at pqcomm.c:854
#3  0x0000000100192053 in pq_getbyte () at pqcomm.c:895
#4  0x0000000100257fec in SocketBackend [inlined] () at
/media/src/OSS/postgresql/src/backend/tcop/postgres.c:344
#5  0x0000000100257fec in ReadCommand (inBuf=0x7fff5fbfe0d0) at postgres.c:492
#6  0x0000000100258746 in PostgresMain (argc=1, argv=0x10101a010,
dbname=0x101019e78 "adsync", username=<value temporarily unavailable,
due to optimizations>) at postgres.c:3946
#7  0x0000000100204a95 in BackendRun [inlined] () at
/media/src/OSS/postgresql/src/backend/postmaster/postmaster.c:3985
#8  0x0000000100204a95 in ServerLoop () at postmaster.c:3674
#9  0x00000001002083d4 in PostmasterMain (argc=3, argv=0x100800700) at
postmaster.c:1244
#10 0x0000000100194089 in main (argc=3, argv=0x100800700) at main.c:196


Josh

On Thu, May 16, 2013 at 3:33 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> Backtrace looks like this:

My mistake -- the last backtrace was from an idle client before the
crash. Thank you andres and wulczer for the correction. Here is the
interesting one:

(gdb) bt
#0  has_unnamed_full_join_using (jtnode=0x0) at ruleutils.c:2647
#1  0x00000001002c65ef in set_deparse_for_query (dpns=0x7fff5fbfd6c0,
query=0x101117090, parent_namespaces=<value temporarily unavailable,
due to optimizations>) at ruleutils.c:2568
#2  0x00000001002c7b2b in get_query_def (query=0x101117090,
buf=0x7fff5fbfd880, parentnamespace=0x0, resultDesc=0x0,
prettyFlags=3, wrapColumn=0, startIndent=0) at ruleutils.c:3997
#3  0x00000001002d10f2 in pg_get_ruledef_worker (ruleoid=<value
temporarily unavailable, due to optimizations>, prettyFlags=3) at
ruleutils.c:3888
#4  0x00000001002d12da in pg_get_ruledef_ext (fcinfo=<value
temporarily unavailable, due to optimizations>) at ruleutils.c:434
#5  0x000000010016327a in ExecMakeFunctionResult (fcache=0x101100a80,
econtext=0x101100068, isNull=0x101100618 "", isDone=<value temporarily
unavailable, due to optimizations>) at execQual.c:1938
#6  0x000000010015f92d in ExecEvalFuncArgs (fcinfo=0x1011002d8,
argList=<value temporarily unavailable, due to optimizations>,
econtext=0x101100068) at execQual.c:1478
#7  0x0000000100162e75 in ExecMakeFunctionResult (fcache=0x101100268,
econtext=0x101100068, isNull=0x101102321 "", isDone=0x101102494) at
execQual.c:1709
#8  0x000000010015f5da in ExecTargetList [inlined] () at
/media/src/OSS/postgresql/src/backend/executor/execQual.c:5240
#9  0x000000010015f5da in ExecProject (projInfo=<value temporarily
unavailable, due to optimizations>, isDone=0x7fff5fbfdc2c) at
execQual.c:5455
#10 0x0000000100166f9b in ExecScan (node=0x1010fff50,
accessMtd=0x100173cd0 <IndexNext>, recheckMtd=0x100173c80
<IndexRecheck>) at execScan.c:207
#11 0x000000010015efc8 in ExecProcNode (node=0x1010fff50) at execProcnode.c:404
#12 0x000000010015d97e in ExecutePlan [inlined] () at
/media/src/OSS/postgresql/src/backend/executor/execMain.c:1450
#13 0x000000010015d97e in standard_ExecutorRun (queryDesc=0x101109a38,
direction=<value temporarily unavailable, due to optimizations>,
count=0) at execMain.c:306
#14 0x000000010025a3a7 in PortalRunSelect (portal=0x101039638,
forward=<value temporarily unavailable, due to optimizations>,
count=0, dest=<value temporarily unavailable, due to optimizations>)
at pquery.c:944
#15 0x000000010025bde7 in PortalRun (portal=0x101039638,
count=9223372036854775807, isTopLevel=1 '\001', dest=0x1010f1908,
altdest=0x1010f1908, completionTag=0x7fff5fbfdeb0 "") at pquery.c:788
#16 0x0000000100257a8a in exec_simple_query (query_string=0x101031238
"SELECT r.rulename, trim(trailing ';' from
pg_catalog.pg_get_ruledef(r.oid, true)), ev_enabled\nFROM
pg_catalog.pg_rewrite r\nWHERE r.ev_class = '40964' ORDER BY 1;") at
postgres.c:1048
#17 0x0000000100259498 in PostgresMain (argc=1, argv=0x101040740,
dbname=0x1010405a8 "test", username=<value temporarily unavailable,
due to optimizations>) at postgres.c:3985
#18 0x0000000100204a95 in BackendRun [inlined] () at
/media/src/OSS/postgresql/src/backend/postmaster/postmaster.c:3985
#19 0x0000000100204a95 in ServerLoop () at postmaster.c:3674
#20 0x00000001002083d4 in PostmasterMain (argc=3, argv=0x100800700) at
postmaster.c:1244
#21 0x0000000100194089 in main (argc=3, argv=0x100800700) at main.c:196

Josh

Josh Kupershmidt <schmiddy@gmail.com> writes:
> I am pretty sure this is an easily-reproducible crash on git head
> (well, as of a2a480af889b5), helpfully confirmed on IRC by wulczer and
> deko. I reproduced the crash myself on OS X and 64-bit Debian.

> create table foo (a int);
> CREATE RULE notify_foo_updates AS ON UPDATE TO foo DO NOTIFY foo;
> \d foo

Thanks, will fix.

            regards, tom lane