Skip to main content

Reinstall MySQL on cPanel?

Comments

4 comments

  • navhost
    I've got a problem after MariaDB upgrade: root@hn [~]# systemctl status mariadb.service ? mariadb.service - MariaDB 10.2.17 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d ??migrated-from-my.cnf-settings.conf Active: activating (auto-restart) (Result: signal) since Fri 2018-08-17 11:10:22 EEST; 854ms ago Docs: man:mysqld(8) systemd Process: 4590 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 18449 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT) Process: 18395 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS) Process: 18393 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Main PID: 18449 (code=killed, signal=ABRT) Aug 17 11:10:22 cp.xtremehost.ro systemd[1]: Failed to start MariaDB 10.2.17 database server. Aug 17 11:10:22 cp.xtremehost.ro systemd[1]: Unit mariadb.service entered failed state. Aug 17 11:10:22 cp.xtremehost.ro systemd[1]: mariadb.service failed. root@hn[~]# service mysql status ERROR! MariaDB is not running Setting I have in /etc/my.cnf [mysqld] log-error=/var/lib/mysql/logitex.net.err performance-schema=off default-storage-engine=MyISAM max_allowed_packet=268435456 open_files_limit=11000 innodb_force_recovery=6 #i put v. 6 beacouse database won't start normally. innodb_file_per_table=1 read_only =0 datadir=/var/lib/mysql Errors I have in /var/lib/mysql/logitex.net.err 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Started in read only mode 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Uses event mutexes 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Using Linux native AIO 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Number of pools: 1 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Using generic crc32 instructions 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Disabling background log and ibuf IO write threads. 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Completed initialization of buffer pool 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: innodb_force_recovery=6 skips redo log apply 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: innodb_force_recovery=6 skips redo log apply 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: 5.7.23 started; log sequence number 0 2018-08-17 11:12:39 140121457760448 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!! 2018-08-17 11:12:39 140121457760448 [Note] Plugin 'FEEDBACK' is disabled. 2018-08-17 11:12:39 140121457760448 [Note] Server socket created on IP: '::'. 2018-08-17 11:12:39 140120983725824 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`gtid_slave_pos` in the cache. Attempting to load the tablespace with space id 63217 2018-08-17 11:12:39 140120983725824 [Warning] InnoDB: Allocated tablespace ID 63217 for mysql/gtid_slave_pos, old maximum was 0 2018-08-17 11:12:39 140121457760448 [Note] Reading of all Master_info entries succeded 2018-08-17 11:12:39 140121457760448 [Note] Added new Master_info '' to hash table 2018-08-17 11:12:39 140121457760448 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.17-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-08-17 11:15:32 140120983418624 [ERROR] InnoDB: Failed to find tablespace for table `tripleh_whmcs`.`tblapplinks` in the cache. Attempting to load the tablespace with space id 62853 2018-08-17 11:15:32 140120983111424 [ERROR] InnoDB: Failed to find tablespace for table `tripleh_whmcs`.`tblknowledgebasetags` in the cache. Attempting to load the tablespace with space id 62858 I putted also bind-address 127.0.0.1 & port 3306. If I start in normal mode with innodb_force recovery setted to 0 I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Also, I've checked where socket is, and I found it. I've putted in my.cnf the socket location, but nothing.. Same problem. Please help!
    0
  • cPanelMichael
    Hello @navhost, It looks like InnoDB is corrupted and it's preventing MySQL from starting. Here's a resource regarding InnoDB repair that you may find helpful:
    0
  • navhost
    @cPanelMichael thank you! I resolved the problem with your help.
    0
  • cPanelMichael
    @cPanelMichael thank you! I resolved the problem with your help.

    Hi @navhost, You're very welcome! I'm glad to see you were able to solve the problem.
    0

Please sign in to leave a comment.