[MDEV-36873] aria_block_size=4096 is unusable - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Duplicate
Affects Version/s: 10.6, 10.11, 11.4, 11.8
Fix Version/s: N/A
Component/s: Storage Engine - Aria, Variables
Labels:
None

Bug Category:
Not for Release Notes

Description

In 10.4 in the scope of ~~MDEV-19805~~ the minimal value of aria_block_size was changed from 1024 to 4096, because 1024 didn't work for system tables anymore.

Now we have the same problem with 4096 – starting from 10.6 apparently due to longer fields in mysql.db and such, the server cannot bootstrap with aria_block_size=4096, so I the min value needs to be bumped up again, to 8192.

10.6 60f046d7e6b0a61f9b0762fe05c4021cff1b79d8
data/bld/10.6/scripts/mysql_install_db --no-defaults --plugin-dir=/data/bld/10.6/lib/plugin --srcdir=/data/bld/10.6 --datadir=/data/bld/10.6/data --aria-block-size=4096
Installing MariaDB/MySQL system tables in '/data/bld/10.6/data' ...
ERROR: 1071 Specified key was too long; max key length is 1233 bytes
2025-05-24 16:26:31 0 [ERROR] Aborting

Attachments

Issue Links

is duplicated by

MDEV-30278 4K aria block size is no longer usable, bootstrap fails

Open

relates to

MDEV-19805 Changing aria block size to 1024 will break install_system_tables

Closed

Activity

People

Assignee:: Michael Widenius

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2025-05-24 13:27

Updated:: 2025-05-25 13:22

Resolved:: 2025-05-24 23:43

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.