[jira] [Commented] (HAWQ-1453) relation_close() report error at analyzeStmt(): is not owned by resource owner TopTransaction (resowner.c:814)
[ https://issues.apache.org/jira/browse/HAWQ-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16084933#comment-16084933 ] Vineet Goel commented on HAWQ-1453: --- [~liming01] - I think this JIRA can be resolved now, since you merged the PR. If that's correct, could you please Resolve this? Thanks > relation_close() report error at analyzeStmt(): is not owned by resource > owner TopTransaction (resowner.c:814) > -- > > Key: HAWQ-1453 > URL: https://issues.apache.org/jira/browse/HAWQ-1453 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Reporter: Ming LI >Assignee: Ming LI > Fix For: backlog > > > I created a simple MapReduce map-only program (to simulate a Spark executor, > like in the customer's environment) that uses JDBC through Postgresql Driver > (like the customer is doing) and I executed the queries the customer is > trying to execute. I can reproduce all the errors reported by customer. > 2017-04-28 03:50:38.299276 > IST,"gpadmin","gpadmin",p91745,th-609535712,"10.193.102.144","3228",2017-04-28 > 03:50:35 > IST,156637,con4578,cmd36,seg-1,,,x156637,sx1,"ERROR","XX000","relcache > reference e_event_1_0_102_1_prt_2 is not owned by resource owner > TopTransaction (resowner.c:814)",,"ANALYZE > mis_data_ig_account_details.e_event_1_0_102",0,,"resowner.c",814,"Stack trace: > 10x8ce4a8 postgres errstart + 0x288 > 20x8d022b postgres elog_finish + 0xab > 30x4ca654 postgres relation_close + 0x14 > 40x5e7508 postgres analyzeStmt + 0xd58 > 50x5e8b07 postgres analyzeStatement + 0x97 > 60x65c3bc postgres vacuum + 0x6c > 70x7f61e2 postgres ProcessUtility + 0x542 > 80x7f1cae postgres + 0x7f1cae > 90x7f348e postgres + 0x7f348e > 10 0x7f51f5 postgres PortalRun + 0x465 > 11 0x7ee268 postgres PostgresMain + 0x1908 > 12 0x7a0560 postgres + 0x7a0560 > 13 0x7a3329 postgres PostmasterMain + 0x759 > 14 0x4a5319 postgres main + 0x519 > 15 0x3a1661ed1d libc.so.6 __libc_start_main + 0xfd > 16 0x4a5399 postgres + 0x4a5399 > " -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HAWQ-1453) relation_close() report error at analyzeStmt(): is not owned by resource owner TopTransaction (resowner.c:814)
[ https://issues.apache.org/jira/browse/HAWQ-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15994580#comment-15994580 ] Ming LI commented on HAWQ-1453: --- Although we can support resource owner beyond transaction block now, but the relation opened at TopResourceOwner, while close at a new transaction resource owner. So when we close these relations, we need to firstly switch back to the TopResourceOwner. > relation_close() report error at analyzeStmt(): is not owned by resource > owner TopTransaction (resowner.c:814) > -- > > Key: HAWQ-1453 > URL: https://issues.apache.org/jira/browse/HAWQ-1453 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Reporter: Ming LI >Assignee: Ed Espino > Fix For: backlog > > > I created a simple MapReduce map-only program (to simulate a Spark executor, > like in the customer's environment) that uses JDBC through Postgresql Driver > (like the customer is doing) and I executed the queries the customer is > trying to execute. I can reproduce all the errors reported by customer. > 2017-04-28 03:50:38.299276 > IST,"gpadmin","gpadmin",p91745,th-609535712,"10.193.102.144","3228",2017-04-28 > 03:50:35 > IST,156637,con4578,cmd36,seg-1,,,x156637,sx1,"ERROR","XX000","relcache > reference e_event_1_0_102_1_prt_2 is not owned by resource owner > TopTransaction (resowner.c:814)",,"ANALYZE > mis_data_ig_account_details.e_event_1_0_102",0,,"resowner.c",814,"Stack trace: > 10x8ce4a8 postgres errstart + 0x288 > 20x8d022b postgres elog_finish + 0xab > 30x4ca654 postgres relation_close + 0x14 > 40x5e7508 postgres analyzeStmt + 0xd58 > 50x5e8b07 postgres analyzeStatement + 0x97 > 60x65c3bc postgres vacuum + 0x6c > 70x7f61e2 postgres ProcessUtility + 0x542 > 80x7f1cae postgres + 0x7f1cae > 90x7f348e postgres + 0x7f348e > 10 0x7f51f5 postgres PortalRun + 0x465 > 11 0x7ee268 postgres PostgresMain + 0x1908 > 12 0x7a0560 postgres + 0x7a0560 > 13 0x7a3329 postgres PostmasterMain + 0x759 > 14 0x4a5319 postgres main + 0x519 > 15 0x3a1661ed1d libc.so.6 __libc_start_main + 0xfd > 16 0x4a5399 postgres + 0x4a5399 > " -- This message was sent by Atlassian JIRA (v6.3.15#6346)