3134
MariaDBERRORNotableDDLHIGH confidence
Identifier causes too long file path
Production Risk
Low — typically encountered at creation time; easy to work around with shorter names.
What this means
The combination of the data directory path, database name, table name, and/or partition name produces a file path that exceeds the operating system limit (typically 512 characters on Linux).
Why it happens
- 1Very long database names or table names that, combined with the MySQL data directory path, exceed OS path length limits.
- 2Deeply nested or verbose partition names.
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE very_long_database_name.another_very_long_table_name_here (id INT);
expected output
ERROR 3134 (HY000): The file path is too long. Reduce identifier length.
Fix 1
Use shorter database and table names
Use shorter database and table names
CREATE TABLE short_db.short_tbl (id INT);
Why this works
Shorter names produce shorter file paths that fit within OS limits.
Fix 2
Move the MySQL data directory to a shorter base path
Move the MySQL data directory to a shorter base path
-- Edit my.cnf: datadir=/d
Why this works
Reduces the base portion of the constructed path.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3134 ER_IDENT_CAUSES_TOO_LONG_PATH2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev