maxicep
Active member
I'm getting some deadlocks related with that add-on in these days sometimes. even i'm using the CLI Job Runner add-on of you (may it related with cron times ? cron works every 5 min and time=240 parameter, should i increase them for prevent deadlocks? )
@Xon
@Xon
Code:
XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:217
Tarafından: Bilinmeyen hesap 9 Eyl 2019 - 18:49
Stack Trace
-- XFDB=noForceAllWrite
INSERT INTO xf_sv_user_activity
(content_type, content_id, `blob`, `timestamp`)
VALUES
(?,?,?,?),(?,?,?,?),(?,?,?,?)
ON DUPLICATE KEY UPDATE `timestamp` = values(`timestamp`)