Failed to get operation result within specified timeout: 30000

A DB set up through ssh tunnel. every query times out.
Failed to get operation result within specified timeout: 30000.
i have increased streaming/archive delay timeouts on the DB side but still no luck.

DefaultConnectFuture[user@/<IP>:22]: Failed to get operation result within specified timeout: 30000

{

"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "4.14.219-164.354.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"druid",
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-17",
"tag": "v1.39.2",
"branch": "release-x.39.x",
"hash": "b0d9436"
},
"settings": {
"report-timezone": null
}
}
}

Hi @shaiksuhale90
Are you using Metabase Cloud, or the Enterprise Edition?
SSH tunnels can be really tricky to debug, since a lot depends on the bastion server you're tunneling through.
If you're using Metabase Cloud, could it be that you have not allowed all 3 IPs to access your bastion?
IP to whitelist for Metabase Cloud instances

perfect that was it . thanks @flamber. how do i know the new Ips once the app is upgraded. if i remember it right the outbound ip keeps changing for every upgrade that happens on metabase cloud.

@shaiksuhale90 No, you instance IP might change during upgrades, but the outgoing IPs are the ones that I have posted and will not change (if they do, all Cloud customers will be notified first).

1 Like