You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Dong Li (JIRA)" <ji...@apache.org> on 2015/11/12 14:24:11 UTC
[jira] [Updated] (HAWQ-155) large tuple in
[ https://issues.apache.org/jira/browse/HAWQ-155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dong Li updated HAWQ-155:
-------------------------
Description:
This may occur when your cluster has more than one physical segments.
1. Set guc value "appendonly_split_write_size_mb"
hawq config -c appendonly_split_write_size_mb -v 2
2.Run sql
{code}
set default_segment_num=1;
create table eightbytleft_for_readsplit(str varchar) with (appendonly=true,blocksize=2097152,checksum=true);
insert into eightbytleft_for_readsplit select repeat('a',2097136*63-12-8);
insert into eightbytleft_for_readsplit select repeat('a',2097136*63-12-8);
select count(*) from eightbytleft_for_readsplit;
{code}
ERROR: Header checksum does not match. Expected 0x0 and found 0xA92A344A headerOffsetInFile is134217728 overallBlockLen is 0 (cdbappendonlystorageread.c:913) (seg0 test3:31100 pid=7878) (dispatcher.c:1700)
DETAIL:
Append-Only storage header kind 0 unknown
Scan of Append-Only Row-Oriented relation 'eightbytleft_for_readsplit'. Append-Only segment file 'hdfs://test5:9000/hawq/hawq-1447309068/16385/16532/17522/1', block header offset in file = 134217728, bufferCount 65
> large tuple in
> ---------------
>
> Key: HAWQ-155
> URL: https://issues.apache.org/jira/browse/HAWQ-155
> Project: Apache HAWQ
> Issue Type: Bug
> Reporter: Dong Li
> Assignee: Lei Chang
>
> This may occur when your cluster has more than one physical segments.
> 1. Set guc value "appendonly_split_write_size_mb"
> hawq config -c appendonly_split_write_size_mb -v 2
> 2.Run sql
> {code}
> set default_segment_num=1;
> create table eightbytleft_for_readsplit(str varchar) with (appendonly=true,blocksize=2097152,checksum=true);
> insert into eightbytleft_for_readsplit select repeat('a',2097136*63-12-8);
> insert into eightbytleft_for_readsplit select repeat('a',2097136*63-12-8);
> select count(*) from eightbytleft_for_readsplit;
> {code}
> ERROR: Header checksum does not match. Expected 0x0 and found 0xA92A344A headerOffsetInFile is134217728 overallBlockLen is 0 (cdbappendonlystorageread.c:913) (seg0 test3:31100 pid=7878) (dispatcher.c:1700)
> DETAIL:
> Append-Only storage header kind 0 unknown
> Scan of Append-Only Row-Oriented relation 'eightbytleft_for_readsplit'. Append-Only segment file 'hdfs://test5:9000/hawq/hawq-1447309068/16385/16532/17522/1', block header offset in file = 134217728, bufferCount 65
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)