these errors stream, SQLNonTransientConnectionException we get after opening questions that have not been loaded for some hoursare a kind of annoying showstopper and makes the otherwise great metabase software look bad.
We hope that using the information above you can reproduce the issue e.g. setup a similar test environment to debug the issues.
Does anyone have ideas how to fix this or can anyone reproduce and debug this issue on a test system? Would be helpful, we can’t work well with Metabase if it has issues with core functions like it does for us and other people!
System info:
Version of Metabase? (preferably "Diagnostic Info" from Admin > Troubleshooting)
0.33.6
Version of MySQL/MariaDB? Output from Metabase Native query:
SELECT @@version;
5.7.28-1
Output from Metabase Native query:
SHOW VARIABLES LIKE "%timeout%";
delayed_insert_timeout
300
have_statement_timeout
YES
innodb_flush_log_at_timeout
1
innodb_lock_wait_timeout
50
innodb_rollback_on_timeout
OFF
interactive_timeout
28800
lock_wait_timeout
31536000
net_read_timeout
30
net_write_timeout
60
rpl_stop_slave_timeout
31536000
slave_net_timeout
60
wait_timeout
14400"
Are you using any Connection String parameters (Admin > Databases > mysql/mariadb)?
sessionVariables=wait_timeout=14400&collation=utf8mb4_unicode_ci
How is your MySQL/MariaDB connected to Metabase? localhost, local network, SSH tunnel, ...? Are you using TLS or other connection encryption?
Right now using a SSH tunnel, we tried without the SSH tunnel (Directly to the database on localhost) but it behaved very similar, sometimes the mentioned errors when trying to open charts. About encryption I’m not sure, we didn’t activate anything special maybe it’s on by default.
Diagnostic Info
{
“browser-info”: {
“language”: “de”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.0”,
“vendor”: “”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “1.8.0_232-8u232-b09-1~deb9u1-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_232”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “25.232-b09”,
“os.name”: “Linux”,
“os.version”: “4.9.0-11-amd64”,
“user.language”: “en”,
“user.timezone”: “Europe/Berlin”
},
“metabase-info”: {
“databases”: [
“mysql”
],
“hosting-env”: “unknown”,
“application-database”: “mysql”,
“run-mode”: “prod”,
“version”: {
“tag”: “v0.33.6”,
“date”: “2019-11-19”,
“branch”: “release-0.33.x”,
“hash”: “be1e0e1”
},
“settings”: {
“report-timezone”: “Europe/Berlin”
}
}
}