Issue with updgrade to Kaltura CE 13.9.0

t-saito · January 4, 2018, 3:14pm

Hello, everyone.

After upgrading our Kaltura servers from the Kaltura CE 13.0.0 to 13.9.0, sphinx server has a issue.
So, users and administrator cannot create new media entry after upgrading.

/opt/kaltura/log/sphinx/kaltura_api_v3.log

2018-01-04 20:56:39 [0.000773] [133.62.132.148] [1134616295] [138] [API] [kSphinxSearchManager->execSphinx] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST7 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,7,1,2,0,101,6,1,0,0,0,0,0,0,0,0,0,1515066999,1515066999,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:39 [0.001305] [133.62.132.148] [1134616295] [145] [API] [KalturaStatement->execute] DEBUG: /* cak01adm.cc.yamaguchi-u.ac.jp[1134616295][sphinx_log] / INSERT INTO sphinx_log (ID,EXECUTED_SERVER_ID,OBJECT_TYPE,OBJECT_ID,ENTRY_ID,PARTNER_ID,DC,SQL,CREATED_AT,TYPE) VALUES (NULL,‘0’,‘entry’,‘0_n6sczfva’,‘0_n6sczfva’,‘101’,‘0’,‘replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,’‘cuePoint_101 cpend’’,’‘0_n6sczfva’’,’‘0_n6sczfva’’,’‘mother1’’,’‘HASNOVALUE101’’,’‘pid101 HASVALUE101’’,’‘HASNOVALUE101’’,’‘0_82uuf98y HASVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘short’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘K_Pref HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘P101ST7 0_n6sczfva’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘ENTRYPC_9 HASVALUE101’’,’‘pid101DEFAULTPCTYPE1 HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,1886145582,7,1,2,0,101,6,1,0,0,0,0,0,0,0,0,0,1515066999,1515066999,1515066999,0,0,0,1515066999,0,’’[]’’)’,‘2018-01-04 20:56:39’,‘0’)
2018-01-04 20:56:39 [0.000547] [133.62.132.148] [1134616295] [148] [API] [KalturaPDO->exec] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST7 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,7,1,2,0,101,6,1,0,0,0,0,0,0,0,0,0,1515066999,1515066999,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:39 [0.000410] [133.62.132.148] [1134616295] [150] [API] [kSphinxSearchManager->execSphinx] ERR: exception ‘Exception’ with message ‘unknown column: ‘entitled_kusers_view’’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
2018-01-04 20:56:40 [0.000706] [133.62.132.148] [2015061473] [120] [API] [kSphinxSearchManager->execSphinx] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST0 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,0,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067000,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:40 [0.001309] [133.62.132.148] [2015061473] [127] [API] [KalturaStatement->execute] DEBUG: / cak01adm.cc.yamaguchi-u.ac.jp[2015061473][sphinx_log] / INSERT INTO sphinx_log (ID,EXECUTED_SERVER_ID,OBJECT_TYPE,OBJECT_ID,ENTRY_ID,PARTNER_ID,DC,SQL,CREATED_AT,TYPE) VALUES (NULL,‘0’,‘entry’,‘0_n6sczfva’,‘0_n6sczfva’,‘101’,‘0’,‘replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,’‘cuePoint_101 cpend’’,’‘0_n6sczfva’’,’‘0_n6sczfva’’,’‘mother1’’,’‘HASNOVALUE101’’,’‘pid101 HASVALUE101’’,’‘HASNOVALUE101’’,’‘0_82uuf98y HASVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘short’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘K_Pref HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘P101ST0 0_n6sczfva’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘ENTRYPC_9 HASVALUE101’’,’‘pid101DEFAULTPCTYPE1 HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,1886145582,0,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067000,1515066999,0,0,0,1515066999,0,’’[]’’)’,‘2018-01-04 20:56:40’,‘0’)
2018-01-04 20:56:40 [0.000605] [133.62.132.148] [2015061473] [130] [API] [KalturaPDO->exec] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST0 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,0,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067000,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:40 [0.000408] [133.62.132.148] [2015061473] [132] [API] [kSphinxSearchManager->execSphinx] ERR: exception ‘Exception’ with message ‘unknown column: ‘entitled_kusers_view’’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
2018-01-04 20:56:41 [0.000695] [133.62.132.148] [788840494] [157] [API] [kSphinxSearchManager->execSphinx] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST2 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,2,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067001,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:41 [0.001281] [133.62.132.148] [788840494] [164] [API] [KalturaStatement->execute] DEBUG: / cak01adm.cc.yamaguchi-u.ac.jp[788840494][sphinx_log] */ INSERT INTO sphinx_log (ID,EXECUTED_SERVER_ID,OBJECT_TYPE,OBJECT_ID,ENTRY_ID,PARTNER_ID,DC,SQL,CREATED_AT,TYPE) VALUES (NULL,‘0’,‘entry’,‘0_n6sczfva’,‘0_n6sczfva’,‘101’,‘0’,‘replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,’‘cuePoint_101 cpend’’,’‘0_n6sczfva’’,’‘0_n6sczfva’’,’‘mother1’’,’‘HASNOVALUE101’’,’‘pid101 HASVALUE101’’,’‘HASNOVALUE101’’,’‘0_82uuf98y HASVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘short’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘K_Pref HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘P101ST2 0_n6sczfva’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘HASNOVALUE101’’,’‘ENTRYPC_9 HASVALUE101’’,’‘pid101DEFAULTPCTYPE1 HASVALUE101’’,’‘9’’,’‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,’‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’’,1886145582,2,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067001,1515066999,0,0,0,1515066999,0,’’[]’’)’,‘2018-01-04 20:56:41’,‘0’)
2018-01-04 20:56:41 [0.000473] [133.62.132.148] [788840494] [167] [API] [KalturaPDO->exec] DEBUG: replace into kaltura_entry (id,plugins_data,entry_id,str_entry_id,name,tags,categories,flavor_params,kshow_id,group_id,description,admin_tags,duration_type,reference_id,replacing_entry_id,replaced_entry_id,roots,kuser_id,puser_id,sphinx_match_optimizations,entitled_kusers_publish,entitled_kusers_edit,entitled_kusers_view,entitled_kusers,privacy_by_contexts,creator_kuser_id,creator_puser_id,user_names,int_entry_id,entry_status,type,media_type,views,partner_id,moderation_status,display_in_search,length_in_msecs,access_control_id,moderation_count,rank,total_rank,plays,partner_sort_value,replacement_status,source,created_at,updated_at,modified_at,media_date,start_date,end_date,available_from,last_played_at,dynamic_attributes) values(793,‘cuePoint_101 cpend’,‘0_n6sczfva’,‘0_n6sczfva’,‘mother1’,‘HASNOVALUE101’,‘pid101 HASVALUE101’,‘HASNOVALUE101’,‘0_82uuf98y HASVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘short’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘K_Pref HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘P101ST2 0_n6sczfva’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘HASNOVALUE101’,‘ENTRYPC_9 HASVALUE101’,‘pid101DEFAULTPCTYPE1 HASVALUE101’,‘9’,‘mduser@cak01adm.cc.yamaguchi-u.ac.jp’,‘Moodle User mduser@cak01adm.cc.yamaguchi-u.ac.jp’,1886145582,2,1,2,0,101,6,1,0,0,0,0,0,0,0,0,1,1515066999,1515067001,1515066999,0,0,0,1515066999,0,’[]’)
2018-01-04 20:56:41 [0.000184] [133.62.132.148] [788840494] [169] [API] [kSphinxSearchManager->execSphinx] ERR: exception ‘Exception’ with message ‘unknown column: ‘entitled_kusers_view’’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>
[entitledUsersEditMatchAnd] =>
[entitledUsersEditMatchOr] =>
[entitledUsersPublishMatchAnd] =>
[entitledUsersPublishMatchOr] =>
[entitledUsersViewMatchAnd] =>
[entitledUsersViewMatchOr] =>

