apache / dolphinscheduler

Apache DolphinScheduler is the modern data orchestration platform. Agile to create high performance workflow with low-code
https://dolphinscheduler.apache.org/
Apache License 2.0
12.78k stars 4.59k forks source link

[Bug] [upgrade] 3.1.7 upgrade 3.2.0,upgrade-schema.sh, mysql sql error, upgradeDolphinSchedulerDDL #15052

Closed aruizhong closed 8 months ago

aruizhong commented 12 months ago

Search before asking

What happened

目前我的ds是3.1.7版本,当尝试更新到3.2.0时候,执行sh ./tools/bin/upgrade-schema.sh,sql报错;

我将该路径apache-dolphinscheduler-3.2.0-bin/tools/sql/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql 下的sql全部拿出来执行是成功的,但是执行sh ./tools/bin/upgrade-schema.sh脚本报错;

但是我新建一个数据库,执行sh ./tools/bin/upgrade-schema.sh,没有报错

What you expected to happen

sh ./tools/bin/upgrade-schema.sh

How to reproduce

sh ./tools/bin/upgrade-schema.sh

Anything else

2023-10-19 19:10:44.476 INFO 5494 --- [ main] o.a.d.t.d.UpgradeDolphinScheduler : Starting UpgradeDolphinScheduler v3.2.0 using Java 1.8.025 on s2-100 with PID 5494 (/opt/tmp/apache-dolphinscheduler-3.2.0-bin/tools/libs/dolphinscheduler-tools-3.2.0.jar started by dolphinscheduler in /opt/tmp/apache-dolphinscheduler-3.2.0-bin) 2023-10-19 19:10:44.482 INFO 5494 --- [ main] o.a.d.t.d.UpgradeDolphinScheduler : The following 2 profiles are active: "upgrade", "mysql" 2023-10-19 19:10:45.860 WARN 5494 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[org.apache.dolphinscheduler.tools.datasource]' package. Please check your configuration. 2023-10-19 19:10:46.406 INFO 5494 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsAutoConfiguration' of type [io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.438 INFO 5494 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'kubernetes.manifests-io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsProperties' of type [io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.445 INFO 5494 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'io.kubernetes.client.spring.extended.controller.config.KubernetesInformerAutoConfiguration' of type [io.kubernetes.client.spring.extended.controller.config.KubernetesInformerAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.795 INFO 5494 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'defaultApiClient' of type [io.kubernetes.client.openapi.ApiClient] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | |_. __ | | | |\/|)(| | |\ |)|||_\ / |
3.5.2 2023-10-19 19:10:48.227 INFO 5494 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Starting... 2023-10-19 19:10:48.445 INFO 5494 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Start completed. 2023-10-19 19:10:50.855 INFO 5494 --- [ main] o.a.d.t.d.UpgradeDolphinScheduler : Started UpgradeDolphinScheduler in 7.277 seconds (JVM running for 7.975) 2023-10-19 19:10:50.869 INFO 5494 --- [ main] o.a.d.t.d.DolphinSchedulerManager : The database has been initialized. Skip the initialization step 2023-10-19 19:10:50.891 INFO 5494 --- [ main] o.a.d.t.d.DolphinSchedulerManager : upgrade DolphinScheduler metadata version from 3.1.7 to 3.2.0 2023-10-19 19:10:50.892 INFO 5494 --- [ main] o.a.d.t.d.DolphinSchedulerManager : Begin upgrading DolphinScheduler's table structure 2023-10-19 19:10:50.906 INFO 5494 --- [ main] o.a.d.common.sql.SqlScriptRunner : Execute sql: SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); success 2023-10-19 19:10:50.909 INFO 5494 --- [ main] o.a.d.common.sql.SqlScriptRunner : Execute sql: DROP PROCEDURE IF EXISTS ut_dolphin_T_t_ds_fav; success 2023-10-19 19:10:50.912 INFO 5494 --- [ main] o.a.d.common.sql.SqlScriptRunner : Execute sql: CREATE PROCEDURE ut_dolphin_T_t_ds_fav() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_ds_fav' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_ds_fav RENAME t_ds_fav_task; END IF; END; success 2023-10-19 19:10:50.931 ERROR 5494 --- [ main] o.a.d.tools.datasource.dao.UpgradeDao : Execute ddl file failed, meet an unknown exception, schemaDir: 3.2.0_schema, ddlScript: dolphinscheduler_ddl.sql

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP PROCEDURE ut_dolphin_T_t_ds_fav; CREATE TABLE if not exists t_ds_fav_task' at line 2 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:768) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.common.sql.SqlScriptRunner.execute(SqlScriptRunner.java:58) ~[dolphinscheduler-common-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:158) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinScheduler(UpgradeDao.java:93) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:123) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler$UpgradeRunner.run(UpgradeDolphinScheduler.java:53) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:771) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:755) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) [spring-boot-2.7.3.jar:2.7.3] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler.main(UpgradeDolphinScheduler.java:36) [dolphinscheduler-tools-3.2.0.jar:3.2.0]

2023-10-19 19:10:50.935 INFO 5494 --- [ main] ConditionEvaluationReportLoggingListener :

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2023-10-19 19:10:50.968 ERROR 5494 --- [ main] o.s.boot.SpringApplication : Application run failed

java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:774) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:755) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) [spring-boot-2.7.3.jar:2.7.3] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler.main(UpgradeDolphinScheduler.java:36) [dolphinscheduler-tools-3.2.0.jar:3.2.0] Caused by: java.lang.RuntimeException: Execute ddl file failed, meet an unknown exception at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:166) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinScheduler(UpgradeDao.java:93) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:123) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler$UpgradeRunner.run(UpgradeDolphinScheduler.java:53) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:771) [spring-boot-2.7.3.jar:2.7.3] ... 5 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP PROCEDURE ut_dolphin_T_t_ds_fav; CREATE TABLE if not exists t_ds_fav_task' at line 2 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:768) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.common.sql.SqlScriptRunner.execute(SqlScriptRunner.java:58) ~[dolphinscheduler-common-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:158) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] ... 9 common frames omitted

