• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Resolved mysql.service can't start

Alaa Mansour

Alaa Mansour

Basic Pleskian
Hello everybody

i have this problem :

Server Error
500
Zend_Db_Adapter_Exception
SQLSTATE[HY000] [2002] No such file or directory

Type Zend_Db_Adapter_Exception
Message SQLSTATE[HY000] [2002] No such file or directory
File Abstract.php
Line 144


, here is the two results

Code: 
root@plesk:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Thu 2019-09-19 12:29:08 CEST; 10s ago
  Process: 8369 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 8361 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 8369 (code=exited, status=1/FAILURE);         : 8370 (mysql-systemd-s)
    Tasks: 2
   Memory: 336.0K
      CPU: 300ms
   CGroup: /system.slice/mysql.service
           └─control
             ├─8370 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─8417 sleep 1

Sep 19 12:29:08 plesk.mns.ps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Sep 19 12:29:08 plesk.mns.ps systemd[1]: Stopped MySQL Community Server.
Sep 19 12:29:08 plesk.mns.ps systemd[1]: Starting MySQL Community Server...
Sep 19 12:29:10 plesk.mns.ps systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Code: 
lines 1455-1511/1511 (END)
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Sep 19 12:27:35 plesk.mns.ps systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Sep 19 12:27:36 plesk.mns.ps systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Sep 19 12:28:01 plesk.mns.ps CRON[8055]: pam_unix(cron:session): session opened for user root by (uid=0)
Sep 19 12:28:01 plesk.mns.ps CRON[8056]: (root) CMD (/opt/psa/admin/bin/php -dauto_prepend_file=sdk.php '/opt/psa/admin/plib/modules/revisium-antivirus/scripts/ra_executor_run.php')
Sep 19 12:28:01 plesk.mns.ps CRON[8055]: pam_unix(cron:session): session closed for user root
Sep 19 12:28:03 plesk.mns.ps monit[1151]: 'mysql' failed to start
Sep 19 12:28:05 plesk.mns.ps monit[1151]: 'mysql' process is not running
Sep 19 12:28:05 plesk.mns.ps monit[1151]: 'mysql' trying to restart
Sep 19 12:28:05 plesk.mns.ps monit[1151]: 'mysql' start: /opt/psa/admin/sbin/pleskrc
Sep 19 12:28:05 plesk.mns.ps dovecot[4844]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS, session=<bRq1aOWSRM9/AAAB>
Sep 19 12:28:05 plesk.mns.ps dovecot[4844]: pop3-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<1C+1aOWSdI1/AAAB>
Sep 19 12:28:05 plesk.mns.ps dovecot[4844]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS, session=<wHC1aOWSmtV/AAAB>
Sep 19 12:28:05 plesk.mns.ps dovecot[4844]: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<XoG1aOWScut/AAAB>
Sep 19 12:28:06 plesk.mns.ps systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Sep 19 12:28:06 plesk.mns.ps systemd[1]: mysql.service: Unit entered failed state.
Sep 19 12:28:06 plesk.mns.ps systemd[1]: mysql.service: Failed with result 'exit-code'.
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Sep 19 12:28:06 plesk.mns.ps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Sep 19 12:28:06 plesk.mns.ps systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Sep 19 12:28:06 plesk.mns.ps systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Sep 19 12:28:06 plesk.mns.ps monit[1151]: INFO: [Thu Sep 19 12:28:05 CEST 2019]: Service: mysql, Action: start
Sep 19 12:28:06 plesk.mns.ps monit[1151]:  Trying to start service mysql... /usr/sbin/mysqld is stopped
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Sep 19 12:28:06 plesk.mns.ps systemd[1]: Failed to start MySQL Community Server.
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Sep 19 12:28:06 plesk.mns.ps systemd[1]: mysql.service: Unit entered failed state.
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Sep 19 12:28:06 plesk.mns.ps systemd[1]: mysql.service: Failed with result 'exit-code'.
Sep 19 12:28:06 plesk.mns.ps monit[1151]: WARNING!
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Some problems are found during start service mysql(see log file: /var/log/plesk/rc_actions.log)
Sep 19 12:28:06 plesk.mns.ps monit[1151]: Continue...
Sep 19 12:28:07 plesk.mns.ps monit[1151]: Collector: cannot open a connection to http://127.0.0.1:2912/ -- Transport endpoint is not connected
Sep 19 12:28:07 plesk.mns.ps monit[1151]: Collector: no server available -- aborting message
Sep 19 12:28:08 plesk.mns.ps systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
~
~


I cant understand what is going on?any help please?
 
Do you see more details in
# systemctl status mysql.service
or
# journalctl -xe
? Normally these should show a detailed explanation on why it is shutting down or not starting.
 
You must log in or register to reply here.

Similar threads

M
Resolved Failed to start The Apache HTTP Server: SELinux impedisce a /usr/sbin/httpd un accesso open su file /var/log/modsec_audit.log. -- SOLVED --
Replies
0
Views
2K
mmcomputers
M
iWiLL
Issue dist-upgrade Ubuntu 18.04 to Ubuntu 20.04 mySQL FAIL
Replies
2
Views
1K
Mikhail_S
Mikhail_S
A
Question Plesk install in ubuntu
Replies
2
Views
935
alexk345
A
K
Issue not starting the following service:maldet.service,php-fpm.service,[email protected]
Replies
0
Views
1K
kalombo
K
O
Resolved Update Plesk 18.0.68 on CentOS7 result in no website reachable and email not working anymore
Replies
3
Views
558
Onkeltom01
O
Back
Top