Unable to access Plesk with 500 error message: [2002] No such file or directory

Follow

Comments

5 comments

  • Avatar
    heidarymr

    f

    systemctl start mariadb
    Job for mariadb.service failed because the control process exited with error code.
    See "systemctl status mariadb.service" and "journalctl -xe" for details.

    f

    systemctl status mariadb.service
    ● mariadb.service - MariaDB 10.1.48 database server
    Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Active: failed (Result: exit-code) since Thu 2021-10-28 12:38:48 +0330; 4s ago
    Docs: man:mysqld(8)
    https://mariadb.com/kb/en/library/systemd/
    Process: 16732 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
    Process: 16650 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSRE
    Process: 16647 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 16640 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Main PID: 16732 (code=exited, status=1/FAILURE)
    Status: "MariaDB server is down"

    Oct 28 12:38:45 ... systemd[1]: Starting MariaDB 10.1.48 database server...
    Oct 28 12:38:45 ... mysqld[16732]: 2021-10-28 12:38:45 140204800543872 [Note] /usr/sbin/mysqld (mysqld 10.1.48-MariaDB-0ubuntu0.18.04.1) starting as process 16732 ...
    Oct 28 12:38:48 ... systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
    Oct 28 12:38:48 ... systemd[1]: mariadb.service: Failed with result 'exit-code'.
    Oct 28 12:38:48 ... systemd[1]: Failed to start MariaDB 10.1.48 database server.

     

     

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Reo Wulf


    root@hopeful-khorana:~# mkdir /var/log/mariadb
    root@hopeful-khorana:~# chown mysql:mysql /var/log/mariadb
    root@hopeful-khorana:~# systemctl start mariadb
    Failed to start mariadb.service: Unit mariadb.service not found.

    0
    Comment actions Permalink
  • Avatar
    Fernando Macías (Edited )

    xxxx:~# mkdir /var/log/mariadb
    mkdir: cannot create directory ‘/var/log/mariadb’: File exists
    xxxx:~# chown mysql:mysql /var/log/mariadb
    xxxx:~# systemctl start mariadb
    Failed to start mariadb.service: Unit mariadb.service failed to load: No such file or directory.

    no se ha reparado el error. Todo sigue igual el directorio ya exite pero no arranca el servicio mariadb
    Al mirar el estado de mariadb.... dice DEAD.  que ha pasado??

    ● mariadb.service
       Loaded: not-found (Reason: No such file or directory)
       Active: inactive (dead)

    Sep 02 20:27:48 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:27:54 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:27:59 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:04 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:09 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:15 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:20 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:25 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:30 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.
    Sep 02 20:28:36 vps536206.ovh.net systemd[1]: Cannot add dependency job for unit mariadb.service, ignoring...ory.

    0
    Comment actions Permalink
  • Avatar
    Muhammad Farooqi

    This is the error I'm getting after this command. 

    root@host:/var/lib/mysql# chown mysql:mysql /var/log/mariadb/
    root@host:/var/lib/mysql# systemctl start mariadb
    Job for mariadb.service failed because a fatal signal was delivered to the control process.
    See "systemctl status mariadb.service" and "journalctl -xe" for details.
    and this is systemctl status mariadb.service response


    ● mariadb.service - MariaDB 10.3.34 database server
         Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
         Active: activating (start) since Sat 2022-09-10 05:48:47 UTC; 526ms ago
           Docs: man:mysqld(8)
                 https://mariadb.com/kb/en/library/systemd/
        Process: 350186 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
        Process: 350190 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
        Process: 350201 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP>
       Main PID: 350266 (mysqld)
          Tasks: 15 (limit: 9439)
         Memory: 57.3M
         CGroup: /system.slice/mariadb.service
                 └─350266 /usr/sbin/mysqld



    Sep 10 05:48:47 host systemd[1]: Starting MariaDB 10.3.34 database server...
    Sep 10 05:48:47 host mysqld[350266]: 2022-09-10  5:48:47 0 [Note] /usr/sbin/mysqld (mysqld 10.3.34-MariaDB-0ubuntu0.20.04.1) starting as process 350266 ...

    And this is the journalctl -xe response 

    root@host:/var/lib/mysql# journalctl -xe

    -- Support: http://www.ubuntu.com/support

    -- 

    -- The unit mariadb.service has entered the 'failed' state with result 'signal'.

    Sep 10 05:50:41 host systemd[1]: Failed to start MariaDB 10.3.34 database server.

    -- Subject: A start job for unit mariadb.service has failed

    -- Defined-By: systemd

    -- Support: http://www.ubuntu.com/support

    -- 

    -- A start job for unit mariadb.service has finished with a failure.

    -- 

    -- The job identifier is 488407 and the job result is failed.

    Sep 10 05:50:41 host systemd[1]: Started Plesk Web Socket Service.

    -- Subject: A start job for unit plesk-web-socket.service has finished successfully

    -- Defined-By: systemd

    -- Support: http://www.ubuntu.com/support

    -- 

    -- A start job for unit plesk-web-socket.service has finished successfully.

    -- 

    -- The job identifier is 488488.

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: [2022-09-10 05:50:41.218] 351309:631c25b1350d2 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:103

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract::initDbAdapter()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 2: /opt/psa/admin/plib/Session/Helper.php:176

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         Plesk\Session\Helper::initStorage()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:52

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract->run()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:34

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         CommonPanel_Application_Abstract::init()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:16

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         pm_Bootstrap::init()

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 6: /opt/psa/admin/plib/sdk.php:11

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]:         require_once(string '/opt/psa/admin/plib/sdk.php')

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3

    Sep 10 05:50:41 host sw-engine-pleskrun[351309]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)

    Sep 10 05:50:41 host systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE

    lines 2881-2917/2930 100%
    0
    Comment actions Permalink
  • Avatar
    IONOS Support
    Server Error

    500 Plesk\Exception\Database

    DB query failed: SQLSTATE[HY000] [2002] No such file or directory

    Type Plesk\Exception\Database
    Message DB query failed: SQLSTATE[HY000] [2002] No such file or directory
    File Mysql.php
    Line 79
    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request