mysql down, need to restart server and also cleanup not work

[murshed]

Dear admin,
Please help me. My server mysql down automatically, need to restart server fro ssh.

Im face this problem after yum update command.

After yum update its install new kloxmr update file, after install install i got this problem. yum cleanup not work. Even sh /script/sysinfo command not work also.

Here is my Putty screenshot after command yum cleanup. I see upcp and fix-all command works.


N.B: Specail thanks to MR for previous help. He saved my big data.

[MRatWork]

Did you mean 'yum clean all' or 'sh /script/cleanup'?.

[murshed]

yum clean all works well but sh/script/cleanup and also sh /script/upcp not work.

fix-all; fix related command works. not check every command.
---------------
update : still not work.

[MRatWork]

Try 'yum clean all; yum update kloxomr7 -y; yum update -y'. If no found error, try 'sh /script/upcp -y' (it's for re-install Kloxo-MR).

[murshed]

Try 'yum clean all; yum update kloxomr7 -y; yum update -y'. If no found error, try 'sh /script/upcp -y' (it's for re-install Kloxo-MR).

sh /script/upcp -y not work. its hang on when install mariaDB install 1/5.

Transaction Test Succeeded
Running Transaction
  Installing : MariaDB-common-10.0.17-1.el6.x86_64                          1/5
  Installing : MariaDB-compat-10.0.17-1.el6.x86_64                          2/5
  Installing : MariaDB-client-10.0.17-1.el6.x86_64                          3/5

[MRatWork]

How long to be waiting until you tell 'hang'?.

Try open 2 ssh session/windows. One with execute 'top' and other with execute 'sh /script/upcp -y'.

[murshed]

here is the "top" relsult. no improvement. its hang when install mariaDB 1/3

top - 00:00:14 up  6:29,  2 users,  load average: 0.60, 0.28, 0.18
Tasks:  32 total,   2 running,  30 sleeping,   0 stopped,   0 zombie
Cpu(s): 21.5%us,  1.3%sy,  0.0%ni, 77.2%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   6291456k total,  1862392k used,  4429064k free,        0k buffers
Swap:   131072k total,    12052k used,   119020k free,  1270252k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
18539 root      20   0  498m  77m  11m R 90.2  1.3   0:12.28 yum
    1 root      20   0 19236 1048  880 S  0.0  0.0   0:00.09 init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd/8590
    3 root      20   0     0    0    0 S  0.0  0.0   0:00.00 khelper/8590
  125 root      16  -4 10644  348  344 S  0.0  0.0   0:00.00 udevd
  473 dbus      20   0 21436  372  368 S  0.0  0.0   0:00.00 dbus-daemon
  564 root      20   0 66220  504  408 S  0.0  0.0   0:00.00 sshd
  703 root      20   0 66404  316  312 S  0.0  0.0   0:00.00 saslauthd
  704 root      20   0 66404   32   28 S  0.0  0.0   0:00.00 saslauthd
  838 root      20   0  4068  496  492 S  0.0  0.0   0:00.00 mingetty
  839 root      20   0  4068  496  492 S  0.0  0.0   0:00.00 mingetty
 4207 root      20   0 21796  472  468 S  0.0  0.0   0:00.02 screen
 4208 root      20   0 11444  688  680 S  0.0  0.0   0:00.00 bash
 9759 root      20   0 21720  812  704 S  0.0  0.0   0:00.01 xinetd
 9812 root      20   0  310m 9256 3384 S  0.0  0.1   0:00.62 php
 9845 lxlabs    20   0 2039m 3832  948 S  0.0  0.1   0:09.17 kloxo-hiawatha
17996 root      20   0 98384 4716 3720 S  0.0  0.1   0:00.05 sshd

here is another window info

lete-transaction first to finish them.
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.0.17-1.el6 will be installed
--> Processing Dependency: MariaDB-common for package: MariaDB-server-10.0.17-1.                                                                                        el6.x86_64
--> Processing Dependency: MariaDB-client for package: MariaDB-server-10.0.17-1.                                                                                        el6.x86_64
---> Package MariaDB-shared.x86_64 0:10.0.17-1.el6 will be installed
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.0.17-1.el6 will be installed
---> Package MariaDB-common.x86_64 0:10.0.17-1.el6 will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.0.17-1.                                                                                        el6.x86_64
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.0.17-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package            Arch       Version            Repository               Size
================================================================================
Installing:
 MariaDB-server     x86_64     10.0.17-1.el6      mratwork-mariadb-64      57 M
 MariaDB-shared     x86_64     10.0.17-1.el6      mratwork-mariadb-64     1.3 M
Installing for dependencies:
 MariaDB-client     x86_64     10.0.17-1.el6      mratwork-mariadb-64      11 M
 MariaDB-common     x86_64     10.0.17-1.el6      mratwork-mariadb-64      23 k
 MariaDB-compat     x86_64     10.0.17-1.el6      mratwork-mariadb-64     2.7 M

Transaction Summary
================================================================================
Install       5 Package(s)

Total size: 72 M
Installed size: 72 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : MariaDB-common-10.0.17-1.el6.x86_64                          1/5
  Installing : MariaDB-compat-10.0.17-1.el6.x86_64                          2/5
  Installing : MariaDB-client-10.0.17-1.el6.x86_64                          3/5

Now every host is down. After this command, php branch is zero, i mean no selected. not selecet 53u or any php branch. httpd down also.

[MRatWork]

It's not related to KLoxo-MR install process but maybe something wrong with your system like limiting CPU allocation and or HDD speed.

At 10 ago, I was installed Kloxo-MR 7.0 in dedicated server. No issue I found.

[murshed]

its 4vCore, 6gb ram

[root@host ~]# less /proc/cpuinfo
cpu cores       : 8
apicid          : 4
initial apicid  : 4
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid fsgsbase smep erms
bogomips        : 5187.18
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 62
model name      : Intel(R) Xeon(R) CPU E5-2650 v2 @ 2.60GHz
stepping        : 4
cpu MHz         : 2593.590
cache size      : 20480 KB
physical id     : 0
siblings        : 16
core id         : 3
cpu cores       : 8
apicid          : 6
initial apicid  : 6
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm ida arat epb xsaveopt pln pts dts tpr_shadow vnmi flexpriority ept vpid fsgsbase smep erms
bogomips        : 5187.18
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

[root@host ~]# dd if=/dev/zero of=speetest bs=1M count=100
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.260591 s, 402 MB/s

[root@bns24 ~]# dd if=/dev/zero of=speetest bs=1M count=100 conv=fdatasync
100+0 records in
100+0 records out
104857600 bytes (105 MB) copied, 0.114372 s, 917 MB/s

[MRatWork]

Possible 'bad' OS template. And or network setting issue in your provider and or issue in resolv.conf.

Remember, your previous server problem?.

[murshed]

Yes, i remember and thanks for your help. I just move my backup files and reload again. But my server company said, its about my vm settings. They have no problem from their end.

but, cleanup and upcp not work now. If i hit that command, my server going down, like httpd, php-fpm, mysql. I dont want to hit that command again. Its production server

Anyway,
I just solve this problem, after fix-all command and change first php branch, change php-fpm, change webserver and set again my previous settings then reboot. Kloxo works fine now.

Thanks.