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


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.


Best Regard


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.

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

You may find required configuration steps in the next forum thread