You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ozone.apache.org by "Devesh Kumar Singh (Jira)" <ji...@apache.org> on 2024/08/26 13:15:00 UTC
[jira] [Resolved] (HDDS-11309) Increase CONTAINER_STATE Column Length in UNHEALTHY_CONTAINERS Table to Avoid Truncation Errors for Enum States
[ 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: issues-unsubscribe@ozone.apache.org
For additional commands, e-mail: issues-help@ozone.apache.org