[
https://issues.apache.org/jira/browse/PHOENIX-7652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Palash Chauhan updated PHOENIX-7652:
------------------------------------
Description:
When CDC is created on a table, we create an entry in SYSTEM.CDC_STREAM. When
such a table is dropped, we should clear all stream metadata. Since we only
allow one ENABLED stream on a table at a time, creating the table and cdc again
with same names would throw an Exception.
*java.sql.SQLException: ERROR 10963 (44A45): CDC on this table is either
enabled or is in the process of being enabled.*
was:
When CDC is created on a table, we create an entry in SYSTEM.CDC_STREAM. When
such a table is dropped, we should mark the status of this entry as DISABLED.
Since we only allow one ENABLED stream on a table at a time, creating the table
and cdc again with same names would throw an Exception.
*java.sql.SQLException: ERROR 10963 (44A45): CDC on this table is either
enabled or is in the process of being enabled.*
> Clear CDC Stream metadata when a table with CDC enabled is dropped
> ------------------------------------------------------------------
>
> Key: PHOENIX-7652
> URL: https://issues.apache.org/jira/browse/PHOENIX-7652
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Palash Chauhan
> Assignee: Palash Chauhan
> Priority: Major
> Fix For: 5.3.0
>
>
> When CDC is created on a table, we create an entry in SYSTEM.CDC_STREAM. When
> such a table is dropped, we should clear all stream metadata. Since we only
> allow one ENABLED stream on a table at a time, creating the table and cdc
> again with same names would throw an Exception.
> *java.sql.SQLException: ERROR 10963 (44A45): CDC on this table is either
> enabled or is in the process of being enabled.*
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
