Hi all!
I upgraded from 0.53.7.5 to v0.54.12 and now email subscriptions for dashboards which take a while to generate (30+ seconds) will fail and no mail gets send (also verified this with the mail server logs).
Going to the subscription definition and pressing the "send email now" for these larger dashboards will simply result in the mail not being send. Smaller dashboards work fine. There is no exception in the logs. There is just a bunch of query logs and the "Sent successfully" message never appears. When looking at the mail server logs it's clear Metabase never contacted the mail server so I'm assuming this is some timeout kicking in during dashboard generation?
I understand that putting a time limit on this generation makes sense. However I can't seem to find any info on it. Is there someway to increase this timeout?
These are the logs:
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:42+02:00 INFO metabase.notification.send Sending
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:43+02:00 INFO metabase.query-processor.middleware.cache Query b053e853 took 606.9 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:43+02:00 INFO metabase.query-processor.middleware.cache Query 194d05c7 took 499.4 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:44+02:00 INFO metabase.query-processor.middleware.cache Query e9cfaad8 took 155.0 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:44+02:00 INFO metabase.query-processor.middleware.cache Query 932c08a1 took 261.5 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:46+02:00 INFO metabase.query-processor.middleware.cache Query 8f235ebe took 1.5 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:47+02:00 INFO metabase.query-processor.middleware.cache Query 1468249d took 1.0 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:48+02:00 INFO metabase.query-processor.middleware.cache Query e31fed8d took 1.1 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:51+02:00 INFO metabase.query-processor.middleware.cache Query ad1509b4 took 2.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:54+02:00 INFO metabase.query-processor.middleware.cache Query b7b27157 took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:57+02:00 INFO metabase.query-processor.middleware.cache Query 2385ac79 took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:21:59+02:00 INFO metabase.query-processor.middleware.cache Query 0b669a3b took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:00+02:00 INFO metabase.query-processor.middleware.cache Query 11fcb0b9 took 155.6 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:00+02:00 INFO metabase.query-processor.middleware.cache Query d18faa47 took 275.9 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:01+02:00 INFO metabase.query-processor.middleware.cache Query 8045c3e7 took 261.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:01+02:00 INFO metabase.query-processor.middleware.cache Query 6ee9f2bc took 137.3 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:01+02:00 INFO metabase.query-processor.middleware.cache Query 191bc8cd took 186.8 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:02+02:00 INFO metabase.query-processor.middleware.cache Query 29246163 took 241.6 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:02+02:00 INFO metabase.query-processor.middleware.cache Query 2248709f took 133.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:02+02:00 INFO metabase.query-processor.middleware.cache Query bef40c16 took 185.4 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:03+02:00 INFO metabase.query-processor.middleware.cache Query b09b2860 took 175.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:03+02:00 INFO metabase.query-processor.middleware.cache Query 6c7889d6 took 111.9 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:03+02:00 INFO metabase.query-processor.middleware.cache Query bd368c8e took 119.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:05+02:00 INFO metabase.query-processor.middleware.cache Query 3740eac0 took 1.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:06+02:00 INFO metabase.query-processor.middleware.cache Query 3beb007c took 993.4 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:07+02:00 INFO metabase.query-processor.middleware.cache Query 16e4e222 took 1.0 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:08+02:00 INFO metabase.query-processor.middleware.cache Query ed61e4f7 took 298.5 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:08+02:00 INFO metabase.query-processor.middleware.cache Query c49b5e9b took 450.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:09+02:00 INFO metabase.query-processor.middleware.cache Query bb9367bd took 397.4 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:09+02:00 INFO metabase.query-processor.middleware.cache Query 52280859 took 370.5 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:13+02:00 INFO metabase.query-processor.middleware.cache Query 553259e5 took 3.0 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:16+02:00 INFO metabase.query-processor.middleware.cache Query 22444809 took 2.7 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:19+02:00 INFO metabase.query-processor.middleware.cache Query a4a6827d took 2.9 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:21+02:00 INFO metabase.query-processor.middleware.cache Query 2385ac79 took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:24+02:00 INFO metabase.query-processor.middleware.cache Query 2c0e1969 took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:27+02:00 INFO metabase.query-processor.middleware.cache Query ade98f76 took 2.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:29+02:00 INFO metabase.query-processor.middleware.cache Query 0b669a3b took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:32+02:00 INFO metabase.query-processor.middleware.cache Query 4a74584c took 2.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:35+02:00 INFO metabase.query-processor.middleware.cache Query 76c5f0cd took 2.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:35+02:00 INFO metabase.query-processor.middleware.cache Query 9098de5a took 79.4 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:36+02:00 INFO metabase.query-processor.middleware.cache Query 3222e6cc took 70.3 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:36+02:00 INFO metabase.query-processor.middleware.cache Query 880cb4d8 took 72.1 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:36+02:00 INFO metabase.query-processor.middleware.cache Query f667ca46 took 69.9 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:37+02:00 INFO metabase.query-processor.middleware.cache Query e75d52d7 took 71.1 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:37+02:00 INFO metabase.query-processor.middleware.cache Query 8a40956f took 82.1 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:39+02:00 INFO metabase.query-processor.middleware.cache Query a556dc2e took 1.2 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:40+02:00 INFO metabase.query-processor.middleware.cache Query 04efb0b2 took 1.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:43+02:00 INFO metabase.query-processor.middleware.cache Query f6584e18 took 2.3 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:45+02:00 INFO metabase.query-processor.middleware.cache Query a5f9a0fb took 1.4 s to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:45+02:00 INFO metabase.query-processor.middleware.cache Query 8612a5e4 took 129.1 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:45+02:00 INFO metabase.query-processor.middleware.cache Query c324adc0 took 274.7 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:45+02:00 INFO metabase.query-processor.middleware.cache Query 4b9cd99c took 81.0 ms to run; minimum for cache eligibility is 5.0 s; not eligible
[7e489e96-eb37-458d-b8d6-4cc1d17863c4] 2025-06-16T21:22:47+02:00 INFO metabase.query-processor.middleware.cache Query df069841 took 1.4 s to run; minimum for cache eligibility is 5.0 s; not eligible