Please help us help you and fill where relevant:
LimeSurvey version: LimeSurvey Community Edition Version 6.14.2+250610 
Own server or LimeSurvey Cloud: Own server / Aliyun Linux / nginx/1.20.1 / PHP Version 7.4.33
Survey theme/template: irrelevant ls_line (extends from fruity)
==================
I have a survey with many output columns (about 100) and over 14,000 responses.  For reason I don't want to explain, my connection to the server is not the best (it is close to the survey takers).  When I'm trying to export the resonses, I get the error message:

504 Gateway Time-out

the web server is nginx/1.20.1, PHP Version 7.4.33

The message came up roughly around 60 seconds after I click the 'export' button.

I have tried to to the following parameters in nginx.conf
    proxy_connect_timeout 300s;
    proxy_send_timeout 300s;
    proxy_read_timeout 300s;
    send_timeout 300s;
And in /etc/php-fpm.d/www.conf
  request_terminate_timeout = 300s

And didn't seem to work (or maybe I didn't put in the correct section of the nginx.conf

Has anyone seen this and is there a solution?  Somewhere, there should be a 60s timer that I need to change.


 

It most probably is due to limits in your PHP configuration.

This could be different limits:
- Maximum execution time
- Maximum variable constraints
- Maximum file size that the script can generate
- etc.

Maximum execution time and max_vars being the most probable in my opinion.

You might be able to work around this by exporting responses in batches and not all 14k at the same time.