gpdb icon indicating copy to clipboard operation
gpdb copied to clipboard

Published 20 hours ago • verified publisher icon greenplum-db

ignore_checksum_failure not works

Open cobolbaby opened this issue 2 years ago • 1 comments

Bug Report

Greenplum version or build

  • 6.25.3

OS version and uname -a

autoconf options used ( config.status --config )

Installation information ( pg_config )

Expected behavior

When I face issues such as disk bad blocks, I need to recover data as much as possible. However, I have found that the configuration ignore_checksum_failure in the latest version does not seem to work.

Actual behavior

[gpadmin@gp6mdw greenplum]$ psql F6_BDC
psql (9.4.26)
Type "help" for help.

F6_BDC=# select count(1) from mes.pcbcomponenttrace_1_prt_82;
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg9 slice1 172.17.239.212:40001 pid=3916222)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg0 slice1 172.17.239.210:40000 pid=3986004)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg0 slice1 172.17.239.210:40000 pid=3986004)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg1 slice1 172.17.239.210:40001 pid=3986005)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg1 slice1 172.17.239.210:40001 pid=3986005)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg2 slice1 172.17.239.210:40002 pid=3986007)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg2 slice1 172.17.239.210:40002 pid=3986007)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg3 slice1 172.17.239.210:40003 pid=3986006)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg3 slice1 172.17.239.210:40003 pid=3986006)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg4 slice1 172.17.239.211:40000 pid=4027879)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg4 slice1 172.17.239.211:40000 pid=4027879)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg5 slice1 172.17.239.211:40001 pid=4027878)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg5 slice1 172.17.239.211:40001 pid=4027878)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg6 slice1 172.17.239.211:40002 pid=4027880)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg6 slice1 172.17.239.211:40002 pid=4027880)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg7 slice1 172.17.239.211:40003 pid=4027881)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg7 slice1 172.17.239.211:40003 pid=4027881)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg8 slice1 172.17.239.212:40000 pid=3916219)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg8 slice1 172.17.239.212:40000 pid=3916219)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg10 slice1 172.17.239.212:40002 pid=3916220)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg10 slice1 172.17.239.212:40002 pid=3916220)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg11 slice1 172.17.239.212:40003 pid=3916221)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg11 slice1 172.17.239.212:40003 pid=3916221)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg12 slice1 172.17.239.217:40000 pid=3983097)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg12 slice1 172.17.239.217:40000 pid=3983097)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg13 slice1 172.17.239.217:40001 pid=3983098)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg13 slice1 172.17.239.217:40001 pid=3983098)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg14 slice1 172.17.239.217:40002 pid=3983099)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg14 slice1 172.17.239.217:40002 pid=3983099)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg15 slice1 172.17.239.217:40003 pid=3983100)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg15 slice1 172.17.239.217:40003 pid=3983100)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg16 slice1 172.17.239.218:40000 pid=4009692)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg16 slice1 172.17.239.218:40000 pid=4009692)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg17 slice1 172.17.239.218:40001 pid=4009693)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg17 slice1 172.17.239.218:40001 pid=4009693)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg18 slice1 172.17.239.218:40002 pid=4009694)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg18 slice1 172.17.239.218:40002 pid=4009694)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg19 slice1 172.17.239.218:40003 pid=4009695)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;  (seg19 slice1 172.17.239.218:40003 pid=4009695)
LOG:  An exception was encountered during the execution of statement: select count(1) from mes.pcbcomponenttrace_1_prt_82;
ERROR:  block checksum does not match, expected 0x7D1D4480 and found 0x0F3EDB11  (seg9 slice1 172.17.239.212:40001 pid=3916222)
DETAIL:  Append-Only storage Small Content header: smallcontent_bytes_0_3 0x1900E406, smallcontent_bytes_4_7 0x3400DE8, headerKind = 1, executorBlockKind = 1, rowCount = 57, usingChecksums = true, header checksum 0xADA13539, block checksum 0x7D1D4480, dataLength 12314, compressedLength 3560, overallBlockLen 3576
CONTEXT:  Scan of Append-Only Row-Oriented relation 'pcbcomponenttrace_1_prt_82'. Append-Only segment file 'pg_tblspc/103535299/GPDB_6_301908232/863243/97546314.1', block header offset in file = 373008744, bufferCount 77200

