[jira] [Closed] (HAWQ-71) Cannot query pg_locks

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-71?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang closed HAWQ-71.
-------------------------

> Cannot query pg_locks
> ---------------------
>
>                 Key: HAWQ-71
>                 URL: https://issues.apache.org/jira/browse/HAWQ-71
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Dispatcher
>            Reporter: George Caragea
>            Assignee: Lirong Jian
>             Fix For: 2.0.0-beta-incubating
>
>
> On a devel build of HAWQ, I am trying to simply run a "select * from pg_locks". This hits an assertion in the devel build.
> {code}
> caragg=# select * from pg_locks;
> FATAL:  Unexpected internal error (dispatcher.c:437)
> DETAIL:  FailedAssertion("!(resource)", File: "dispatcher.c", Line: 437)
> HINT:  Process 57486 will wait for gp_debug_linger=120 seconds before termination.
> Note that its locks and other resources will not be released until then.
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> {code}
> Looking at the stack trace: 
> {code}
> gdb) bt
> #0  0x00000030514de2f3 in select () from /lib64/libc.so.6
> #1  0x0000000000b94570 in pg_usleep (microsec=5000000) at pgsleep.c:43
> #2  0x00000000009eb85c in elog_debug_linger (edata=0x118bfe0) at elog.c:4107
> #3  0x00000000009e3ed9 in errfinish (dummy=0) at elog.c:577
> #4  0x00000000009e262c in ExceptionalCondition (conditionName=0xe0b14e "!(resource)", errorType=0xe0b123 "FailedAssertion", fileName=0xe0b100 "dispatcher.c",
>     lineNumber=437) at assert.c:48
> #5  0x0000000000b889dc in initialize_dispatch_data (resource=0x0, dispatch_to_all_cached_executors=0 '\000') at dispatcher.c:437
> #6  0x0000000000b8c08a in dispatch_statement (stmt=0x7fff80626780, resource=0x0, result=0x7fff80626880) at dispatcher.c:1384
> #7  0x0000000000b8c352 in dispatch_statement_string (
>     string=0x283d010 "SELECT * FROM  pg_lock_status() L  (locktype text, database oid, relation oid, page int4, tuple int2, transactionid xid, classid oid, objid oid, objsubid int2, transaction xid, pid int4, mode text, gr"..., serializeQuerytree=0x0, serializeLenQuerytree=0, resource=0x0, result=0x7fff80626880,
>     sync_on_all_executors=0 '\000') at dispatcher.c:1443
> #8  0x0000000000962fcd in pg_lock_status (fcinfo=0x7fff80626af0) at lockfuncs.c:202
> #9  0x000000000072d834 in ExecMakeTableFunctionResult (funcexpr=0x28045c0, econtext=0x27bb418, expectedDesc=0x2803828, operatorMemKB=32768) at execQual.c:1965
> #10 0x0000000000755220 in FunctionNext (node=0x27baf68) at nodeFunctionscan.c:71
> #11 0x0000000000736483 in ExecScan (node=0x27baf68, accessMtd=0x7551ab <FunctionNext>) at execScan.c:110
> #12 0x0000000000755567 in ExecFunctionScan (node=0x27baf68) at nodeFunctionscan.c:143
> #13 0x0000000000728e07 in ExecProcNode (node=0x27baf68) at execProcnode.c:947
> #14 0x0000000000721dcc in ExecutePlan (estate=0x27ba9c8, planstate=0x27baf68, operation=CMD_SELECT, numberTuples=0, direction=ForwardScanDirection,
>     dest=0x7f573d574f58) at execMain.c:3186
> #15 0x000000000071de93 in ExecutorRun (queryDesc=0x27fd7a0, direction=ForwardScanDirection, count=0) at execMain.c:1182
> #16 0x00000000009061c1 in PortalRunSelect (portal=0x280c3a8, forward=1 '\001', count=0, dest=0x7f573d574f58) at pquery.c:1641
> #17 0x0000000000905d9e in PortalRun (portal=0x280c3a8, count=9223372036854775807, isTopLevel=1 '\001', dest=0x7f573d574f58, altdest=0x7f573d574f58,
>     completionTag=0x7fff80627670 "") at pquery.c:1463
> #18 0x00000000008fbe1c in exec_simple_query (query_string=0x25e0498 "select * from pg_locks;", seqServerHost=0x0, seqServerPort=-1) at postgres.c:1721
> #19 0x0000000000900a5c in PostgresMain (argc=4, argv=0x252ac80, username=0x252aad8 "caragg") at postgres.c:4691
> #20 0x00000000008a379f in BackendRun (port=0x24f1300) at postmaster.c:5845
> #21 0x00000000008a2c29 in BackendStartup (port=0x24f1300) at postmaster.c:5438
> #22 0x000000000089d2b5 in ServerLoop () at postmaster.c:2140
> #23 0x000000000089c378 in PostmasterMain (argc=9, argv=0x24db130) at postmaster.c:1432
> #24 0x00000000007b5e3e in main (argc=9, argv=0x24db130) at main.c:226
> {code}
> Looks like an issue during metadata collecting / dispatch. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)