GBase8a MPP Cluster view details of the Cluster data inconsistency-CodePudding

1.1.1. Use the
When appear inconsistent between the cluster master copy, or cluster data file fails, will be in a state of the cluster set datastate is 1, the command is to show what the causes of the

1.1.2. Use the
Data file is inconsistent, generally is a disk failure, power outages, cause the file is damaged,

Gcadmin showdmlstorageevent

DDL, part of the node DDL operation fails,

Gcadmin showddlevent

Data inconsistency and part of the node do the malfunction of the DML operations including LOAD,

Gcadmin showdmlevent

1.1.3. Use the sample
[gbase @ DB01 gcluster] $gcadmin showdmlevent

Event count: 3 * * * * * * total number of the Event, if many becomes 16/100 on behalf of a total of 100 Event, the show only 16,

The Event ID: 252 * * * * * * Event number, incremental,

TableName: mydb. Table1 * * * * * * on behalf of the table1 defective * * * * * * *

The Fail Data Copy:

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

SegName: n2 SCN: 8314414 NodeIP: 11.0.0.201 pool_raise_if_allocation_failure is * * * * * * * * * represents 201 nodes of n2 fragmentation is damaged, need to get the data from 202 * * * * * * * * * *

SegName: n6 SCN: 8314414 NodeIP: 11.0.0.206 pool_raise_if_allocation_failure is * * * * * * * * * on behalf of 206 nodes n6 fragmentation is damaged, need to get the data from 205 * * * * * * * * * *

SegName: n1 SCN: 8314436 NodeIP: 11.0.0.201 pool_raise_if_allocation_failure is * * * * * * * * * on behalf of 201 nodes n1 fragmentation is damaged, need to get the data from 202 * * * * * * * * * *

The Event ID: 246

TableName: mydb table2 * * * * * * on behalf of the table2 defective * * * * * * *

The Fail Data Copy:

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

SegName: n1 SCN: 8314439 NodeIP: 11.0.0.202 pool_raise_if_allocation_failure is * * * * * * * * * on behalf of 202 nodes n1 fragmentation is damaged, need to get the data from 201 * * * * * * * * * *

The Event ID: 245

TableName: mydb. Table3

The Fail Data Copy:

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

SegName: n1 SCN: 8314443 NodeIP: 11.0.0.202 FAILURE

SegName: n2 SCN: 8314478 NodeIP: 11.0.0.202 FAILURE