New uploaded videos appear on database but don't appear on KMC - Possible error: Entry id "Failed" not found

Hi

We’re experiencing the following error: we are able to upload videos, the flavors are transcoded as expected, the mp4 files are correctly written on /web/content/data. But when we look at the KMC content list, the most recent videos are simply not displayed.

When we look at the entries table of the database, the new uploaded videos have similar field values as the ones that are working.

It is important to say that this error began when the hard drive reached its capacity and we have to download all the data (videos) folder and move it to another host. We already uploaded all videos again and nothing seems to be wrongly configurated.

When we run /opt/kaltura/bin/kaltura-sanity.sh it throws the following message:
PHP Fatal error: Uncaught KalturaException: Entry id “Failed” not found in /opt/kaltura/apps/clientlibs/php5/KalturaClientBase.php:912
Stack trace:
#0 /opt/kaltura/apps/clientlibs/php5/KalturaClient.php(763): KalturaClientBase->throwExceptionIfError(Array)
#1 /opt/kaltura/bin/check_entry_status.php(21): KalturaBaseEntryService->get(‘Failed’, NULL)
#2 {main}
thrown in /opt/kaltura/apps/clientlibs/php5/KalturaClientBase.php on line 912

Any ideas? Thanks in advance for any help you may give us

Oscar

We found the error, the sphinx_log table on the database was damaged and returned the message “Table ‘sphinx_log’ is marked as crashed and should be repaired”

We used the mysql command REPAIR TABLE, and finally we are seeing the last entries on the entry list

Hope this helps someone