Then, I exexuted kaltura-base-config.sh, kaltura-front-config.sh, kaltura-sphinx-config.sh on the each front-node.
And, I executed kaltura-base-config.sh, kaltura-frint- config.sh on the database node.
But, tihs issue is not solved.

The versions of the related packages are as follows.

# rpm -q kaltura-base
kaltura-base-13.9.0-19.noarch
# rpm -q kaltura-front
kaltura-front-13.9.0-1.noarch
# rpm -q kaltura-sphinx
kaltura-sphinx-2.2.1-21.x86_64

And, OS of each server is “CentOS Linux release 7.4.1708 (Core)”.

Could you teach me how to solve this issue?

jess · January 4, 2018, 4:09pm

Hi @t-saito,

The issue starts here:

This additional Sphinx field was added in this pull request:

and was released as part of 13.4.0.

Let’s start by making sure you have this additional field in /opt/kaltura/app/configurations/sphinx/kaltura.conf, if you do not, please check whether you have it in /opt/kaltura/app/configurations/sphinx/kaltura.conf.template.
As you probably know, /opt/kaltura/app/configurations/sphinx/kaltura.conf.template is used to regenerate the active Sphinx config every time you run the kaltura-base-config.sh script.

Assuming that part is OK, my guess would be that something went wrong when the upgrade process ran /opt/kaltura/bin/kaltura-sphinx-schema-update.sh.

