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/10/13 05:58:04 UTC
[GitHub] [dolphinscheduler] lugela opened a new issue, #12349: [Bug] [sql task pulgin] Users are locked after oracle password is changed
lugela opened a new issue, #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349
### 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
After the oracle password of the database data source is updated and the data source center is changed at the same time, it is found that the used connection pool has cached the old password, which causes the database user to be locked due to multiple connections with the old password
![Uploading 0a3a6185cad4c37c80e554b4463bb00.jpg…]()
### What you expected to happen
After the oracle password of the database data source is updated and the data source center is changed at the same time, it is found that the used connection pool has cached the old password, which causes the database user to be locked due to multiple connections with the old password
### How to reproduce
no
### Anything else
no
### Version
3.0.x
### 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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] fuchanghai commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
fuchanghai commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1281726952
> > > Does anyone want to repair this bug? If not, I want to repair this bug
> >
> >
> > I don't have a good idea at the moment
>
> Maybe we can do it together
> > Does anyone want to repair this bug? If not, I want to repair this bug
>
> I don't have a good idea at the moment
maybe you can refer to the interface ```/projects/{projectCode}/executors/execute```
--
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 #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1441043468
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] ruanwenjun commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
ruanwenjun commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1277115463
Good catch, when we update the password, we need to notify the worker to expire their old datasource.
--
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] zhongjiajie commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
zhongjiajie commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1280174091
@xdu-chenrj Hi, I assign to you now
--
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 #12349: [Bug] [sql task pulgin] Users are locked after oracle password is changed
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1277069137
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 [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`
--
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] lugela commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
lugela commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1280126089
> Does anyone want to repair this bug? If not, I want to repair this bug
I don't have a good idea at the moment
--
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] xdu-chenrj commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
xdu-chenrj commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1280733870
> > Does anyone want to repair this bug? If not, I want to repair this bug
>
> I don't have a good idea at the moment
Maybe we can do it together
--
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] xdu-chenrj commented on issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by GitBox <gi...@apache.org>.
xdu-chenrj commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1279931170
Does anyone want to repair this bug? If not, I want to repair this bug
--
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 #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #12349:
URL: https://github.com/apache/dolphinscheduler/issues/12349#issuecomment-1423413248
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] closed issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #12349: [Bug] [sql task pulgin] After the oracle user password is changed, the oracle user will be locked after the synchronization change in the data source center
URL: https://github.com/apache/dolphinscheduler/issues/12349
--
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