JOIN PostTags pt2 ON pt1.PostId = pt2.PostId We already have the cache enabled and that don’t helped a lot, and our Metabase version is the 0.33.6.Īlso, what does that Request lifecycle recycled means?Īlso, sometimes we get this error too: 11-25 20:35:43 e[1mWARN middleware.SELECT t1.TagName AS, t2.TagName AS, COUNT(pt1.PostId) AS What seems strange to me is if I try to run the aggregations direct on DB (using Robo 3T) the query run normally and sometimes even faster. After reading through the logs I’ve had found this: Exception in thread "async-dispatch-429" : AsyncContext completed and/or Request lifecycle recycledĪt .AsyncContextState.state(AsyncContextState.java:54)Īt .plete(AsyncContextState.java:74)Īt $make_output_stream$fn_46932.invoke(servlet.clj:89)Īt $java.io.FilterOutputStream$ff19274a.close(Unknown Source)Īt java.base/.StreamEncoder.implClose(Unknown Source)Īt java.base/.StreamEncoder.close(Unknown Source)Īt java.base/java.io.OutputStreamWriter.close(Unknown Source)Īt java.base/java.io.BufferedWriter.close(Unknown Source)Īt _response$write_chan_vals_to_writer_BANG_$fn_67375$state_machine_6775_auto_67380$fn_67382.invoke(api_response.clj:87)Īt _response$write_chan_vals_to_writer_BANG_$fn_67375$state_machine_6775_auto_67380.invoke(api_response.clj:79)Īt .ioc_macros$run_state_machine.invokeStatic(ioc_macros.clj:973)Īt .ioc_macros$run_state_machine.invoke(ioc_macros.clj:972)Īt .ioc_macros$run_state_machine_wrapped.invokeStatic(ioc_macros.clj:977)Īt .ioc_macros$run_state_machine_wrapped.invoke(ioc_macros.clj:975)Īt .ioc_macros$take_BANG_$fn_6793.invoke(ioc_macros.clj:986)Īt .channels.ManyToMan圜hannel$fn_1679$fn_1680.invoke(channels.clj:95)Īt java.base/.runWorker(Unknown Source)Īt java.base/$n(Unknown Source)Īt java.base/(Unknown Source)ġ1-25 20:14:27 e 10.0 mins (7 DB calls) Jetty threads: 2/50 (4 idle, 0 queued) (119 total active threads) Queries in flight: 10e[0mĪnd this happens to every question that take more than 10 min to load. We have long queries (MongoDB aggregation ones) that usually take 12/15 min to load, but recently we had some problems loading them, sometimes the question simply stops.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |