[jira] [Commented] (HAWQ-232) Crash on INSERT into big partition table will cause a long time recovery

["Ming LI (JIRA)" <ji...@apache.org>]

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

Ming LI commented on HAWQ-232:
------------------------------

The previous fix will introduce bug https://issues.apache.org/jira/browse/HAWQ-812.

mmxlog not only include hdfs file/dir xlog, but also include heap xlog for standby node. Only hdfs file/dir can be skipped at recovery PASS3. 

> 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
>             Fix For: 2.0.0
>
>
> 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)