Hi guys.
I get this error
This is the result of running: SHOW VARIABLES LIKE '%timeout%';
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 150
Hi @mkidk
Post "Diagnostic Info" from Admin > Troubleshooting.
Check the full stacktrace in Admin > Troubleshooting > Logs.
Most likely caused by a reverse-proxy closing the connection too early.
@flamber Thank you for your continuous support!
Diagnostic info:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36 Edg/101.0.1210.47",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_181-b13",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_181",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.181-b13",
"os.name": "Linux",
"os.version": "4.4.0-1128-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.33-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.41.1",
"date": "2021-10-21",
"branch": "release-x.41.x",
"hash": "76aa4a5"
},
"settings": {
"report-timezone": "Asia/Kuwait"
}
}
}
Logs:
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:54:30+02:00 DEBUG metabase.server.middleware.log POST /api/card/501/query 202 [ASYNC: completed] 58.5 s (11 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 1 (0 queued); mysql DB 4 connections: 2/2 (0 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:54:30+02:00 DEBUG metabase.server.middleware.log POST /api/card/502/query 202 [ASYNC: completed] 58.4 s (12 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (6 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued); mysql DB 4 connections: 2/2 (1 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:56:59+02:00 DEBUG metabase.server.middleware.log GET /api/setting 200 1.6 ms (0 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (109 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:56:59+02:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 102.6 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:56:59+02:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 245.4 ms (11 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:57:03+02:00 DEBUG metabase.server.middleware.log GET /api/permissions/group 200 5.7 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:57:03+02:00 DEBUG metabase.server.middleware.log GET /api/user 200 54.4 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:57:03+02:00 DEBUG metabase.server.middleware.log GET /api/permissions/membership 200 19.4 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:57:08+02:00 DEBUG metabase.server.middleware.log DELETE /api/permissions/membership/104 204 202.1 ms (7 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (113 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:00+02:00 INFO metabase.task.sync-databases Starting sync task for Database 3.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:00+02:00 INFO metabase.sync.util STARTING: Sync metadata for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:00+02:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:00+02:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for mysql Database 3 'WalaPlus-Meta' (291.6 ms)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:00+02:00 INFO metabase.sync.util STARTING: step 'sync-tables' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for mysql Database 3 'WalaPlus-Meta' (856.5 ms)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 INFO metabase.sync.util STARTING: step 'sync-fields' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:01+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:02+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:03+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:04+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:05+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:06+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 WARN metabase.driver.sql-jdbc.sync.describe-table Don't know how to map column type 'JSON' to a Field base_type, falling back to :type/*.
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for mysql Database 3 'WalaPlus-Meta' (6.6 s)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:07+02:00 INFO metabase.sync.util STARTING: step 'sync-fks' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for mysql Database 3 'WalaPlus-Meta' (1.3 s)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for mysql Database 3 'WalaPlus-Meta' (260.7 ms)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util FINISHED: Sync metadata for mysql Database 3 'WalaPlus-Meta' (9.5 s)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util STARTING: Analyze data for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:09+02:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:11+02:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [*****·············································] 10% Table 123 'issues'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:12+02:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [**********········································] 20% Table 174 'retailers_payment'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:14+02:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [***************···································] 31% Table 120 'views'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for mysql Database 3 'WalaPlus-Meta' (5.4 s)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util STARTING: step 'classify-fields' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-fields Analyzed [********************······························] 41% Table 128 'favorites'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-fields Analyzed [*************************·························] 51% Table 158 'posts_users_tags'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-fields Analyzed [******************************····················] 61% Table 118 'users_offers'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for mysql Database 3 'WalaPlus-Meta' (181.5 ms)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util STARTING: step 'classify-tables' for mysql Database 3 'WalaPlus-Meta'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-tables Analyzed [***********************************···············] 71% Table 203 'clients_products'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-tables Analyzed [****************************************··········] 81% Table 181 'places'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.analyze classify-tables Analyzed [*********************************************·····] 92% Table 179 'updates_requests'
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for mysql Database 3 'WalaPlus-Meta' (375.9 ms)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:58:15+02:00 INFO metabase.sync.util FINISHED: Analyze data for mysql Database 3 'WalaPlus-Meta' (6.0 s)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:13+02:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 36.9 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (4 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:13+02:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 50.8 ms (2 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (110 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:13+02:00 DEBUG metabase.server.middleware.log GET /api/database 200 74.5 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 DEBUG metabase.server.middleware.log GET /api/dashboard/67 200 272.3 ms (16 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 DEBUG metabase.server.middleware.log GET /api/field/3997 200 79.5 ms (6 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (2 idle, 0 queued) (111 total active threads) Queries in flight: 0 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 INFO metabase.api.card Question's average execution duration is 23.8 s; using 'magic' TTL of 4.0 mins
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 DEBUG metabase.server.middleware.log GET /api/field/4157 200 215.8 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 7/50 (0 idle, 0 queued) (111 total active threads) Queries in flight: 1 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 INFO metabase.api.card Question's average execution duration is 41.3 s; using 'magic' TTL of 6.9 mins
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 INFO metabase.api.card Question's average execution duration is 32.9 s; using 'magic' TTL of 5.5 mins
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 DEBUG metabase.server.middleware.log GET /api/field/4032 200 444.5 ms (6 DB calls) App DB connections: 2/15 Jetty threads: 7/50 (1 idle, 0 queued) (114 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:14+02:00 INFO metabase.api.card Question's average execution duration is 39.8 s; using 'magic' TTL of 6.6 mins
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:15+02:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 21.8 ms (2 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (3 idle, 0 queued) (115 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:29+02:00 DEBUG metabase.server.middleware.log GET /api/field/4032/values 200 57.6 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (117 total active threads) Queries in flight: 4 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:34+02:00 DEBUG metabase.server.middleware.log GET /api/field/3997/values 200 57.0 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (117 total active threads) Queries in flight: 4 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:36+02:00 INFO metabase.query-processor.middleware.cache Query took 21.7 s to run; minimum for cache eligibility is 60.0 s
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:36+02:00 DEBUG metabase.server.middleware.log POST /api/card/510/query 202 [ASYNC: completed] 21.9 s (9 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 3 (0 queued); mysql DB 4 connections: 0/4 (0 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:36+02:00 DEBUG metabase.server.middleware.log GET /api/field/4157/values 200 38.6 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:44+02:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/67/cards 200 280.2 ms (26 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:45+02:00 DEBUG metabase.server.middleware.log PUT /api/dashboard/67 200 63.8 ms (8 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:45+02:00 DEBUG metabase.server.middleware.log GET /api/dashboard/67 200 220.1 ms (16 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 3 (0 queued)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:52+02:00 DEBUG metabase.server.middleware.log POST /api/card/501/query 202 [ASYNC: canceled] 38.3 s (10 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 2 (0 queued); mysql DB 4 connections: 2/4 (0 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:53+02:00 DEBUG metabase.server.middleware.log POST /api/card/502/query 202 [ASYNC: canceled] 38.4 s (10 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 1 (0 queued); mysql DB 4 connections: 3/4 (0 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:53+02:00 DEBUG metabase.server.middleware.log POST /api/card/509/query 202 [ASYNC: canceled] 39.4 s (8 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (5 idle, 0 queued) (119 total active threads) Queries in flight: 0 (0 queued); mysql DB 4 connections: 1/4 (0 threads blocked)
[d572adac-8930-4a0a-97c2-d59274380fe6] 2022-05-18T14:59:59+02:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 4,
:started_at #t "2022-05-18T12:59:14.756Z[Etc/UTC]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query",
:stacktrace
["--> driver.sql_jdbc.execute$execute_reducible_query$fn__52415.invoke(execute.clj:504)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__85057.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__85057.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__49067.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__49554.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__47440.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__49928.invoke(cache.clj:203)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__50921.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50965.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49124.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39226.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__43657.invoke(annotate.clj:615)"
"query_processor.middleware.permissions$check_query_permissions$fn__45595.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__50105.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45993.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__45931.invoke(visualization_settings.clj:63)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47038.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50691.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__50227.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47057.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__50279.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46429.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__45904.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39126.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45238.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__49479.invoke(add_dimension_projections.clj:312)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__49777.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47425.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__46806.invoke(add_source_metadata.clj:123)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50027.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48376.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45219.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48030.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45292.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__51349.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__47809.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50294.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49788$fn__49792.invoke(resolve_database_and_driver.clj:31)"
"driver$do_with_driver.invokeStatic(driver.clj:60)"
"driver$do_with_driver.invoke(driver.clj:56)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49788.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45842.invoke(fetch_source_query.clj:274)"
"query_processor.middleware.store$initialize_store$fn__46030$fn__46031.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__46030.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50077.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50084.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__47755.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49053.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47773.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50063.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__50374.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___42477$thunk__42478.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___42477$fn__42480.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:sql
"-- Metabase:: userID: 26 queryType: native queryHash: 06924ada1b1e7680a65b0216860fa2cc8f8b0fda75ef3973784476ef8ac129e6\nselect\n(\n SELECT count(*)\n FROM \n (\n \tSELECT\n user_id,\n \tCOUNT(*)\n \tFROM users_transactions \n \tWHERE 1 = 1\n \tGROUP BY user_id \n HAVING count(*) > 1 \n ) dups\n)/\n(\n select count(*)\n from users\n join clients\n on clients.id = users.client_id\n where 1 = 1\n and users.status = 1\n and users.deleted_at is null\n and clients.status = 1\n and clients.deleted_at is null\n)*100 retention_rate",
:params [],
:type :invalid-query}}],
:state "70100",
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? false, :process-viz-settings? false},
:native
{:template-tags
{"start"
{:id "af861bfd-767a-e297-5442-5b5891162129",
:name "start",
:display-name "Start",
:type :dimension,
:required false,
:dimension [:field 4032 nil],
:widget-type :date/all-options},
"period"
{:id "40a711de-b3d4-666a-db28-82e2aca63bbb",
:name "period",
:display-name "Period",
:type :dimension,
:dimension [:field 4157 nil],
:widget-type :date/range}},
:query
"select\n(\n SELECT count(*)\n FROM \n (\n \tSELECT\n user_id,\n \tCOUNT(*)\n \tFROM users_transactions \n \tWHERE {{period}}\n \tGROUP BY user_id \n HAVING count(*) > 1 \n ) dups\n)/\n(\n select count(*)\n from users\n join clients\n on clients.id = users.client_id\n where {{start}}\n and users.status = 1\n and users.deleted_at is null\n and clients.status = 1\n and clients.deleted_at is null\n)*100 retention_rate"},
:database 4,
:parameters [],
:async? true,
:cache-ttl 413},
:status :failed,
:class java.sql.SQLTimeoutException,
:stacktrace
["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:47)"
"org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)"
"org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)"
"org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:363)"
"org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:501)"
"com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)"
"--> driver.sql_jdbc.execute$fn__52335.invokeStatic(execute.clj:368)"
"driver.sql_jdbc.execute$fn__52335.invoke(execute.clj:366)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:376)"
"driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:373)"
"driver.sql_jdbc.execute$execute_reducible_query$fn__52415.invoke(execute.clj:502)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:501)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:496)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:487)"
"driver.sql_jdbc$fn__85057.invokeStatic(sql_jdbc.clj:54)"
"driver.sql_jdbc$fn__85057.invoke(sql_jdbc.clj:52)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"@mkidk You need to upgrade immediately to a newer release:
https://github.com/metabase/metabase/releases/latest
The timeout is coming from your database. You need to either change the timeout on the database, or see if you are allowed to adjust it in the session. See Killing too-long queries
