Max Execution PHP7

[javad-afzal]

Kindly need guidance on the following issue.

Code: Select all

[Fri May 29 21:50:54.745304 2020] [php7:error] [pid 19002] [client 192.168.2.15:55624] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:50:57.661247 2020] [php7:error] [pid 19262] [client 192.168.2.15:55597] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2585, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:00.041276 2020] [php7:error] [pid 19237] [client 192.168.2.15:55595] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/vdc_db_query.php on line 495, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:02.049322 2020] [php7:error] [pid 19187] [client 192.168.2.15:55612] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:04.333353 2020] [php7:error] [pid 19268] [client 192.168.2.15:55627] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 50, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:11.209235 2020] [php7:error] [pid 19214] [client 192.168.2.15:55604] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 27, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:11.833275 2020] [php7:error] [pid 19221] [client 192.168.2.15:55619] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2585, referer: http://192.168.2.250/agc/vicidial.php
[Fri May 29 21:51:13.117242 2020] [php7:error] [pid 19205] [client 192.168.2.15:55661] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php


Max execution time in PHP.INI

max_execution_time = 990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

I have tried changing every Max time in the PHP.ini, but the error is still there.
it works fine for some time but after a while, it starts giving this error and all agents get paused and GUI interface starts behaving strangely. if I restart apache2 and httpd services than again it works fine for a while.
Couldn't find out what specific action is triggering this error. there is no load on the server as its just a simple inbound setup for 40 Agents. total leads loaded into the system is around 2M.

ViciBox_v9.x86_64-9.0.2.ISO | Vicidial 2.14-751a Build 200425-0949 | Asterisk 13.29.2-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU X5675 | 32 GB RAM | Load Average 0.13, 0.10, 0.09 |

[mflorell]

Look at your database, you might have too many records in some tables, or you're trying to run a report for too long of a time period.

[javad-afzal]

Thanks for the update dear.
Not running any report, just agents (60) working on the inbound campaign, with recordings turned on.
Only the list table has some records in it. is it too many for the lists I have uploaded? there are only six leads files loaded till now. the highest number of records is 900K in one particular list.

MariaDB [asterisk]> select count(*) from vicidial_list;
+----------+
| count(*) |
+----------+
| 3964451 |
+----------+
1 row in set (0.00 sec)

I think the last changes I made on the server was only updated php.ini execution time and max upload values, and another on was, I tried uploading a lead file of 900K records and the webpage got stuck so i closed it and never uploaded that file now, is it possible if the file is there in the cache somewhere, i have checked databases and could not find any traces of that particular list.
is phpMyAdmin available in this version, i can see the phpMyAdmin in /usr but there is no phpMyAdmin directory at /www

ViciBox_v9.x86_64-9.0.2.ISO | Vicidial 2.14-751a Build 200425-0949 | Asterisk 13.29.2-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU X5675 | 32 GB RAM | Load Average 0.13, 0.10, 0.09 |

[williamconley]

1) Excellent job posting your system specs

2) There is only one "vicidial_list" table. Thus when you say "in any particular list", that's not what's really happening. There are 4M records in the table, each time a request is made of that table it must check all 4M records. The fact that you may put a value in one of the fields (list_id) in some of them that is different than others doesn't make the vicidial_list table less than 4M records.

3) What are the specs on this machine? How many cores at what speed? How much memory?

4) What is at /srv/www/htdocs/agc/functions.php on line 2517 in your version?

5) I've heard reports that the phpMyAdmin configuration fails, not sure why (haven't looked). Simple solution is to move it to the /srv/www/htdocs folder, but be sure you have whitelisting (fireawall) in place first as that application is prone to attack and uses a very "stock" password. Unless you actually apply a "folder lock" with apache (which is also recommended). Or you could have a look at the phpmyadmin configuration vhost file and see what goes wrong with the install (and report back so it can get fixed).

6) If you tried to upload a file that was too large, it failed and did not even attempt to begin loading those leads. Also, they are not temporarily stored anywhere other than the vicidial_list table, so if they are not in there they are NOT messing anything up. The only exception to that is if it was a locked tmp file in /tmp (but that would bock future lead loads, not bog down the server, since the temp file is locked).

[javad-afzal]

Thanks.

2. Yes, Exactly all the leads data is in the vicidial_list table.
3. It's an HP Proliant dl360 G7 with dual processors, each has 12 cores and clock speed is 3.4Ghz. with 32GB of Ram and RAID 1.
4. functions.php line 2517

Code: Select all

 $rslt=mysqli_query($link, $stmt);
        return $rslt;
}


