Forum Activity for @andrusito

JR sites going down...

Using Jamroom

thanks, but the server is fine. This one JR site is the only going down. I have more JR sites doing just fine.

JR sites going down...

Using Jamroom

Hi, I have 2 JR sites, and one that keeps going down every 4 hs. or so. I am on a new dedicated server with 80 CPUs and 192 GB of RAM.

All other sites are just fine but still struggling with one JR site.

I did manage to do an integrity check just fine but the site goes down from time to time.

After it finishes trying to load sometimes I get to the site, but sometimes I get this> "Gateway Timeout
The gateway did not receive a timely response from the upstream server or application.

Additionally, a 504 Gateway Timeout error was encountered while trying to use an ErrorDocument to handle the request."

Is there a way to troubleshoot this?

Currently using 6.1.7 and all modules updated.
updated by @andrusito: 08/01/18 03:17:40AM

Jamroom Sites Slow on Dedicated Server

Proxima

ok, now I am on a new dedicated server>

System Information
System Item Details Status
Server Load 3.605469 (80 CPUs)
Memory Used 5.59% (11,101,992 of 198,470,124)
Swap Used 0.05% (4,272 of 8,388,604)

but still struggling with one JR site.

I did manage to do an integrity check just fine but the site goes down from time to time.

After it finishes trying to load sometimes I get to the site, but sometimes I get this> "Gateway Timeout
The gateway did not receive a timely response from the upstream server or application.

Additionally, a 504 Gateway Timeout error was encountered while trying to use an ErrorDocument to handle the request."

Is there a way to troubleshoot this?

Currently using 6.1.7 and all modules updated.
updated by @andrusito: 04/17/18 08:57:31AM

Jamroom Sites Slow on Dedicated Server

Proxima

Thanks, Brian. My server has 32GB of RAM.

My server is now stable. However I tried to run the integrity check again with no luck. Same errors as shown in the image attachments posted before.

How can I run the integrity check without running into "Internal server error"?

Jamroom Sites Slow on Dedicated Server

Proxima

Guys do you have any idea how to proceed here? I really need to bring my sites up asap.

Jamroom Sites Slow on Dedicated Server

Proxima

My WP sites are all ok. The server is now stable. I have the two JR accounts suspended for now. Tech support says this when asked what may have been the cause> "Modules: well there is a evidence of huge load generated by two users (JR sites now suspended) and made a server unresponsive. A lot of process in the sleep state.

When these two users were suspended the server became responsive. I'm
not expert in the CMS, I believe the module is functional but should be
adapted.

I unsuspended one, I tried to run an integrity check, but after 30 minutes it got stuck with error message you see attached.

Jamroom Sites Slow on Dedicated Server

Proxima

Hi! they are currently investigating the load issue. They told me this:

that cpu load we think it is more related with your
websites application, we have noticed this file in many domains, what is
the purpose of this, we'd suggest to check it with your developper

/usr/bin/php /home/USER/public_html/modules/jrCore/router.php

Jamroom Sites Slow on Dedicated Server

Proxima

thanks for replying.

it did hung and it was taking up too many of my server's resources and it crashed.

I have a dedicated server Intel(R) Xeon(R) CPU E5-1620 v3 @ 3.50GHz - (8 CPUs) and all those sites are mine. Mostly wordpress sites.

After getting MySQL services up and running again, I tried running the Integrity check again.
Load Averages: were about 20.

It got to the point were it went to 60 and I just cancelled the Integrity check. after that the server crashed again.

I tried Restarting MySQL Server and I got this (if it's helpful in any way):

Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

Service Status
mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=host.contactoparaweb.com.err --open-files-limit=28666 --pid-file=/var/lib/mysql/host.contactoparaweb.com.pid) is running as mysql with PID 22016 (pidfile+/proc check method).

Startup Log
Starting MySQL............. SUCCESS!

Log Messages
180314 12:09:59 [Note] /usr/sbin/mysqld: Shutdown complete
180314 12:09:46 [Warning] /usr/sbin/mysqld: Forcing close of thread 11515 user: 'sermsnet_user'
180314 12:09:44 [Note] /usr/sbin/mysqld: Normal shutdown
180314 10:56:05 [Note] /usr/sbin/mysqld: ready for connections.
180314 10:55:59 [Note] /usr/sbin/mysqld: Shutdown complete
180314 10:55:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9173334 user: 'sermsnet_user'
180314 10:55:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9218518 user: 'root'
180314 10:55:49 [Note] /usr/sbin/mysqld: Normal shutdown
180302 6:56:37 [Note] /usr/sbin/mysqld: ready for connections.
180302 6:56:30 [Note] /usr/sbin/mysqld: Shutdown complete
180302 6:56:13 [ERROR] /usr/sbin/mysqld: Sort aborted: Query execution was interrupted
180302 6:56:13 [Note] /usr/sbin/mysqld: Normal shutdown

mysql restarted successfully.
----
Right now the server is still down, and support is trying to bring it back in...

Is there a way JR can run it without consuming that much resources?

Jamroom Sites Slow on Dedicated Server

Proxima

If it does not affect the theme (which I changed to Spanish) yes, no problem!

Jamroom Sites Slow on Dedicated Server

Proxima

WOW!. I went there and I see a lot of these type of errors:

Debug Entry
Key Value
Message Query Error: Lock wait timeout exceeded; try restarting transaction
Date 03/12/18 07:46:17
IP Address 69.162.124.235
URL /
Memory 12MB
Data
Array
(
[error] => Query Error: Lock wait timeout exceeded; try restarting transaction
[_post] => Array
(
)

[query] => UPDATE jr_jrcore_cache SET cache_expires = (cache_expires + 30) WHERE cache_key = '0eb4a5995304a0554becaf69b1ed9110'
)

Is there a way to fix it?