I suggest you stop Sphinx [the script stops it but maybe the init script reported the daemon successfully stopped when in fact it hasn’t] and, temporarily, also stop the watchdog daemon [kaltura-monit] which again, the script does but best ensure it is stopped and let the script re-start these two once done.
Then, after confirming both Sphinx and monit are no longer running,
run:

# bash -x /opt/kaltura/bin/kaltura-sphinx-schema-update.sh

and look closely for potential errors.

Let me know how it goes,

t-saito · January 4, 2018, 4:42pm

Thaks @jess

“entitled_kusers_view” field exists in /opt/kaltura/app/configurations/sphinx/kaltura.conf.
So, I execute “/opt/kaltura/bin/kaltura-sphinx-schema-update.sh”.
Result is as follows.

# bash -x /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
++ dirname /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
+ KALTURA_FUNCTIONS_RC=/opt/kaltura/bin/kaltura-functions.rc
+ ‘[’ ‘!’ -r /opt/kaltura/bin/kaltura-functions.rc ‘]’
+ . /opt/kaltura/bin/kaltura-functions.rc
++ RC_FILE=/etc/kaltura.d/system.ini
++ ‘[’ -r /etc/kaltura.d/system.ini ‘]’
++ . /etc/kaltura.d/system.ini
+++ WEB_DIR=/opt/kaltura/web
+++ LOG_DIR=/opt/kaltura/log
+++ APP_DIR=/opt/kaltura/app
+++ BASE_DIR=/opt/kaltura
+++ PHP_BIN=/usr/bin/php
+++ OS_KALTURA_USER=kaltura
+++ MAILTO=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
+++ ADMIN_CONSOLE_ADMIN_MAIL=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
+++ DB1_HOST=10.137.15.205
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=hogehoge1
+++ DWH_HOST=10.137.15.205
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=hogehoge2
+++ SERVICE_URL=https://cak01fn.cc.yamaguchi-u.ac.jp
+++ SPHINX_HOST=10.137.15.198
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=hogehoge0
+++ KALTURA_VIRTUAL_HOST_NAME=cak01fn1.cc.yamaguchi-u.ac.jp
+++ PRIMARY_MEDIA_SERVER_HOST=cak01adm.cc.yamaguchi-u.ac.jp
+++ IS_SSL=y
+++ CRT_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.cer
+++ KEY_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.key
+++ CA_FILE=
+++ CHAIN_FILE=/etc/httpd/ssl.crt/nii-odca3sha2.cer
+++ dirname /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ ‘[’ -r /opt/kaltura/bin/colors.sh ‘]’
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR=’\033[1;31m’
+++ ESC=’\033’
+++ NORMAL=’\033[m’
+++ RESET=’\033[0;37;00m’
+++ BLACK=’\033[0;30m’
+++ RED=’\033[0;31m’
+++ GREEN=’\033[0;32m’
+++ YELLOW=’\033[0;33m’
+++ BLUE=’\033[0;34m’
+++ VIOLET=’\033[0;35m’
+++ CYAN=’\033[0;36m’
+++ WHITE=’\033[0;37m’
+++ BRIGHT_BLACK=’\033[1;30m’
+++ BRIGHT_RED=’\033[1;31m’
+++ BRIGHT_GREEN=’\033[1;32m’
+++ BRIGHT_YELLOW=’\033[1;33m’
+++ BRIGHT_BLUE=’\033[1;34m’
+++ BRIGHT_VIOLET=’\033[1;35m’
+++ BRIGHT_CYAN=’\033[1;36m’
+++ BRIGHT_WHITE=’\033[1;37m’
+++ REV_CYAN=’\033[0;47;46m’
+++ REV_RED=’\033[0;33; 41m’
+++ JESS=‘Jess likes this one :)’
++ ‘[’ -r /etc/sysconfig/clock ‘]’
++ ‘[’ -z ‘’ ‘]’
+++ get_tz
+++ ‘[’ -r /etc/sysconfig/clock ‘]’
+++ ‘[’ -n ‘’ ‘]’
++++ md5sum /etc/localtime
++++ awk -F ’ ’ ‘{print $1}’
+++ LOCALTIME_MD5=4387b905d699977cb48c740de16e610b
++++ find /usr/share/zoneinfo -type f
++++ xargs md5sum
++++ grep 4387b905d699977cb48c740de16e610b
++++ awk -F ’ ’ ‘{print $2}’
++++ sed s@/usr/share/zoneinfo/@@g
++++ tail -1
+++ TZGUESS=Japan
+++ echo Japan
++ ZONE=Japan
++ export ZONE
++ ‘[’ -r /opt/kaltura/app/configurations/consent_msgs ‘]’
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT=‘Do you agree for Kaltura to collect data about your installation?
This data will be used for analysis and ongoing improvement of the Kaltura platform and services.’
+++ POST_CONSENT=‘Thank you for helping making Kaltura better! To review what information is being collected, please read: Kaltura Community Edition QA Tracking - Community data sharing to improve platform stability and quality .’
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ ‘[’ CentOS = Ubuntu -o CentOS = Debian ‘]’
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS=‘httpd kaltura-sphinx kaltura-batch kaltura-monit memcached’
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND=‘rpm -q’
++ MAIL_LOG=/var/log/maillog
++ POST_INST_MAIL_SUBJECT=‘Your new Kaltura server is up! and 6 Quick Tips For Smooth Kaltura Maintenance’
++ POST_INST_MAIL_TMPL=/opt/kaltura/app/configurations/post_inst_mail
++ ANALYTICS_SERVER_URI=https://installytics.kaltura.org/report/add_rec.php
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG=‘
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
’
+ RC_FILE=/etc/kaltura.d/system.ini
+ ‘[’ ‘!’ -r /etc/kaltura.d/system.ini ‘]’
+ . /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
++ ADMIN_CONSOLE_ADMIN_MAIL=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
++ DB1_HOST=10.137.15.205
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=hogehoge1
++ DWH_HOST=10.137.15.205
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=hogehoge2
++ SERVICE_URL=https://cak01fn.cc.yamaguchi-u.ac.jp
++ SPHINX_HOST=10.137.15.198
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=hogehoge1
++ KALTURA_VIRTUAL_HOST_NAME=cak01fn1.cc.yamaguchi-u.ac.jp
++ PRIMARY_MEDIA_SERVER_HOST=cak01adm.cc.yamaguchi-u.ac.jp
++ IS_SSL=y
++ CRT_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.cer
++ KEY_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.key
++ CA_FILE=
++ CHAIN_FILE=/etc/httpd/ssl.crt/nii-odca3sha2.cer
+ ‘[’ -r /opt/kaltura/app/configurations/sphinx_schema_update ‘]’

jess · January 4, 2018, 4:58pm

Hi @t-saito,

That means it already ran during the last upgrade as /opt/kaltura/app/configurations/sphinx_schema_update is not present.
Please:
# touch /opt/kaltura/app/configurations/sphinx_schema_update
and re-run.

t-saito · January 4, 2018, 5:09pm

Thanks @jess

Now, results of command and script are as follows.

# touch /opt/kaltura/app/configurations/sphinx_schema_update
# bash -x /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
++ dirname /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
+ KALTURA_FUNCTIONS_RC=/opt/kaltura/bin/kaltura-functions.rc
+ ‘[’ ‘!’ -r /opt/kaltura/bin/kaltura-functions.rc ‘]’
+ . /opt/kaltura/bin/kaltura-functions.rc
++ RC_FILE=/etc/kaltura.d/system.ini
++ ‘[’ -r /etc/kaltura.d/system.ini ‘]’
++ . /etc/kaltura.d/system.ini
+++ WEB_DIR=/opt/kaltura/web
+++ LOG_DIR=/opt/kaltura/log
+++ APP_DIR=/opt/kaltura/app
+++ BASE_DIR=/opt/kaltura
+++ PHP_BIN=/usr/bin/php
+++ OS_KALTURA_USER=kaltura
+++ MAILTO=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
+++ ADMIN_CONSOLE_ADMIN_MAIL=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
+++ DB1_HOST=10.137.15.205
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=hogehoge1
+++ DWH_HOST=10.137.15.205
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=hogehoge1
+++ SERVICE_URL=https://cak01fn.cc.yamaguchi-u.ac.jp
+++ SPHINX_HOST=10.137.15.198
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=hogehoge0
+++ KALTURA_VIRTUAL_HOST_NAME=cak01fn1.cc.yamaguchi-u.ac.jp
+++ PRIMARY_MEDIA_SERVER_HOST=cak01adm.cc.yamaguchi-u.ac.jp
+++ IS_SSL=y
+++ CRT_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.cer
+++ KEY_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.key
+++ CA_FILE=
+++ CHAIN_FILE=/etc/httpd/ssl.crt/nii-odca3sha2.cer
+++ dirname /opt/kaltura/bin/kaltura-sphinx-schema-update.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ ‘[’ -r /opt/kaltura/bin/colors.sh ‘]’
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR=’\033[1;31m’
+++ ESC=’\033’
+++ NORMAL=’\033[m’
+++ RESET=’\033[0;37;00m’
+++ BLACK=’\033[0;30m’
+++ RED=’\033[0;31m’
+++ GREEN=’\033[0;32m’
+++ YELLOW=’\033[0;33m’
+++ BLUE=’\033[0;34m’
+++ VIOLET=’\033[0;35m’
+++ CYAN=’\033[0;36m’
+++ WHITE=’\033[0;37m’
+++ BRIGHT_BLACK=’\033[1;30m’
+++ BRIGHT_RED=’\033[1;31m’
+++ BRIGHT_GREEN=’\033[1;32m’
+++ BRIGHT_YELLOW=’\033[1;33m’
+++ BRIGHT_BLUE=’\033[1;34m’
+++ BRIGHT_VIOLET=’\033[1;35m’
+++ BRIGHT_CYAN=’\033[1;36m’
+++ BRIGHT_WHITE=’\033[1;37m’
+++ REV_CYAN=’\033[0;47;46m’
+++ REV_RED=’\033[0;33; 41m’
+++ JESS=‘Jess likes this one :)’
++ ‘[’ -r /etc/sysconfig/clock ‘]’
++ ‘[’ -z ‘’ ‘]’
+++ get_tz
+++ ‘[’ -r /etc/sysconfig/clock ‘]’
+++ ‘[’ -n ‘’ ‘]’
++++ md5sum /etc/localtime
++++ awk -F ’ ’ ‘{print $1}’
+++ LOCALTIME_MD5=4387b905d699977cb48c740de16e610b
++++ find /usr/share/zoneinfo -type f
++++ xargs md5sum
++++ grep 4387b905d699977cb48c740de16e610b
++++ awk -F ’ ’ ‘{print $2}’
++++ sed s@/usr/share/zoneinfo/@@g
++++ tail -1
+++ TZGUESS=Japan
+++ echo Japan
++ ZONE=Japan
++ export ZONE
++ ‘[’ -r /opt/kaltura/app/configurations/consent_msgs ‘]’
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT=‘Do you agree for Kaltura to collect data about your installation?
This data will be used for analysis and ongoing improvement of the Kaltura platform and services.’
+++ POST_CONSENT=‘Thank you for helping making Kaltura better! To review what information is being collected, please read: Kaltura Community Edition QA Tracking - Community data sharing to improve platform stability and quality .’
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ ‘[’ CentOS = Ubuntu -o CentOS = Debian ‘]’
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS=‘httpd kaltura-sphinx kaltura-batch kaltura-monit memcached’
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND=‘rpm -q’
++ MAIL_LOG=/var/log/maillog
++ POST_INST_MAIL_SUBJECT=‘Your new Kaltura server is up! and 6 Quick Tips For Smooth Kaltura Maintenance’
++ POST_INST_MAIL_TMPL=/opt/kaltura/app/configurations/post_inst_mail
++ ANALYTICS_SERVER_URI=https://installytics.kaltura.org/report/add_rec.php
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG=‘
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
’
+ RC_FILE=/etc/kaltura.d/system.ini
+ ‘[’ ‘!’ -r /etc/kaltura.d/system.ini ‘]’
+ . /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
++ ADMIN_CONSOLE_ADMIN_MAIL=kadmin@cak01adm.cc.yamaguchi-u.ac.jp
++ DB1_HOST=10.137.15.205
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=hogehoge1
++ DWH_HOST=10.137.15.205
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=hogehoge1
++ SERVICE_URL=https://cak01fn.cc.yamaguchi-u.ac.jp
++ SPHINX_HOST=10.137.15.198
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=hogehoge0
++ KALTURA_VIRTUAL_HOST_NAME=cak01fn1.cc.yamaguchi-u.ac.jp
++ PRIMARY_MEDIA_SERVER_HOST=cak01adm.cc.yamaguchi-u.ac.jp
++ IS_SSL=y
++ CRT_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.cer
++ KEY_FILE=/etc/httpd/ssl.crt/cak01fn1.cc.yamaguchi-u.ac.jp.key
++ CA_FILE=
++ CHAIN_FILE=/etc/httpd/ssl.crt/nii-odca3sha2.cer
+ ‘[’ -r /opt/kaltura/app/configurations/sphinx_schema_update ‘]’
+ /etc/init.d/kaltura-sphinx status
searchd は停止しています
++ date +%s
+ STMP=1515085332
+ mkdir -p /opt/kaltura/sphinx.bck.1515085332
+ echo 'Backing up files to /opt/kaltura/sphinx.bck.1515085332. Once the upgrade is done and tested, please remove this directory to save space’
Backing up files to /opt/kaltura/sphinx.bck.1515085332. Once the upgrade is done and tested, please remove this directory to save space
+ mv /opt/kaltura/sphinx/kaltura_caption_item_rt.kill /opt/kaltura/sphinx/kaltura_caption_item_rt.lock /opt/kaltura/sphinx/kaltura_caption_item_rt.meta /opt/kaltura/sphinx/kaltura_caption_item_rt.ram /opt/kaltura/sphinx/kaltura_category_kuser_rt.kill /opt/kaltura/sphinx/kaltura_category_kuser_rt.lock /opt/kaltura/sphinx/kaltura_category_kuser_rt.meta /opt/kaltura/sphinx/kaltura_category_kuser_rt.ram /opt/kaltura/sphinx/kaltura_category_rt.kill /opt/kaltura/sphinx/kaltura_category_rt.lock /opt/kaltura/sphinx/kaltura_category_rt.meta /opt/kaltura/sphinx/kaltura_category_rt.ram /opt/kaltura/sphinx/kaltura_cue_point_rt.kill /opt/kaltura/sphinx/kaltura_cue_point_rt.lock /opt/kaltura/sphinx/kaltura_cue_point_rt.meta /opt/kaltura/sphinx/kaltura_cue_point_rt.ram /opt/kaltura/sphinx/kaltura_distribution_rt.kill /opt/kaltura/sphinx/kaltura_distribution_rt.lock /opt/kaltura/sphinx/kaltura_distribution_rt.meta /opt/kaltura/sphinx/kaltura_distribution_rt.ram /opt/kaltura/sphinx/kaltura_kuser_rt.kill /opt/kaltura/sphinx/kaltura_kuser_rt.lock /opt/kaltura/sphinx/kaltura_kuser_rt.meta /opt/kaltura/sphinx/kaltura_kuser_rt.ram /opt/kaltura/sphinx/kaltura_metadata_rt.kill /opt/kaltura/sphinx/kaltura_metadata_rt.lock /opt/kaltura/sphinx/kaltura_metadata_rt.meta /opt/kaltura/sphinx/kaltura_metadata_rt.ram /opt/kaltura/sphinx/kaltura_rt.kill /opt/kaltura/sphinx/kaltura_rt.lock /opt/kaltura/sphinx/kaltura_rt.meta /opt/kaltura/sphinx/kaltura_rt.ram /opt/kaltura/sphinx/kaltura_schedule_event_rt.kill /opt/kaltura/sphinx/kaltura_schedule_event_rt.lock /opt/kaltura/sphinx/kaltura_schedule_event_rt.meta /opt/kaltura/sphinx/kaltura_schedule_event_rt.ram /opt/kaltura/sphinx/kaltura_tag_rt.kill /opt/kaltura/sphinx/kaltura_tag_rt.lock /opt/kaltura/sphinx/kaltura_tag_rt.meta /opt/kaltura/sphinx/kaltura_tag_rt.ram /opt/kaltura/log/sphinx/data/binlog.meta /opt/kaltura/sphinx.bck.1515085332
+ /etc/init.d/kaltura-sphinx start
Starting searchd: Sphinx 2.2.1-id64-dev (r4097)
Copyright © 2001-2013, Andrew Aksyonoff
Copyright © 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file ‘/opt/kaltura/app/configurations/sphinx/kaltura.conf’…
listening on all interfaces, port=9312
WARNING: index ‘kaltura_base’: no fields configured (use rt_field directive) - NOT SERVING
WARNING: index ‘kaltura_base_gt_in_charset’: no fields configured (use rt_field directive) - NOT SERVING
precaching index 'kaltura_entry’
precaching index 'kaltura_category’
precaching index 'kaltura_kuser’
precaching index 'kaltura_category_kuser’
precaching index 'kaltura_cue_point’
precaching index 'kaltura_entry_distribution’
precaching index 'kaltura_caption_item’
precaching index 'kaltura_tag’
precaching index 'kaltura_metadata’
precaching index 'kaltura_schedule_event’
precached 10 indexes in 0.029 sec

+ ln -sf /opt/kaltura/app/configurations/monit/monit.avail/sphinx.rc /opt/kaltura/app/configurations/monit/monit.d/enabled.sphinx.rc
+ php /opt/kaltura/app/deployment/base/scripts/populateSphinxEntries.php
2018-01-05 02:02:13 [DbManager::connectFallbackLogic] ERR: exception ‘Exception’ with message ‘failed to connect to sphinx2’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php(279): KalturaLog::err(‘failed to conne…’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php(217): DbManager::connectFallbackLogic(Array, Array, Array, false, ‘300’)
#2 /opt/kaltura/app/plugins/search/providers/sphinx_search/lib/kSphinxSearchManager.php(456): DbManager::getSphinxConnection(false)
#3 /opt/kaltura/app/plugins/search/providers/sphinx_search/lib/kSphinxSearchManager.php(426): kSphinxSearchManager->retrieveSphinxConnectionId()
#4 /opt/kaltura/app/plugins/search/providers/sphinx_search/lib/kSphinxSearchManager.php(531): kSphinxSearchManager->execSphinx(‘replace into ka…’, Object(entry))
#5 /opt/kaltura/app/deployment/base/scripts/populateSphinxEntries.php(33): kSphinxSearchManager->saveToSphinx(Object(entry), true)
#6 {main}
+ RC=0
+ ‘[’ 0 -ne 0 ‘]’
+ /etc/init.d/kaltura-sphinx restart
Stopping searchd: Sphinx 2.2.1-id64-dev (r4097)
Copyright © 2001-2013, Andrew Aksyonoff
Copyright © 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file ‘/opt/kaltura/app/configurations/sphinx/kaltura.conf’…
stop: successfully sent SIGTERM to pid 1744

Starting searchd: Sphinx 2.2.1-id64-dev (r4097)
Copyright © 2001-2013, Andrew Aksyonoff
Copyright © 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file ‘/opt/kaltura/app/configurations/sphinx/kaltura.conf’…
listening on all interfaces, port=9312
WARNING: index ‘kaltura_base’: no fields configured (use rt_field directive) - NOT SERVING
WARNING: index ‘kaltura_base_gt_in_charset’: no fields configured (use rt_field directive) - NOT SERVING
precaching index 'kaltura_entry’
precaching index 'kaltura_category’
precaching index 'kaltura_kuser’
precaching index 'kaltura_category_kuser’
precaching index 'kaltura_cue_point’
precaching index 'kaltura_entry_distribution’
precaching index 'kaltura_caption_item’
precaching index 'kaltura_tag’
precaching index 'kaltura_metadata’
precaching index 'kaltura_schedule_event’
precached 10 indexes in 0.075 sec

+ rm /opt/kaltura/app/configurations/sphinx_schema_updat

Best regards.

jess · January 4, 2018, 5:14pm

Hi @t-saito,

Apart from:

This looks better.
Do you have several Sphinx nodes in your cluster?
Please check /opt/kaltura/app/configurations/db.ini on all nodes and ensure that the sphinxN.connection.dsn directives all point to valid Sphinx hosts. I use N as a placeholder for an integer, of course. The default config should have:

sphinx1.adapter = mysql
sphinx1.connection.dsn = "mysql:host=@SPHINX_SERVER1@;port=9312;"

sphinx2.adapter = mysql
sphinx2.connection.dsn = "mysql:host=@SPHINX_SERVER2@;port=9312;"

Also, is the issue now resolved?

jess · January 4, 2018, 5:22pm

@t-saito,

In the event you had to make changes to /opt/kaltura/app/configurations/db.ini, please be sure to reload Apache.

t-saito · January 4, 2018, 5:44pm

Thanks @jess

We use two sphinx nodes in Kaltura cluster.
At each Kaltura server, configurations of sphinx nodes in “db.ini” are set correctly.
Now, we can upload new media entry.
And we can play, edit and delete the media entry.

I do not know the reason why “kaltura-sphinx-schema-update.sh” was not executed when upgrading the Kaltura CE.
But, I seem that the issue is solved.

I appreciate your kind advice.

jess · January 4, 2018, 5:48pm

Hi @t-saito,

Glad to hear we’re good. My guess is kaltura-sphinx-schema-update.sh did execute but there was an issue with stopping Sphinx so it never got restarted post the configuration changes. When you manually stopped it, did it go down OK?

t-saito · January 4, 2018, 6:01pm

Hi @jess,

Surely, when executing “kaltura-sphinx-config.sh”, the Sphinx process did not stop normally.
This behavior sometimes occurs.
In such a case, I restart sphinx process manually.
I am glad that I could know how to solve this issue.

Many thanks.