[ https://issues.apache.org/jira/browse/HAWQ-978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ming LI reassigned HAWQ-978: ---------------------------- Assignee: Ming LI (was: Lei Chang) > long running query got hang on master and can't be terminated > ------------------------------------------------------------- > > Key: HAWQ-978 > URL: https://issues.apache.org/jira/browse/HAWQ-978 > Project: Apache HAWQ > Issue Type: Bug > Reporter: Ming LI > Assignee: Ming LI > > One backend process on master had been running for several days and can't be > terminated. > The session is idle on all segments but master instance. > pstack/strace/back trace of the backend process. > {code} > [gpadmin@alpmdwgp1prd ~]$ pstack 423984 > Thread 2 (Thread 0x7f0457844700 (LWP 424026)): > #0 0x00007f04756670d3 in poll () from /lib64/libc.so.6 > #1 0x0000000000b90114 in rxThreadFunc () > #2 0x00007f0475e889d1 in start_thread () from /lib64/libpthread.so.0 > #3 0x00007f04756708fd in clone () from /lib64/libc.so.6 > Thread 1 (Thread 0x7f047862b720 (LWP 423984)): > #0 0x00007f047568005e in __lll_lock_wait_private () from /lib64/libc.so.6 > #1 0x00007f0475604dc0 in _L_lock_5199 () from /lib64/libc.so.6 > #2 0x00007f047560071b in _int_free () from /lib64/libc.so.6 > #3 0x0000000000b1be91 in gp_free2 () > #4 0x0000000000b10acc in AllocSetDelete () > #5 0x0000000000b1468b in MemoryContextDeleteImpl () > #6 0x0000000000aaf0f1 in RelationDestroyRelation () > #7 0x0000000000ab60f2 in RelationCacheInvalidate () > #8 0x0000000000aa9453 in InvalidateSystemCaches () > #9 0x0000000000937eeb in ReceiveSharedInvalidMessages () > #10 0x000000000093c295 in LockRelationOid () > #11 0x00000000004d8afd in heap_open () > #12 0x0000000000aa46d4 in SearchCatCache () > #13 0x00000000005c6512 in caql_getnext () > #14 0x0000000000749153 in sql_exec_error_callback () > #15 0x0000000000ad6e5a in errfinish () > #16 0x0000000000ad8ed9 in elog_finish () > #17 0x0000000000944e6b in handle_sig_alarm () > #18 <signal handler called> > #19 0x00007f047560168f in _int_malloc () from /lib64/libc.so.6 > #20 0x00007f04756026b1 in malloc () from /lib64/libc.so.6 > #21 0x0000000000b1c2c1 in gp_malloc () > #22 0x0000000000b1259c in AllocSetAlloc () > #23 0x0000000000b15f5d in MemoryContextAllocZeroImpl () > #24 0x0000000000b6cb4f in initMotionLayerStructs () > #25 0x00000000007275e0 in ExecutorStart () > #26 0x0000000000749a2e in fmgr_sql () > #27 0x000000000072e316 in ExecMakeFunctionResultNoSets () > #28 0x000000000072e129 in ExecMakeFunctionResultNoSets () > #29 0x0000000000733312 in ExecProject () > #30 0x00000000007602c7 in ExecHashJoin () > #31 0x000000000072ca84 in ExecProcNode () > #32 0x000000000076bf38 in ExecSort () > #33 0x000000000072caa6 in ExecProcNode () > #34 0x000000000072199c in ExecutePlan () > #35 0x00000000007221a8 in ExecutorRun () > #36 0x0000000000971e09 in PortalRun () > #37 0x0000000000966968 in exec_simple_query () > #38 0x0000000000969ab9 in PostgresMain () > #39 0x00000000008c707e in ServerLoop () > #40 0x00000000008c9e20 in PostmasterMain () > #41 0x00000000007c85af in main () > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)