Control Web Panel

WebPanel => MySQL => Topic started by: srisree on August 25, 2020, 06:16:09 AM

Title: error after mariadb upgrade
Post by: srisree on August 25, 2020, 06:16:09 AM
after successfull upgrade of mariadb 10.1 to 10.2

recived the following security updates


MariaDB-common.x86_64    10.2.33-1.el7.centos    mariadb    
MariaDB-devel.x86_64    10.2.33-1.el7.centos    mariadb    
MariaDB-shared.x86_64    10.2.33-1.el7.centos    mariadb


when i clicked update all

the above updates are updated .

but mysql database server stopped

when i click start its not started still showing failed


websites are not opening

when i click report issue

message displayed that     
Hi, I'm AI-Robot, I will try to recover your mariadb service.
Service Recovered! I have managed to recover your mariadb service !

Ohh I'm improving myself, soon I will be able to take a full control on all your server services.


now websites are working

but

showing in server services that mysql database server  FAILED


regards

logs

Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Cannot open datafile './ibdata1'
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [Note] InnoDB: Starting shutdown...
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] Plugin 'InnoDB' init function returned error.
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Aug 25 12:02:40 vps.familymeet.in mysqld[10073]: 2020-08-25 12:02:40 140626898647232 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
Aug 25 12:02:42 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=193.27.228.172 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=241 ID=28387 PROTO=TCP SPT=50601 DPT=12624 WINDOW=1024 RES=0x00 SYN URGP=0
Aug 25 12:03:02 vps.familymeet.in kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=80.82.77.212 DST=172.105.42.63 LEN=1500 TOS=0x00 PREC=0x00 TTL=240 ID=54321 PROTO=UDP SPT=51012 DPT=1701 LEN=1480
Aug 25 12:03:05 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=195.54.167.93 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=241 ID=6073 PROTO=TCP SPT=54729 DPT=50286 WINDOW=1024 RES=0x00 SYN URGP=0
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Plugin 'Aria' init function returned error.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [Note] Plugin 'FEEDBACK' is disabled.
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Unknown/unsupported storage engine: InnoDB
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: 2020-08-25 12:03:11 140626898647232 [ERROR] Aborting
Aug 25 12:03:11 vps.familymeet.in systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Aug 25 12:03:11 vps.familymeet.in mysqld[10073]: Warning: Memory not freed: 520
Aug 25 12:03:11 vps.familymeet.in systemd[1]: Failed to start MariaDB 10.2.33 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Aug 25 12:03:11 vps.familymeet.in systemd[1]: Unit mariadb.service entered failed state.
Aug 25 12:03:11 vps.familymeet.in systemd[1]: mariadb.service failed.
Aug 25 12:03:17 vps.familymeet.in kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=89.248.168.17 DST=172.105.42.63 LEN=220 TOS=0x00 PREC=0x00 TTL=241 ID=54321 PROTO=UDP SPT=37998 DPT=123 LEN=200
Aug 25 12:03:20 vps.familymeet.in kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:92:b9:79:0a:1a:12:1c:98:45:62:08:00 SRC=185.176.27.238 DST=172.105.42.63 LEN=40 TOS=0x00 PREC=0x00 TTL=246 ID=33910 PROTO=TCP SPT=40996 DPT=35456 WINDOW=1024 RES=0x00 SYN URGP=0

Title: Re: error after mariadb upgrade
Post by: Igor S. on August 27, 2020, 06:18:42 AM
Hi, I would recommend using a competent system admin help to fix it.
So, if you understand what exactly you doing you try to fix it with the command below:

Code: [Select]
cd /var/lib/mysql/
mv ib_logfile0 ib_logfile0_OLD
mv ib_logfile1 ib_logfile1_OLD
systemctl restart mariadb
If MariaDB has been started then use the command below:
Code: [Select]
mysql_upgradeif MariaDB has not been started the you have to ask a sysadmin to check that.
Title: Re: error after mariadb upgrade
Post by: srisree on August 31, 2020, 06:44:05 AM
i am getting this message

[root@vps ~]# cd /var/lib/mysql/
[root@vps mysql]# mv ib_logfile0 ib_logfile0_OLD
mv: cannot stat ‘ib_logfile0’: No such file or directory
[root@vps mysql]# mv ib_logfile1 ib_logfile1_OLD
mv: cannot stat ‘ib_logfile1’: No such file or directory
[root@vps mysql]# systemctl restart mariadb

** (pkttyagent:9569): WARNING **: 11:47:46.380: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)

Title: Re: error after mariadb upgrade
Post by: srisree on September 03, 2020, 03:55:44 PM
problem solved after upgrading mariadb from 10.2 to 10.4 by  following

https://www.mysterydata.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/


thanks mysterydata