delete.trace

application/octet-stream

Filename: delete.trace
Type: application/octet-stream
Part: 1
Message: Re: RFC: Logging plan of the running query
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c71738) at ../sysdeps/nptl/futex-internal.h:323
#0  futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c71738) at ../sysdeps/nptl/futex-internal.h:323
#1  do_futex_wait (sem=sem@entry=0x7ffa08c71738, abstime=0x0, clockid=0) at sem_waitcommon.c:112
#2  0x00007ffa1431f278 in __new_sem_wait_slow (sem=sem@entry=0x7ffa08c71738, abstime=0x0, clockid=0) at sem_waitcommon.c:184
#3  0x00007ffa1431f2f1 in __new_sem_wait (sem=sem@entry=0x7ffa08c71738) at sem_wait.c:42
#4  0x0000559d61cfe5a0 in PGSemaphoreLock (sema=0x7ffa08c71738) at pg_sema.c:327
#5  0x0000559d61d96ee1 in LWLockAcquire (lock=0x7ffa08c7a980, mode=mode@entry=LW_EXCLUSIVE) at lwlock.c:1314
#6  0x0000559d61d9e83c in CheckDeadLock () at proc.c:1700
#7  0x0000559d61da02b2 in ProcSleep (locallock=locallock@entry=0x559d63013510, lockMethodTable=lockMethodTable@entry=0x559d621f0ca0 <default_lockmethod>) at proc.c:1292
#8  0x0000559d61d90dae in WaitOnLock (locallock=locallock@entry=0x559d63013510, owner=owner@entry=0x559d6307a968) at lock.c:1819
#9  0x0000559d61d927fa in LockAcquireExtended (locktag=locktag@entry=0x7ffec414ba90, lockmode=lockmode@entry=1, sessionLock=sessionLock@entry=false, dontWait=dontWait@entry=false, reportMemoryError=reportMemoryError@entry=true, locallockp=locallockp@entry=0x7ffec414ba88) at lock.c:1083
#10 0x0000559d61d8ee6e in LockRelationOid (relid=1259, lockmode=1) at lmgr.c:117
#11 0x0000559d619b21c0 in relation_open (relationId=1259, lockmode=lockmode@entry=1) at relation.c:56
#12 0x0000559d61a52bd3 in table_open (relationId=<optimized out>, lockmode=lockmode@entry=1) at table.c:44
#13 0x0000559d61ed4c24 in SearchCatCacheMiss (cache=cache@entry=0x559d6305ac80, nkeys=nkeys@entry=2, hashValue=hashValue@entry=1798983317, hashIndex=hashIndex@entry=21, v1=v1@entry=94134459092936, v2=v2@entry=11, v3=0, v4=0) at catcache.c:1355
#14 0x0000559d61ed4f3c in SearchCatCacheInternal (cache=0x559d6305ac80, nkeys=2, v1=v1@entry=94134459092936, v2=11, v3=v3@entry=0, v4=v4@entry=0) at catcache.c:1297
#15 0x0000559d61ed5a27 in SearchCatCache (cache=<optimized out>, v1=v1@entry=94134459092936, v2=<optimized out>, v3=v3@entry=0, v4=v4@entry=0) at catcache.c:1151
#16 0x0000559d61ee98f1 in SearchSysCache (cacheId=cacheId@entry=54, key1=key1@entry=94134459092936, key2=<optimized out>, key3=key3@entry=0, key4=key4@entry=0) at syscache.c:816
#17 0x0000559d61ee9af5 in GetSysCacheOid (cacheId=cacheId@entry=54, oidcol=oidcol@entry=1, key1=key1@entry=94134459092936, key2=<optimized out>, key3=key3@entry=0, key4=key4@entry=0) at syscache.c:940
#18 0x0000559d61ed9913 in get_relname_relid (relname=relname@entry=0x559d62fecfc8 "ro_view2", relnamespace=<optimized out>) at lsyscache.c:1891
#19 0x0000559d61aa7c2a in RelnameGetRelid (relname=0x559d62fecfc8 "ro_view2") at namespace.c:676
#20 0x0000559d61aa91c2 in RangeVarGetRelidExtended (relation=relation@entry=0x559d62fecfe8, lockmode=lockmode@entry=3, flags=flags@entry=1, callback=callback@entry=0x0, callback_arg=callback_arg@entry=0x0) at namespace.c:319
#21 0x0000559d619b23ea in relation_openrv_extended (relation=relation@entry=0x559d62fecfe8, lockmode=lockmode@entry=3, missing_ok=missing_ok@entry=true) at relation.c:186
#22 0x0000559d61a52d97 in table_openrv_extended (relation=relation@entry=0x559d62fecfe8, lockmode=lockmode@entry=3, missing_ok=missing_ok@entry=true) at table.c:108
#23 0x0000559d61b086af in parserOpenTable (pstate=pstate@entry=0x559d62fed108, relation=relation@entry=0x559d62fecfe8, lockmode=lockmode@entry=3) at parse_relation.c:1424
#24 0x0000559d61aee042 in setTargetTable (pstate=pstate@entry=0x559d62fed108, relation=0x559d62fecfe8, inh=<optimized out>, alsoSource=alsoSource@entry=true, requiredPerms=requiredPerms@entry=8) at parse_clause.c:209
#25 0x0000559d61acb12e in transformDeleteStmt (pstate=0x559d62fed108, stmt=0x559d62fed038) at analyze.c:528
#26 0x0000559d61ace296 in transformStmt (pstate=pstate@entry=0x559d62fed108, parseTree=parseTree@entry=0x559d62fed038) at analyze.c:353
#27 0x0000559d61acf59a in transformOptionalSelectInto (pstate=pstate@entry=0x559d62fed108, parseTree=0x559d62fed038) at analyze.c:306
#28 0x0000559d61acf5d2 in transformTopLevelStmt (pstate=pstate@entry=0x559d62fed108, parseTree=parseTree@entry=0x559d62fed088) at analyze.c:256
#29 0x0000559d61acf640 in parse_analyze_fixedparams (parseTree=parseTree@entry=0x559d62fed088, sourceText=sourceText@entry=0x559d62fec600 "DELETE FROM ro_view2;", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at analyze.c:124
#30 0x0000559d61daa5dc in pg_analyze_and_rewrite_fixedparams (parsetree=parsetree@entry=0x559d62fed088, query_string=query_string@entry=0x559d62fec600 "DELETE FROM ro_view2;", paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at postgres.c:689
#31 0x0000559d61daad61 in exec_simple_query (query_string=query_string@entry=0x559d62fec600 "DELETE FROM ro_view2;") at postgres.c:1191
#32 0x0000559d61dacd28 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4641
#33 0x0000559d61d083e0 in BackendRun (port=port@entry=0x559d63016fd0) at postmaster.c:4435
#34 0x0000559d61d0b385 in BackendStartup (port=port@entry=0x559d63016fd0) at postmaster.c:4163
#35 0x0000559d61d0b524 in ServerLoop () at postmaster.c:1777
#36 0x0000559d61d0ca1d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559d62fe5bb0) at postmaster.c:1461
#37 0x0000559d61c2a03c in main (argc=8, argv=0x559d62fe5bb0) at main.c:198
[Inferior 1 (process 3243656) detached]