Kaltura Cluster, both Sphinx Servers are showing wrong and different amounts of Users

Community Forums Backend Server Support
1

Hey,

I am currently working on a clustered Kaltura 12.2.0 Community Edition.

The issue I am having right now is that both Spinx Servers are showing different amounts of Users compared to the amount of entry’s that are in the database.

sphinx 1 has 21:
/* Fri Oct 28 14:06:54.939 2016 conn 951 real 0.001 wall 0.001 found 21 */ SELECT id FROM kaltura_kuser WHERE MATCH('@puser_id HASVALUE103') AND partner_id=103 AND is_admin=1 AND login_data_id>0 AND kuser_status!=2 AND kuser_status IN (0,1) AND type=0 ORDER BY created_at ASC LIMIT 0,25 OPTION max_matches=25, comment=''$CLIENT[71353521][sphinx1]'', ranker=none;

fixxed.png1148×1100 88.8 KB

sphinx 2 has 18:
/* Fri Oct 28 14:08:09.627 2016 conn 974 real 0.001 wall 0.001 found 18 */ SELECT id FROM kaltura_kuser WHERE MATCH('@puser_id HASVALUE103') AND partner_id=103 AND is_admin=1 AND login_data_id>0 AND kuser_status!=2 AND kuser_status IN (0,1) AND type=0 ORDER BY created_at ASC LIMIT 0,25 OPTION max_matches=25, comment=''$CLIENT[972352517][sphinx2]'', ranker=none;

And the Amount of Users in the Database are 25

fixxxxx.png1149×611 37.3 KB

Does anyone have an idea how to fix this issue?
I can provide more logs/screenshots if needed.

best regards

2

Hi @Raumen837,

To correct the current issue, you can run:
/opt/kaltura/bin/kaltura-sphinx-reindex.sh

To make sure it does not happen again, ensure /etc/init.d/kaltura-populate is running on both Sphinx instances.
If it is not, then that would explain it.
You should see this process running on both instances:
/usr/bin/php populateFromLog.php

This logs to /opt/kaltura/log/kaltura_populate.log

3

Hi @jess

Thanks !
This Works for me!