thirsd opened a new issue, #8942: URL: https://github.com/apache/seatunnel/issues/8942
### 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 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Fatal Error, 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Please submit bug report in https://github.com/apache/seatunnel/issues 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Reason:SeaTunnel job executed failed 2025-03-08 05:43:15,837 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Exception StackTrace:org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228) at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40) at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34) Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:119) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:68) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:404) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:236) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: java.lang.RuntimeException: java.sql.SQLException: ResultSet closed at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:262) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:286) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:255) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:376) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:369) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:134) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:131) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:91) ... 8 more Caused by: java.sql.SQLException: ResultSet closed at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:82) at org.sqlite.core.CoreResultSet.markCol(CoreResultSet.java:111) at org.sqlite.jdbc3.JDBC3ResultSet.lambda$safeGetLongCol$4(JDBC3ResultSet.java:978) at org.sqlite.core.SafeStmtPtr.safeRunLong(SafeStmtPtr.java:99) at org.sqlite.jdbc3.JDBC3ResultSet.safeGetLongCol(JDBC3ResultSet.java:978) at org.sqlite.jdbc3.JDBC3ResultSet.getLong(JDBC3ResultSet.java:349) at org.sqlite.jdbc3.JDBC3ResultSet.getColumnType(JDBC3ResultSet.java:665) at org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.JdbcDialectTypeMapper.mappingColumn(JdbcDialectTypeMapper.java:137) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:260) ... 17 more 2025-03-08 05:43:15,838 ERROR [o.a.s.c.s.SeaTunnel ] [main] - =============================================================================== Exception in thread "main" org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228) at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40) at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34) Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:119) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:68) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:404) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:236) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: java.lang.RuntimeException: java.sql.SQLException: ResultSet closed at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:262) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:286) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:255) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:376) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:369) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:134) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:131) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:91) ... 8 more Caused by: java.sql.SQLException: ResultSet closed at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:82) at org.sqlite.core.CoreResultSet.markCol(CoreResultSet.java:111) at org.sqlite.jdbc3.JDBC3ResultSet.lambda$safeGetLongCol$4(JDBC3ResultSet.java:978) at org.sqlite.core.SafeStmtPtr.safeRunLong(SafeStmtPtr.java:99) at org.sqlite.jdbc3.JDBC3ResultSet.safeGetLongCol(JDBC3ResultSet.java:978) at org.sqlite.jdbc3.JDBC3ResultSet.getLong(JDBC3ResultSet.java:349) at org.sqlite.jdbc3.JDBC3ResultSet.getColumnType(JDBC3ResultSet.java:665) at org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.JdbcDialectTypeMapper.mappingColumn(JdbcDialectTypeMapper.java:137) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:260) ... 17 more thirsd@ubuntu2404:~/myworld/temp/apache-seatunnel-2.3.9$ ### SeaTunnel Version apache-seatunnel-2.3.9 ### SeaTunnel Config ```conf env { parallelism = 1 job.mode = "BATCH" } source { # This is a example source plugin **only for test and demonstrate the feature source plugin** jdbc { url = "jdbc:sqlite:data/test.db" driver = "org.sqlite.JDBC" query="select * from department" } } transform { } sink { console { plugin_input="fake" } sqllit的数据库相关信息 C:\Users\thirsd>sqlite3 test.db SQLite version 3.49.1 2025-02-18 13:38:58 Enter ".help" for usage hints. sqlite> .databases main: C:\Users\thirsd\test.db r/w sqlite> CREATE TABLE DEPARTMENT( (x1...> ID INT PRIMARY KEY NOT NULL, (x1...> DEPT CHAR(50) NOT NULL (x1...> ); sqlite> .tables DEPARTMENT sqlite> select * from department ...> ; sqlite> INSERT INTO department VALUES (1, 'James'); sqlite> INSERT INTO department VALUES (2, 'hello'); sqlite> select * from department; 1|James 2|hello sqlite> .exit ``` ### Running Command ```shell apache-seatunnel-2.3.9$ bin/seatunnel.sh --config config/job/sqlite_to_console.conf -e local ``` ### Error Exception ```log 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Fatal Error, 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Please submit bug report in https://github.com/apache/seatunnel/issues 2025-03-08 05:43:15,835 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Reason:SeaTunnel job executed failed 2025-03-08 05:43:15,837 ERROR [o.a.s.c.s.SeaTunnel ] [main] - Exception StackTrace:org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228) at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40) at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34) Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:119) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:68) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:404) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:236) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: java.lang.RuntimeException: java.sql.SQLException: ResultSet closed at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:262) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:286) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:255) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:376) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:369) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:134) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:131) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:91) ... 8 more Caused by: java.sql.SQLException: ResultSet closed at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:82) at org.sqlite.core.CoreResultSet.markCol(CoreResultSet.java:111) at org.sqlite.jdbc3.JDBC3ResultSet.lambda$safeGetLongCol$4(JDBC3ResultSet.java:978) at org.sqlite.core.SafeStmtPtr.safeRunLong(SafeStmtPtr.java:99) at org.sqlite.jdbc3.JDBC3ResultSet.safeGetLongCol(JDBC3ResultSet.java:978) at org.sqlite.jdbc3.JDBC3ResultSet.getLong(JDBC3ResultSet.java:349) at org.sqlite.jdbc3.JDBC3ResultSet.getColumnType(JDBC3ResultSet.java:665) at org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.JdbcDialectTypeMapper.mappingColumn(JdbcDialectTypeMapper.java:137) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:260) ... 17 more 2025-03-08 05:43:15,838 ERROR [o.a.s.c.s.SeaTunnel ] [main] - =============================================================================== Exception in thread "main" org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228) at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40) at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34) Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'jdbc'. at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:119) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:68) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:404) at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:236) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123) at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191) at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165) ... 2 more Caused by: java.lang.RuntimeException: java.sql.SQLException: ResultSet closed at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:262) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:286) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.getCatalogTable(CatalogUtils.java:255) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:376) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getCatalogTable(JdbcCatalogUtils.java:369) at org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:134) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57) at org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80) at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:131) at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:91) ... 8 more Caused by: java.sql.SQLException: ResultSet closed at org.sqlite.core.CoreResultSet.checkOpen(CoreResultSet.java:82) at org.sqlite.core.CoreResultSet.markCol(CoreResultSet.java:111) at org.sqlite.jdbc3.JDBC3ResultSet.lambda$safeGetLongCol$4(JDBC3ResultSet.java:978) at org.sqlite.core.SafeStmtPtr.safeRunLong(SafeStmtPtr.java:99) at org.sqlite.jdbc3.JDBC3ResultSet.safeGetLongCol(JDBC3ResultSet.java:978) at org.sqlite.jdbc3.JDBC3ResultSet.getLong(JDBC3ResultSet.java:349) at org.sqlite.jdbc3.JDBC3ResultSet.getColumnType(JDBC3ResultSet.java:665) at org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.JdbcDialectTypeMapper.mappingColumn(JdbcDialectTypeMapper.java:137) at org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.utils.CatalogUtils.lambda$getCatalogTable$2(CatalogUtils.java:260) ... 17 more thirsd@ubuntu2404:~/myworld/temp/apache-seatunnel-2.3.9$ ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### 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: commits-unsubscr...@seatunnel.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
