Currently we are running the Metabase in Production Environment, when it goes for within 5 lakhs of records without any issue we can export it to Csv. But the problem while exporting more then 8 lakhs , other users cannot access the Application. if i see the log i am getting error like "**Rollback failed handling “Communications link failure during rollback(). Transaction resolution unknown.**”.then i need to restart the service
Below are the current production setup
AWS environment
8 GB RAM
Running jar by using below env variables -Xmx6g
Is there any suggestion to handle this situation rather then increasing the JVM memory? If a want to increase JVM what is the suggested one
And Metabase handle how many connections at a time.
Just to understand correctly, I’m guessing “lakhs” = “hundred thousands” ?
Which datasource are you connecting to? Which version of Metabase.
Metabase has a hardcoded limit of 2 million 1 million rows, when doing export, but you might be hitting a data size limit ?
Are those errors coming from your database or Metabase itself?