2023-10-19 19:10:50.974 INFO 5494 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Shutdown initiated... 2023-10-19 19:10:50.993 INFO 5494 --- [ main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Shutdown completed.

Version

3.2.x

Are you willing to submit PR?

Code of Conduct

github-actions[bot] commented 12 months ago

Search before asking

What happened

Currently, my ds is version 3.1.7. When I try to update to 3.2.0, I execute sh ./tools/bin/upgrade-schema.sh and the sql reports an error;

I took out all the sql under the path apache-dolphinscheduler-3.2.0-bin/tools/sql/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql and executed it successfully, but executing sh ./tools/bin The /upgrade-schema.sh script reports an error;

But I created a new database and executed sh ./tools/bin/upgrade-schema.sh, no error was reported.

What you expected to happen

sh ./tools/bin/upgrade-schema.sh

How to reproduce

sh ./tools/bin/upgrade-schema.sh

Anything else

2023-10-19 19:10:44.476 INFO 5494 --- [main] o.a.d.t.d.UpgradeDolphinScheduler : Starting UpgradeDolphinScheduler v3.2.0 using Java 1.8.025 on s2-100 with PID 5494 (/opt/tmp/apache-dolphinscheduler-3.2. 0-bin/tools/libs/dolphinscheduler-tools-3.2.0.jar started by dolphinscheduler in /opt/tmp/apache-dolphinscheduler-3.2.0-bin) 2023-10-19 19:10:44.482 INFO 5494 --- [main] o.a.d.t.d.UpgradeDolphinScheduler : The following 2 profiles are active: "upgrade", "mysql" 2023-10-19 19:10:45.860 WARN 5494 --- [main] o.m.s.mapper.ClassPathMapperScanner: No MyBatis mapper was found in '[org.apache.dolphinscheduler.tools.datasource]' package. Please check your configuration. 2023-10-19 19:10:46.406 INFO 5494 --- [main] trationDelegate$BeanPostProcessorChecker : Bean 'io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsAutoConfiguration' of type [io.kubernetes.client.spring .extended.manifests.config.KubernetesManifestsAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.438 INFO 5494 --- [main] trationDelegate$BeanPostProcessorChecker : Bean 'kubernetes.manifests-io.kubernetes.client.spring.extended.manifests.config.KubernetesManifestsProperties' of type [io.kubernetes .client.spring.extended.manifests.config.KubernetesManifestsProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.445 INFO 5494 --- [main] trationDelegate$BeanPostProcessorChecker : Bean 'io.kubernetes.client.spring.extended.controller.config.KubernetesInformerAutoConfiguration' of type [io.kubernetes.client.spring .extended.controller.config.KubernetesInformerAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-19 19:10:46.795 INFO 5494 --- [main] trationDelegate$BeanPostProcessorChecker : Bean 'defaultApiClient' of type [io.kubernetes.client.openapi.ApiClient] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) | |_. __ | | | |\/|)(| | |\ |)|||_\ / | 3.5.2 2023-10-19 19:10:48.227 INFO 5494 --- [main] com.zaxxer.hikari.HikariDataSource: DolphinScheduler - Starting... 2023-10-19 19:10:48.445 INFO 5494 --- [main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Start completed. 2023-10-19 19:10:50.855 INFO 5494 --- [main] o.a.d.t.d.UpgradeDolphinScheduler : Started UpgradeDolphinScheduler in 7.277 seconds (JVM running for 7.975) 2023-10-19 19:10:50.869 INFO 5494 --- [main] o.a.d.t.d.DolphinSchedulerManager : The database has been initialized. Skip the initialization step 2023-10-19 19:10:50.891 INFO 5494 --- [main] o.a.d.t.d.DolphinSchedulerManager : upgrade DolphinScheduler metadata version from 3.1.7 to 3.2.0 2023-10-19 19:10:50.892 INFO 5494 --- [main] o.a.d.t.d.DolphinSchedulerManager: Begin upgrading DolphinScheduler's table structure 2023-10-19 19:10:50.906 INFO 5494 --- [main] o.a.d.common.sql.SqlScriptRunner: Execute sql: SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); success 2023-10-19 19:10:50.909 INFO 5494 --- [main] o.a.d.common.sql.SqlScriptRunner: Execute sql: DROP PROCEDURE IF EXISTS ut_dolphin_T_t_ds_fav; success 2023-10-19 19:10:50.912 INFO 5494 --- [main] o.a.d.common.sql.SqlScriptRunner: Execute sql: CREATE PROCEDURE ut_dolphin_T_t_ds_fav() BEGIN IF EXISTS (SELECT 1 FROM information_schema.TABLES WHERE TABLE_NAME='t_ds_fav' AND TABLE_SCHEMA=(SELECT DATABASE())) THEN ALTER TABLE t_ds_fav RENAME t_ds_fav_task; END IF; END;success 2023-10-19 19:10:50.931 ERROR 5494 --- [main] o.a.d.tools.datasource.dao.UpgradeDao: Execute ddl file failed, meet an unknown exception, schemaDir: 3.2.0_schema, ddlScript: dolphinscheduler_ddl.sql

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP PROCEDURE ut_dolphin_T_t_ds_fav; CREATE TABLE if not exists t_ds_fav_task' at line 2 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:768) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.common.sql.SqlScriptRunner.execute(SqlScriptRunner.java:58) ~[dolphinscheduler-common-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:158) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinScheduler(UpgradeDao.java:93) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:123) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler$UpgradeRunner.run(UpgradeDolphinScheduler.java:53) [dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:771) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:755) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) [spring-boot-2.7.3.jar:2.7.3] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler.main(UpgradeDolphinScheduler.java:36) [dolphinscheduler-tools-3.2.0.jar:3.2.0]

2023-10-19 19:10:50.935 INFO 5494 --- [main] ConditionEvaluationReportLoggingListener:

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. 2023-10-19 19:10:50.968 ERROR 5494 --- [main] o.s.boot.SpringApplication: Application run failed

java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:774) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:755) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) [spring-boot-2.7.3.jar:2.7.3] at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) [spring-boot-2.7.3.jar:2.7.3] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler.main(UpgradeDolphinScheduler.java:36) [dolphinscheduler-tools-3.2.0.jar:3.2.0] Caused by: java.lang.RuntimeException: Execute ddl file failed, meet an unknown exception at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:166) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinScheduler(UpgradeDao.java:93) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:123) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.UpgradeDolphinScheduler$UpgradeRunner.run(UpgradeDolphinScheduler.java:53) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:771) [spring-boot-2.7.3.jar:2.7.3] ... 5 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP PROCEDURE ut_dolphin_T_t_ds_fav; CREATE TABLE if not exists t_ds_fav_task' at line 2 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:768) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) ~[mysql-connector-java-8.0.27.jar:8.0.27] at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na] at org.apache.dolphinscheduler.common.sql.SqlScriptRunner.execute(SqlScriptRunner.java:58) ~[dolphinscheduler-common-3.2.0.jar:3.2.0] at org.apache.dolphinscheduler.tools.datasource.dao.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:158) ~[dolphinscheduler-tools-3.2.0.jar:3.2.0] ... 9 common frames omitted

