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/04/29 14:07:21 UTC

[GitHub] [dolphinscheduler] AirToSupply opened a new issue, #9854: [Bug] [api] Query access token for specified user failed

AirToSupply opened a new issue, #9854:
URL: https://github.com/apache/dolphinscheduler/issues/9854

   ### 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
   
   We try to pull the dev branch to try to deploy the cluster. When storing metadata through the **PostgreSQL** database, an exception occurred when calling the following interface to **query access token for specified user**. The interface method signature is as follows:
   
   ![image](https://user-images.githubusercontent.com/62897740/165958850-19673cdb-9cd6-4c8a-bbab-a6d9b73d0627.png)
   
   The exception log is as follows:
   
   ![image](https://user-images.githubusercontent.com/62897740/165959122-309e49dd-1f1c-43ca-b3df-a4033629a378.png)
   
   
   ### What you expected to happen
   
   There is a problem with the queryAccessTokenByUser method SQL in the AccessTokenMapper.xml file. The main problem is that MySQL can use the '**`**' symbol to represent the field name, but it is not supported in PostgreSQL.
   
   ### How to reproduce
   
   This exception works with MySQL database as storage, but as PostgreSQL database will generate exception
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   dev
   
   ### 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.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #9854: [Bug] [api] Query access token for specified user failed

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #9854:
URL: https://github.com/apache/dolphinscheduler/issues/9854#issuecomment-1113356905

   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://join.slack.com/t/asf-dolphinscheduler/shared_invite/zt-omtdhuio-_JISsxYhiVsltmC5h38yfw) 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] SbloodyS closed issue #9854: [Bug] [api] Query access token for specified user failed

Posted by GitBox <gi...@apache.org>.
SbloodyS closed issue #9854: [Bug] [api] Query access token for specified user failed
URL: https://github.com/apache/dolphinscheduler/issues/9854


-- 
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] SbloodyS commented on issue #9854: [Bug] [api] Query access token for specified user failed

Posted by GitBox <gi...@apache.org>.
SbloodyS commented on issue #9854:
URL: https://github.com/apache/dolphinscheduler/issues/9854#issuecomment-1113901076

   close due to #9855 


-- 
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