[jira] [Updated] (HAWQ-512) Query hang due to deadlock in entrydb catalog access

["Ruilong Huo (JIRA)" <ji...@apache.org>]

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

Ruilong Huo updated HAWQ-512:
-----------------------------
    Affects Version/s: 2.0.0-beta-incubating

> Query hang due to deadlock in entrydb catalog access
> ----------------------------------------------------
>
>                 Key: HAWQ-512
>                 URL: https://issues.apache.org/jira/browse/HAWQ-512
>             Project: Apache HAWQ
>          Issue Type: Bug
>    Affects Versions: 2.0.0-beta-incubating
>            Reporter: zhenglin tao
>            Assignee: Lei Chang
>
> When entry database is involved in query with joins, it may hang due to deadlock while accessing catalog.
> {noformat}
> DROP TABLE IF EXISTS t;
> CREATE TABLE t (key INT, value INT) DISTRIBUTED RANDOMLY;
> INSERT INTO t VALUES (1, 0);
> CREATE OR REPLACE FUNCTION f()
> RETURNS VOID AS $$
>     sql = """ALTER TABLE t SET DISTRIBUTED BY (key)"""
>     plpy.execute(sql)
>     sql = """INSERT INTO t
>              SELECT t2.key, t2.value
>              FROM
>                  (SELECT key, value FROM t WHERE value = 0) AS t1,
>                  (SELECT generate_series(1, 2)::INT AS key, 0::INT AS value ) AS t2
>              WHERE t1.value = t2.value """
>     # plan = plpy.prepare(sql)
>     plpy.execute(sql)
> $$
> LANGUAGE plpythonu VOLATILE;
> -- Call of function f() hangs here
> SELECT f();
> {noformat}



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