github-actions[bot] commented on issue #7229: URL: https://github.com/apache/dolphinscheduler/issues/7229#issuecomment-987592153
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues. ### What happened ``` 2021-12-07 11:51:55.774 INFO 10511 --- [ main] o.a.d.dao.upgrade.UpgradeDao : sqlSQLFilePathclass path resource [sql/upgrade/2.0.0_schema/postgresql/dolphinscheduler_dml.sql] 2021-12-07 11:51:55.783 ERROR 10511 --- [ main] o.a.d.dao.upgrade.ProjectDao : 错误: 字段 "code" 不存在 Position: 11 org.postgresql.util.PSQLException: 错误: 字段 "code" 不存在 Position: 11 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106) ~[postgresql-42.2.5.jar:42.2.5] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.dao.upgrade.ProjectDao.queryAllProject(ProjectDao.java:49) ~[dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.processDefinitionJsonSplit(UpgradeDao.java:422) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.upgradeDolphinSchedulerTo200(UpgradeDao.java:184) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:104) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler$CreateRunner.run(CreateDolphinScheduler.java:58) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:791) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:775) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:143) [spring-boot-2.5.6.jar:2.5.6] at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler.main(CreateDolphinScheduler.java:40) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] 2021-12-07 11:51:55.783 ERROR 10511 --- [ main] o.a.d.dao.upgrade.UpgradeDao : json split error java.lang.RuntimeException: sql: SELECT id,code FROM t_ds_project at org.apache.dolphinscheduler.dao.upgrade.ProjectDao.queryAllProject(ProjectDao.java:60) ~[dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.processDefinitionJsonSplit(UpgradeDao.java:422) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.upgradeDolphinSchedulerTo200(UpgradeDao.java:184) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:104) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler$CreateRunner.run(CreateDolphinScheduler.java:58) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:791) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:775) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) [spring-boot-2.5.6.jar:2.5.6] at org.springframework.boot.builder.SpringApplicationBuilder.run(SpringApplicationBuilder.java:143) [spring-boot-2.5.6.jar:2.5.6] at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler.main(CreateDolphinScheduler.java:40) [dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] Caused by: org.postgresql.util.PSQLException: 错误: 字段 "code" 不存在 Position: 11 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106) ~[postgresql-42.2.5.jar:42.2.5] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.dao.upgrade.ProjectDao.queryAllProject(ProjectDao.java:49) ~[dolphinscheduler-dao-2.0.1-SNAPSHOT.jar:2.0.1-SNAPSHOT] ... 9 common frames omitted ``` ### What you expected to happen run postgre upgrade sh error. ### How to reproduce run postgre upgrade sh successfully. ### Anything else _No response_ ### Version 2.0.0 ### Are you willing to submit PR? - [X] 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]
