Download error

When I download data in CSV or xlsx format, the following error occurs.

There are only 10000 rows of data

erro log:
{:status :failed,
:class java.sql.SQLDataException,
:error "(conn=225894769) ",
:stacktrace
("org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:232)"
"org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)"
"org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)"
"org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:225)"
"org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)"
"org.mariadb.jdbc.ClientSidePreparedStatement.executeUpdate(ClientSidePreparedStatement.java:176)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)"
"clojure.java.jdbc$db_do_execute_prepared_return_keys$exec_and_return_keys__13986.invoke(jdbc.clj:961)"
"clojure.java.jdbc$db_do_execute_prepared_return_keys.invokeStatic(jdbc.clj:989)"
"clojure.java.jdbc$db_do_execute_prepared_return_keys.invoke(jdbc.clj:945)"
"clojure.java.jdbc$db_do_prepared_return_keys.invokeStatic(jdbc.clj:1020)"
"clojure.java.jdbc$db_do_prepared_return_keys.invoke(jdbc.clj:997)"
"clojure.java.jdbc$db_do_prepared_return_keys.invokeStatic(jdbc.clj:1022)"
"clojure.java.jdbc$db_do_prepared_return_keys.invoke(jdbc.clj:997)"
"toucan.db$simple_insert_many_BANG_$iter__17048__17052$fn__17053$fn__17054.invoke(db.clj:560)"
"toucan.db$simple_insert_many_BANG_$iter__17048__17052$fn__17053.invoke(db.clj:558)"
"clojure.lang.LazySeq.sval(LazySeq.java:42)"
"clojure.lang.LazySeq.seq(LazySeq.java:51)"
"clojure.lang.RT.seq(RT.java:535)"
"clojure.core$seq__5402.invokeStatic(core.clj:137)"
"clojure.core$dorun.invokeStatic(core.clj:3133)"
"clojure.core$doall.invokeStatic(core.clj:3148)"
"clojure.core$doall.invoke(core.clj:3148)"
"toucan.db$simple_insert_many_BANG_.invokeStatic(db.clj:557)"
"toucan.db$simple_insert_many_BANG_.invoke(db.clj:543)"
"toucan.db$simple_insert_BANG_.invokeStatic(db.clj:590)"
"toucan.db$simple_insert_BANG_.invoke(db.clj:579)"
"toucan.db$insert_BANG_.invokeStatic(db.clj:607)"
"toucan.db$insert_BANG_.invoke(db.clj:594)"
"toucan.db$insert_BANG_.invokeStatic(db.clj:610)"
"toucan.db$insert_BANG_.doInvoke(db.clj:594)"
"clojure.lang.RestFn.invoke(RestFn.java:494)"
"--> query_processor.middleware.cache_backend.db$save_results_BANG_.invokeStatic(db.clj:91)"
"query_processor.middleware.cache_backend.db$save_results_BANG_.invoke(db.clj:77)"
"query_processor.middleware.cache_backend.db$reify__68624.save_results_BANG_(db.clj:101)"
"query_processor.middleware.cache$save_results_BANG_.invokeStatic(cache.clj:88)"
"query_processor.middleware.cache$save_results_BANG_.invoke(cache.clj:86)"
"query_processor.middleware.cache$save_results_if_successful_BANG_.invokeStatic(cache.clj:103)"
"query_processor.middleware.cache$save_results_if_successful_BANG_.invoke(cache.clj:97)"
"query_processor.middleware.cache$run_query_with_cache$respond__36561.invoke(cache.clj:114)"
"query_processor.middleware.async$async__GT_sync$fn__20163.invoke(async.clj:23)"
"query_processor.middleware.async_wait$runnable$fn__35853.invoke(async_wait.clj:89)"),
:query
{:constraints nil,
:type :native,
:middleware {:skip-results-metadata? true, :userland-query? true},
:native
{:query
"select\ndate_flag 日期标识,\ndatdt 日期,\nsaleid 销售id,\ndeparttype 销售归属,\nsale_center 中心,\nsale_area 区,\nsale_group 组,\nsaletype 销售类型,\nlevel leads级别,\nfinish_rate 签单率,\norder_rate 总转,\nleads_num leads数,\nfinish_num 完课数,\norder_num 成单数,\n-- bef_class_conn_tm 课前拨打总时长(分钟),\n-- sub_apply_conn_tm 申请试听拨打时延(小时),\n-- aft_class_call_num 课后拨打数 ,\n-- aft_class_conn_num 课后拨通数,\n-- aft_class_conn_tm 课后总通时(分钟),\n-- sub_aft_conn_tm 课后首拨打时延(小时), \n\n-- 课前电话拨打数目\n(invite_num - bef_class_1_89_num -bef_class_90_400_num -bef_class_401_600_num -bef_class_601_1200_num -bef_class_1200_num )/ invite_num '课前拨打时长_0_用户占比',\nbef_class_1_89_num / invite_num '课前拨打时长_[1, 89]用户占比',\nbef_class_90_400_num / invite_num '课前拨打时长[90, 400]用户占比',\nbef_class_401_600_num / invite_num '课前拨打时长[401, 600]用户占比',\nbef_class_601_1200_num / invite_num '课前拨打时长[601, 1200]_用户占比',\nbef_class_1200_num / invite_num '课前拨打时长_1200+用户占比',\n\n-- 申请时延 \n(leads_num- sub_apply_conn_tm_1_1799_num -sub_apply_conn_tm_1800_3599_num -sub_apply_conn_tm_3600_7199_num -sub_apply_conn_tm_7200_86399_num -sub_apply_conn_tm_86400_num) / leads_num '绑定无拨打用户占比',\nsub_apply_conn_tm_1_1799_num / leads_num '申请至首次拨打时延[1, 1799]用户占比',\nsub_apply_conn_tm_1800_3599_num / leads_num '申请至首次拨打时延[1800, 3599]用户占比' ,\nsub_apply_conn_tm_3600_7199_num / leads_num '申请至首次拨打时延[3600, 7199]用户占比',\nsub_apply_conn_tm_7200_86399_num / leads_num '申请至首次拨打时延[7200, 86399]_用户占比',\nsub_apply_conn_tm_86400_num / leads_num '申请至首次拨打时延_86400+用户占比',\n\n\n-- 课后拨打数 \n(finish_num - aft_class_call_num_1_3_num - aft_class_call_num_4_5_num - aft_class_call_num_6_num) / finish_num '课后拨打数_0_用户占比',\naft_class_call_num_1_3_num / finish_num '课后拨打数[1, 3]用户占比',\naft_class_call_num_4_5_num / finish_num '课后拨打数[4, 5]_用户占比',\naft_class_call_num_6_num / finish_num '课后拨打数_6+用户占比',\n \n-- 课后拨通数 \n(finish_num - aft_class_conn_num_1_2_num -aft_class_conn_num_3_4_num -aft_class_conn_num_5_num)/ finish_num '课后拨通数_0_用户占比',\naft_class_conn_num_1_2_num / finish_num '课后拨通数[1, 2]用户占比',\naft_class_conn_num_3_4_num / finish_num '课后拨通数[3, 4]_用户占比',\naft_class_conn_num_5_num / finish_num '课后拨通数_5+用户占比',\n\n-- 课后首通时延\nsub_aft_conn_tm_1_599_num / sub_aft_conn_tm_num '课后首通时延[1, 599]用户占比',\nsub_aft_conn_tm_600_1799_num / sub_aft_conn_tm_num '课后首通时延[600, 1799]用户占比',\nsub_aft_conn_tm_1800_3599_num / sub_aft_conn_tm_num '课后首通时延[1800, 3599]用户占比',\nsub_aft_conn_tm_3600_86399_num / sub_aft_conn_tm_num '课后首通时延[3600, 86399]_用户占比',\nsub_aft_conn_tm_86400_num / sub_aft_conn_tm_num '课后首通时延_86400+用户占比',\n\n-- 课后通话总时长\naft_class_conn_tm_1_599_num / aft_class_conn_tm_num '课后通话总时长[1, 599]用户占比', \naft_class_conn_tm_600_1499_num / aft_class_conn_tm_num '课后通话总时长[600, 1499]用户占比', \naft_class_conn_tm_1500_2399_num / aft_class_conn_tm_num '课后通话总时长[1500, 2399]_用户占比', \naft_class_conn_tm_2400_num / aft_class_conn_tm_num '课后通话总时长_2400+_用户占比'\n\n\n\n\nfrom\nstat_sale_link_moniter\nwhere 1=1\n and {{date_flag}}\n and {{level}}\n and {{departtype}}\n and {{saletype}}\norder by datdt desc ,finish_rate desc ,order_rate desc",
:template-tags
{"date_flag" {:id "fe3783d6-45d3-fd4d-2cf9-e730cd0e0176", :name "date_flag", :display-name "日期标识", :type :dimension, :dimension [:field-id 51711], :widget-type :category, :default "天"},
"level" {:id "89768bc8-43ef-9e51-fafe-09d0bf17c397", :name "level", :display-name "用户级别", :type :dimension, :dimension [:field-id 51752], :widget-type :category},
"departtype" {:id "99d2d56b-937a-f154-62cc-1433354fd69b", :name "departtype", :display-name "部门标识", :type :dimension, :dimension [:field-id 51702], :widget-type :category, :default "区"},
"saletype" {:id "9a660adf-67e5-6867-a100-489854109848", :name "saletype", :display-name "销售标识", :type :dimension, :dimension [:field-id 51715], :widget-type :category}}},
:info
{:executed-by 1,
:context :csv-download,
:card-id 1489,
:dashboard-id nil,
:query-hash [88, -36, -97, 16, 14, 39, 79, 68, 127, 98, 105, 28, 80, -127, 6, -68, 77, 11, 123, 102, -96, -2, 94, 24, 85, 105, -4, 41, 1, 120, -128, -5]},
:parameters
({:type "category", :target ["dimension" ["template-tag" "date_flag"]], :value ["天" "周"]}
{:type "category", :target ["dimension" ["template-tag" "departtype"]], :value ["区" "组"]}
{:type "category", :target ["dimension" ["template-tag" "saletype"]], :value ["全体top50" "区top20" "全部" "主管" "新销售" "老销售"]}),
:async? true,
:cache-ttl 418},
:cause {:class java.sql.SQLException, :error ""}}

{
“browser-info”: {
“language”: “zh-CN”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_45-b14”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_45”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.45-b02”,
“os.name”: “Linux”,
“os.version”: “3.10.0-957.el7.x86_64”,
“user.language”: “en”,
“user.timezone”: “Asia/Shanghai”
},
“metabase-info”: {
“databases”: [
“h2”,
“mysql”,
“sparksql”,
“presto”
],
“hosting-env”: “unknown”,
“application-database”: “mysql”,
“run-mode”: “prod”,
“version”: {
“tag”: “v0.33.7.3”,
“date”: “2019-12-16”,
“branch”: “release-0.33.x”,
“hash”: “7ee7193”
},
“settings”: {
“report-timezone”: “Asia/Hong_Kong”
}
}
}

Hi @rayn
Latest release is 0.36.4 - try with that version - make sure to backup before upgrading.