[
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 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.`
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. `
> Mark CDC Stream as Disabled 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 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.`
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
