[jira] [Commented] (HAWQ-273) Concurrent read committed SELECT return 0 rows for AO table which is ALTERed with REORGANIZE by other transaction

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/HAWQ-273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15069496#comment-15069496
 ] 

ASF GitHub Bot commented on HAWQ-273:
-------------------------------------

GitHub user liming01 opened a pull request:

    https://github.com/apache/incubator-hawq/pull/211

    HAWQ-273. Need re-fetch snapshot at planning stage

    Because data locality and hdfs metadata cache will fetch pg_aoseg meta data 
when planning, we need to re-fetch the latest snapshot.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/liming01/incubator-hawq mli/tx_alttbl_sel

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/211.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #211
    
----
commit a5b8c0af402d120895997da2686fc207b3cae22f
Author: Ming LI <m...@pivotal.io>
Date:   2015-12-23T10:28:29Z

    HAWQ-273. Need re-fetch snapshot at planning stage because data locality 
and hdfs metadata cache will fetch pg_aoseg data

----


> Concurrent read committed SELECT return 0 rows for AO table which is ALTERed 
> with REORGANIZE by other transaction
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: HAWQ-273
>                 URL: https://issues.apache.org/jira/browse/HAWQ-273
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Transaction
>            Reporter: Ming LI
>            Assignee: Ming LI
>
> testdb=# DROP TABLE tbl_isolation;
> DROP TABLE
> testdb=# CREATE TABLE tbl_isolation (a INT, b int, c int) WITH 
> (appendonly=true);
> CREATE TABLE
> testdb=# INSERT INTO tbl_isolation SELECT generate_series(1, 100000), 
> generate_series(1, 100000), generate_series(1, 100000);
> INSERT 0 100000
> •
> Thread A:
> testdb=# BEGIN transaction isolation level SERIALIZABLE;
> BEGIN
> testdb=# ALTER TABLE tbl_isolation set with ( reorganize='true') distributed 
> randomly;
> ALTER TABLE
> •
> Thread B:
> testdb=# BEGIN transaction isolation level read committed;
> BEGIN
> testdb=# select count(*) from tbl_isolation;
> •
> Thread A:
> testdb=# commit;
> COMMIT
> •
> •
> Thread B:
> testdb=# select count(*) from tbl_isolation;
> count
> -------
> 0
> (1 row)



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