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.

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

Error displaying binded SQL of v2.0.3 #7047

Open
zxymd5 opened this issue Jul 22, 2020 · 0 comments
Open

Error displaying binded SQL of v2.0.3 #7047

zxymd5 opened this issue Jul 22, 2020 · 0 comments

Comments

@zxymd5
Copy link

zxymd5 commented Jul 22, 2020

Prerequisites

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

I have checked the FAQ, and issues and found no answer.

What version of pinpoint are you using?

v2.0.3 v1.8.5

Describe the bug

Our microservice using Postgresql 10 and jooq 3.9.4. When we use the pinpoint 2.0.3 docker edition, there's a display error showing binded sql like belowing:

select
  & quot;
public & quot;.& quot;
users & quot;.& quot;
user_id & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
username & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
password & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
enabled & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
name & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
gender & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
email & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
created_date & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
updated_date & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
last_login & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
language & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
mobile & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
nick_name & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
country_code & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
resources_access_type & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
device_channel_id & quot;,
  & quot;
public & quot;.& quot;
users & quot;.& quot;
password_flag & quot;
from
  & quot;
public & quot;.& quot;
users & quot;
where
  & quot;
public & quot;.& quot;
users & quot;.& quot;
username & quot;
= 'gm_admin'

while the original sql is normally displayed:
select "public"."users"."user_id", "public"."users"."username", "public"."users"."password", "public"."users"."enabled", "public"."users"."name", "public"."users"."gender", "public"."users"."email", "public"."users"."created_date", "public"."users"."updated_date", "public"."users"."last_login", "public"."users"."language", "public"."users"."mobile", "public"."users"."nick_name", "public"."users"."country_code", "public"."users"."resources_access_type", "public"."users"."device_channel_id", "public"."users"."password_flag" from "public"."users" where "public"."users"."username" = ?
But when I use the 1.8.5 edition without docker. This problem doesn't occur. The binded sql is correctly displayed as belowing:

select "public"."users"."user_id", "public"."users"."username", "public"."users"."password", "public"."users"."enabled", "public"."users"."name", "public"."users"."gender", "public"."users"."email", "public"."users"."created_date", "public"."users"."updated_date", "public"."users"."last_login", "public"."users"."language", "public"."users"."mobile", "public"."users"."nick_name", "public"."users"."country_code", "public"."users"."resources_access_type", "public"."users"."device_channel_id", "public"."users"."password_flag" from "public"."users" where "public"."users"."username" = 'gm_admin'

Following are the command line for invoking:

java -javaagent:D:\pinpoint-agent-2.0.3\pinpoint-bootstrap.jar -Dpinpoint.agentId=gclife-registry-peer1 -Dpinpoint.applicationName=gclife-registry-peer1 -Xms100m -Xmx100m -jar gclife-registry.jar

java -javaagent:D:\pp-agent\pinpoint-bootstrap-1.8.5.jar -Dpinpoint.agentId=gclife-registry-peer1 -Dpinpoint.applicationName=gclife-registry-peer1 -Xms100m -Xmx100m -jar gclife-registry.jar

I think this gonna be a html problem.

What did you do to trigger the bug?

Steps to reproduce, for example:
java -javaagent:D:\pinpoint-agent-2.0.3\pinpoint-bootstrap.jar -Dpinpoint.agentId=gclife-registry-peer1 -Dpinpoint.applicationName=gclife-registry-peer1 -Xms100m -Xmx100m -jar gclife-registry.jar

Screenshots

This is the v2.0.3 screenshot:
result

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

1 participant