PHP version 5.6
I have a PHP program (running in
CodeIgniter 'CI_VERSION', '2.1.3') looping through 100 items to process.
Apache (via Codeigniter) will give me 500 Error and no indication anywhere in the logs what actually happened.
/var/log/mysql/error.log has this single line:
[Note] Aborted connection 899 to db: 'dbname' user: 'username' host: 'localhost' (Got an error reading communication packets)
Last lines of /var/lib/mysql/ns1.log - it contains no errors anywhere
2019-07-26T02:08:10.254327Z 581 Connect username@localhost on dbname using Socket 2019-07-26T02:08:10.254499Z 581 Init DB dbname 2019-07-26T02:08:10.254607Z 581 Query SET NAMES utf8 2019-07-26T02:08:10.255229Z 581 Query SHOW TABLES FROM `dbname` 2019-07-26T02:08:10.257569Z 581 Query SELECT `value` FROM (`multiscraper_settings`) WHERE `key` = 'ts' 2019-07-26T02:08:10.257962Z 581 Query SELECT `value` FROM (`multiscraper_settings`) WHERE `key` = 'au' 2019-07-26T02:08:10.258304Z 581 Query SELECT `value` FROM (`multiscraper_settings`) WHERE `key` = 'au' 2019-07-26T02:08:10.261331Z 581 Quit
I am sure that there are no SQL query errors, because if there were, I have enabled all logging and I would see it in the logs (as I have seen such when they happenned).
When I run the program in batches of 25 items, all 100 items complete successfully with no 500 Errors. I am suspecting some variable is hitting a ceiling here. It is not Maximum PHP script run time, because I changed that to unlimited.
What do you think is causing this?