Data empty

When I'm trying to download data in the form of csv or excel format. It is not happening for .xlsx and when it happens after a long time for csv, the file is empty, any idea why???
@flamber

Hi @ishkabirk
Do not tag me when you create an issue. This forum is for everyone to help everyone.
Post "Diagnostic Info" from Admin > Troubleshooting.
And check the logs, when you are having problems - Admin > Troubleshooting > Logs.

dignostic info

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.54 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "5.4.156-83.273.amzn2.x86_64",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"postgres",
"h2",
"mysql",
"mongo",
"redshift",
"presto"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.23"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-12-16",
"tag": "v0.41.5",
"branch": "release-x.41.x",
"hash": "fbfffc6"
},
"settings": {
"report-timezone": "UTC"
}
}
}

[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:50:55+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:00+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:15+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:25+05:30 INFO metabase.query-processor.middleware.cache Query took 46.7 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:25+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "9e456274". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:25+05:30 DEBUG metabase.server.middleware.log POST /api/card/523/query 202 [ASYNC: completed] 47.0 s (22 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 10 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:27+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "3132b096". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:27+05:30 INFO metabase.query-processor.middleware.cache Query took 48.7 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:27+05:30 DEBUG metabase.server.middleware.log POST /api/card/520/query 202 [ASYNC: completed] 48.9 s (22 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 9 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:28+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "a3f32953". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:28+05:30 INFO metabase.query-processor.middleware.cache Query took 50.2 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:28+05:30 DEBUG metabase.server.middleware.log POST /api/card/686/query 202 [ASYNC: completed] 50.5 s (22 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 9 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:29+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "67111675". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:29+05:30 INFO metabase.query-processor.middleware.cache Query took 50.5 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:29+05:30 DEBUG metabase.server.middleware.log POST /api/card/524/query 202 [ASYNC: completed] 51.0 s (22 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 7 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Query took 51.2 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "8b96ab2f". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 DEBUG metabase.server.middleware.log POST /api/card/676/query 202 [ASYNC: completed] 51.7 s (21 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 6 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "caa30fd3". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Query took 52.0 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 DEBUG metabase.server.middleware.log POST /api/card/565/query 202 [ASYNC: completed] 52.4 s (22 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 5 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "d1d911a7". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 INFO metabase.query-processor.middleware.cache Query took 52.2 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:30+05:30 DEBUG metabase.server.middleware.log POST /api/card/525/query 202 [ASYNC: completed] 52.6 s (22 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 5 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:31+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "12f3cb99". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:31+05:30 INFO metabase.query-processor.middleware.cache Query took 52.2 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:31+05:30 DEBUG metabase.server.middleware.log POST /api/card/723/query 202 [ASYNC: completed] 52.6 s (22 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (9 idle, 0 queued) (170 total active threads) Queries in flight: 4 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:35+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:39+05:30 DEBUG metabase.server.middleware.log POST /api/card/pivot/527/query 202 [ASYNC: completed] 1.0 mins (42 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (9 idle, 0 queued) (168 total active threads) Queries in flight: 2 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:40+05:30 DEBUG metabase.server.middleware.log POST /api/card/pivot/526/query 202 [ASYNC: completed] 1.0 mins (41 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (9 idle, 0 queued) (168 total active threads) Queries in flight: 1 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:40+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:40+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:45+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:50+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:51:55+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 22.6 s; using 'magic' TTL of 3.1 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 22.8 s; using 'magic' TTL of 3.2 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 23.1 s; using 'magic' TTL of 3.2 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 23.4 s; using 'magic' TTL of 3.2 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 23.4 s; using 'magic' TTL of 3.3 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 22.5 s; using 'magic' TTL of 3.1 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 21.5 s; using 'magic' TTL of 3.0 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:10+05:30 INFO metabase.api.card Question's average execution duration is 23.1 s; using 'magic' TTL of 3.2 hours :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:15+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:20+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:25+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:25+05:30 DEBUG metabase.server.middleware.log GET /api/automagic-dashboards/database/2/candidates 200 4.5 ms (4 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (10 idle, 0 queued) (161 total active threads) Queries in flight: 11 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:26+05:30 WARN metabase.integrations.slack {:error-code "method_deprecated",
:message "Slack API error: method_deprecated",
:response {:ok false, :error "method_deprecated"}}

[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:26+05:30 ERROR metabase.metabot.websocket Error connecting websocket:
clojure.lang.ExceptionInfo: Slack API error: method_deprecated {:error-code "method_deprecated", :message "Slack API error: method_deprecated", :response {:ok false, :error "method_deprecated"}, :url "https://slack.com/api/rtm.start", :request {:query-params {:token "xoxb-201856940006-3039119250624-a9x89sX7Fqba2me7nVStk4kA"}, :as :stream, :conn-timeout 10000, :socket-timeout 10000}}
at metabase.integrations.slack$do_slack_request.invokeStatic(slack.clj:64)
at metabase.integrations.slack$do_slack_request.invoke(slack.clj:46)
at metabase.integrations.slack$GET.invokeStatic(slack.clj:69)
at metabase.integrations.slack$GET.doInvoke(slack.clj:66)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at clojure.core$partial$fn__5857.invoke(core.clj:2627)
at clojure.core$comp$fn__5825.invoke(core.clj:2572)
at metabase.metabot.websocket$connect_websocket_BANG_.invokeStatic(websocket.clj:28)
at metabase.metabot.websocket$connect_websocket_BANG_.invoke(websocket.clj:27)
at metabase.metabot.websocket$reopen_websocket_connection_if_needed_BANG_.invokeStatic(websocket.clj:99)
at metabase.metabot.websocket$reopen_websocket_connection_if_needed_BANG_.invoke(websocket.clj:89)
at metabase.metabot.websocket$start_websocket_monitor_BANG_$fn__64813.invoke(websocket.clj:114)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: clojure.lang.ExceptionInfo: Slack API error: method_deprecated {:error-code "method_deprecated", :message "Slack API error: method_deprecated", :response {:ok false, :error "method_deprecated"}}
at metabase.integrations.slack$handle_error.invokeStatic(slack.clj:37)
at metabase.integrations.slack$handle_error.invoke(slack.clj:25)
at metabase.integrations.slack$handle_response.invokeStatic(slack.clj:44)
at metabase.integrations.slack$handle_response.invoke(slack.clj:39)
at metabase.integrations.slack$do_slack_request.invokeStatic(slack.clj:62)
... 17 more
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:30+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:35+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:45+05:30 INFO metabase.query-processor.middleware.cache Query took 34.1 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:45+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "dec8d6f6". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:45+05:30 DEBUG metabase.server.middleware.log POST /api/card/686/query 202 [ASYNC: completed] 34.3 s (19 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 10 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:45+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:50+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:53+05:30 INFO metabase.query-processor.middleware.cache Query took 42.8 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:53+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "c2a3b40f". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:53+05:30 DEBUG metabase.server.middleware.log POST /api/card/723/query 202 [ASYNC: completed] 43.1 s (20 DB calls) App DB connections: 3/15 Jetty threads: 3/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 9 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:56+05:30 INFO metabase.query-processor.middleware.cache Query took 45.9 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:56+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "c0cc4bc9". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:56+05:30 DEBUG metabase.server.middleware.log POST /api/card/520/query 202 [ASYNC: completed] 46.1 s (20 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 8 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:59+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "17285e1e". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:59+05:30 INFO metabase.query-processor.middleware.cache Query took 48.2 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:52:59+05:30 DEBUG metabase.server.middleware.log POST /api/card/525/query 202 [ASYNC: completed] 48.5 s (20 DB calls) App DB connections: 3/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 7 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:00+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:00+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "ae7c7804". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:00+05:30 INFO metabase.query-processor.middleware.cache Query took 49.5 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:00+05:30 DEBUG metabase.server.middleware.log POST /api/card/524/query 202 [ASYNC: completed] 49.8 s (19 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 6 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "cf034ac7". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Query took 50.9 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 DEBUG metabase.server.middleware.log POST /api/card/565/query 202 [ASYNC: completed] 51.1 s (20 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 5 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "e684f943". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Query took 50.8 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 DEBUG metabase.server.middleware.log POST /api/card/676/query 202 [ASYNC: completed] 51.1 s (20 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 4 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Caching results for next time for query with hash "4c02c8ed". :floppy_disk:
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 INFO metabase.query-processor.middleware.cache Query took 50.9 s to run; minimum for cache eligibility is 5.0 s
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:01+05:30 DEBUG metabase.server.middleware.log POST /api/card/523/query 202 [ASYNC: completed] 51.2 s (20 DB calls) App DB connections: 2/15 Jetty threads: 2/50 (10 idle, 0 queued) (164 total active threads) Queries in flight: 3 (0 queued)
[170064df-864a-4f9f-b2fb-e68da8192ab8] 2022-05-03T10:53:02+05:30 ERROR metabase.models.field-values Error fetching field values
java.net.ConnectException: Connection timed out (Connection timed out)

@ishkabirk Try a newer release. I'm not seeing any downloads in the logs you have provided, so try to only include the relevant parts of the log. But there's a connection timeout at the end, so try to figure out where the timeout is coming from and fix that problem.

i was going through other problems as well, does the empty excel issue is being reported in v41??

@ishkabirk There are 11,000 issues (opened and closed). Go ahead and look through them:
https://github.com/metabase/metabase/issues?q=is%3Aissue

Or easier, just upgrade to a newer release.

the csv and excel i download is empty , runnning on v41.5 and the datasource which i'm trying to download is in mongodb

Hi @ishkabirk
Upgrade to a newer release: https://github.com/metabase/metabase/releases/latest

can't this be solved without the upgrade??, there are many databases connected to it and with the upgrade, what is the possibility that there might be issues with other kinds of db such as postgres, mysql etc etc

@ishkabirk We've been over this multiple times. You have not provided enough logging details to understand the problem, so upgrade to a later release first. And make sure that you don't have a reverse-proxy causing problems.

I've provided the logging details as per my understanding

What exactly you need please tell

@ishkabirk Like I wrote here:

I'm on v41.5, the table which i have created is too big to download , even the upper limit of metabase does not suffice it which is 204800 kB and the download is empty which log message as too big of data at row 1. Will this problem be solved if i upgrade to higher versions or i need to reduce the number of columns in it?

In few of my previous questions , mentioned that I'm not able to download the data and therefore i was discussing with @flamber for the solution, I would like to point out that my data was downloading normally if the question was not saved and throwing errors when saved , so just to keep him of one of the possible solutions :grin::grin:

1 Like

@flamber I'm also facing the same issue. Could you please help?
Diagnostic info
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16.1+1",
"os.name": "Linux",
"os.version": "5.4.204-113.362.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"mysql",
"athena",
"sparksql",
"mongo",
"snowflake"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.37"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2022-11-01",
"tag": "v0.44.6",
"branch": "release-x.44.x",
"hash": "5c6ae21"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

Download log
[3b70e5aa-7212-4ebd-8607-2caa91d0b14f] 2023-03-08T17:23:30+05:30 DEBUG metabase.server.middleware.log POST /api/card/3387/query/xlsx 202 [ASYNC: completed] 21.2 s (12 DB calls) App DB connections: 6/15 Jetty threads: 6/200 (1 idle, 0 queued) (577 total active threads) Queries in flight: 0 (0 queued); athena DB 35 connections: 0/1 (0 threads blocked)

upgrade to the latest version of the product and also let us know the question you're facing this issue with (specifically the type of question and the DW connected to it with the structure of the table)

Type of Question: Native Query written and saved as a Question with the date and text/number filters(No Field filters)
Database : Amazon Athena

FYI: The data includes a lot of JSON content which is parsed and flattened into columns

upgrade to 45 with the latest version of Athena and let us know if the issue keeps happening

But another native query saved as a question from the same database but a different table is working fine and the downloaded excel has the data.
Not sure why this particular question is giving an empty excel, even though the data loads properly. Only the downloaded files are blank(all Excel/CSV/JSON files are blank)