I’m running Bluecherry 3.1.14 on Ubuntu Linux 6.17.0-22-generic #22~24.04.1-Ubuntu
I have not had any issues for a while now, then today I noticed my recordings stopped, I did a reboot of the computer and they started back up but adding in a new camera and setting motion detection, nothing was happening. I could live vie the camera but no motion detection.
I reviewed the log and found two database errors:
CRITICAL: Database lock timeout - potential deadlock detected
CRITICAL: Database lock retry failed - server may be overloaded
I used the Brave browser AI to see if it could give me some insights and it had me run a few commands, one of them SHOW ENGINE INNODB STATUS\G
I provided the results back and it told me that my InnoDB redo log is completely full (Log capacity used 104857600 out of 104857600 ), which prevents any further write operations and will cause the database to hang or crash.
It gave an instruction to resolve it, which I elected to do:
edit /etc/mysql/mysql.conf.d/mysqld.cnf and change or add
[mysqld]
innodb_redo_log_capacity = 1073741824
I added the setting, there was not an existing setting. and restarted mysqld and bluecherry.
Things are running better but not perfect.
The new camera is functioning with motion detection and recordings, however some recordings are not accessible with an error “Error loading this resource”. Also fdisk management is not working well. I have it set to 90% and when it cleans it attempts to go to 89% but its only removing a handfull of files and having to do file reduction on a regular basis. It appears the database is no longer in sync with the stored recordings and the sync database is not doing anything.
Is there anyway to get the database events and recordings between the database and the stored files back into harmony?