• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

S
Issue Too many connections (Several plesk servers same problem in the last week)
Replies
8
Views
1K
SalvadorS
S
F
Question Mariadb down after update Plesk /var 100% full
Replies
8
Views
1K
flieg4bei
F
iWiLL
Issue dist-upgrade Ubuntu 18.04 to Ubuntu 20.04 mySQL FAIL
Replies
2
Views
575
Mikhail_S
Mikhail_S
S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
2K
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
2K
emreboy
E
Back
Top