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 2020/09/28 08:15:47 UTC
[GitHub] [incubator-dolphinscheduler] yangruochen opened a new issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
yangruochen opened a new issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845
Description：
I install the dolphinscheduler in Ambari, I try to start DS_Api and hit the bug :
15:48:43.481 [main] INFO org.apache.dolphinscheduler.common.utils.ScriptRunner - sql: CALL ct_dolphin_T_t_ds_process_definition_version
15:48:43.492 [main] ERROR org.apache.dolphinscheduler.common.utils.ScriptRunner - SQLException
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 't_ds_process_definition_version' already exists
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:729)
at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:633)
at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:145)
at org.apache.dolphinscheduler.common.utils.ScriptRunner.runScript(ScriptRunner.java:75)
at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.upgradeDolphinSchedulerDDL(UpgradeDao.java:410)
at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.upgradeDolphinScheduler(UpgradeDao.java:258)
at org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:117)
at org.apache.dolphinscheduler.dao.upgrade.shell.UpgradeDolphinScheduler.main(UpgradeDolphinScheduler.java:36)
Screenshots
version:
dev
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] yangruochen closed issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
yangruochen closed issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] yangruochen commented on issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
yangruochen commented on issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845#issuecomment-699876769
because of pull request #3053 , the t_ds_process_definition_version was added.
I delete upgrade-dolphinscheduler in dolphin_api_service.py, because there is upgradeDolphinScheduler in CreateDolphinScheduler.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] yangruochen commented on issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
yangruochen commented on issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845#issuecomment-699908978
> I think the problem is in the schema file. Not here.
> In order to ensure that the table structure metadata is up to date, we need to execute the upgrade-dolphinscheduler.sh script at startup. This script will automatically check the current version number and execute the corresponding upgrade sql file.
>
> Therefore, we require that the sql file in the schema must meet the ability of repeatable execution.
> In order to achieve this goal, if we need to create the table t_ds_process_definition_version, then we should use
>
> ```
> create table IF NOT EXISTS t_ds_process_definition_version;
> ```
>
> or
>
> ```
> drop table if exists t_ds_process_definition_version;
> create table t_ds_process_definition_version;
> ```
ok, thank you, I correct it.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] yangruochen closed issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
yangruochen closed issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] gaojun2048 commented on issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
gaojun2048 commented on issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845#issuecomment-699897669
I think the problem is in the schema file. Not here.
In order to ensure that the table structure metadata is up to date, we need to execute the upgrade-dolphinscheduler.sh script at startup. This script will automatically check the current version number and execute the corresponding upgrade sql file.
Therefore, we require that the sql file in the schema must meet the ability of repeatable execution.
In order to achieve this goal, if we need to create the table t_ds_process_definition_version, then we should use
```
create table IF NOT EXISTS t_ds_process_definition_version;
```
or
```
drop table if exists t_ds_process_definition_version;
create table t_ds_process_definition_version;
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] yangruochen edited a comment on issue #3845: [Bug][Ambari Plugin] Start Ambari report an error: Table 't_ds_process_definition_version' already exists
Posted by GitBox <gi...@apache.org>.
yangruochen edited a comment on issue #3845:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/3845#issuecomment-699876769
because of pull request #3053 , the t_ds_process_definition_version was added.
I delete upgrade-dolphinscheduler in dolphin_api_service.py, because there is upgradeDolphinScheduler in CreateDolphinScheduler.java.
中文：
因为pull request #3053, t_ds_process_definition_version被添加进了sql里。
我把dolphin_api_service.py里的upgrade-dolphinscheduler删掉了，因为create-dolphinscheduler.sh对应的java代码CreateDolphinScheduler，其中已经有upgradeDolphinScheduler方法了
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org