Metabase Crashes After Performing Export

Get Help
1

Hi

Metabase v.0.41.2 installed on Ubuntu 20.04.3 LTS
t3a.medium instance with HDD 20GB.
Installed via docker with PostgreSQL outside Docker.
Run CMD:
docker run -d –network=host -p 3000:3000
-e "MB_DB_TYPE=postgres"
-e "MB_DB_DBNAME=metabaseDB"
-e "MB_DB_PORT=5432"
-e "MB_DB_USER="
-e "MB_DB_PASS="
-e "MB_DB_HOST=localhost"
--name metabase metabase/metabase

It's been 2 weeks. But now we are facing issue when we perform a Export Operation.

Whenever we do a Export Operation, after that Metabase doesn't load and shows 'HTTP ERROR 500 Connections could not be acquired from the underlying database!'

What is the issue and how to resolve it ?
Please Help

2

Hi @spanda
Post "Diagnostic Info" from Admin > Troubleshooting.
And check the logs during startup to see how much memory Metabase is allowed to use, and check the logs at the end to understand why it crashed.
docker logs metabase

3

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "5.11.0-1022-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"sqlserver",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.0 (Ubuntu 14.0-1.pgdg20.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2021-11-09",
"tag": "v0.41.2",
"branch": "release-x.41.x",
"hash": "ad599fd"
},
"settings": {
"report-timezone": null
}
}
}

4

May I know, how the Export Works? Like Does it create the Excel inside the Server and moves to client ?

5

@spanda Yes, Metabase gets streaming results, when is then generates a temporary file, because it's not possible to stream XLSX directly to the client, which then gets send to the client, when it's generated.

1 Like
6

Can you tell the location, where it's creating the temp?

7

@spanda Based on the Java temporary directory.

1 Like