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 2021/10/29 01:11:09 UTC
[GitHub] [dolphinscheduler] choucmei opened a new issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
choucmei opened a new issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628
### 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
when i use script/create-dolphinscheduler.sh to create init database 'dolphinscheduler2', i got this exception.
08:58:12.170 [main] ERROR org.apache.dolphinscheduler.dao.upgrade.UpgradeDao - Table 'dolphinscheduler2.t_ds_version' doesn't exist
java.sql.SQLSyntaxErrorException: Table 'dolphinscheduler2.t_ds_version' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1005)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.getCurrentVersion(UpgradeDao.java:246)
at org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:101)
at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler.main(CreateDolphinScheduler.java:41)
08:58:12.172 [main] DEBUG com.alibaba.druid.pool.PreparedStatementPool - stmt exit cache
08:58:12.172 [main] ERROR org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler - create DolphinScheduler failed
java.lang.RuntimeException: sql: select version from t_ds_version
at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.getCurrentVersion(UpgradeDao.java:256)
at org.apache.dolphinscheduler.dao.upgrade.DolphinSchedulerManager.upgradeDolphinScheduler(DolphinSchedulerManager.java:101)
at org.apache.dolphinscheduler.dao.upgrade.shell.CreateDolphinScheduler.main(CreateDolphinScheduler.java:41)
Caused by: java.sql.SQLSyntaxErrorException: Table 'dolphinscheduler2.t_ds_version' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1005)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at org.apache.dolphinscheduler.dao.upgrade.UpgradeDao.getCurrentVersion(UpgradeDao.java:246)
... 2 common frames omitted
Process finished with exit code 0
### What you expected to happen
got success.
### How to reproduce
because i didn't drop old database 'dolphinscheduler ',and sametimes i want to create database 'dolphinscheduler2'.
org.apache.dolphinscheduler.dao.upgrade.MysqlUpgradeDao#isExistsTable
this method just check table exists, didn't specify the database.
if other database contains same table of name, it got true from this method.
conn.getMetaData().getTables(null, null, tableName, null);
this should specify catalog and schema .
org.apache.dolphinscheduler.dao.upgrade.MysqlUpgradeDao#isExistsColumn this method sames too.
### Anything else
And this BUG maybe exists in postgreSQL. i will check soon
### 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: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] choucmei removed a comment on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei removed a comment on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-954333418
I wiil submit PR soon.
--
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
[GitHub] [dolphinscheduler] choucmei commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-954333362
I wiil submit PR soon.
--
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
[GitHub] [dolphinscheduler] github-actions[bot] closed issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628
--
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
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-954333005
Hi:
* Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can subscribe to the developer's email,Mail subscription steps reference https://dolphinscheduler.apache.org/zh-cn/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.
--
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
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-984172784
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.
--
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
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-989330370
This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.
--
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
[GitHub] [dolphinscheduler] choucmei commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-954333418
I wiil submit PR soon.
--
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
[GitHub] [dolphinscheduler] choucmei commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-955887334
> Hi:
>
> * Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
> * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
> * If you haven't received a reply for a long time, you can subscribe to the developer's email,Mail subscription steps reference https://dolphinscheduler.apache.org/zh-cn/community/development/subscribe.html ,Then write the issue URL in the email content and send question to [dev@dolphinscheduler.apache.org](mailto:dev@dolphinscheduler.apache.org).
#6646
--
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
[GitHub] [dolphinscheduler] choucmei removed a comment on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei removed a comment on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-955887334
> Hi:
>
> * Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
> * In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
> * If you haven't received a reply for a long time, you can subscribe to the developer's email,Mail subscription steps reference https://dolphinscheduler.apache.org/zh-cn/community/development/subscribe.html ,Then write the issue URL in the email content and send question to [dev@dolphinscheduler.apache.org](mailto:dev@dolphinscheduler.apache.org).
#6646
--
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
[GitHub] [dolphinscheduler] choucmei commented on issue #6628: [Bug] [DAO] Check Table or Column didn't specify the catalog(database)
Posted by GitBox <gi...@apache.org>.
choucmei commented on issue #6628:
URL: https://github.com/apache/dolphinscheduler/issues/6628#issuecomment-955878064
#6646
--
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