2023-10-19 19:10:50.974 INFO 5494 --- [main] com.zaxxer.hikari.HikariDataSource : DolphinScheduler - Shutdown initiated... 2023-10-19 19:10:50.993 INFO 5494 --- [main] com.zaxxer.hikari.HikariDataSource: DolphinScheduler - Shutdown completed.

Version

3.2.x

Are you willing to submit PR?

Code of Conduct

aruizhong commented 12 months ago

我用的伪集群部署方式,我尝试3.1.7升级到3.2.0,但是更新数据库脚本报错; 于是我尝试直接安装3.2.0,但是无法生成workflow 实例,我从issue 15041中得知,重新下载tar包并部署了,解决了“无法生成workflow 实例”问题; 但是3.1.7升级到3.2.0的upgrade-schema.sh还是报一样的错误 @zhongjiajie

ruanwenjun commented 12 months ago

Should be fixed by https://github.com/apache/dolphinscheduler/pull/15043

github-actions[bot] commented 10 months ago

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

q4q5q6qw commented 10 months ago

我用的伪集群部署方式,我尝试3.1.7升级到3.2.0,但是更新数据库脚本报错; 于是我尝试直接安装3.2.0,但是无法生成workflow 实例,我从issue 15041中得知,重新下载tar包并部署了,解决了“无法生成workflow 实例”问题; 但是3.1.7升级到3.2.0的upgrade-schema.sh还是报一样的错误 @zhongjiajie

俺也一样,从3.1.1升级至3.2.0SQL报错,但是从源码中拿出来执行不报错

llphxd commented 10 months ago

我也是3.1.7升级3.2.0,执行更新数据库脚本时,出现同样报错,期待修复

kbxu commented 9 months ago

我也是3.1.7升级3.2.0,执行更新数据库脚本时,出现同样报错,期待修复

sql拿出来手动跑一遍就行了 楼上回复里#15043说那个parser写的有点问题

zhongjiajie commented 8 months ago

我也是3.1.7升级3.2.0,执行更新数据库脚本时,出现同样报错,期待修复

sql拿出来手动跑一遍就行了 楼上回复里#15043说那个parser写的有点问题

We fix in #15043 and will be release in version 3.2.1 during those days, will close this