Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Again: Error 1054: Unknown column 'performance_schema.events_statements_summary_by_digest.QUERY_SAMPLE_TEXT' in 'field list'

Description

User impact:

pmm-agent.log is cluttered with 'Unknown column...' errors when MariaDB from Debian package (10.2, 10.3, 10.4, 10.5) is added to monitoring

STR:

Install PMM Server and Client
Add MariaDB to PMM

Check pmm-agent.log

Result:

How to test.

How to test example

1. Start PMM server.
2. Start a MariaDB instance from a Debian distribution.
For my tests I started a Debian docker container and then manually installed MariaDB inside it.

3. Get your local IP address to use it when adding the MariaDB instance to PMM

4. Config pmm-admin inside the pmm-server docker container.

5. Add the MariaDB instance

6. Check there are no errors in the log (the output should be empty).

Solution:
Check if vendor is Debian, and the version string has mariadb, set vendor as mariadb

How to test

None

How to document

None

Attachments

2

Smart Checklist

Activity

Show:

Carlos Salguero June 7, 2022 at 6:12 PM

Thanks  

Vadym Yarosh June 3, 2022 at 8:27 PM

there is no need to doublecheck since I've got the correct scenario to reproduce the issue. And the fix works fine. The difference is that I have pmm-agent in container and logs are there but not on the pmm server side. Attached files launches Debian 10 with MariaDB 10.3 version. 

Vadym Yarosh June 3, 2022 at 2:19 PM
Edited

Adjusted my comment and scenario, for the pmm-client container logs are is the docker.

So the correct place to look for target error is 

I'm able to reproduce the issue and confirm the fix.

Carlos Salguero June 3, 2022 at 10:55 AM

PMM 2.29 is planned for the end of June. There will be the standard client/server packages you can download.

Ingo Zansinger June 3, 2022 at 10:30 AM

Thank you folks so far

@Vadym I'm not (yet) that into docker but imho your scenario is correct.

Just for double check you could dump the two SQL version variables to see if they match mine.

 

PS: any clue how long it aprox. will take till this bugfix makes it's way into the debian repository / there will be a temporary .deb?

Done

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Fix versions

Story Points

Affects versions

Environment

Debian 11

Smart Checklist

Created May 11, 2022 at 12:17 AM
Updated March 6, 2024 at 1:14 AM
Resolved June 7, 2022 at 7:59 AM
Configure