0
I have the following problem, I have a report screen that makes an Ajax call that returns all items to me. But when the report has few records it returns everything right, Ajax makes the request receives the information and plays on the screen. But when the query returns more than 13 thousand record the method is time consuming, and Ajax is for a few minutes processing, then error 500 or 502 occurs. When I use Debug in the method passing the same parameters of Ajax, the method takes a while to be executed due to the amount of records, but the method comes to the end, already running in the browser it dies and gives the error 500 or 502.
Does anyone have any alternative solution ?
Run this ajax file directly and enable the herros in php and see what the real problem is, it must have something to do with the amount of records ...
– rray
I bet a clue is in the log of apache.
– Daniel Omine
LOG PHP gave the following information : [01-Feb-2016 11:47:43 America/Sao_paulo] PHP Notice: Undefined offset: 5 in C:/.... Someone has been there before ?
– Filipe Cristian
LOG APACHE : [Mon Feb 01 11:47:57.816753 2016] [core:error] [pid 3324:tid 972] [client 192.168.0.210:16290] End of script output before headers: retorna_metodo_ajax.php5, referer: http:/192.168. 0.210/manager/rel_relacao_couponons.php5 Someone has experienced this before ?
– Filipe Cristian
I already passed, I said there is no Indice 5 in the array.
– rray
There’s more. [Fri Jan 29 11:49:21.383525 2016] [mpm_winnt:notice] [pid 11640:tid 4] AH00362: Child: Waiting 30 more Seconds for 3 worker threads to Finish. [Fri Jan 29 11:49:51.560937 2016] [mpm_winnt:notice] [pid 11640:tid 4] AH00362: Child: Waiting 0 more Seconds for 3 worker threads to Finish. [Fri Jan 29 11:49:51.661375 2016] [mpm_winnt:notice] [pid 11640:tid 4] AH00363: Child: Terminating 3 threads that failed to Exit.
– Filipe Cristian