it has been noted that upon flagging a content , when multiple users are present on the site , it generates a Deadlock , which in turn returns an ajax error. Deadlock is on the flag_counts table.
Following are the Error details
LATEST DETECTED DEADLOCK
------------------------
2020-01-30 14:16:50 0x7f07c40e4700
*** (1) TRANSACTION:
TRANSACTION 130240161, ACTIVE 11 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 4968, OS thread handle 139671330227968, query id 1493957 10.132.0.39 root update
INSERT INTO flag_counts (flag_id, entity_id, entity_type, last_updated, count) VALUES ('mvc_like', '594827', 'node', '1580393799', '1')
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 64482 page no 3 n bits 104 index PRIMARY of table "mvc"."flag_counts" trx id 130240161 lock_mode X locks rec but not gap waiting
Closed: cannot reproduce
4.0
Flag core
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.