[debian-mysql] Bug#985821: Bug#985821: Mariadb crashes on long semaphore list related to "InnoDB persistent stats analyze forces full scan forcing lock crash"

[vasilis g]

Thank you for your reply.

I'm glad that you will include it. Pitty that we didn't catch up this
relese.

In the meantime, I am just adding some evidence (and a workaround) that
I tried in our production write intensive mariadb (10.3.27).

Indeed after changing

# mysql

|> set global innodb_stats_auto_recalc=0;|

|
|

|the server continues for the 6th day without crashes. Before that we
experienced daily crashes. |

||

|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.|

|Regards
|

On 29/3/21 6:29 μ.μ., Faustin Lammler wrote:
> Control: -1 forwarded https://jira.mariadb.org/browse/MDEV-24275
> 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
> https://salsa.debian.org/mariadb-team/mariadb-10.3/-/merge_requests/30#note_234016.
>
> In the mean time, if using the MariaDB Foundation deb packages is an
> option for you, take a look at
> https://mariadb.org/download/#mariadb-repositories.
>
> Regards,
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20210329/ce7bf0f7/attachment.htm>