pipinet edited a comment on issue #7712: URL: https://github.com/apache/dolphinscheduler/issues/7712#issuecomment-1051561930
@kezhenxu94 Database migration did not succeed ```log $ docker-compose up Creating volume "dolphinscheduler_dolphinscheduler-postgresql" with default driver Creating volume "dolphinscheduler_dolphinscheduler-zookeeper" with default driver Creating volume "dolphinscheduler_dolphinscheduler-worker-data" with default driver Creating volume "dolphinscheduler_dolphinscheduler-logs" with default driver Creating volume "dolphinscheduler_dolphinscheduler-shared-local" with default driver Creating volume "dolphinscheduler_dolphinscheduler-resource-local" with default driver Creating dolphinscheduler_dolphinscheduler-zookeeper_1 ... done Creating dolphinscheduler_dolphinscheduler-postgresql_1 ... done Creating dolphinscheduler_dolphinscheduler-schema-initializer_1 ... done ERROR: for dolphinscheduler-api Container "888519df87ac" exited with code 1. ERROR: for dolphinscheduler-master Container "888519df87ac" exited with code 1. ERROR: for dolphinscheduler-worker Container "888519df87ac" exited with code 1. ERROR: for dolphinscheduler-alert Container "888519df87ac" exited with code 1. ERROR: Encountered errors while bringing up the project. ``` ```log $ docker-compose logs -f dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.383 INFO 9 --- [ main] o.a.d.common.utils.ScriptRunner : sql: create index process_task_relation_log_idx_project_code_process_definition_code on t_ds_process_task_relation_log (project_code,process_definition_code) dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.386 INFO 9 --- [ main] o.a.d.common.utils.ScriptRunner : -- dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.386 INFO 9 --- [ main] o.a.d.common.utils.ScriptRunner : -- Table structure for table t_ds_process_instance dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.386 INFO 9 --- [ main] o.a.d.common.utils.ScriptRunner : -- dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.386 INFO 9 --- [ main] o.a.d.common.utils.ScriptRunner : sql: DROP TABLE IF EXISTS t_ds_process_instance dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.395 ERROR 9 --- [ main] o.a.d.common.utils.ScriptRunner : SQLException dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | org.postgresql.util.PSQLException: ERROR: cannot drop table t_ds_process_instance because other objects depend on it dolphinscheduler-schema-initializer_1 | Detail: constraint foreign_key_instance_id on table t_ds_task_instance depends on table t_ds_process_instance dolphinscheduler-schema-initializer_1 | Hint: Use DROP ... CASCADE to drop the dependent objects too. dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:118) [dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:73) [dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.runInitSql(UpgradeDao.java:107) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.initSchema(UpgradeDao.java:93) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinSchedulerSchema(DolphinSchedulerManager.java:78) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinScheduler(DolphinSchedulerManager.java:58) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.InitDolphinScheduler$InitRunner.run(InitDolphinScheduler.java:45) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:791) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:775) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1332) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.CreateDolphinScheduler.main(CreateDolphinScheduler.java:30) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.395 ERROR 9 --- [ main] o.a.d.common.utils.ScriptRunner : Error executing: DROP TABLE IF EXISTS t_ds_process_instance dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.396 ERROR 9 --- [ main] o.a.d.tools.datasource.dao.UpgradeDao : ERROR: cannot drop table t_ds_process_instance because other objects depend on it dolphinscheduler-schema-initializer_1 | Detail: constraint foreign_key_instance_id on table t_ds_task_instance depends on table t_ds_process_instance dolphinscheduler-schema-initializer_1 | Hint: Use DROP ... CASCADE to drop the dependent objects too. dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | org.postgresql.util.PSQLException: ERROR: cannot drop table t_ds_process_instance because other objects depend on it dolphinscheduler-schema-initializer_1 | Detail: constraint foreign_key_instance_id on table t_ds_task_instance depends on table t_ds_process_instance dolphinscheduler-schema-initializer_1 | Hint: Use DROP ... CASCADE to drop the dependent objects too. dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:118) ~[dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:73) ~[dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.runInitSql(UpgradeDao.java:107) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.initSchema(UpgradeDao.java:93) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinSchedulerSchema(DolphinSchedulerManager.java:78) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinScheduler(DolphinSchedulerManager.java:58) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.InitDolphinScheduler$InitRunner.run(InitDolphinScheduler.java:45) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:791) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:775) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1332) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.CreateDolphinScheduler.main(CreateDolphinScheduler.java:30) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.398 INFO 9 --- [ main] ConditionEvaluationReportLoggingListener : dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.423 ERROR 9 --- [ main] o.s.boot.SpringApplication : Application run failed dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | java.lang.IllegalStateException: Failed to execute CommandLineRunner dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:794) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:775) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:345) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1332) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.CreateDolphinScheduler.main(CreateDolphinScheduler.java:30) [dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | Caused by: java.lang.RuntimeException: ERROR: cannot drop table t_ds_process_instance because other objects depend on it dolphinscheduler-schema-initializer_1 | Detail: constraint foreign_key_instance_id on table t_ds_task_instance depends on table t_ds_process_instance dolphinscheduler-schema-initializer_1 | Hint: Use DROP ... CASCADE to drop the dependent objects too. dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.runInitSql(UpgradeDao.java:110) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.initSchema(UpgradeDao.java:93) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinSchedulerSchema(DolphinSchedulerManager.java:78) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.initDolphinScheduler(DolphinSchedulerManager.java:58) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.InitDolphinScheduler$InitRunner.run(InitDolphinScheduler.java:45) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:791) [spring-boot-2.5.6.jar:2.5.6] dolphinscheduler-schema-initializer_1 | ... 5 common frames omitted dolphinscheduler-schema-initializer_1 | Caused by: org.postgresql.util.PSQLException: ERROR: cannot drop table t_ds_process_instance because other objects depend on it dolphinscheduler-schema-initializer_1 | Detail: constraint foreign_key_instance_id on table t_ds_task_instance depends on table t_ds_process_instance dolphinscheduler-schema-initializer_1 | Hint: Use DROP ... CASCADE to drop the dependent objects too. dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266) ~[postgresql-42.2.5.jar:42.2.5] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:118) ~[dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:73) ~[dolphinscheduler-common-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.runInitSql(UpgradeDao.java:107) ~[dolphinscheduler-tools-2.0.4-SNAPSHOT.jar:2.0.4-SNAPSHOT] dolphinscheduler-schema-initializer_1 | ... 10 common frames omitted dolphinscheduler-schema-initializer_1 | dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.426 INFO 9 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Shutdown initiated... dolphinscheduler-schema-initializer_1 | 2022-02-26 12:10:05.432 INFO 9 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Shutdown completed. dolphinscheduler_dolphinscheduler-schema-initializer_1 exited with code 1 ``` -- 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]
