You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/02/26 04:15:10 UTC

[GitHub] [dolphinscheduler] pipinet edited a comment on issue #7712: [Bug] [Docker] Cannot build docker container with docker-compose 2.X

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: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org