Dashboard query is not loading when using filter

Dashboard is not loading data when I select filter, and has a big data.. immediately return empty value

It is not timeout - because it is immediately.. and other query run by long time...

But in log not return any error

"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/ Safari/537.36",
"vendor": "Google Inc."
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "",
"os.name": "Linux",
"os.version": "5.10.0-14-amd64",
"user.language": "en",
"user.timezone": "GMT"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
"run-mode": "prod",
"version": {
"date": "2022-10-17",
"tag": "v0.44.5",
"branch": "release-x.44.x",
"hash": "29fab4d"
"settings": {
"report-timezone": null

log wrong

Hi @arielesp
I'm not sure I understand what "big data" means.
Try looking in your browser developer Network-tab to see the response data for the question request.

big database .. more than 100M lines some tables

@arielesp You are showing a Number visualization, which means it's only getting a single row.
Your queries are being stopped by timeout on the database.

the query in metabase timeout in some seconds ...

The mysql database has timeout in 7200s
the nginx proxy 7200s
when running sql in mysql prompt, works fine .. takes a long time to run, but return ok

where I could increase metabase timeouts ?

@arielesp The timeout is in your database connection session (not Metabase):
java.sql.SQLTimeoutException error state 70100
You can try to force-set a different timeout via Metabase: Killing too-long queries - #7 by flamber

really .. this log was from a timed out query ...
I am not able to locate the error log from specific query error in dashboard .. because its very fast..
can I record screen and send to you in PV ?


@arielesp Check your database query debug logs. The stacktrace that you have posted twice is a timeout being done by the database, I cannot tell you more than that.