Page 1 of 1

Opencart site 2.3.0.2 becomes unresponsive and the cpu maxed out

Posted: Tue Feb 05, 2019 8:21 am
by luisvillacrez
Hello,

Recently, we are experiencing some issue with our opencart site (2.3.0.2) that it is not responding at all. MYSQL's cpu goes super high very fast and the website becomes unresponsive.

Also, recently our server update it the cPanel which caused nginx to fail

The only thing that loads is the homepage. any product link does not work.

The people from server thinks it might have to do vqmod?

------------

staff from the server said the following:

Something is causing all php processes to stick so no new ones can spawn, trying to figure out what it is.



something with the install is causing PHP to never free up. When I check slow logging, it all points to the same thing:

[04-Feb-2019 14:36:43] [pool domain_com] pid 4248
script_filename = /home/domain/public_html/index.php
[0x00007f1c1b616420] read() /home/domain/public_html/system/library/session/native.php:17
[0x00007f1c1b6163a0] read() /home/domain/public_html/system/library/session.php:30
[0x00007f1c1b616340] session_start() /home/domain/public_html/system/library/session.php:30
[0x00007f1c1b616280] __construct() /home/domain/public_html/system/framework.php:40
[0x00007f1c1b616140] [INCLUDE_OR_EVAL]() /home/domain/public_html/vqmod/vqcache/vq2-system_startup.php:142
[0x00007f1c1b6160b0] start() /home/domain/public_html/index.php:23


A session like issue but relates to vqcache

Regards,

- Justin


We asked if the mysql version was changed during the cpanel update:

No, there were no package updates last night, the last time packages were updated was on the 2nd:

[root@server log]# journalctl -r |grep yum
Feb 02 05:04:29 server.domain.com yum[410]: Updated: mesa-libGL-18.0.5-4.el7_6.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: systemd-sysv-219-62.el7_6.3.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: nscd-2.17-260.el7_6.3.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: ImageMagick-6.7.8.9-16.el7_6.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: freetype-devel-2.8-12.el7_6.1.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: mesa-libEGL-18.0.5-4.el7_6.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: openldap-2.4.44-21.el7_6.x86_64
Feb 02 05:04:28 server.domain.com yum[410]: Updated: krb5-devel-1.15.1-37.el7_6.x86_64
Feb 02 05:04:27 server.domain.com yum[410]: Updated: 32:bind-utils-9.9.4-73.el7_6.x86_64
Feb 02 05:04:27 server.domain.com yum[410]: Updated: 32:bind-9.9.4-73.el7_6.x86_64
Feb 02 05:04:27 server.domain.com yum[410]: Updated: 32:bind-devel-9.9.4-73.el7_6.x86_64
Feb 02 05:04:27 server.domain.com yum[410]: Updated: glibc-static-2.17-260.el7_6.3.x86_64
Feb 02 05:04:27 server.domain.com yum[410]: Updated: glibc-devel-2.17-260.el7_6.3.x86_64
Feb 02 05:04:26 server.domain.com yum[410]: Updated: glibc-headers-2.17-260.el7_6.3.x86_64
Feb 02 05:04:26 server.domain.com yum[410]: Updated: kernel-headers-3.10.0-957.5.1.el7.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: 32:bind-libs-9.9.4-73.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: 32:bind-license-9.9.4-73.el7_6.noarch
Feb 02 05:04:25 server.domain.com yum[410]: Updated: libkadm5-1.15.1-37.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: nss-tools-3.36.0-7.1.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: nss-sysinit-3.36.0-7.1.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: nss-3.36.0-7.1.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: mesa-libgbm-18.0.5-4.el7_6.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: 7:device-mapper-libs-1.02.149-10.el7_6.3.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: 7:device-mapper-1.02.149-10.el7_6.3.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: policycoreutils-python-2.5-29.el7_6.1.x86_64
Feb 02 05:04:25 server.domain.com yum[410]: Updated: selinux-policy-3.13.1-229.el7_6.9.noarch
Feb 02 05:04:25 server.domain.com yum[410]: Updated: freetype-2.8-12.el7_6.1.x86_64
Feb 02 05:04:24 server.domain.com yum[410]: Updated: policycoreutils-2.5-29.el7_6.1.x86_64
Feb 02 05:04:24 server.domain.com yum[410]: Updated: systemd-219-62.el7_6.3.x86_64
Feb 02 05:04:22 server.domain.com yum[410]: Updated: systemd-libs-219-62.el7_6.3.x86_64
Feb 02 05:04:22 server.domain.com yum[410]: Updated: mesa-libglapi-18.0.5-4.el7_6.x86_64
Feb 02 05:04:22 server.domain.com yum[410]: Updated: nss-util-3.36.0-1.1.el7_6.x86_64
Feb 02 05:04:22 server.domain.com yum[410]: Updated: krb5-libs-1.15.1-37.el7_6.x86_64
Feb 02 05:04:22 server.domain.com yum[410]: Updated: glibc-2.17-260.el7_6.3.x86_64
Feb 02 05:04:21 server.domain.com yum[410]: Updated: glibc-common-2.17-260.el7_6.3.x86_64

but even then, no MySQL was not updated.

Regards,

- Justin

------

Do you guys know what the issue might be?