After Upgrade 1.34.20 mysql server has error
Posted: Sun Sep 06, 2020 9:00 am
Good morning,
after installing version 1.34.20 on Friday, the mySQL server can no longer be started.
I have no idea what happened there and how to get it running again. Can anyone help me?
Thanks
Olaf
after installing version 1.34.20 on Friday, the mySQL server can no longer be started.
I have no idea what happened there and how to get it running again. Can anyone help me?
Thanks
Olaf
Code: Select all
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
06.09.2020 10:54:04.612568 zmupdate[1857].ERR [ZoneMinder::Database:113] [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
06.09.2020 10:54:04.612841 zmupdate[1857].ERR [ZoneMinder::Database:113] [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
DBI connect('database=zm;host=localhost','zmuser',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/perl5/ZoneMinder/Database.pm line 110.
06.09.2020 10:54:04.613357 zmupdate[1857].ERR [ZoneMinder::Database:113] [Error reconnecting to db: errstr:Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error val:]
Can't call method "prepare_cached" on an undefined value at /usr/share/perl5/ZoneMinder/Config.pm line 96.
BEGIN failed--compilation aborted at /usr/share/perl5/ZoneMinder/Config.pm line 147.
Compilation failed in require at /usr/bin/zmupdate.pl line 73.
BEGIN failed--compilation aborted at /usr/bin/zmupdate.pl line 73.
root@S2018Z620N001:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.23 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sun 2020-09-06 10:52:36 CEST; 1min 39s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 1627 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 1629 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1631 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=
Process: 1745 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 1745 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Sep 06 10:52:27 S2018Z620N001 systemd[1]: Starting MariaDB 10.3.23 database server...
Sep 06 10:52:28 S2018Z620N001 mysqld[1745]: 2020-09-06 10:52:28 0 [Note] /usr/sbin/mysqld (mysqld 10.3.23-MariaDB-0+deb10u1) starting as process 1745 ...
Sep 06 10:52:36 S2018Z620N001 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Sep 06 10:52:36 S2018Z620N001 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Sep 06 10:52:36 S2018Z620N001 systemd[1]: Failed to start MariaDB 10.3.23 database server.