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/03/15 02:15:04 UTC
[GitHub] [dolphinscheduler] lordk911 opened a new issue #8889: [Bug] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
lordk911 opened a new issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889
### 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
upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work:
[ERROR] 2022-03-15 09:38:30.560 TaskLogLogger-class org.apache.dolphinscheduler.plugin.task.sql.SqlTask:[160] - sql task error: java.lang.RuntimeException: JDBC connect failed
[ERROR] 2022-03-15 09:38:30.561 org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread:[207] - task scheduler failure
java.lang.RuntimeException: JDBC connect failed
at org.apache.dolphinscheduler.plugin.datasource.api.client.CommonDataSourceClient.checkClient(CommonDataSourceClient.java:106)
at org.apache.dolphinscheduler.plugin.datasource.api.client.CommonDataSourceClient.<init>(CommonDataSourceClient.java:55)
at org.apache.dolphinscheduler.plugin.datasource.oracle.OracleDataSourceClient.<init>(OracleDataSourceClient.java:27)
at org.apache.dolphinscheduler.plugin.datasource.oracle.OracleDataSourceChannel.createDataSourceClient(OracleDataSourceChannel.java:29)
at org.apache.dolphinscheduler.plugin.datasource.api.plugin.DataSourceClientProvider.lambda$getConnection$0(DataSourceClientProvider.java:64)
at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
at org.apache.dolphinscheduler.plugin.datasource.api.plugin.DataSourceClientProvider.getConnection(DataSourceClientProvider.java:58)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:183)
at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:154)
at org.apache.dolphinscheduler.server.worker.runner.TaskExecuteThread.run(TaskExecuteThread.java:189)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:57)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:431)
at org.apache.dolphinscheduler.plugin.datasource.api.client.CommonDataSourceClient.checkClient(CommonDataSourceClient.java:104)
... 16 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
### What you expected to happen
all my job faild
### How to reproduce
a jdbc datasouce create in 2.0.0 or before then upgrade to 2.0.5
### Anything else
_No response_
### Version
2.0.5
### Are you willing to submit PR?
- [ ] 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] lordk911 commented on issue #8889: [Bug][DataSource] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
lordk911 commented on issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889#issuecomment-1069844865
> > it's because the datasource create in 2.0.0 didn't not have property : validationQuery
>
> It seems that you had found the reason, can you submit a pr to fix this issue?
@caishunfeng I have submited a PR
--
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] caishunfeng commented on issue #8889: [Bug][DataSource] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
caishunfeng commented on issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889#issuecomment-1067755959
> it's because the datasource create in 2.0.0 didn't not have property : validationQuery
It seems that you had found the reason, can you submit a pr to fix this issue?
--
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] caishunfeng closed issue #8889: [Bug][DataSource] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
caishunfeng closed issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889
--
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] lordk911 commented on issue #8889: [Bug][DataSource] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
lordk911 commented on issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889#issuecomment-1067718916
> > Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
>
> Hi @lordk911 can you provide the sql in `how to reproduce`?
it's because the datasource create in 2.0.0 didn't not have property : validationQuery
--
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 #8889: [Bug] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889#issuecomment-1067489635
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/en-us/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] caishunfeng commented on issue #8889: [Bug] upgrade from 2.0.0 to 2.0.5 then oracle datasource will not to work
Posted by GitBox <gi...@apache.org>.
caishunfeng commented on issue #8889:
URL: https://github.com/apache/dolphinscheduler/issues/8889#issuecomment-1067713727
>Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
Hi @lordk911 can you provide the sql in `how to reproduce`?
--
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