Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 19:47:46

Author Topic: Mysql can't start and getting failed  (Read 12814 times)

0 Members and 1 Guest are viewing this topic.

Offline tolaleng

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Mysql can't start and getting failed
« on: 2019-08-22, 10:20:12 »
Hello Team,

Could anyone having experience with this issue. Could you help me to fix it?

[root@ns1 ~]# sh /script/restart-mysql

*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190822 15:12:50 mysqld_safe Logging to '/var/lib/mysql/xxxxx.com.err'.
190822 15:12:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6060) - No such process
                                                           [FAILED]
  - Process: restart
MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.190822 15:12:53 mysqld_safe Logging to '/var/lib/mysql/xxxx.com.err'.
190822 15:12:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6254) - No such process
                                                           [FAILED]
-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'

Thank you

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #1 on: 2019-08-23, 03:48:52 »
Hello Team,

Could anyone having experience with this issue. Could you help me to fix it?

[root@ns1 ~]# sh /script/restart-mysql

*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190822 15:12:50 mysqld_safe Logging to '/var/lib/mysql/xxxxx.com.err'.
190822 15:12:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6060) - No such process
                                                           [FAILED]
  - Process: restart
MariaDB server PID file could not be found!                [FAILED]
Starting MariaDB.190822 15:12:53 mysqld_safe Logging to '/var/lib/mysql/xxxx.com.err'.
190822 15:12:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/etc/init.d/mysql: line 264: kill: (6254) - No such process
                                                           [FAILED]
-------------------------------------------------------------------

- For help, type '/script/restart-mysql [--help|-h]'

