Skip to content

Performance schema and Sysschema installation for MariaDB >= 10.4 fails #556

@jeremyj11

Description

@jeremyj11

mysql -u root -p < ./sys_10.sql
on mariadb >= 10.4 fails with:

ERROR 1054 (42S22) at line 78 in file: './views/p_s/metrics_56.sql': Unknown column 'STATUS' in 'field list'

Due to:
prometheus/mysqld_exporter#494

Solution is to change line 78 in file: './views/p_s/metrics_56.sql' from:
IF(STATUS,'enabled'
to
IF(ENABLED,'1'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions