Daily.sh finished with errors

3 replies [Last post]
Fri, 02/24/2012 - 04:09
Joined: 01/16/2012
Points: 22

Hi all , i encountered an issue when i run /opt/kaltura/dwh/etlsource/execute/daily.sh and there have errors once run finished. Have anyone face this problem before? Mind to share some solution to fix this issue?

INFO 24-02 11:37:24,177 - Kitchen - Start of run.
INFO 24-02 11:37:25,576 - Using "/tmp/vfs_cache" as temporary files store.
INFO 24-02 11:37:25,889 - daily - Starting entry [Get daily lock]
INFO 24-02 11:37:25,930 - Get lock - Starting entry [Get lock state]
INFO 24-02 11:37:25,930 - Get lock state - Loading transformation from XML file [/opt/kaltura/dwh/etlsource//common/get_lock_state.ktr]
INFO 24-02 11:37:25,967 - Get lock state - Dispatching started for transformation [Get lock state]
INFO 24-02 11:37:25,972 - Get lock state - This transformation can be replayed with replay date: 2012/02/24 11:37:25
INFO 24-02 11:37:26,140 - Table input.0 - Finished reading query, closing connection.
INFO 24-02 11:37:26,141 - Set Variables.0 - Setting environment variables...
INFO 24-02 11:37:26,141 - Set Variables.0 - Set variable lock_state to value [Y]
INFO 24-02 11:37:26,142 - Table input.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
INFO 24-02 11:37:26,144 - Set Variables.0 - Finished after 1 rows.
INFO 24-02 11:37:26,144 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
INFO 24-02 11:37:26,202 - Get lock - Starting entry [Check if lock free]
INFO 24-02 11:37:26,203 - Get lock - Finished job entry [Check if lock free] (result=[false])
INFO 24-02 11:37:26,203 - Get lock - Finished job entry [Get lock state] (result=[false])
INFO 24-02 11:37:26,203 - daily - Finished job entry [Get daily lock] (result=[false])
INFO 24-02 11:37:26,204 - Kitchen - Finished!
ERROR 24-02 11:37:26,204 - Kitchen - Finished with errors
INFO 24-02 11:37:26,204 - Kitchen - Start=2012/02/24 11:37:25.775, Stop=2012/02/24 11:37:26.204
INFO 24-02 11:37:26,204 - Kitchen - Processing ended after 0 seconds.

Joined: 09/07/2011
Points: 21

hi ,

try this , once logged to mysql run

UPDATE kalturadw_ds.locks set lock_state = 0;

Joined: 01/20/2012
Points: 85

As I understand, kaltura 4ce has missing table, kalturadw_ds.updated_kusers_storage_usage; so it will probably your analytics will not work.

Joined: 08/23/2012
Points: 5

This morning I went online to wwoz to hear some Jazz and was delighted to hear a great live version of Fire on the Mountain. Of course, I'm reminded of what is beautiful about Jerry's music.

Water Damage Midland MI