Seem to be receiving a 504 error message when trying to generate a csv/xlsx file on Metabase for reporting, when checking error for this displays as “API endpoint does not exist”
This has only recently started happening and can normally download the files without any issues, does anyone have any suggestions on what the cause of this error could be?
Hi @Dsmith87
Post "Diagnostic Info" from Admin > Troubleshooting.
Sounds like two different problems.
The http status code 504 means "Gateway Timeout", which is an error coming from your reverse-proxy, likely because it's closing the connection too soon.
https://www.metabase.com/docs/latest/troubleshooting-guide/proxies.html
The "API endpoint does not exist" must be coming from something else, but without seeing the full error/stacktrace, then it's difficult to say.
Hi@flamber
Thanks for the reply on this issue, as requested please see diagnostic info below:
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.5+10",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.5",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.5+10",
"os.name": "Linux",
"os.version": "4.14.123-86.109.amzn1.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"mongo",
"postgres"
],
"hosting-env": "elastic-beanstalk",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "10.18"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"date": "2020-02-25",
"tag": "v0.34.3",
"branch": "release-0.34.x",
"hash": "1a83edb"
},
"settings": {
"report-timezone": "UTC"
}
}
}
Hi @Dsmith87
You are running a 2+ year old version of Metabase. You should really start looking into upgrading. It's likely a slightly longer process because you're using EBS and it's a large upgrade gap.
Make sure you have backups before upgrading.
And make sure your RDS is decoupled:
https://www.metabase.com/docs/latest/operations-guide/running-metabase-on-elastic-beanstalk.html
Hi@flamber
Will this also affect the main issue mentioned of being unable to download the reports as normal in csv/xlsx format?
Anything we can do to resolve or as a potential workaround?
@Dsmith87 There has been thousands of fixes and changes. But your problem would like be fixed if you upgraded. Make sure to make a backup if you want to revert.