Hello,
I have Lock Table problem on my Kaltura, we are using version 16.04
When i run :
su kaltura -c “/opt/kaltura/dwh/etlsource/execute/etl_perform_retention_policy.sh -p /opt/kaltura/dwh -k /opt/kaltura/pentaho/pdi/kitchen.sh”
I have the following error in logs:
INFO 23-08 10:38:45,361 - perform retention policy - Starting entry [Move old partitions to archive]
ERROR 23-08 10:38:45,417 - Move old partitions to archive - An error occurred executing this job entry :
Couldn’t execute SQL: CALL move_innodb_to_archive()
and then the lock is stuck again:
ERROR 23-08 10:42:09,149 - seize_lock_by_name - Errors detected!
ERROR 23-08 10:42:09,149 - seize_lock_by_name - Errors detected!
How can this be resolved?
MariaDB [kalturadw]> CALL move_innodb_to_archive();
ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead
[root@kaltura logs]# mysql -V
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1