Support

Home Forums Event Espresso Premium Timing out when downloading Event Espresso – Registrations

Timing out when downloading Event Espresso – Registrations

Posted: January 6, 2020 at 4:33 am


mchoudhury

January 6, 2020 at 4:33 am

Hi all,

For one of my events, we have over 2500 registrations and whenever I try to download the CVS file, the system crashes with the following error message ‘Gateway Timeout The gateway did not receive a timely response from the upstream server or application. Additionally, a 504 Gateway Timeout error was encountered while trying to use an ErrorDocument to handle the request.’

I have spoken to our hosting company and developer and they conclude there are no issues on the server and its the Event Espresso application which cant seem to handle that many requests?

Please can someone advise or help

Is it possible to download in batches from specific time periods or registrations?

Mizan


Tony

  • Support Staff

January 6, 2020 at 5:19 am

Hi Mizan,

Are you using EE3 or EE4?

I have spoken to our hosting company and developer and they conclude there are no issues on the server and its the Event Espresso application which cant seem to handle that many requests?

With EE3 it would attempt to handle the export in a single request, which can timeout if there is a lot of data to pull in (not usually with
a 504 error), however that’s very different from multiple requests.

With EE4 we have a ‘batch’ system which pulls in smaller numbers of registrations and writes them to a temp file on the server, then when all of the registrations have been pulled/written to the file it streams that to the browser to download.

Multiple requests in this instance are actually better than a single request, especially for larger numbers of registrations.

—-

5XX errors are server related errors, they happen when your server can’t handle the request for various reasons.

I tried to have a look over your site but your sites home page is also showing 504 Gateway timeout, that home page should certainly not be loading EE registrations. The fact that you are getting that error on what appears to be every page of the sites means this isn’t likely an issue right now and something is causing your server to be under high load.


mchoudhury

January 6, 2020 at 5:26 am

Thanks, so as solution shall I upgrade to EE4 and will I lose all my current data?

Mizan


Tony

  • Support Staff

January 6, 2020 at 5:32 am

No, right now the solution is to find what is causing your server to choke and return 504 errors.

Are you currently trying to export registrations on the site?

I do NOT recommend updating to EE4 until you have that worked out first, it’s a totally separate system to EE3, it works differently and has its own learning curve. You don’t want to jump into that just to try and export registrations and then end up in even more of a mess because your server can’t handle the requests (EE4 requires more resources than EE3 does for some of its requests).


mchoudhury

January 6, 2020 at 5:39 am

Currently all I do is download CSV and that causes the crash


Tony

  • Support Staff

January 6, 2020 at 5:46 am

Your server is crashing for me just from loading the home page of your site.

If you are trying to run exports right now you may be bogging down the server which is preventing the home page from being served so stop any requests you have running for exports for a little and see if the server catches up.


mchoudhury

January 6, 2020 at 5:47 am

Sorry I don’t understand? So exactly am I need to so?


Tony

  • Support Staff

January 6, 2020 at 10:56 am

You just needed to leave the site alone a little to see if the 504’s stopped (or restarted the server) to force any processes to stop. Your home page now loads so I can view the site.

So, your using EE4 already but you are using an older version (4.6.19.p), that version of EE4 users a similar set up to how EE3 does it and the ‘batch system’ I mentioned above was added in 4.8+.

I recommend updating to the latest version of EE4 (currently 4.10.2.p) and using the batch system to export your registrations in smaller batches (the process is the same and EE will batch export for you). I don’t have issues exporting over 3000 registrations on my test sites but it depends on a lot of different factors.


mchoudhury

January 6, 2020 at 11:11 am

Ok – Sure I just do an upgrade to the latest version of EE4 – Just to confirm by upgrading I will not lose the current registrations?


Tony

  • Support Staff

January 6, 2020 at 2:10 pm

No, Updating to the latest version will not lose registrations.

However, you should back up your database before you run the update just to be safe, you can use a plugin to do so, such as:

https://en-gb.wordpress.org/plugins/backupwordpress/

(Its important to get into the habit of creating a backup before updating plugins, if something goes wrong you’ll need that backup. It’s rare but can happen)

As you are updating from a rather old version you’ll have multiple ‘migrations’ to run when you update EE. Ee will go into maintenance mode and tell you to update the database, just follow the on screen instructions and click through to update until they are complete.

The support post ‘Timing out when downloading Event Espresso – Registrations’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso