MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: tolaleng on 2019-08-22, 10:20:12

Title: Mysql can't start and getting failed
Post by: tolaleng 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
Title: Re: Mysql can't start and getting failed
Post by: MRatWork 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'.
Title: Re: Mysql can't start and getting failed
Post by: tolaleng 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 ~]#
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-08-23, 03:57:34
Did you upgrade MariaDB using 'sh /script/mariadb-upgrade'?.

Try upgrade to version 10.3.
Title: Re: Mysql can't start and getting failed
Post by: tolaleng 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)
Title: Re: Mysql can't start and getting failed
Post by: tolaleng 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)
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-08-23, 05:08:20
Give me your ssh access.
Title: Re: Mysql can't start and getting failed
Post by: tolaleng on 2019-08-23, 05:30:01
Okay sir,
I already share via the message
thanks
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-03, 18:56:14
Same situation here...
Any progress on it??
Thx!!
Title: Re: Mysql can't start and getting failed
Post by: dfreddie 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".
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 03:56:01
Inform here 'systemctl status mysql -l'.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie 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
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 16:54:11
Nothing wrong with restart process. MariaDB also restart mysqld_safe together with their main service.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie 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"!
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 17:26:00
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 17:54:56
Did you tried 'sh /script/reset-mysql-root-password YOURNEWPASSWORD'?
After that seems everything is ok!  ;D
Thanks a lot!!
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 18:05:12
... but after restart ... I have again to restart manually mysql with: sh /script/restart-mysql
  :( :( :-[
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 19:00:29
inform here 'chkconfig --list|grep -i mysql|grep -v grep' and 'systemctl list-unit-files|grep mysql'.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 19:12:38
 chkconfig --list|grep -i mysql|grep -v grep

Note: This output shows SysV services only and does not include native
      systemd services. SysV configuration data might be overridden by native
      systemd configuration.

      If you want to list systemd services use 'systemctl list-unit-files'.
      To see services enabled on particular target use
      'systemctl list-dependencies [target]'.

mysql             0:off   1:off   2:on   3:on   4:on   5:on   6:off

systemctl list-unit-files|grep mysql
shows no output
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 19:21:40
inform here 'pgrep mysql -a' and 'ps aux|grep -i mysql|grep -v grep'
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 19:27:04
pgrep mysql -a
4301 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
4380 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid


ps aux|grep -i mysql|grep -v grep
root      4301  0.0  0.0  11816  1604 pts/0    S    19:02   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/xxx.pid
mysql     4380  0.3  1.5 1288988 188228 pts/0  Sl   19:02   0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xxx.err --pid-file=/var/lib/mysql/xxx.pid
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 19:31:29
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 19:35:54
Look like mysql running in your vps from 'pgrep' and 'ps aux' information.
Yes becouse I've started it with "sh /script/restart-mysql" command after server booted.

With fresh restart:
pgrep mysql -a - no output
ps aux|grep -i mysql|grep -v grep - no output
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 19:41:55
Try reboot and then check with 'pgrep' a couple of times.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 19:46:32
Try reboot and then check with 'pgrep' a couple of times.
It starts delayed!
But my webpages shows Error 500 - Internal Server Error!
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 19:54:21
inform here 'cat /etc/my.cnf.d/server.cnf'.
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 19:56:41
cat /etc/my.cnf.d/server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
performance-schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
innodb-use-native-aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]
Title: Re: Mysql can't start and getting failed
Post by: MRatWork on 2019-09-04, 20:01:40
Try add:
Code: [Select]
socket=/var/lib/mysql/mysql.sock
bind-address=127.0.0.1
under '[mysqld]'
Title: Re: Mysql can't start and getting failed
Post by: dfreddie on 2019-09-04, 20:28:33
I've added but is the same. Mysql starts delayed and that for (I think) web server have to be restart for avoiding error 500.