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

2021-03-29 Thread 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

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

2021-03-29 Thread Faustin Lammler
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.

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

2021-03-24 Thread vasilis g
Package: mariadb-server Version: 1:10.3.27-0+deb10u1 Mariadb aborts an long semaphore list relating to analyze table commands for large databases. After I ran analyze on a big table on a server with slow storage, I aborted the command and restarted the server. Since then it seems that mariadb c