ratadepally opened a new issue, #8184: URL: https://github.com/apache/seatunnel/issues/8184
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened When we provide a hostname for Postgres-CDC connection and try to run the job we are seeing unwanted WARN logs which says TableDiscoveryUtils class is trying to scan for all the databases under the specified host. Even though we specify the database name in the source config we are still getting these unwanted warnings. Is there any way to avoid other databases and tables which are not part of the connection ? ### SeaTunnel Version seatunnel-2.3.8 ### SeaTunnel Config ```conf env { execution.parallelism = 1 job.mode = "STREAMING" checkpoint.interval = 5000 read_limit.bytes_per_second=7000000 read_limit.rows_per_second=400 } source { Postgres-CDC { result_table_name = "employees" username = "postgres" password = "password" database-names = ["postgres"] schema-names = ["public"] slot.name = "employeeslot" table-names = ["postgres.public.employees"] base-url = "jdbc:postgresql://localhost:5432/postgres" } } transform { } sink { Console { source_table_name = "employees" } } ``` ### Running Command ```shell ./bin/seatunnel.sh --config config/postgres-cdc.template --async -n postgrescdcsync ``` ### Error Exception ```log [915470173375299585] 2024-11-30 23:11:41,544 INFO [.c.s.c.p.u.TableDiscoveryUtils] [hz.main.seaTunnel.task.thread-128] - list of available databases is: [postgres, database2, database3] [915470173375299585] 2024-11-30 23:11:41,544 INFO [.c.s.c.p.u.TableDiscoveryUtils] [hz.main.seaTunnel.task.thread-128] - Read list of available tables in each database [915470173375299585] 2024-11-30 23:11:41,606 WARN [.c.s.c.p.u.TableDiscoveryUtils] [hz.main.seaTunnel.task.thread-128] - skipping database 'database2' due to error reading tables: ERROR: cross-database references are not implemented: "database2.information_schema.tables" Position: 15 [915470173375299585] 2024-11-30 23:11:41,657 WARN [.c.s.c.p.u.TableDiscoveryUtils] [hz.main.seaTunnel.task.thread-128] - skipping database 'database3' due to error reading tables: ERROR: cross-database references are not implemented: "database3.information_schema.tables" Position: 15 ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version Jdk 1.8 ### Screenshots _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
