] Statement diagnostic data from driver is XX002:0:7:ERROR: index “pk_vpx_alarm_runtime” contains corrupted page at block xxxx;

on the vpxd.log:

–> Error while executing the query
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [VdbStatement] Connection diagnostic data from driver is HY000:0:110:
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [VdbStatement] Bind parameters:
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [VdbStatement] [0]datatype: 1, size: 4, arraySize: 0
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [VdbStatement] value = 172237
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [Vdb::IsRecoverableErrorCode] Unable to recover from XX002:7
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [Vdb::IsRecoverableErrorCode] Unable to recover from HY000:110
2018-09-25T21:17:09.351Z error vpxd[7F3FC958B800] [Originator@6876 sub=Default] [VdbStatement] SQLError was thrown: “ODBC error: (XX002) – ERROR: index “pk_vpx_alarm_runtime” contains corrupted page at block 5877;
–> Error while executing the query” is returned when executing SQL statement “DELETE FROM VPX_ALARM_RUNTIME WHERE ENTITY_ID=?”
2018-09-25T21:17:09.355Z error vpxd[7F3FC958B800] [Originator@6876 sub=Daemon] Unhandled exception: Error[VdbODBCError] (-1) “ODBC error: (XX002) – ERROR: index “pk_vpx_alarm_runtime” contains corrupted page at block 5877;
–> Error while executing the query” is returned when executing SQL statement “DELETE FROM VPX_ALARM_RUNTIME WHERE ENTITY_ID=?”
2018-09-25T21:17:09.355Z info vpxd[7F3FC958B800] [Originator@6876 sub=SupportMgr] Wrote uptime information
(END)

 

 

Resolution:

Take a snapshot of the vcsa

Export affected table:
VCDB=# copy (select * from vpx_alarm_runtime) to ‘/tmp/vpx_alarm_runtime_select_.csv’ with CSV DELIMITER ‘,’;
COPY 3854

Drop affected constrain.
VCDB=# alter table vpx_alarm_runtime drop CONSTRAINT PK_VPX_ALARM_RUNTIME;

re-create constrain.


recrate Table: VPX_ALARM_RUNTIME


/*==============================================================*/
/* Table: VPX_ALARM_RUNTIME */
/*==============================================================*/
create table VPX_ALARM_RUNTIME (
ENTITY_ID INTEGER not null,
ALARM_ID INTEGER not null,
ENTITY_TYPE INTEGER,
EXPRESSION_NAME VARCHAR(440) not null,
STATE_VALUE VARCHAR(255),
METRIC_VALUE INTEGER,
CREATED_TIME TIMESTAMP,
STATUS_VALUE VARCHAR(50),
EVENT_KEY INTEGER null,
constraint PK_VPX_ALARM_RUNTIME primary key (ENTITY_ID, ALARM_ID,
EXPRESSION_NAME)
);