Error Web Server FreeBSD

Ketika membukan alamat : http://www.batan.go.id/wcm/ ada pesan kesalahan sbb :

Network Error (tcp_error)

A communication error occurred: ""
The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

For assistance, contact your network support team.

Tindakan yang dilakukan : ???


Iseng-iseng dicoba akses halaman yang berbasis SQL, ternyata pesannya sama. Patut diduga, kalau mysql-nya terhenti.

Restart MySQL di FreeBSD

[root@serpong4 2012Aug18 13:43] ~ # /usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 53551.
Starting mysql.
[root@serpong4 2012Aug18 13:49] ~ #

Tes buka halaman berbasis SQL, seperti berita. Ternyata belum normal. Apalagi ya???
Kenapa APACHE-nya tidak dicoba untuk di-restart?

Restart Apache di FreeBSD

[root@serpong4 2012Aug18 13:53] ~ # /usr/local/etc/rc.d/apache22 restart
Performing sanity check on apache22 configuration:
Syntax OK
apache22 not running? (check /var/run/httpd.pid).
Performing sanity check on apache22 configuration:
Syntax OK
Starting apache22.
(48)Address already in use: make_sock: could not bind to address [::]:80
(48)Address already in use: make_sock: could not bind to address [::]:443
[root@serpong4 2012Aug18 13:53] ~ #

Tampaknya masalah ditimbulkan oleh terhentinya Apache. Ini terlihat dari pesan "apache22 not running? ".

It works!!!

Sekarang semuanya sudah normal.

Sumber : http://www.cyberciti.biz/faq/freebsd-start-stop-restart-mysql-server/

Karena di stop gak bisa juga, akhirnya di-kill


[root@serpong4 2013Feb24 9:29] ~ # ps -aux | grep mysql
mysql   33354  0.0  0.0  3628     0  ??  TWs  -         0:00.00 /bin/sh /usr/lo
mysql   33459  0.0  5.6 696872 117204  ??  I    11Dec12 33788:53.48 [mysqld]
root    41140  0.0  0.0  3496  1024   1  S+    9:29AM   0:00.00 grep mysql

# kill -KILL 33354
# kill -KILL 33459

[root@serpong4 2013Feb24 9:30] ~ # ps -aux | grep mysql
root    41153  0.0  0.0  3496  1024   1  S+    9:30AM   0:00.00 grep mysql

Start lagi mysqlnya :

[root@serpong4 2013Feb24 9:30] ~ # /usr/local/etc/rc.d/mysql-server start

Starting mysql.

[root@serpong4 2013Feb24 9:30] ~ # ps -aux | grep mysql

mysql   41276 28.7  2.4 320260 49356  ??  S     9:30AM   0:01.64 [mysqld]

mysql   41169  0.1  0.1  3628  1312  ??  Ss    9:30AM   0:00.02 /bin/sh /usr/lo

root    41278  0.0  0.0  3496  1024   1  S+    9:30AM   0:00.00 grep mysql

[root@serpong4 2013Feb24 9:30] ~ # /usr/local/etc/rc.d/apache22 restart
Performing sanity check on apache22 configuration:
Syntax OK
Stopping apache22.
Waiting for PIDS: 40295.
Performing sanity check on apache22 configuration:
Syntax OK
Starting apache22.
[root@serpong4 2013Feb24 9:33] ~ # /usr/local/etc/rc.d/mysql-server restart
mysql not running? (check /var/db/mysql/serpong4.batan.go.id.pid).
Starting mysql.
[root@serpong4 2013Feb24 9:33] ~ #

[root@serpong4 2013Feb24 9:37] ~ # /usr/local/etc/rc.d/mysql-server start
Starting mysql.
[root@serpong4 2013Feb24 9:38] ~ # /usr/local/etc/rc.d/mysql-server status
mysql is not running.

Kenapa mysql gak running juga ya?

[root@serpong4 2013Feb24 15:44] /usr/local/etc/rc.d # tail -f /var/log/messages
Feb 24 10:18:57 serpong4 kernel: pid 43451 (httpd), uid 80 inumber 3063650 on /var: filesystem full
Feb 24 10:18:59 serpong4 kernel: pid 41780 (mysqld), uid 88 inumber 567618 on /var: filesystem full
Feb 24 10:18:59 serpong4 kernel: pid 41780 (mysqld), uid 88 inumber 566495 on /var: filesystem full
Feb 24 10:19:04 serpong4 kernel: pid 41951 (cleanup), uid 125 inumber 2025691 on /var: filesystem full
Feb 24 10:19:08 serpong4 kernel: pid 41491 (mysqld), uid 88 inumber 567511 on /var: filesystem full
Feb 24 10:25:18 serpong4 su: wenr to root on /dev/pts/3
Feb 24 10:29:04 serpong4 su: las to root on /dev/pts/2
Feb 24 14:54:44 serpong4 kernel: pid 50150 (httpd), uid 80: exited on signal 11
Feb 24 15:03:42 serpong4 kernel: pid 50497 (httpd), uid 80: exited on signal 11
Feb 24 15:38:03 serpong4 su: msmunir to root on /dev/pts/2

Tampaknya /var: FULL


[root@serpong4 2013Feb24 15:38] ~ # set echo_style=both ; alias precmd 'echo $cwd:q >>/tmp/mc-root/mc.pipe.44397;kill -STOP $$'
[root@serpong4 2013Feb24 15:38] ~ # cd "`printf "%b" '\0057'`"
[root@serpong4 2013Feb24 15:38] ~ # cd "`printf "%b" '\0057var'`"
[root@serpong4 2013Feb24 15:38] ~ # cd "`printf "%b" '\0057var\0057log'`"
[root@serpong4 2013Feb24 15:41] ~ # tail -f /var/log/messages
# killall mysqld
# cd /usr/local/etc/rc.d
[root@serpong4 2013Feb24 15:38] ~ # ./mysql-server restart