[gpadmin@gp6mdw greenplum]$ gpconfig -s ignore_checksum_failure
Values on all segments are consistent
GUC          : ignore_checksum_failure
Master  value: off
Segment value: off
[gpadmin@gp6mdw greenplum]$ gpconfig -c ignore_checksum_failure -v on
20231127:10:45:46:3623652 gpconfig:gp6mdw:gpadmin-[INFO]:-completed successfully with parameters '-c ignore_checksum_failure -v on'
[gpadmin@gp6mdw greenplum]$ gpstop -u
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Starting gpstop with args: -u
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Gathering information and validating the environment...
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Obtaining Segment details from master...
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.25.3 build commit:367edc6b4dfd909fe38fc288ade9e294d74e3f9a'
20231127:10:46:13:3623878 gpstop:gp6mdw:gpadmin-[INFO]:-Signalling all postmaster processes to reload
[gpadmin@gp6mdw greenplum]$ gpconfig -s ignore_checksum_failure
Values on all segments are consistent
GUC          : ignore_checksum_failure
Master  value: on
Segment value: on
[gpadmin@gp6mdw greenplum]$ psql F6_BDC
psql (9.4.26)
Type "help" for help.

F6_BDC=# create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;
NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy entry.
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg9 slice1 172.17.239.212:40001 pid=3903773)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg0 slice1 172.17.239.210:40000 pid=3973545)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg0 slice1 172.17.239.210:40000 pid=3973545)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg1 slice1 172.17.239.210:40001 pid=3973546)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg1 slice1 172.17.239.210:40001 pid=3973546)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg2 slice1 172.17.239.210:40002 pid=3973547)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg2 slice1 172.17.239.210:40002 pid=3973547)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg3 slice1 172.17.239.210:40003 pid=3973548)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg3 slice1 172.17.239.210:40003 pid=3973548)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg4 slice1 172.17.239.211:40000 pid=4015397)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg4 slice1 172.17.239.211:40000 pid=4015397)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg5 slice1 172.17.239.211:40001 pid=4015398)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg5 slice1 172.17.239.211:40001 pid=4015398)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg6 slice1 172.17.239.211:40002 pid=4015399)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg6 slice1 172.17.239.211:40002 pid=4015399)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg7 slice1 172.17.239.211:40003 pid=4015400)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg7 slice1 172.17.239.211:40003 pid=4015400)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg8 slice1 172.17.239.212:40000 pid=3903772)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg8 slice1 172.17.239.212:40000 pid=3903772)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg10 slice1 172.17.239.212:40002 pid=3903774)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg10 slice1 172.17.239.212:40002 pid=3903774)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg11 slice1 172.17.239.212:40003 pid=3903775)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg11 slice1 172.17.239.212:40003 pid=3903775)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg12 slice1 172.17.239.217:40000 pid=3970651)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg12 slice1 172.17.239.217:40000 pid=3970651)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg13 slice1 172.17.239.217:40001 pid=3970652)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg13 slice1 172.17.239.217:40001 pid=3970652)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg14 slice1 172.17.239.217:40002 pid=3970653)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg14 slice1 172.17.239.217:40002 pid=3970653)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg15 slice1 172.17.239.217:40003 pid=3970654)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg15 slice1 172.17.239.217:40003 pid=3970654)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg16 slice1 172.17.239.218:40000 pid=3997241)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg16 slice1 172.17.239.218:40000 pid=3997241)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg17 slice1 172.17.239.218:40001 pid=3997242)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg17 slice1 172.17.239.218:40001 pid=3997242)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg18 slice1 172.17.239.218:40002 pid=3997243)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg18 slice1 172.17.239.218:40002 pid=3997243)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:5255)  (seg19 slice1 172.17.239.218:40003 pid=3997244)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg19 slice1 172.17.239.218:40003 pid=3997244)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg12 172.17.239.217:40000 pid=3970643)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg12 172.17.239.217:40000 pid=3970643)
LOG:  Process interrupt for 'query cancel pending' (execProcnode.c:932)  (seg9 172.17.239.212:40001 pid=3903764)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg9 172.17.239.212:40001 pid=3903764)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg18 172.17.239.218:40002 pid=3997236)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg18 172.17.239.218:40002 pid=3997236)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg8 172.17.239.212:40000 pid=3903765)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg8 172.17.239.212:40000 pid=3903765)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg4 172.17.239.211:40000 pid=4015390)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg6 172.17.239.211:40002 pid=4015391)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg0 172.17.239.210:40000 pid=3973537)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg3 172.17.239.210:40003 pid=3973540)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg4 172.17.239.211:40000 pid=4015390)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg11 172.17.239.212:40003 pid=3903767)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg6 172.17.239.211:40002 pid=4015391)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg3 172.17.239.210:40003 pid=3973540)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg11 172.17.239.212:40003 pid=3903767)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg0 172.17.239.210:40000 pid=3973537)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg10 172.17.239.212:40002 pid=3903766)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg14 172.17.239.217:40002 pid=3970644)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg17 172.17.239.218:40001 pid=3997234)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg10 172.17.239.212:40002 pid=3903766)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg16 172.17.239.218:40000 pid=3997233)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg14 172.17.239.217:40002 pid=3970644)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg17 172.17.239.218:40001 pid=3997234)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg16 172.17.239.218:40000 pid=3997233)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg15 172.17.239.217:40003 pid=3970646)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg5 172.17.239.211:40001 pid=4015389)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg15 172.17.239.217:40003 pid=3970646)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg19 172.17.239.218:40003 pid=3997235)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg5 172.17.239.211:40001 pid=4015389)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg19 172.17.239.218:40003 pid=3997235)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg7 172.17.239.211:40003 pid=4015392)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg2 172.17.239.210:40002 pid=3973539)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg7 172.17.239.211:40003 pid=4015392)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg2 172.17.239.210:40002 pid=3973539)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg1 172.17.239.210:40001 pid=3973538)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg1 172.17.239.210:40001 pid=3973538)
LOG:  Process interrupt for 'query cancel pending' (ic_udpifc.c:3836)  (seg13 172.17.239.217:40001 pid=3970645)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;  (seg13 172.17.239.217:40001 pid=3970645)
LOG:  An exception was encountered during the execution of statement: create table mes.pcbcomponenttrace_1_prt_82_temp as select * from mes.pcbcomponenttrace_1_prt_82;
ERROR:  block checksum does not match, expected 0x7D1D4480 and found 0x0F3EDB11  (seg9 slice1 172.17.239.212:40001 pid=3903773)
DETAIL:  Append-Only storage Small Content header: smallcontent_bytes_0_3 0x1900E406, smallcontent_bytes_4_7 0x3400DE8, headerKind = 1, executorBlockKind = 1, rowCount = 57, usingChecksums = true, header checksum 0xADA13539, block checksum 0x7D1D4480, dataLength 12314, compressedLength 3560, overallBlockLen 3576
CONTEXT:  Scan of Append-Only Row-Oriented relation 'pcbcomponenttrace_1_prt_82'. Append-Only segment file 'pg_tblspc/103535299/GPDB_6_301908232/863243/97546314.1', block header offset in file = 373008744, bufferCount 77200
F6_BDC=# \q

Step to reproduce the behavior

cobolbaby avatar Nov 27 '23 02:11 cobolbaby