[ 
https://issues.apache.org/jira/browse/HDDS-11309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Devesh Kumar Singh resolved HDDS-11309.
---------------------------------------
    Target Version/s: 1.5.0
          Resolution: Fixed

> 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
>            Assignee: Arafat Khan
>            Priority: Major
>              Labels: pull-request-available
>
> 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]

Reply via email to