Centova Technologies Forum
Centova Cast v3 => Bugs and issues => Topic started by: roteck on May 12, 2018, 08:48:09 am
-
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.