MySQL parameter max_execution_time

alexandrebarbieri · August 3, 2026, 4:29pm

I’m getting errors when trying to connect to mysql:

Error processing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'max_statement_time=1200 FOR -- Metabase

I was looking at mysql documentation and found out that there’s no max_statement_time. The parameter has changed to max_execution_time (at least in mysq 26.7.0-cloud).

So, unless the system sends the correct parameter name, I won’t be able to get anything from my database.

My Metabase version is the latest runing on docker: v0.63.2

dwhitemv · August 4, 2026, 4:18am

This problem is being tracked under this GitHub issue:

github.com/metabase/metabase

Metabase 0.63.2.7 uses SET STATEMENT max_statement_time against MySQL Community Server 26.x

opened 06:00PM - 03 Aug 26 UTC

sistemmsn

Type:Bug Priority:P2 .Needs Triage .Team/QueryingPlatform

### Describe the bug SELECT VERSION(); 26.7.0 SHOW VARIABLES LIKE 'max_statem…ent_time'; Empty set SHOW VARIABLES LIKE 'max_execution_time'; exists SET STATEMENT max_statement_time= 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context ### To Reproduce 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context 2026-08-03T11:45:56-06:00 WARN metabase.driver.sql-jdbc.execute Requesting a resilient connection, but we're not in a resilient context ### Expected behavior _No response_ ### Logs _No response_ ### Information about your Metabase installation ```JSON { "browser-info": { "language": "es-MX", "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36 Edg/150.0.0.0", "vendor": "Google Inc." }, "metabase-info": { "databases": [ "mysql" ], "run-mode": "prod", "plan-alias": "", "version": { "date": "2026-07-31", "tag": "v0.63.2.7", "hash": "30c5762" }, "settings": { "report-timezone": null }, "hosting-env": "unknown", "application-database": "postgres", "application-database-details": { "database": { "name": "PostgreSQL", "version": "16.14 (Debian 16.14-1.pgdg13+1)" }, "jdbc-driver": { "name": "PostgreSQL JDBC Driver", "version": "42.7.12" } } }, "system-info": { "file.encoding": "UTF-8", "java.runtime.name": "OpenJDK Runtime Environment", "java.runtime.version": "25.0.3+9-LTS", "java.vendor": "Eclipse Adoptium", "java.vendor.url": "https://adoptium.net/", "java.version": "25.0.3", "java.vm.name": "OpenJDK 64-Bit Server VM", "java.vm.version": "25.0.3+9-LTS", "jvm.available-processors": 32, "jvm.max-memory": "15.7 GB", "os.name": "Linux", "os.version": "6.1.0-43-amd64", "system.total-memory": "62.7 GB", "user.language": "en", "user.timezone": "America/Mexico_City" } } ``` ### Severity It's not working on recent versions of MySQL; what I need to do is downgrade. ### Additional context _No response_