PMM 2.12 => Error 1109: Unknown table 'INNODB_SYS_TABLESPACES'

MySQL & MariaDB Other MySQL® Questions
1

Hello

My config:

Database 8.0.20 MySQL Community Server

PMM Server 2.12.0

PMM Client (admin/agent) 2.12.0

I am getting this error in my /var/log/messages every minutes.

time=“2020-12-22T11:07:55+01:00” level=error msg=“Error scraping for collect.info_schema.innodb_tablespaces: Error 1109: Unknown table ‘INNODB_SYS_TABLESPACES’ in information_schema”

It possible to disabled this.

Thanks

Best Regard

2

Hi,

It’s related to enabled collectors by default (–collect.info_schema.innodb_tablespaces). Now it’s not possible to enable/disable collectors.

We have got the ticket for adding such functionality.

https://jira.percona.com/browse/PMM-4994

3

Thanks for your feedback.

It’s possible to kept the logs separate and tidy in PMM Client server?.

for exemple log for pmm => /var/log/pmm2.log

best regard

4

You may find required configuration steps in the next forum thread

https://forums.percona.com/discussion/comment/57969