Arafat Khan created HDDS-11309:
----------------------------------
Summary: Increase CONTAINER_STATE Column Length in
UNHEALTHY_CONTAINERS Table to Avoid Truncation Errors for Enum States
Key: HDDS-11309
URL: https://issues.apache.org/jira/browse/HDDS-11309
Project: Apache Ozone
Issue Type: Bug
Components: Ozone Recon
Reporter: Arafat Khan
During the execution of the {*}{{ContainerHealthTask}}{*}, it was discovered
that the length of the *{{CONTAINER_STATE}}* column in the
*{{UNHEALTHY_CONTAINERS}}* table is insufficient to store some of the enum
values defined in {*}{{UnHealthyContainerStates}}{*}. Specifically, the
*{{ALL_REPLICAS_UNHEALTHY}}* state, which has a length of {*}21 characters{*},
exceeds the current *VARCHAR(16)* limit set for the *{{CONTAINER_STATE}}*
column.
When attempting to insert a record with the {{ALL_REPLICAS_UNHEALTHY}} state
into the {{UNHEALTHY_CONTAINERS}} table, a truncation error is thrown:
{code:java}
org.jooq.exception.DataAccessException: SQL [insert into "UNHEALTHY_CONTAINERS"
("container_id", "container_state", "in_state_since", "expected_replica_count",
"actual_replica_count", "replica_delta", "reason") values ...]; A truncation
error was encountered trying to shrink VARCHAR 'ALL_REPLICAS_UNHEALTHY' to
length 16. {code}
This issue affects the functionality of the *ContainerHealthTask* and prevents
it from correctly recording certain unhealthy container states.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
