[
https://issues.apache.org/jira/browse/HAWQ-232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15046329#comment-15046329
]
ASF GitHub Bot commented on HAWQ-232:
-------------------------------------
GitHub user liming01 opened a pull request:
https://github.com/apache/incubator-hawq/pull/167
HAWQ-232: recovery Pass3 do not need to redo all relfile and relation dir
create/drop for on flight transaction
Because all persistent table state and relation dir and relfile on hdfs are
keep in consistent status at recovery PASS2, so recovery Pass3 do not need to
redo all relfile and relation dir create/drop for on flight transaction.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/liming01/incubator-hawq mli/pass3skipRedo
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/167.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 #167
----
commit a136d081bfff835610209f43dfae8256a90a20a4
Author: Ming LI <[email protected]>
Date: 2015-12-07T11:02:36Z
HAWQ-232: recovery Pass3 do not need to redo all relfile and relation dir
create/drop for on flight transaction
----
> Crash on INSERT into big partition table will cause a long time recovery
> ------------------------------------------------------------------------
>
> Key: HAWQ-232
> URL: https://issues.apache.org/jira/browse/HAWQ-232
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Transaction
> Reporter: Ming LI
> Assignee: Ming LI
>
> The sample testcase is below:
> DROP TABLE integer_part1;
> CREATE TABLE integer_part1 (a int, b int, c int)
> WITH (appendonly=true, compresslevel=5)
> partition by range (a)
> (
> partition aa start (0) end (1000) every (1)
> );
> CHECKPOINT;
> insert into integer_part1 select i,i,i from generate_series(0, 999) i;
> -- run shell: killall -9 postgres
> -- Then restart hawq.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
