@!
Hubzilla Support Forum OK, let's see if I can properly post to the Support channel this time. To try to consolidate my previous post and replies...
Since Saturday, I've started getting the following error:
General error: 1205 Lock wait timeout exceeded; try restarting transactionI also am having the same (I assume) error happen when there is no error checking to report the error. One of the more obvious places this is happening is during the cron job. Items get taken and worked from the workerq table, but then fail to be deleted. When the Cron item fails to be deleted (which seems to be pretty much every time), the future cron jobs don't do anything. Oddly, though, new items created during the run of the job seem to get deleted. I might start with 50 items, have 400 get processed during the job and have 50 left at the end.
I am running Hubzilla 10.0.8 and MySQL 8.0.41 and I don't think either of those changed at the point where this issue started. I have tried changing the transaction_isolation to READ_COMMITTED in MySQL. I have tried setting db_skip_locked_supported to 1 in Hubzilla. Nothing has made a difference. I have done checks of my disk in case there was some sort of corruption there. I optimized the database in case there was something funky there. I have wasted so many hours on this and feel like I have gotten no where beyond keeping things hobbling along by manually deleting items that have been completed, but not deleted.
