Copyright © 2012 Kaltura Inc.
All Rights Reserved. Designated trademarks and brands are the property of their respective owners.
Use of this web site constitutes acceptance of the Terms of Use and Privacy Policy.
EduVideo.org
Deleting entries
Wed, 08/19/2009 - 18:01
Hi!
I realized that deleting entries in KMC just don't delete actual files or database entries. It seems to "flag" them (adding a &deleted_video/image on records in the entry table, in the database), but they stay that way.
Kalturian told me on IRC (join us on #kaltura@freenode!) that there should be a batch for deletion. There is one, named "batchEntryDeleteServer" (I guess this is the one), but it isn't listed in the Server > System Status page in KMC, so it never runs.
If I'm not supposed to launch it manually, did I miss something to have it listed?
Thank you.
Wed, 08/26/2009 - 08:23
#2
Ok so I didn't miss anything. I'll do that way then, manually launching batch. Thank you. :)
Thu, 09/03/2009 - 14:08
#3
I tried to manually launch the batch, but it doesn't seem to delete entries effectively.
Entries to be deleted seem to be logged, I found this in my logs/avalon-batchEntryDeleteServer.log:
03/09 15:36:03.43 {1381068} ENTRYDELETE: ----------------- Initializing DB -------------------
03/09 15:36:03.52 {2150316} ENTRYDELETE: Indicator exists - removing it and checking DB
03/09 15:36:03.137 {6330944} ENTRYDELETE: [0] roughcuts for entry [8pn4jk92bc]
(all deleted ids are listed)
03/09 15:36:03.333 {6841076} ENTRYDELETE: Ended EntryDelete. sleeping for a while (3 seconds). Will write to the log in (180) seconds
03/09 15:36:03.52 {2150316} ENTRYDELETE: Indicator exists - removing it and checking DB
03/09 15:36:03.137 {6330944} ENTRYDELETE: [0] roughcuts for entry [8pn4jk92bc]
(all deleted ids are listed)
03/09 15:36:03.333 {6841076} ENTRYDELETE: Ended EntryDelete. sleeping for a while (3 seconds). Will write to the log in (180) seconds
The entry 8pn4jk92bc should be deleted. But in my database, I still have a row in the entry table at id 8pn4jk92bc. When I check for the files related to that entry id, I still found all of them on my server.
The id 8pn4jk92bc is just an exemple, the same applies to all deleted ids.
Is there anything I've missed?
Kaltura has been designed in such a way that when you delete items from the KMC it DOES NOT delete them automatically from the database. This is both the case with Kaltura Self-Serve packages and Kaltura Community Edition (Kaltura CE).
If you want to "clean up" the database and remove items from the "trash" my suggestion would be to manually delete them using the supplied batch script. If you want to automate this process, you can always create a cron job.