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.
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
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 2487I 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
gxt_m00ix likes this.
utzer [Friendica]
•utzer [Friendica]
•Friendica DB should not be that write heavy, I will try with
innodb_adaptive_hash_index = 0and see.