[ERROR] Error message file /usr/share/mysql/errmsg.sys had only 1118 error messages, but it should contain at least 3076 error messages

今天碰到怪問題, mariadb 重開失敗, 直接跑 mysqld 碰到這個訊息

[ERROR] Error message file '/usr/share/mysql/errmsg.sys' had only 1118 error messages, but it should contain at least 3076 error messages

重編一次 mariadb , 然後到 /var/tmp/portage 找 errmsg.sys 這個檔案, 然後 copy 到 /usr/share/mysql/errmsg.sys

# cd /var/tmp/portage
# find -name errmsg*.sys
# cp ./dev-db/mariadb-10.2.9/work/mysql-abi_x86_64.amd64/sql/share/english/errmsg.sys /usr/share/mysql/errmsg.sys
# /etc/init.d/mysql restart

2018/02/24 Update

這樣比較快

# cp /usr/share/mariadb/english/errmsg.sys /usr/share/mysql/errmsg.sys