mariadb stuck

[microz]

mariadb stuck [solved]

Hi,

For some reason in CentOS 7 (with nat), mariadb It gets stuck trying to start (Is a fresh install of CentOS and Directadmin)

I'm trying reinstall with custombuild.

./build set mysql_inst mariadb
./build mysql

And getting some errors

Preparing...                          ################################# [100%]
Updating / installing...
   1:MariaDB-common-10.0.23-1.el7.cent################################# [ 17%]
   2:MariaDB-client-10.0.23-1.el7.cent################################# [ 33%]
   3:MariaDB-server-10.0.23-1.el7.cent################################# [ 50%]
   4:MariaDB-devel-10.0.23-1.el7.cento################################# [ 67%]
   5:MariaDB-shared-10.0.23-1.el7.cent################################# [ 83%]
   6:MariaDB-compat-10.0.23-1.el7.cent################################# [100%]
Job for mysqld.service failed because a fatal signal was delivered to the control process. See "systemctl status mysqld.service" and "journalctl -xe" for details.
Giving mysqld a few seconds to start up...
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") when trying to connect
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.

UPDATE - Logs

160124  6:29:02 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
160124  6:29:02 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
160124  6:29:02 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
160124  6:29:02 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
160124  6:29:02 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
160124  6:29:02 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
160124  6:29:02 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MariaDB 50541, now running 100023. Please use mysql_upgrade to fix this error.
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
160124  6:29:02 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure

Any suggestion?

Solved
I reinstall DB with:
http://help.directadmin.com/item.php?id=563

Rgds,