altertable.trace

[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=0x7ffa08c71638) at ../sysdeps/nptl/futex-internal.h:323
#0  futex_abstimed_wait_cancelable (private=128, abstime=0x0, clockid=0, expected=0, futex_word=0x7ffa08c71638) at ../sysdeps/nptl/futex-internal.h:323
#1  do_futex_wait (sem=sem@entry=0x7ffa08c71638, abstime=0x0, clockid=0) at sem_waitcommon.c:112
#2  0x00007ffa1431f278 in __new_sem_wait_slow (sem=sem@entry=0x7ffa08c71638, abstime=0x0, clockid=0) at sem_waitcommon.c:184
#3  0x00007ffa1431f2f1 in __new_sem_wait (sem=sem@entry=0x7ffa08c71638) at sem_wait.c:42
#4  0x0000559d61cfe5a0 in PGSemaphoreLock (sema=0x7ffa08c71638) 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=0x559d630fd4a0, lockMethodTable=lockMethodTable@entry=0x559d621f0ca0 <default_lockmethod>) at proc.c:1292
#8  0x0000559d61d90dae in WaitOnLock (locallock=locallock@entry=0x559d630fd4a0, owner=owner@entry=0x559d6307b488) at lock.c:1819
#9  0x0000559d61d927fa in LockAcquireExtended (locktag=locktag@entry=0x7ffec414b400, lockmode=lockmode@entry=3, sessionLock=sessionLock@entry=false, dontWait=dontWait@entry=false, reportMemoryError=reportMemoryError@entry=true, locallockp=locallockp@entry=0x7ffec414b3f8) at lock.c:1083
#10 0x0000559d61d8ee6e in LockRelationOid (relid=1259, lockmode=3) at lmgr.c:117
#11 0x0000559d619b21c0 in relation_open (relationId=relationId@entry=1259, lockmode=lockmode@entry=3) at relation.c:56
#12 0x0000559d61a52bd3 in table_open (relationId=relationId@entry=1259, lockmode=lockmode@entry=3) at table.c:44
#13 0x0000559d61abaaf4 in RemoveConstraintById (conId=<optimized out>) at pg_constraint.c:892
#14 0x0000559d61a9bba1 in doDeletion (object=object@entry=0x559d6317cc88, flags=flags@entry=0) at dependency.c:1443
#15 0x0000559d61a9bcbf in deleteOneObject (object=0x559d6317cc88, depRel=depRel@entry=0x7ffec414b678, flags=flags@entry=0) at dependency.c:1323
#16 0x0000559d61a9bea2 in deleteObjectsInList (targetObjects=targetObjects@entry=0x559d6317c618, depRel=depRel@entry=0x7ffec414b678, flags=flags@entry=0) at dependency.c:284
#17 0x0000559d61a9bf67 in performDeletion (object=object@entry=0x7ffec414b808, behavior=behavior@entry=DROP_RESTRICT, flags=flags@entry=0) at dependency.c:369
#18 0x0000559d61b8eb81 in dropconstraint_internal (rel=rel@entry=0x7ffa08ad6250, constraintTup=<optimized out>, behavior=behavior@entry=DROP_RESTRICT, recurse=recurse@entry=true, recursing=recursing@entry=false, missing_ok=missing_ok@entry=false, readyRels=0x7ffec414b888, lockmode=8) at tablecmds.c:12443
#19 0x0000559d61b8fb9c in ATExecDropConstraint (rel=rel@entry=0x7ffa08ad6250, constrName=0x559d631666a8 "ac_check", behavior=DROP_RESTRICT, recurse=<optimized out>, recursing=recursing@entry=false, missing_ok=<optimized out>, lockmode=8) at tablecmds.c:12317
#20 0x0000559d61b96c2e in ATExecCmd (wqueue=wqueue@entry=0x7ffec414baa8, tab=tab@entry=0x559d630f11c0, cmd=<optimized out>, lockmode=lockmode@entry=8, cur_pass=cur_pass@entry=0, context=context@entry=0x7ffec414bb80) at tablecmds.c:5256
#21 0x0000559d61b97118 in ATRewriteCatalogs (wqueue=wqueue@entry=0x7ffec414baa8, lockmode=lockmode@entry=8, context=context@entry=0x7ffec414bb80) at ../../../src/include/nodes/nodes.h:193
#22 0x0000559d61b97356 in ATController (parsetree=parsetree@entry=0x559d62fed110, rel=rel@entry=0x7ffa08ad6250, cmds=0x559d62fed0c0, recurse=<optimized out>, lockmode=lockmode@entry=8, context=context@entry=0x7ffec414bb80) at tablecmds.c:4666
#23 0x0000559d61b973c7 in AlterTable (stmt=stmt@entry=0x559d62fed110, lockmode=lockmode@entry=8, context=context@entry=0x7ffec414bb80) at tablecmds.c:4321
#24 0x0000559d61db153c in ProcessUtilitySlow (pstate=pstate@entry=0x559d630f10b0, pstmt=pstmt@entry=0x559d62fed1c0, queryString=queryString@entry=0x559d62fec600 "alter table bc drop constraint ac_check;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x559d62fed480, qc=0x7ffec414c0c0) at utility.c:1329
#25 0x0000559d61db0fe2 in standard_ProcessUtility (pstmt=0x559d62fed1c0, queryString=0x559d62fec600 "alter table bc drop constraint ac_check;", readOnlyTree=<optimized out>, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x559d62fed480, qc=0x7ffec414c0c0) at utility.c:1078
#26 0x0000559d61db109a in ProcessUtility (pstmt=pstmt@entry=0x559d62fed1c0, queryString=<optimized out>, readOnlyTree=<optimized out>, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=<optimized out>, queryEnv=<optimized out>, dest=0x559d62fed480, qc=0x7ffec414c0c0) at utility.c:530
#27 0x0000559d61dae5bd in PortalRunUtility (portal=portal@entry=0x559d630660e0, pstmt=pstmt@entry=0x559d62fed1c0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x559d62fed480, qc=qc@entry=0x7ffec414c0c0) at pquery.c:1158
#28 0x0000559d61dae8ae in PortalRunMulti (portal=portal@entry=0x559d630660e0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x559d62fed480, altdest=altdest@entry=0x559d62fed480, qc=qc@entry=0x7ffec414c0c0) at pquery.c:1315
#29 0x0000559d61daec9f in PortalRun (portal=portal@entry=0x559d630660e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x559d62fed480, altdest=altdest@entry=0x559d62fed480, qc=0x7ffec414c0c0) at pquery.c:791
#30 0x0000559d61daae6d in exec_simple_query (query_string=query_string@entry=0x559d62fec600 "alter table bc drop constraint ac_check;") at postgres.c:1275
#31 0x0000559d61dacd28 in PostgresMain (dbname=<optimized out>, username=<optimized out>) at postgres.c:4641
#32 0x0000559d61d083e0 in BackendRun (port=port@entry=0x559d63016fd0) at postmaster.c:4435
#33 0x0000559d61d0b385 in BackendStartup (port=port@entry=0x559d63016fd0) at postmaster.c:4163
#34 0x0000559d61d0b524 in ServerLoop () at postmaster.c:1777
#35 0x0000559d61d0ca1d in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559d62fe5bb0) at postmaster.c:1461
#36 0x0000559d61c2a03c in main (argc=8, argv=0x559d62fe5bb0) at main.c:198
[Inferior 1 (process 3243657) detached]