• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Issues updating mariaDB-Ubuntu 18.4

Space Monkey

Space Monkey

Basic Pleskian
I followed this guide https://support.plesk.com/hc/en-us/...5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux-

When I start step 6 I get:
Job for mariadb.service failed because the control process exited with error cod e.
See "systemctl status mariadb.service" and "journalctl -xe" for details
Click to expand...

When I check the status it says the following:

Code: 
# systemctl status mariadb.service
● mariadb.service - MariaDB 11.0.2 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Mon 2023-06-26 07:43:25 UTC; 2min 3s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 6633 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exite
  Process: 6601 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr
  Process: 6590 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0
  Process: 6588 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/
 Main PID: 6633 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [Note] InnoDB: Loading buffer pool(s) from /va
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [Note] Plugin 'wsrep-provider' is disabled.
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [Note] Server socket created on IP: '127.0.0.1
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [ERROR] Can't start server: Bind on TCP/IP por
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [ERROR] Do you already have another server run
Jun 26 07:43:24 Alternus.nl mariadbd[6633]: 2023-06-26  7:43:24 0 [ERROR] Aborting
Jun 26 07:43:25 Alternus.nl systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 26 07:43:25 Alternus.nl systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 26 07:43:25 Alternus.nl systemd[1]: Failed to start MariaDB 11.0.2 database server.
lines 1-24...skipping...
● mariadb.service - MariaDB 11.0.2 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Mon 2023-06-26 07:43:25 UTC; 2min 3s ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 6633 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 6601 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: 6590 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 6588 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 6633 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
But I can't start the DB because then I get the first error.

Luckily I took a snapshop gheghe but what went wrong and how can I fix it?
 
Ah yeah and the journalctl -xe log:

Code: 
-- Unit plesk-web-socket.service has finished starting up.
--
-- The start-up result is RESULT.
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: [2023-06-26 07:52:27.102] 6121:649943bb18555 ER
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         Db_Adapter_Pdo_Mysql->query(string 'SET
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 1: /opt/psa/admin/plib/CommonPanel/Application/
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract::initD
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 2: /opt/psa/admin/plib/Session/Helper.php:176
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         Plesk\Session\Helper::initStorage()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 3: /opt/psa/admin/plib/CommonPanel/Application/
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract->run()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 4: /opt/psa/admin/plib/CommonPanel/Application/
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract::init(
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:18
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         pm_Bootstrap::init()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 6: /opt/psa/admin/plib/sdk.php:11
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         require_once(string '/opt/psa/admin/pli
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: ERROR: Plesk\Exception\Database: DB query faile
Jun 26 07:52:27 Alternus.nl systemd[1]: plesk-web-socket.service: Main process exited, code=exited, s
Jun 26 07:52:27 Alternus.nl systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
lines 1603-1625/1625 (END)
--
-- Unit plesk-web-socket.service has finished starting up.
--
-- The start-up result is RESULT.
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: [2023-06-26 07:52:27.102] 6121:649943bb18555 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract::initDbAdapter()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 2: /opt/psa/admin/plib/Session/Helper.php:176
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         Plesk\Session\Helper::initStorage()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:48
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract->run()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:30
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         CommonPanel_Application_Abstract::init()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:18
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         pm_Bootstrap::init()
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 6: /opt/psa/admin/plib/sdk.php:11
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]:         require_once(string '/opt/psa/admin/plib/sdk.php')
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3
Jun 26 07:52:27 Alternus.nl sw-engine-pleskrun[6121]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)
Jun 26 07:52:27 Alternus.nl systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
Jun 26 07:52:27 Alternus.nl systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
~
 
Kaspar said:
Yes, doesn't matter what Linux OS (and version) you're running, that step is needed when upgrading to MariaDB version 10.6 or higher.


Also yes, as 18.04 is EOL and no longer supported by Plesk. Upgrading to 20.04 won't solve the MariaDB issue you are currently having tough.
Click to expand...
Ok I will give it a go. Although I wished that upgrading mariadb was as easy like updating php through the visual menu :)
 
You must log in or register to reply here.

Similar threads

F
Question Mariadb down after update Plesk /var 100% full
Replies
8
Views
315
flieg4bei
F
S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
351
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
614
emreboy
E
P
Resolved Failed to start MariaDB database server.
Replies
2
Views
8K
pattolentno
P
B
  • Locked
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
780
Peter Debik
P
Back
Top