I’m currently using Metabase version 33.4. I’m also running this on Elastic Beanstalk With an RDS instance that was configured on Startup. I am connected to a SQL Server database for the query I am attempting to export. The table has quite a few records but when I filter down the recordset I am approximately pulling back 67,000 records. that is using one filter on one field.
When I attempt to export to XLSX format I end up getting a 504 Gateway timeout error. I have successfully exported out to CSV. when I do attempt to export to xlsx it ends up stressing out my machine so much that it goes from Green to Yellow to Red status in EB and then becomes unresponsive for a while until it regains consciousness in a few minutes.
I have read a handful of different posts about instance size or timeout settings. I have attempted the following fixes without success.
- Change the connection draining setting two connection draining enabled and drain time out a hundred and 20 seconds. (Goal to ensure that the load balancer would continue to stay connected even after 20 seconds.)
- Set up a new instance without a load balancer in front and Leverage The H2 database for configuration. (Goal is to remove the load balancer from the equation)
- change the instance size of the Metabase instance from a T3. small to an M4.Xlarge ( goal is trying to eliminate memory or CPU performance from the equation)
I did read many different posts trying to identify the underlying problem. 1 Post recommended adding some additional statements in Nginx to increase connection time before time out. I wasn’t exactly sure where to put these values as it didn’t look like they were environmental values to be added to EB.
I also was not able to find any place to disable the ability to use the Excel export so that my user would not how is the system by doing something that doesn’t seem to work. While telling them to only use CSV is a logical answer somebody eventually will attempt to export to Excel and break the system for 5 minutes until it regains consciousness.
Any thoughts would be much appreciated.