Skip to content

Incorrect Query Logging in Pinpoint #12062

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.

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

Open
DAVE2404 opened this issue Feb 20, 2025 · 0 comments
Open

Incorrect Query Logging in Pinpoint #12062

DAVE2404 opened this issue Feb 20, 2025 · 0 comments
Assignees

Comments

@DAVE2404
Copy link

Prerequisites

Please check the FAQ, and search existing issues for similar questions before creating a new issue.YOU MAY DELETE THIS PREREQUISITES SECTION.

What version of pinpoint are you using?

agent/collector/web 2.3.3
Mysql 8.0.32
jdbc

Describe the bug

There is an issue where the actual query executed and logged by Tomcat differs from the query captured in Pinpoint.

Expected Query (Actual Executed Query & Tomcat Log):

WHERE 1=1
AND a.cntrt_doc_type = 'n'
AND a.cntrt_status IN ('e', 'a', 'c', 's', 'u', 'o')
AND a.srch_type = '1'

Query Captured in Pinpoint:

WHERE a=c
AND a.cntrt_doc_type = 's'
AND a.cntrt_status IN ('u', 'o', '1', '%Y-%m-%d', '%Y-%m-%d', '%Y-%m-%d')
AND a.srch_type = '%Y-%m-%d'

What did you do to trigger the bug?

The query structure and conditions appear to be incorrectly altered in the data displayed by Pinpoint.
It seems that input values are shifted, possibly due to spaces, tabs, or formatting differences rather than incorrect value bindings.
The degree of misalignment varies across different cases.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants