Sometimes an error appears.
http://joxi.ru/V2Vg0OpSBJnEWA
MESSAGE:(conn=788) unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
How to configure mysql so that it does not appear?
Hi @Leno4ka
Post "Diagnostic Info" from Admin > Troubleshooting.
And which version of MySQL you're using.
{
"browser-info": {
"language": "ru-RU",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36",
"vendor": "Google Inc."
}
}
mysqld Ver 5.7.38-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))
@Leno4ka Login to Metabase, go to Admin > Troubleshooting, and copy the entire "Diagnostic Info" and paste it here.
{
"browser-info": {
"language": "ru-RU",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.63 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.15+10-Ubuntu-0ubuntu0.18.04.1",
"java.vendor": "Private Build",
"java.vendor.url": "Unknown",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10-Ubuntu-0ubuntu0.18.04.1",
"os.name": "Linux",
"os.version": "4.15.0-177-generic",
"user.language": "en",
"user.timezone": "Europe/Moscow"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.38-0ubuntu0.18.04.1"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.5"
}
},
"run-mode": "prod",
"version": {
"date": "2022-05-31",
"tag": "v0.43.2",
"branch": "release-x.43.x",
"hash": "433d533"
},
"settings": {
"report-timezone": null
}
}
}
@Leno4ka Ignore it if it doesn't cause errors. Looks like it's caused by some specific set of MySQL configuration, which we haven't been able to reproduce.
https://github.com/metabase/metabase/issues/12877
from the first time, the data almost never pulls up, you constantly need to update the pages so that all the data is displayed in the dashboards
@Leno4ka Without seeing all logs, then it's difficult to say what is going on.
https://drive.google.com/file/d/1tPZK7hSNMwo4OJh-e2dc0VykP_TfzSET/view?usp=sharing@Leno4ka Looks like Metabase can run queries on 4 connections are the same time, but anything above that is causing connection errors from your database.
I'm not sure which type of setup you have of your MySQL, but I doubt it's default configuration.
Try setting useBatchMultiSend=false in Admin > Databases > (db) > Show advanced options > Additional connection string parameters
