Hello !Friendica Support,
anyone any idea what this messages in journalctl mean? I got lots of these before my server crashed and have no Idea what this is.

Mai 28 03:10:26 friendica mariadbd[553]: 2021-05-28  3:10:26 0 [Warning] InnoDB: A long semaphore wait:
Mai 28 03:10:26 friendica mariadbd[553]: --Thread 139676422764096 has waited at row0upd.cc line 179 for 465.00 seconds the semaphore:
Mai 28 03:10:26 friendica mariadbd[553]: S-lock on RW-latch at 0x55a2a8136178 created in file dict0dict.cc line 1041
Mai 28 03:10:26 friendica mariadbd[553]: a writer (thread id 139674262697536) has reserved it in mode  wait exclusive
Mai 28 03:10:26 friendica mariadbd[553]: number of readers 1, waiters flag 1, lock_word: ffffffff
Mai 28 03:10:26 friendica mariadbd[553]: Last time write locked in file dict0stats.cc line 2487

I guess something was wrong with either MariaDB or the VM itself that cause long operation times on the database which led to lots of long running locks. But what do I do with this?

#Friendica #MariaDB #Mysql #Linux #Semaphore