Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

fix: db 账号没有 super 权限，导致 job-backup 微服务启动失败 #2213

Closed
wangyu096 opened this issue Jul 11, 2023 · 1 comment
Closed

fix: db 账号没有 super 权限，导致 job-backup 微服务启动失败 #2213

wangyu096 opened this issue Jul 11, 2023 · 1 comment
Assignees
@wangyu096
Labels
done 已上线到正式环境并验收通过 kind/bug 程序故障Bug，漏洞

Comments

@wangyu096
Copy link
Collaborator

Version / Branch / tag
3.7.x

出了什么问题？(What Happened?)
db 账号没有 super 权限，导致 job-backup 微服务启动失败
image

如何复现？(How to reproduce?)
见问题描述

预期结果(What you expect?)
使用普通账号即可启动微服务
@wangyu096 wangyu096 added kind/bug 程序故障Bug，漏洞 backlog 需求初始状态，等待产品进行评估 todo 进入开发排期的状态，纳入了最近的迭代 labels Jul 11, 2023
@wangyu096 wangyu096 self-assigned this Jul 11, 2023
@wangyu096
Copy link
Collaborator Author

报错原因分析

#1728 引入的 jdbc url 中的参数 sessionVariables=binlog_format=statement 需要 super 权限

wangyu096 added a commit to wangyu096/bk-job that referenced this issue Jul 11, 2023
@wangyu096
fix: db 账号没有 super 权限，导致 job-backup 微服务启动失败 TencentBlueKing#2213
47186ad
jsonwan added a commit that referenced this issue Jul 11, 2023
@jsonwan
Merge pull request #2214 from wangyu096/issue_2213
dab5b71 
fix: db 账号没有 super 权限，导致 job-backup 微服务启动失败 #2213
@bkjob-bot bkjob-bot added for test 可以在测试环境进行验收 done 已上线到正式环境并验收通过 and removed backlog 需求初始状态，等待产品进行评估 todo 进入开发排期的状态，纳入了最近的迭代 for test 可以在测试环境进行验收 labels Jul 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wangyu096 wangyu096

Labels
done 已上线到正式环境并验收通过 kind/bug 程序故障Bug，漏洞
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@wangyu096 @bkjob-bot