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

Show information about SQL statement in the debug log about coprocessor encountering lock #27718

Closed
MyonKeminta opened this issue Sep 1, 2021 · 0 comments · Fixed by #27735
Closed

Show information about SQL statement in the debug log about coprocessor encountering lock #27718

MyonKeminta opened this issue Sep 1, 2021 · 0 comments · Fixed by #27735
Assignees
@MyonKeminta
Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. type/enhancement The issue or PR belongs to an enhancement.

Comments

@MyonKeminta
Copy link
Contributor

Enhancement

When coprocessor reading meets lock, TiDB will print a debug log. However it shows nothing about the related SQL statements, and there's not anywhere else that shows the statements that's affected by the lock. If this log can print the statement, it will be helpful for diagnose some problems. Of course, the statement in the log should be redacted according to the security options.
@MyonKeminta MyonKeminta added the type/enhancement The issue or PR belongs to an enhancement. label Sep 1, 2021
@MyonKeminta MyonKeminta self-assigned this Sep 1, 2021
This was referenced Sep 1, 2021
Merged
Closed
This was referenced Sep 9, 2021
Merged
Merged
Merged
Merged
@MyonKeminta MyonKeminta added affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. labels Dec 16, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@MyonKeminta MyonKeminta

Labels
affects-4.0 This bug affects 4.0.x versions. affects-5.0 This bug affects 5.0.x versions. affects-5.1 This bug affects 5.1.x versions. affects-5.2 This bug affects 5.2.x versions. type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

*: Log SQL statement when coprocessor encounteres lock MyonKeminta/tidb
1 participant
@MyonKeminta