# function to print/echo content, options for length, alignment and ordered internal variables are included
function _QXZ($English_text, $sprintf=0, $align="l", $v_one='', $v_two='', $v_three='', $v_four='', $v_five='', $v_six='', $v_seven='', $v_eight='', $v_nine='')
        {
        global $SSenable_languages, $SSlanguage_method, $VUselected_language, $link;


5. I will stick to the MySQL CLI for now.
6. I have tried looking those list ids in all the vicidial list associated tables, there is nothing there except list id entry in the vicidial_list_custom table which only has 7 rows in it.

The error does not specifically come from functions.php line 2517, it changes frequently. kindly see the details below.

Code: Select all

[Tue Jun 02 03:36:23.189960 2020] [php7:error] [pid 25270] [client 192.168.2.15:54121] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/conf_exten_check.php on line 383, referer: http://192.168.2.250/agc/vicidial.php


Below i deleted a list of 900K records in it the following error generated.

Code: Select all

[Tue Jun 02 03:21:22.849657 2020] [php7:error] [pid 21944] [client 192.168.0.242:58953] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/vicidial/admin.php on line 7, referer: http://192.168.2.250/vicidial/admin_listloader_fourth_gen.php

Below are generated randomly, unable to trace what triggered these.

Code: Select all

[Tue Jun 02 03:08:48.209595 2020] [php7:error] [pid 11471] [client 192.168.2.15:61432] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 17, referer: http://192.168.2.250/agc/vicidial.php
[Tue Jun 02 03:12:42.733562 2020] [php7:error] [pid 11486] [client 192.168.0.242:58918] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/vicidial/admin_listloader_fourth_gen.php on line 430, referer: http://192.168.2.250/vicidial/admin_listloader_fourth_gen.php

Code: Select all

[Tue Jun 02 02:40:19.845696 2020] [php7:error] [pid 6448] [client 192.168.2.15:52428] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2498, referer: http://192.168.2.250/agc/vicidial.php


Below i uploaded a new list with 400K records in it, list loaded fine, but eventually got below PHP error.

Code: Select all

[Tue Jun 02 02:28:14.225799 2020] [php7:error] [pid 2501] [client 192.168.0.242:58469] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/vicidial/functions.php on line 1305, referer: http://192.168.2.250/vicidial/admin_listloader_fourth_gen.php

ViciBox_v9.x86_64-9.0.2.ISO | Vicidial 2.14-751a Build 200425-0949 | Asterisk 13.29.2-vici | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU X5675 | 32 GB RAM | Load Average 0.13, 0.10, 0.09 |

[javad-afzal]

Any Body?

Should I replace php.ini with the default one on the new installation?

Code: Select all

[Thu Jun 04 04:17:11.289594 2020] [php7:error] [pid 21489] [client 192.168.2.15:62026] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2585, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:17:42.877556 2020] [php7:error] [pid 21679] [client 192.168.2.15:62019] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/vdc_db_query.php on line 511, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:18:55.553553 2020] [php7:error] [pid 21754] [client 192.168.2.15:62266] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 20, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:19:37.193574 2020] [php7:error] [pid 21510] [client 192.168.2.15:62241] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:20:14.665600 2020] [php7:error] [pid 21568] [client 192.168.2.15:62284] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:20:20.445559 2020] [php7:error] [pid 21574] [client 192.168.2.15:60894] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/vicidial/functions.php on line 1305, referer: http://192.168.2.250/vicidial/realtime_report.php?RR=4&DB=0&groups[]=Directv&user_group_filter[]=ALL-GROUPS&user_group_filter[]=ALL-GROUPS&ingroup_filter[]=ALL-INGROUPS&adastats=1&SIPmonitorLINK=&IAXmonitorLINK=&usergroup=&UGdisplay=0&UidORname=1&orderby=timeup&SERVdisplay=0&CALLSdisplay=1&PHONEdisplay=0&CUSTPHONEdisplay=0&with_inbound=Y&monitor_active=&monitor_phone=&ALLINGROUPstats=&DROPINGROUPstats=0&NOLEADSalert=&CARRIERstats=0&PRESETstats=0&AGENTtimeSTATS=0&INGROUPcolorOVERRIDE=0&droppedOFtotal=0&report_display_type=TEXT
[Thu Jun 04 04:20:25.757562 2020] [php7:error] [pid 21595] [client 192.168.2.15:62306] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/functions.php on line 2517, referer: http://192.168.2.250/agc/vicidial.php
[Thu Jun 04 04:20:27.509770 2020] [php7:error] [pid 21388] [client 192.168.2.15:62273] PHP Fatal error:  Maximum execution time of 9223372036854775807 seconds exceeded in /srv/www/htdocs/agc/dbconnect_mysqli.php on line 50, referer: http://192.168.2.250/agc/vicidial.php


Errors are still there I have tried everything up to my knowledge.
If i reboot apache2 and httpd every hour, Than it works fine without any single error.

[williamconley]

are you running virtualization software on this server? how about hyperthreading?