EC
3072
MariaDBERRORNotableSchemaHIGH confidence

Wrong structure for native performance schema table

Production Risk

High — performance monitoring may be unavailable until resolved.

What this means

The structure of a native Performance Schema table does not match the expected structure, usually because the table was manually altered or corrupted.

Why it happens
  1. 1Manual ALTER TABLE on a performance_schema table.
  2. 2Schema mismatch after an in-place upgrade.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered on server start or when accessing performance_schema

expected output

ERROR 3072 (HY000): Native table 'performance_schema'.'<table>' has the wrong structure.

Fix

Run mysql_upgrade to repair schema mismatches

Run mysql_upgrade to repair schema mismatches
mysql_upgrade -u root -p

Why this works

Rebuilds system tables to match the expected server version structure.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 3072 ER_WRONG_NATIVE_TABLE_STRUCTURE2

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors