MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: redpages on 2015-11-03, 18:48:25

Title: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-03, 18:48:25

Dear masta, mohon bantuannya.
Mysql tiba-tiba error. Cek status hasilnya :

Quote

[root@server100 ~]# service mysql status
 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Jika di cleanup ada baris spt ini

Quote

- Get process
- Create database interface template (Forced)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
>>> Execute driverload.php <<<

Sysinfo:

Quote

A. Kloxo-MR: 7.0.0.b-2015103001
   - Web: hiawatha-9.15.0-f.6.mr.el6.i686
   - PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) i686
   - Hostname: server100.xbackbone.com
C. Services:
   1. MySQL: MariaDB-server-10.0.22-1.el6.i686
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.i686
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.31-1.mr.el6.i386
      - PHP Type: [unknown]
   4. Lighttpd: --uninstalled--
   5. Hiawatha: --unused--
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: bind-9.9.7-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        335        688          5          0         40
   -/+ buffers/cache:        294        729
   Swap:            0          0          0
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/simfs       30G  5.2G   25G  18% /

Title: Re: MYSQL tiba-tiba ERROR!
Post by: noob on 2015-11-04, 11:05:00

kalo di restart mysql nya gimana?

Code: [Select]

service mysql restart


Title: Re: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-04, 12:17:14

Hasilnya seperti ini

Quote

[root@server100 ~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR!
[root@server100 ~]#

Title: Re: MYSQL tiba-tiba ERROR!
Post by: MRatWork on 2015-11-04, 12:21:06

Infokan 'df -h /; df -ih /'

Title: Re: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-04, 13:27:34

Seperti ini

Quote

[root@server100 ~]# df -h /; df -ih /
Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs       30G  5.5G   25G  19% /
Filesystem     Inodes IUsed IFree IUse% Mounted on
/dev/simfs        15M  304K   15M    2% /

Title: Re: MYSQL tiba-tiba ERROR!
Post by: MRatWork on 2015-11-04, 14:38:35

Infokan 'fdisk -l'.

Title: Re: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-04, 21:08:57

tidak ada hasilnya

Quote

[root@server100 ~]# fdisk -l
[root@server100 ~]#

Title: Re: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-05, 05:23:25

apakah cara di http://forum.mratwork.com/indonesia-users/gimana-cara-pindah-dari-mariadb-ke-mysql/ bisa saya terapkan untuk kasus mysql saya. mengingat mysql saya MARIADB

pada baris

Quote

Kelihatannya my.cnf anda di /etc/my.cnf.d tidak match dengan MariaDB.

Coba rename '/etc/my.cnf.d/my.cnf' ke '/etc/my.cnf.d/my.noncnf' dan copy '/usr/share/mysql/my-medium.cnf' ke '/etc/my.cnf.d/my.cnf'.

Kemudian coba jalankan 'service mysql restart'.

Title: Re: MYSQL tiba-tiba ERROR!
Post by: redpages on 2015-11-05, 05:49:53

udah saya coba dan berhasil.

Quote

Coba rename '/etc/my.cnf.d/my.cnf' ke '/etc/my.cnf.d/my.noncnf' dan copy '/usr/share/mysql/my-medium.cnf' ke '/etc/my.cnf.d/my.cnf

case close  :D