I am having one Codeigniter project that include one "time expensive" synchronization. Basically I am connecting to remote server(running probably CentOS but thats all I know) via OCI8 to Oracle database, picking about 20,000 rows, and then updating local MySQL database.
That synchronization lasts for about 20ihs minutes (yes, MySQL could be more optimized and what not), but thats not the issue that I am having currently...
I have dedicated server with dual Xeon and 16 Gig of ram, CentOS x64, Apache 2.2.15, PHP 5.6.21 and MySQL version 5.6.30.
Now, with Apache 2 Handler and default PREFORK MPM, that synchronization works as intended.
If I leave Apache 2 Handler (mod_php I presume) and change MPM to WORKER or EVENT, that synchronization starts and PHP spits out white screen of death with nothing in log files.
If I switch to fcgi and EVENT or WORKER MPM, synchronization starts, and after about 2 minutes it gives me "The gateway did not receive a timely response from the upstream server or application."
Mind you that its not connection between servers issue since the moment I switch back to Apache 2.0 Handler and PREFORK it works as intended.
Codeigniter version is 2.1.0 (yes I am aware that it long past time to upgrade, its just inherited project and I am not fully aware if there has been some changes with CORE files and the guy is "well its working, ain't it".
Any clue or link with similar issue is more than appreciated.
Thanks in advance