<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Thank you for your reply.</p>
<p>I'm glad that you will include it. Pitty that we didn't catch up
this relese.<br>
</p>
<p>In the meantime, I am just adding some evidence (and a
workaround) that I tried in our production write intensive mariadb
(10.3.27).</p>
<p>Indeed after changing<br>
</p>
<p># mysql<br>
</p>
<p><code>> set global innodb_stats_auto_recalc=0;</code></p>
<p><code><br>
</code></p>
<p><code>the server continues for the 6th day without crashes.
Before that we experienced daily crashes. </code></p>
<p><code></code></p>
<p><code>Also another clue that leads to this bug is that indeed I
have run ANALYZE on a big table and then aborted (and even
restarted mariadb) because it was affecting traffic. Possibly
this triggered the background statistics collection and hit the
bug the days to come.</code></p>
<p><code>Regards<br>
</code></p>
<div class="moz-cite-prefix">On 29/3/21 6:29 μ.μ., Faustin Lammler
wrote:<br>
</div>
<blockquote type="cite" cite="mid:YGHyT1i32KQU5xqM@falared">
<pre class="moz-quote-pre" wrap="">Control: -1 forwarded <a class="moz-txt-link-freetext" href="https://jira.mariadb.org/browse/MDEV-24275">https://jira.mariadb.org/browse/MDEV-24275</a>
Control: -1 tags + fixed-upstream
Hi Vasilis!
Thank you for your report.
I have asked Otto when 10.3.28 (or later) would make it into Debian 10,
see
<a class="moz-txt-link-freetext" href="https://salsa.debian.org/mariadb-team/mariadb-10.3/-/merge_requests/30#note_234016">https://salsa.debian.org/mariadb-team/mariadb-10.3/-/merge_requests/30#note_234016</a>.
In the mean time, if using the MariaDB Foundation deb packages is an
option for you, take a look at
<a class="moz-txt-link-freetext" href="https://mariadb.org/download/#mariadb-repositories">https://mariadb.org/download/#mariadb-repositories</a>.
Regards,
</pre>
</blockquote>
</body>
</html>