You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Palash Chauhan (Jira)" <ji...@apache.org> on 2025/01/28 02:34:00 UTC
[jira] [Resolved] (PHOENIX-7509) Metadata Cache should handle tables which have LAST_DDL_TIMESTAMP column null in syscat
[ https://issues.apache.org/jira/browse/PHOENIX-7509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Palash Chauhan resolved PHOENIX-7509.
-------------------------------------
Fix Version/s: 5.3.0
Resolution: Fixed
> Metadata Cache should handle tables which have LAST_DDL_TIMESTAMP column null in syscat
> ---------------------------------------------------------------------------------------
>
> Key: PHOENIX-7509
> URL: https://issues.apache.org/jira/browse/PHOENIX-7509
> Project: Phoenix
> Issue Type: Bug
> Reporter: Tanuj Khurana
> Assignee: Palash Chauhan
> Priority: Major
> Fix For: 5.3.0
>
>
> PHOENIX-6883 re-designed the Phoenix metadata cache. It relies upon the LAST_DDL_TIMESTAMP column. However, in some scenarios where the table pre-existed before this column was introduced and there hasn't been any DDL change on that table this column will have a null value. If the ddl timestamp validation is enabled, then we get a NPE when querying such tables.
> In my test, I got the below NPE
> {code:java}
> 2025-01-16 13:50:06,084 ERROR ValidateLastDDLTimestampUtil - Error in validating DDL timestamp for Tenant: null, {Schema: TEST, Table: N000001},
> org.apache.phoenix.exception.PhoenixIOException
> at org.apache.phoenix.util.ClientUtil.parseServerException(ClientUtil.java:70)
> at org.apache.phoenix.util.ValidateLastDDLTimestampUtil.validateLastDDLTimestamp(ValidateLastDDLTimestampUtil.java:121)
> at org.apache.phoenix.util.ValidateLastDDLTimestampUtil.validateLastDDLTimestamp(ValidateLastDDLTimestampUtil.java:130)
> at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:390)
> at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:352)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:352)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:334)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:2295)
> at org.apache.phoenix.end2end.PhoenixStandaloneClient.testConnection(PhoenixStandaloneClient.java:25)
> at org.apache.phoenix.end2end.PhoenixStandaloneClient.main(PhoenixStandaloneClient.java:15)
> Caused by: java.lang.NullPointerException
> at org.apache.phoenix.util.ValidateLastDDLTimestampUtil.getValidateDDLTimestampRequest(ValidateLastDDLTimestampUtil.java:173)
> at org.apache.phoenix.util.ValidateLastDDLTimestampUtil.validateLastDDLTimestamp(ValidateLastDDLTimestampUtil.java:118)
> ... 9 more {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)