# Debezium starts, finds no tables?

**URL:** https://forum.confluent.io/t/debezium-starts-finds-no-tables/5247
**Category:** Kafka Connect
**Created:** [9 June 2022 04:50 UTC](https://forum.confluent.io/t/debezium-starts-finds-no-tables/5247 "2022-06-09T04:50:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![mattimo](https://avatars.discourse-cdn.com/v4/letter/m/8edcca/32.png) [@mattimo](https://forum.confluent.io/u/mattimo)
#### Post date: [9 June 2022 04:50 UTC](https://forum.confluent.io/t/debezium-starts-finds-no-tables/5247/1 "2022-06-09T04:50:14Z")

</div>

I’m using SQL Server connector and the logs show `Locking captured tables []` - no tables are captured. I’ve verified my schema, table, and database. I’ve tried the following, all with topics pre-created… (also specify all variables from Debezium SQL docs)

- “table.include.list” : “testTable” && “schema.include.list”: “dbo”
- “table.include.list” : “dbo.testTable” && “schema.include.list”: “dbo”
- “table.include.list” : “DBNAME.dbo.testTable” && “schema.include.list”: “dbo”
- “table.include.list” : “DBNAME.dbo.testTable”
- “table.include.list” : “dbo.testTable”

Running out of ideas, and no data is captured… there are thousands of records in the table and its takes ~25min to redeploy docker and cycle thru for tests

```auto
2022-06-09T01:28:35.036573+00:00 app[web.1]: [2022-06-09 01:28:35,036] INFO Snapshot step 3 - Locking captured tables [] (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.036779+00:00 app[web.1]: [2022-06-09 01:28:35,036] INFO Setting locking timeout to 10 s (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource)
2022-06-09T01:28:35.069576+00:00 app[web.1]: [2022-06-09 01:28:35,066] INFO Executing schema locking (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource)
2022-06-09T01:28:35.069586+00:00 app[web.1]: [2022-06-09 01:28:35,066] INFO Snapshot step 4 - Determining snapshot offset (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.080765+00:00 app[web.1]: [2022-06-09 01:28:35,080] INFO Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.081107+00:00 app[web.1]: [2022-06-09 01:28:35,081] INFO Snapshot step 6 - Persisting schema history (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.087858+00:00 app[web.1]: [2022-06-09 01:28:35,087] INFO Schema locks released. (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource)
2022-06-09T01:28:35.087894+00:00 app[web.1]: [2022-06-09 01:28:35,087] INFO Snapshot step 7 - Snapshotting data (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.088336+00:00 app[web.1]: [2022-06-09 01:28:35,088] INFO Snapshotting contents of 0 tables while still in transaction (io.debezium.relational.RelationalSnapshotChangeEventSource)
2022-06-09T01:28:35.098247+00:00 app[web.1]: [2022-06-09 01:28:35,098] INFO Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource)
2022-06-09T01:28:35.104830+00:00 app[web.1]: [2022-06-09 01:28:35,104] INFO Removing locking timeout (io.debezium.connector.sqlserver.SqlServerSnapshotChangeEventSource)
2022-06-09T01:28:35.118107+00:00 app[web.1]: [2022-06-09 01:28:35,118] INFO Snapshot ended with SnapshotResult [status=COMPLETED, offset=SqlServerOffsetContext [sourceInfoSchema=Schema{io.debezium.connector.sqlserver.Source:STRUCT}, sourceInfo=SourceInfo [serverName=heroku_connect, changeLsn=NULL, commitLsn=001d23f3:00016cc0:0001, eventSerialNo=null, snapshot=FALSE, sourceTime=null], snapshotCompleted=true, eventSerialNo=1]] (io.debezium.pipeline.ChangeEventSourceCoordinator)
2022-06-09T01:28:35.118780+00:00 app[web.1]: [2022-06-09 01:28:35,118] WARN After applying the include/exclude list filters, no changes will be captured. Please check your configuration! (io.debezium.relational.RelationalDatabaseSchema)

```

---

<div class="post-metadata">

### Author: ![dtroiano](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/dtroiano/32/1961_2.png) [@dtroiano](https://forum.confluent.io/u/dtroiano)
#### Post date: [16 June 2022 14:07 UTC](https://forum.confluent.io/t/debezium-starts-finds-no-tables/5247/2 "2022-06-16T14:07:16Z")

</div>

Hi, to help debug this, I suggest [enabling](https://debezium.io/documentation/reference/stable/operations/logging.html#configuring-logging) TRACE level logging on the connector to see if [this](https://github.com/debezium/debezium/blob/86abed2f9b9b3dfa71949519080c307aef999bc8/debezium-core/src/main/java/io/debezium/relational/RelationalSnapshotChangeEventSource.java#L202) line gets printed. If it gets printed, then the issue is with filters; if not, then the problem is upstream. I’m not sure where we’d look if it’s the latter but let’s see if we even need to first.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)
#### Post date: [16 July 2022 14:08 UTC](https://forum.confluent.io/t/debezium-starts-finds-no-tables/5247/3 "2022-07-16T14:08:09Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
