|
Ng Jia Xiang
|
June 16, 2014 at 1:29 am
Hi,
I am unable to export my csv report on one of my events.
When the “Registration CSV report” button is clicked, the page starts loading for a while, then goes to a wordpress default “page not found” without any csv downloaded.
It has 2800+ registrations.
The same function works for other events I have. (below 1500 registrations)
EE4.2.3
WP 3.9.1
Chrome (latest)
Let me know if there is a workaround for this.
|
|
Tony
|
June 16, 2014 at 7:08 am
Hi Ng Jia Xiang,
Its possible the script is timing out before it has time to finish the operation.
Can you enable Error Reporting (via http://codex.wordpress.org/Editing_wp-config.php#Configure_Error_Logging) so we can see if any errors are thrown that we can then investigate?
|
|
Ng Jia Xiang
|
June 17, 2014 at 8:30 am
Hi Tony,
I managed to download it after trying around 50+ times. This is one of the errors:
PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 99 bytes) in /home/-redacted the site path-/public_html/wp-includes/wp-db.php on line 1941
[17-Jun-2014 13:49:30 UTC] PHP Fatal error: Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0
Thanks.
|
|
Lorenzo Orlando Caum
|
June 17, 2014 at 12:51 pm
Hello, could you please raise the memory that is available to PHP?
You can usually do this through your wp-config.php file or your host can do this for you:
http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
—
Lorenzo
|
|
Ng Jia Xiang
|
June 18, 2014 at 1:13 pm
Hi,
I still can’t download the report smoothly. This is the new error:
[18-Jun-2014 19:11:42 UTC] PHP Fatal error: Maximum execution time of 600 seconds exceeded in /home/shaperun/public_html/wp-content/plugins/event-espresso-core-reg/core/EE_Registry.core.php on line 371
|
|
Ng Jia Xiang
|
June 18, 2014 at 3:30 pm
Hi,
Another similar error:
[18-Jun-2014 20:21:44 UTC] PHP Fatal error: Maximum execution time of 600 seconds exceeded in /home/shaperun/public_html/wp-content/plugins/event-espresso-core-reg/core/db_models/EEM_Base.model.php on line 2412
But the downloads fail less frequently now.
|
|
Lorenzo Orlando Caum
|
June 18, 2014 at 5:27 pm
Did you already raise the memory available to PHP?
Also, when it does download about how long does it load before the file is downloaded?
—
Lorenzo
|
|
Ng Jia Xiang
|
June 18, 2014 at 5:30 pm
Hi,
Yes I have raised the memory from 512mb to 1gb.
The successful ones take roughly 8 minutes.
The failures take about 15 minutes to fail.
|
|
Tony
|
June 19, 2014 at 6:50 am
This isn’t really a ‘bug’ per say.
It appears each of those 2800 registrations likely has in the range of 20 questions within them. (From looking at the events on your site)
So what happens is each of registrations pulls in their 20 questions from the database one after the other, which use memory and time, so for 2800 your current server can not consistently handle the load.
I’m assuming this is a shared server? You could try upping the max execution time on the server (host permitting)
I’ve created a ticket to discuss the options EE can offer in situations such as these.
|
|
Ng Jia Xiang
|
June 19, 2014 at 7:00 am
The site is on a VPS with the following specs:
2 vCPU
Guaranteed 2GB RAM
30GB storage [EMC SAN (SSD caching, 15000rpm SAS drives)]
1TB Data Transfer
Would increasing the number of vCPUs help?
|
|
Tony
|
June 19, 2014 at 7:21 am
Is this the only site on that VPS?
You currently have a max execution time of 600 seconds (10 mins)
PHP Fatal error: Maximum execution time of 600 seconds exceeded
Which is close to the amount of time it takes for the successful reports, so if there is something else running on the server at the same time it could run a little longer, then hit the timeout.
Personally I would start by increasing the max execution value.
|
|
Ng Jia Xiang
|
June 19, 2014 at 12:27 pm
Yes, this is the only site on the VPS.
I have raised the max execution to 1800 seconds (30 mins).
|
|
Tony
|
June 20, 2014 at 6:20 am
If you now run the same export does complete or still time out after 30mins?
A max_execution_time of 30mins should really not be needed.
|
|
Ng Jia Xiang
|
June 21, 2014 at 11:35 am
The same export will fail the first time at 11 mins 45 seconds (goes to page not found page), and complete the second time at 9 mins 23 seconds.
max_execution_time is 1800 seconds, but max_input_time is 600 seconds
No errors were logged.
|
|
Josh
|
June 23, 2014 at 6:18 pm
Thanks for the update.
|
|
Ng Jia Xiang
|
June 24, 2014 at 4:58 pm
The csv report no longer works; 2700 registrations with 20 questions appears to be the limit.
max_execution_time has been set to 1800 seconds and max_input_time 1800 seconds, the service has also been restarted after the settings were changed, but the export still fails at 11 mins 40+ seconds. I have tried adding this setting on wp-config.php as well, but it still doesn’t work.
This is the only site on the VPS, I have also paid for extra resources to boost the VPS and hoped the export works; it still doesn’t work.
I have no solutions left to try. Please help. Thanks.
|
|
Ng Jia Xiang
|
June 24, 2014 at 11:13 pm
If I bought a support token, could I have the support staff put together something that can download the report in batches, eg. by date or by amount?
|
|
Ng Jia Xiang
|
June 25, 2014 at 2:08 am
Hi, a little update.
I have managed to port the site to a WAMP server, upped the max execution time etc. to 1800, and it works properly (downloads after 23 minutes for 2770 registrations).
This solved my immediate problem and should be good enough for now.
It is clear this is some server issue, and that even the web host couldn’t resolve it.
|
