Hello,
I would like some guidance\help in troubleshooting an issue I'm having with Metabase. I am running v0.52.8.4 but have seen this on several of the last versions.
I am running a report every day at 6am, and I see several of the following errors followed by the Java Stack Trace.
2025-01-29T11:09:30.977317212Z 2025-01-29 06:09:30,976 ERROR pulse.render :: Pulse card render error
2025-01-29T11:09:30.977919615Z TypeError: Cannot read property 'binning_info' of undefined
2025-01-29T11:09:30.978017734Z at <js> getDefaultIsHistogram(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:137541:6998022-6998049)
2025-01-29T11:09:30.978106613Z at <js> computeStaticComboChartSettings(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:144455:8526066-8526109)
2025-01-29T11:09:30.978185052Z at <js> ComboChart(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:144498:8527138-8527215)
2025-01-29T11:09:30.978259761Z at <js> d(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42114-42115:1307786-1307800)
2025-01-29T11:09:30.978333031Z at <js> ab(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42117:1308822-1308827)
2025-01-29T11:09:30.978508449Z at <js> b.render(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42123:1311444-1311464)
2025-01-29T11:09:30.978594188Z at <js> b.read(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42122:1310975-1311013)
2025-01-29T11:09:30.978668857Z at <js> exports.renderToStaticMarkup(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:42131:1315982-1315997)
2025-01-29T11:09:30.978748836Z at <js> RenderChart(file:/app/metabase.jar!/frontend_client/app/dist/lib-static-viz.bundle.js:156157-156159:8904976-8905086)
2025-01-29T11:09:30.978864015Z at <js> javascript_visualization(file:/app/metabase.jar!/frontend_shared/static_viz_interface.js:68-72:1524-1634)
2025-01-29T11:09:30.978936364Z at org.graalvm.polyglot.Value.execute(Value.java:880)
2025-01-29T11:09:30.979007003Z at metabase.pulse.render.js_engine$execute_fn_name.invokeStatic(js_engine.clj:67)
2025-01-29T11:09:30.979077072Z at metabase.pulse.render.js_engine$execute_fn_name.doInvoke(js_engine.clj:55)
2025-01-29T11:09:30.979144081Z at clojure.lang.RestFn.invoke(RestFn.java:490)
2025-01-29T11:09:30.979210981Z at metabase.pulse.render.js_svg$javascript_visualization.invokeStatic(js_svg.clj:151)
2025-01-29T11:09:30.979280580Z at metabase.pulse.render.js_svg$javascript_visualization.invoke(js_svg.clj:148)
2025-01-29T11:09:30.979348059Z at metabase.pulse.render.body$fn__74589$_AMPERSAND_f__74590.invoke(body.clj:557)
2025-01-29T11:09:30.979419698Z at metabase.pulse.render.body$fn__74589$fn__74597.invoke(body.clj:547)
2025-01-29T11:09:30.979499848Z at clojure.lang.MultiFn.invoke(MultiFn.java:261)
2025-01-29T11:09:30.979569077Z at metabase.pulse.render$render_pulse_card_body.invokeStatic(render.clj:144)
2025-01-29T11:09:30.979639766Z at metabase.pulse.render$render_pulse_card_body.invoke(render.clj:130)
2025-01-29T11:09:30.979708135Z at metabase.pulse.render$render_pulse_card.invokeStatic(render.clj:171)
2025-01-29T11:09:30.979776714Z at metabase.pulse.render$render_pulse_card.invoke(render.clj:154)
2025-01-29T11:09:30.979850084Z at metabase.pulse.render$render_pulse_section$fn__74985.invoke(render.clj:207)
2025-01-29T11:09:30.979921883Z at metabase.pulse.render$render_pulse_section.invokeStatic(render.clj:205)
2025-01-29T11:09:30.979991132Z at metabase.pulse.render$render_pulse_section.invoke(render.clj:201)
2025-01-29T11:09:30.980059701Z at metabase.email.messages$render_part.invokeStatic(messages.clj:439)
2025-01-29T11:09:30.980132140Z at metabase.email.messages$render_part.invoke(messages.clj:435)
2025-01-29T11:09:30.980199660Z at metabase.email.messages$render_message_body$fn__75953$fn__75954.invoke(messages.clj:492)
2025-01-29T11:09:30.980275709Z at clojure.core$mapv$fn__8535.invoke(core.clj:6980)
2025-01-29T11:09:30.980370358Z at clojure.core.protocols$fn__8249.invokeStatic(protocols.clj:168)
2025-01-29T11:09:30.980466787Z at clojure.core.protocols$fn__8249.invoke(protocols.clj:124)
2025-01-29T11:09:30.980537256Z at clojure.core.protocols$fn__8204$G__8199__8213.invoke(protocols.clj:19)
2025-01-29T11:09:30.980608705Z at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
2025-01-29T11:09:30.980678964Z at clojure.core.protocols$fn__8236.invokeStatic(protocols.clj:75)
2025-01-29T11:09:30.980748784Z at clojure.core.protocols$fn__8236.invoke(protocols.clj:75)
2025-01-29T11:09:30.980820313Z at clojure.core.protocols$fn__8178$G__8173__8191.invoke(protocols.clj:13)
2025-01-29T11:09:30.980893452Z at clojure.core$reduce.invokeStatic(core.clj:6887)
2025-01-29T11:09:30.980961291Z at clojure.core$mapv.invokeStatic(core.clj:6971)
2025-01-29T11:09:30.981029890Z at clojure.core$mapv.invoke(core.clj:6971)
2025-01-29T11:09:30.981107320Z at metabase.email.messages$render_message_body$fn__75953.invoke(messages.clj:492)
2025-01-29T11:09:30.981179219Z at metabase.email.messages$render_message_body.invokeStatic(messages.clj:491)
2025-01-29T11:09:30.981249258Z at metabase.email.messages$render_message_body.invoke(messages.clj:489)
2025-01-29T11:09:30.981321897Z at metabase.email.messages$render_pulse_email.invokeStatic(messages.clj:518)
2025-01-29T11:09:30.981398796Z at metabase.email.messages$render_pulse_email.invoke(messages.clj:515)
2025-01-29T11:09:30.981493655Z at metabase.pulse$fn__101793$iter__101803__101807$fn__101808$fn__101809.invoke(pulse.clj:414)
2025-01-29T11:09:30.981567164Z at metabase.pulse$fn__101793$iter__101803__101807$fn__101808.invoke(pulse.clj:413)
2025-01-29T11:09:30.981634954Z at clojure.lang.LazySeq.sval(LazySeq.java:42)
2025-01-29T11:09:30.981704823Z at clojure.lang.LazySeq.seq(LazySeq.java:51)
2025-01-29T11:09:30.981773542Z at clojure.lang.LazySeq.next(LazySeq.java:80)
2025-01-29T11:09:30.981844871Z at clojure.lang.RT.next(RT.java:713)
2025-01-29T11:09:30.981910670Z at clojure.core$next__5451.invokeStatic(core.clj:64)
2025-01-29T11:09:30.981980000Z at clojure.core$next__5451.invoke(core.clj:64)
2025-01-29T11:09:30.982046079Z at metabase.pulse$fn__101901$fn__101903.invoke(pulse.clj:508)
2025-01-29T11:09:30.982119118Z at clojure.lang.MultiFn.invoke(MultiFn.java:229)
2025-01-29T11:09:30.982185727Z at clojure.lang.AFn.applyToHelper(AFn.java:154)
2025-01-29T11:09:30.982252847Z at clojure.lang.AFn.applyTo(AFn.java:144)
2025-01-29T11:09:30.982317286Z at clojure.core$apply.invokeStatic(core.clj:667)
2025-01-29T11:09:30.982385505Z at clojure.core$apply.invoke(core.clj:662)
2025-01-29T11:09:30.982476334Z at metabase.util.retry$decorate$fn$reify__73299.call(retry.clj:77)
2025-01-29T11:09:30.982550983Z at io.github.resilience4j.retry.Retry.lambda$decorateCallable$5(Retry.java:306)
2025-01-29T11:09:30.982624102Z at metabase.util.retry$decorate$fn__73298.doInvoke(retry.clj:78)
2025-01-29T11:09:30.982697391Z at clojure.lang.RestFn.applyTo(RestFn.java:137)
2025-01-29T11:09:30.982764511Z at clojure.core$apply.invokeStatic(core.clj:667)
2025-01-29T11:09:30.982833870Z at clojure.core$apply.invoke(core.clj:662)
2025-01-29T11:09:30.982899439Z at metabase.pulse$send_notification_retrying_BANG_.invokeStatic(pulse.clj:533)
2025-01-29T11:09:30.982972448Z at metabase.pulse$send_notification_retrying_BANG_.doInvoke(pulse.clj:530)
2025-01-29T11:09:30.983047927Z at clojure.lang.RestFn.invoke(RestFn.java:408)
2025-01-29T11:09:30.983118107Z at metabase.pulse$send_notifications_BANG_$fn__101928.invoke(pulse.clj:540)
2025-01-29T11:09:30.983193596Z at metabase.pulse$send_notifications_BANG_.invokeStatic(pulse.clj:539)
2025-01-29T11:09:30.983262905Z at metabase.pulse$send_notifications_BANG_.invoke(pulse.clj:535)
2025-01-29T11:09:30.983329924Z at metabase.pulse$send_pulse_BANG_.invokeStatic(pulse.clj:564)
2025-01-29T11:09:30.983408373Z at metabase.pulse$send_pulse_BANG_.doInvoke(pulse.clj:544)
2025-01-29T11:09:30.983496582Z at clojure.lang.RestFn.invoke(RestFn.java:439)
2025-01-29T11:09:30.983560742Z at metabase.task.send_pulses$send_pulse_BANG_$fn__106916.invoke(send_pulses.clj:57)
2025-01-29T11:09:30.983629181Z at metabase.models.task_history$do_with_task_history.invokeStatic(task_history.clj:115)
2025-01-29T11:09:30.983697680Z at metabase.models.task_history$do_with_task_history.invoke(task_history.clj:104)
2025-01-29T11:09:30.983762999Z at metabase.task.send_pulses$send_pulse_BANG_.invokeStatic(send_pulses.clj:52)
2025-01-29T11:09:30.983828329Z at metabase.task.send_pulses$send_pulse_BANG_.invoke(send_pulses.clj:49)
2025-01-29T11:09:30.983893498Z at metabase.task.send_pulses$send_pulse_BANG__STAR_.invokeStatic(send_pulses.clj:125)
2025-01-29T11:09:30.983961587Z at metabase.task.send_pulses$send_pulse_BANG__STAR_.invoke(send_pulses.clj:116)
2025-01-29T11:09:30.984026146Z at metabase.task.send_pulses.SendPulse.execute(send_pulses.clj:147)
2025-01-29T11:09:30.984095986Z at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
2025-01-29T11:09:30.984165725Z at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
At the same time, we are seeing several Application Events on the MSSQL server
SQL Server has encountered 6 occurrences of I\O requests taking longer than 15 seconds to complete on file [...tempdb6.ndf] ... The duration of the long I\O is 19815 ms.
This is causing another web application to crash since the DB server is consumed with this long I\O.
What I would like help with is determining which query in my Metabase dashboard is causing the long I\O process on the MSSQL server and potential ways to fix it.
Kind regards,
Jim