Connector tries to scan and lock tables that are not configured for CDC [DBZ-1421]
- Dominant language
- HTML
- Stars
- 6
- Forks
- 8
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 1
Description
Migrated from [DBZ-1421](https://issues.redhat.com/browse/DBZ-1421)
I have enabled CDC only on two tables, but the SQL Server connectors still tries to do a SELECT * FROM (TABLOCKX) on ALL tables. Some tables doesn't not support CDC (like in-memory tables) and this causes the connector to crash. Even without crash this behavior is IMHO not correct as it should only use tables with CDC enabled to avoid unnecessary locking.
Contributor guide
Research direction
Start by locating the SQL Server connector logic that discovers tables and issues SELECT * with TABLOCKX. Reproduce the case with CDC enabled on only two tables, including an in-memory table that does not support CDC. Done means the connector avoids scanning or locking non-CDC tables and no longer crashes in this configuration.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100