pmm-agent crashed at query.Fingerprint due to query including a column named "value"

Description

When collecting queries from slow-log, the pmm-agent crashed with the messages below.

 

The slow query is

reproduce

How to test

  • Set up PMM and add MySQL with slowlog as query source

  • Run problematic query on the MySQL server (mysql -BNe "set long_query_time = 0; INSERT INTO test ( ID, Value ) VALUES (1,1)";)

How to document

None

AFFECTED CS IDs

CS0053319

Activity

Show:

Michael Okoko 
April 22, 2025 at 6:47 AM

Thanks , I was able to reproduce it as well.

jinyou.ma 
April 22, 2025 at 4:38 AM

I tested on pmm2 and 3.

Michael Okoko 
April 14, 2025 at 7:32 PM

is it also possible to get the PMM version/PMM agent version that this happened on?

Sveta Smirnova 
March 6, 2025 at 11:14 AM

Slow query log:

Sveta Smirnova 
March 6, 2025 at 11:10 AM

MySQL version is: Server version: 8.0.34-26 Percona Server (GPL), Release '26', Revision '0fe62c85'

Done

Details

Assignee

Reporter

Priority

Components

Needs QA

Needs Doc

Planned Version/s

Fix versions

Story Points

Sprint

Affects versions

Start date

Due date

Created February 27, 2025 at 2:45 AM
Updated May 5, 2025 at 8:55 AM
Resolved May 5, 2025 at 8:55 AM