AJAX request failed (error; Gateway Time-out)

Read 3143 times
Hello.
I am trying to access Statistics > 30 Days > Listeners and i got this error : AJAX request failed (error; Gateway Time-out)

In cc-web.log i got this message:
2018/05/12 18:30:41 [error] 21131#0: *31 upstream timed out (110: Connection timed out) while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: centovacast, request: "GET /admin/rpc.php?m=statistics.get_listener_session_lengths&p%5B0%5D%5B%5D=relative&p%5B0%5D%5B%5D=30 HTTP/1.1", upstream: "fastcgi://unix:/usr/local/centovacast/var/run/cc-appserver.sock", host: "xxx.xxx.xxx.xxx:2199", referrer: "http://xxx.xxx.xxx.xxx:2199/admin/index.php?page=accountstats"

I am guessing that request is being time out since there are a lots of stats to access and i will need to increase duration. Can someone tell me what file and string should i change on the server?

Also i see here another old post without any answer: http://forums.centova.com/index.php?topic=2598.0

It's quite urgent to get this solved asap.

Thx
Hello roteck,

You are right, the request is timing out, however I would suggest first trimming the data in your database as much as possible, and optimizing those tables, before increasing execution time or time-out limits for PHP, as that can have unintended side effects.

This article shout help with trimming unnecessary session data:

http://www.centova.com/en/faq/cast3/troubleshooting/centova_cast_statistics_pages_load_slowly_or_time_out

And you can run database optimization from the utilities section, in your admin dashboard.

Finally, if you must resort to increasing php tolerances, you can do so by editing "/usr/local/centovacast/etc/cc-system.conf" (which is basically a php.ini file), however do bare in mind that editing cc-system.conf is not officially supported.


Regards.