Thank you
Inform 'sh /script/sysinfo'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline tolaleng

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #2 on: 2019-08-23, 03:55:17 »
There is not working all, CP Admin also not reachable and can't be to access.  :'(
[root@ns1 ~]# sh /script/sysinfo
A. Control Panel:               
   - Kloxo-MR: 7.0.0.c-2019070501
   - Web: --uninstalled--
   - PHP: php56s - 5.6.36-1.ius.centos7 (fpm mode)
B. Plateform:
   - OS: CentOS Linux release 7.6.1810 (Core) x86_64
   - Hostname: xxxxxxxx.com
C. Services:
   1. MySQL: MariaDB-server-10.1.41-1.el7.centos.x86_64
   2. PHP:
      - Installed:
        - Branch: php70u-cli-7.0.33-1.ius.el7.x86_64
        - Multiple:
          * php54m - 5.4.45-14.mr.el7
          * php55m - 5.5.38-1.ius.centos7
          * php56m - 5.6.36-1.ius.centos7
          * php70m - 7.0.33-1.ius.el7
          * php71m - 7.1.17-1.ius.centos7
          * php72m - 7.2.19-1.el7.ius
          * php73m - 7.3.6-1.el7.ius
      - Used: php70m-fpm
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: --uninstalled--
     - Lighttpd: lighttpd-1.4.54-1.el7.x86_64
     - Nginx: nginx-1.17.3-1.el7.ngx.x86_64
     - Apache: httpd24u-2.4.39-2.el7.ius.x86_64
       - PHP Type: php-fpm_event (default)
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: bind-9.9.9-1.mr.el7.x86_64
     - DJBDns: djbdns-1.05-17.4.mr.el7.x86_64
     - NSD: nsd-4.1.27-1.mr.el7.x86_64
     - PowerDNS: pdns-4.1.11-1.el7.x86_64
     - Yadifa: yadifa-2.3.9-1.el7.x86_64
   6. Mail: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
      - pop3/imap4: none
      - smtp: none
      - spam: bogofilter-1.2.3-6.el7.x86_64
   7. FTP: pure-ftpd
      - pure-ftpd: pure-ftpd-1.0.49-1.mr.el7.x86_64
   8. Stats: awstats
      - awstats: kloxomr-stats-awstats-7.7-1.mr.noarch
D. Memory:
              total        used        free      shared  buff/cache   available
Mem:           1789         368         187          32        1233        1187
Swap:             0           0           0
E. Disk Space:
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1        40G   31G  6.9G  82% /


*** Process Time: 00:00:00:45.45222 (dd:hh:mm:ss:xxxxxx) ***

* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
        (importance after Kloxo-MR update)

[root@ns1 ~]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #3 on: 2019-08-23, 03:57:34 »
Did you upgrade MariaDB using 'sh /script/mariadb-upgrade'?.

Try upgrade to version 10.3.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline tolaleng

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #4 on: 2019-08-23, 04:01:58 »
Installed:
  MariaDB-server.x86_64 0:10.2.26-1.el7.centos                                                                                                                           

Complete!

- For help, type '/script/restart-mysql [--help|-h]'
Enter password:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed

- For help, type '/script/restart-mysql [--help|-h]'
- End process...

* Note:
  - Format: /script/mariadb-upgrade [target-version]
    where [target-version] = 10.2 (by default)

Offline tolaleng

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #5 on: 2019-08-23, 04:31:36 »
I tried upgrade to 10.3, but still getting an error with can't connect to mysql socket
Could you help me to check it. Thanks

Installed:
  MariaDB-server.x86_64 0:10.3.17-1.el7.centos                                                                                                                           

Complete!

- For help, type '/script/restart-mysql [--help|-h]'
Enter password:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed

- For help, type '/script/restart-mysql [--help|-h]'
- End process...

* Note:
  - Format: /script/mariadb-upgrade [target-version]
    where [target-version] = 10.2 (by default)

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #6 on: 2019-08-23, 05:08:20 »
Give me your ssh access.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline tolaleng

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #7 on: 2019-08-23, 05:30:01 »
Okay sir,
I already share via the message
thanks

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #8 on: 2019-09-03, 18:56:14 »
Same situation here...
Any progress on it??
Thx!!

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #9 on: 2019-09-03, 19:47:43 »
It seems that after make some space on disk now is starting ...

After restart ... same error!! Something is wrong! Mariadb not starting at boot.
I have to manually start it with "sh /script/restart-mysql".
« Last Edit: 2019-09-03, 20:15:54 by dfreddie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #10 on: 2019-09-04, 03:56:01 »
Inform here 'systemctl status mysql -l'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #11 on: 2019-09-04, 12:20:18 »
At new, reboot server:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:systemd-sysv-generator(8)

After:
sh /script/restart-mysql
I have:
*** Process for MYSQL/MARIADB service ***
Starting MariaDB.190904 13:46:30 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
                                                           [  OK  ]
  - Process: restart
Shutting down MariaDB                                      [  OK  ]
Starting MariaDB.190904 13:46:32 mysqld_safe Logging to '/var/lib/mysql/xxx.err'.
190904 13:46:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 
                                                         [  OK  ]
then I have to restart web and php:
sh /script/fixphp; sh /script/restart-web -y

I have:
systemctl status mysql -l
mysql.service - LSB: start and stop MariaDB
   Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
   Active: active (exited) since Wed 2019-09-04 12:39:14 EEST; 41min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 12256 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=0/SUCCESS)
systemd[1]: Starting LSB: start and stop MariaDB...
mysql[12256]: Starting MariaDB[  OK  ]
systemd[1]: Started LSB: start and stop MariaDB.
mysql[12256]: 190904 12:39:14 mysqld_safe Logging to '/var/lib/mysql/xxx.err
mysql[12256]: 190904 12:39:14 mysqld_safe A mysqld process already exists
« Last Edit: 2019-09-04, 17:19:01 by dfreddie »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #12 on: 2019-09-04, 16:54:11 »
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline dfreddie

  • Valuable Member
  • *
  • Posts: 98
  • Karma: +0/-0
    • View Profile
Re: Mysql can't start and getting failed
« Reply #13 on: 2019-09-04, 17:23:20 »
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.

Nope, it's all wrong! MariaDB is not started at boot as I showed! Moreover can't login in mysql as root: Access denied for user 'root'@'localhost' using password="yes"!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql can't start and getting failed
« Reply #14 on: 2019-09-04, 17:26:00 »
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.051 seconds with 21 queries.

web stats analysis