kaltura_populate.log grows exponentially

Hi all,
every second, a new line like that be added in kaltura_populate.log file. What does it mean?
How i can prevent this?
In a few days, the log file has reached several gb.

kaltura_populate.log

/* KalturaCE50-1[1893224560][sphinx_log] */ SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM `sphinx_log` WHERE (sphinx_log.ID IS NULL  OR ((sphinx_log.ID>'5208' AND sphinx_log.DC='0') AND sphinx_log.ID NOT IN ('5209','5210','5211','5212','5213','5214','5215','5216','5217','5218','5219','5220','5221','5222','5223','5224','5225','5226','5227','5228','5229','5230','5231','5232','5233','5234','5235','5236','5237','5238','5239','5240','5241','5242','5243','5244','5245','5246','5247','5248','5249','5250','5251','5252','5253','5254','5255','5256','5257','5258','5259','5260','5261','5262','5263','5264','5265','5266','5267','5268','5269','5270','5271','5272','5273','5274','5275','5276','5277','5278','5279','5280','5281','5282','5283','5284','5285','5286','5287','5288','5289','5290','5291','5292','5293','5294','5295','5296','5297','5298','5299','5300','5301','5302','5303','5304','5305','5306','5307','5308','5309','5310','5311','5312','5313','5314','5315','5316','5317','5318','5319','5320','5321','5322','5323','5324','5325','5326','5327','5328','5329','5330','5331','5332','5333','5334','5335','5336','5337','5338','5339','5340','5341','5342','5343','5344','5345','5346','5347','5348','5349','5350','5351','5352','5353','5354','5355','5356','5357','5358','5359','5360','5361','5362','5363','5364','5365','5366','5367','5368','5369','5370','5371','5372','5373','5374','5375','5376','5377','5378','5379','5380','5381','5382','5383','5384','5385','5386','5387','5388','5389','5390','5391','5392','5393','5394','5395','5396','5397','5398','5399','5400','5401','5402','5403','5404','5405','5406','5407','5408','5409','5410','5411','5412','5413','5414','5415','5416','5417','5418','5419','5420','5421','5422','5423','5424','5425','5426','5427','5428','5429','5430','5431','5432','5433','5434','5435','5436','5437','5438','5439','5440','5441','5442','5443','5444','5445','5446','5447','5448','5449','5450','5451','5452','5453','5454','5455','5456','5457','5458','5459','5460','5461','5462','5463','5464','5465','5466','5467','5468','5469','5470','5471','5472','5473','5474','5475','5476','5477','5478','5479','5480','5481','5482','5483','5484','5485','5486','5487','5488','5489','5490','5491','5492','5493','5494','5495','5496','5497','5498','5499','5500','5501','5502','5503','5504','5505','5506','5507','5508','5509','5510','5511','5512','5513','5514','5515','5516','5517','5518','5519','5520','5521','5522','5523','5524','5525','5526','5527','5528','5529','5530','5531','5532','5533','5534','5535','5536','5537','5538','5539','5540','5541','5542','5543','5544','5545','5546','5547','5548','5549','5550','5551','5552','5553','5554','5555','5556','5557','5558','5559','5560','5561','5562','5563','5564','5565','5566','5567','5568','5569','5570','5571','5572','5573','5574','5575','5576','5577','5578','5579','5580','5581','5582','5583','5584','5585','5586','5587','5588','5589','5590','5591','5592','5593','5594','5595','5596','5597','5598','5599','5600','5601','5602','5603','5604','5605','5606','5607','5608','5609','5610','5611','5612','5613','5614','5615','5616','5617','5618','5619','5620','5621','5622','5623','5624','5625','5626','5627','5628','5629','5630','5631','5632','5633','5634','5635','5636','5637','5638','5639','5640','5641','5642','5643','5644','5645','5646','5647','5648','5649','5650','5651','5652','5653','5654','5655','5656','5657','5658','5659','5660','5661','5662','5663','5664','5665','5666','5667','5668','5669','5670','5671','5672','5673','5674','5675','5676','5677','5678','5679','5680','5681','5682','5683','5684','5685','5686','5687','5688','5689','5690','5691','5692','5693','5694','5695','5696','5697','5698','5699','5700','5701','5702','5703','5704','5705','5706','5707','5708'))) ORDER BY sphinx_log.ID ASC LIMIT 1000

Hello,

This log is rotated daily:
/etc/logrotate.d/kaltura_populate

you can delete them instead of rotating.

Perfect! Thanks you!

Hi Jess! I have the same problem with the kaltura_populate.log that grows exponentially and I don’t know how to stop it. It’s reaching several GB in short time. Many thanks in advice!

Hello @srlomax,

Make sure you have:
# ll /etc/logrotate.d/kaltura_populate
lrwxrwxrwx. 1 root root 58 Oct 25 10:02 /etc/logrotate.d/kaltura_populate -> /opt/kaltura/app/configurations/logrotate/kaltura_populate

And that /opt/kaltura/app/configurations/logrotate/kaltura_populate
has the right log path, i.e:
/opt/kaltura/log/kaltura_populate.log

older versions had a bug where the path stated was /opt/kaltura/log/sphinx/kaltura_populate.log which is wrong, thus causing it not to be rotated.

After fixing that, you can manually rotate using:
# logrotate -vvv -f /etc/logrotate.d/kaltura_populate

but you can also just truncate the log with:
# :> /opt/kaltura/log/kaltura_populate.log

The info there is only important for debugging purposes anyhow.

Oops!! I delete /etc/logrotate.d/kaltura_populate folder, but the path on /opt/kaltura/app/configurations/logrotate/kaltura_populate was wrong.
How I create the /etc/logrotate.d/kaltura_populate? Is a symbolic link, no? Sorry for my noob skills.

I have another question I know this is not the topic but anyway…
Why when I configured S3 Remote Storage & Cloudfront for Delivery Profile, the thumbnails of the playhead on scrubber stop working? Where I tell Kaltura to get these thumbs from the S3 or CF???

Many thanks again Jess, I followed some videos of you about Kaltura deployment in the past!

Hi,

It’s just a symlink, run:
# ln -s /opt/kaltura/app/configurations/logrotate/kaltura_populate /etc/logrotate.d/
I am not quite sure I understand the question about the thumbs… do you mean you cannot create new thumbnails directly on the remote storage? if so, that is a known limitation, if not, please reiterate?

And you’re welcome, I hope you found them useful:)

Good, I run it, I think it’s OK now. I let you know later about results.

The thumbnail of the entrys are working OK.

When I setup the S3 Remote Storage & Cloudfront Delivery Distribution, if I play a video, the preview thumbs that appear in playhead on the scrubber bar when mouse over, stoped working!

Thanks again!

Hello,

Yes, as I said, unfortunately, the thumbnail creation does not work over remote storage.
You can set the scrubber plugin property “showOnlyTime” to true thus turning off the
thumbnail preview feature.

I Found, that if I upload a flavor again its make work the thumbs on scrubber, but the thumb files keeps on Kaltura server instead S3 o CF, but it’s OK for now.

The kaltura_populate.log keeps growing, and a .log-XXXXXXXX.gz is created, the file size grows some like 10Mb per minute, in one night is 5Gb file, in a few days grows to full the hard disk…

The kaltura_api_v3.log the same, but minor in file size…

Many thanks again Jess!

[2015-10-28 12:47:42]/* vps-XXXXXX-x.dattaweb.com[2031895153][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log WHERE (sphinx_log.ID IS NULL OR ((sphinx_log.ID>‘22198’ AND sphinx_log.DC=‘0’) AND sphinx_log.ID NOT IN (‘22199’,‘22200’,‘22201’,‘22202’,‘22203’,‘22204’,‘22205’,‘22206’,‘22207’,‘22208’,‘22209’,‘22210’,‘22211’,‘22212’,‘22213’,‘22214’,‘22215’,‘22216’,‘22217’,‘22218’,‘22219’,‘22220’,‘22221’,‘22222’,‘22223’,‘22224’,‘22225’,‘22226’,‘22227’,‘22228’,‘22229’,‘22230’,‘22231’,‘22232’,‘22233’,‘22234’,‘22235’,‘22236’,‘22237’,‘22238’,‘22239’,‘22240’,‘22241’,‘22242’,‘22243’,‘22244’,‘22245’,‘22246’,‘22247’,‘22248’,‘22249’,‘22250’,‘22251’,‘22252’,‘22253’,‘22254’,‘22255’,‘22256’,‘22257’,‘22258’,‘22259’,‘22260’,‘22261’,‘22262’,‘22263’,‘22264’,‘22265’,‘22266’,‘22267’,‘22268’,‘22269’,‘22270’,‘22271’,‘22272’,‘22273’,‘22274’,‘22275’,‘22276’,‘22277’,‘22278’,‘22279’,‘22280’,‘22281’,‘22282’,‘22283’,‘22284’,‘22285’,‘22286’,‘22287’,‘22288’,‘22289’,‘22290’,‘22291’,‘22292’,‘22293’,‘22294’,‘22295’,‘22296’,‘22297’,‘22298’,‘22299’,‘22300’,‘22301’,‘22302’,‘22303’,‘22304’,‘22305’,‘22306’,‘22307’,‘22308’,‘22309’,‘22310’,‘22311’,‘22312’,‘22313’,‘22314’,‘22315’,‘22316’,‘22317’,‘22318’,‘22319’,‘22320’,‘22321’,‘22322’,‘22323’,‘22324’,‘22325’,‘22326’,‘22327’,‘22328’,‘22329’,‘22330’,‘22331’,‘22332’,‘22333’,‘22334’,‘22335’,‘22336’,‘22337’,‘22338’,‘22339’,‘22340’,‘22341’,‘22342’,‘22343’,‘22344’,‘22345’,‘22346’,‘22347’,‘22348’,‘22349’,‘22350’,‘22351’,‘22352’,‘22353’,‘22354’,‘22355’,‘22356’,‘22357’,‘22358’,‘22359’,‘22360’,‘22361’,‘22362’,‘22363’,‘22364’,‘22365’,‘22366’,‘22367’,‘22368’,‘22369’,‘22370’,‘22371’,‘22372’,‘22373’,‘22374’,‘22375’,‘22376’,‘22377’,‘22378’,‘22379’,‘22380’,‘22381’,‘22382’,‘22383’,‘22384’,‘22385’,‘22386’,‘22387’,‘22388’,‘22389’,‘22390’,‘22391’,‘22392’,‘22393’,‘22394’,‘22395’,‘22396’,‘22397’,‘22398’,‘22399’,‘22400’,‘22401’,‘22402’,‘22403’,‘22404’,‘22405’,‘22406’,‘22407’,‘22408’,‘22409’,‘22410’,‘22411’,‘22412’,‘22413’,‘22414’,‘22415’,‘22416’,‘22417’,‘22418’,‘22419’,‘22420’,‘22421’,‘22422’,‘22423’,‘22424’,‘22425’,‘22426’,‘22427’,‘22428’,‘22429’,‘22430’,‘22431’,‘22432’,‘22433’,‘22434’,‘22435’,‘22436’,‘22437’,‘22438’,‘22439’,‘22440’,‘22441’,‘22442’,‘22443’,‘22444’,‘22445’,‘22446’,‘22447’,‘22448’,‘22449’,‘22450’,‘22451’,‘22452’,‘22453’,‘22454’,‘22455’,‘22456’,‘22457’,‘22458’,‘22459’,‘22460’,‘22461’,‘22462’,‘22463’,‘22464’,‘22465’,‘22466’,‘22467’,‘22468’,‘22469’,‘22470’,‘22471’,‘22472’,‘22473’,‘22474’,‘22475’,‘22476’,‘22477’,‘22478’,‘22479’,‘22480’,‘22481’,‘22482’,‘22483’,‘22484’,‘22485’,‘22486’,‘22487’,‘22488’,‘22489’,‘22490’,‘22491’,‘22492’,‘22493’,‘22494’,‘22495’,‘22496’,‘22497’,‘22498’,‘22499’,‘22500’,‘22501’,‘22502’,‘22503’,‘22504’,‘22505’,‘22506’,‘22507’,‘22508’,‘22509’,‘22510’,‘22511’,‘22512’,‘22513’,‘22514’,‘22515’,‘22516’,‘22517’,‘22518’,‘22519’,‘22520’,‘22521’,‘22522’,‘22523’,‘22524’,‘22525’,‘22526’,‘22527’,‘22528’,‘22529’,‘22530’,‘22531’,‘22532’,‘22533’,‘22534’,‘22535’,‘22536’,‘22537’,‘22538’,‘22539’,‘22540’,‘22541’,‘22542’,‘22543’,‘22544’,‘22545’,‘22546’,‘22547’,‘22548’,‘22549’,‘22550’,‘22551’,‘22552’,‘22553’,‘22554’,‘22555’,‘22556’,‘22557’,‘22558’,‘22559’,‘22560’,‘22561’,‘22562’,‘22563’,‘22564’,‘22565’,‘22566’,‘22567’,‘22568’,‘22569’,‘22570’,‘22571’,‘22572’,‘22573’,‘22574’,‘22575’,‘22576’,‘22577’,‘22578’,‘22579’,‘22580’,‘22581’,‘22582’,‘22583’,‘22584’,‘22585’,‘22586’,‘22587’,‘22588’,‘22589’,‘22590’,‘22591’,‘22592’,‘22593’,‘22594’,‘22595’,‘22596’,‘22597’,‘22598’,‘22599’,‘22600’,‘22601’,‘22602’,‘22603’,‘22604’,‘22605’,‘22606’,‘22607’,‘22608’,‘22609’,‘22610’,‘22611’,‘22612’,‘22613’,‘22614’,‘22615’,‘22616’,‘22617’,‘22618’,‘22619’,‘22620’,‘22621’,‘22622’,‘22623’,‘22624’,‘22625’,‘22626’,‘22627’,‘22628’,‘22629’,‘22630’,‘22631’,‘22632’,‘22633’,‘22634’,‘22635’,‘22636’,‘22637’,‘22638’,‘22639’,‘22640’,‘22641’,‘22642’,‘22643’,‘22644’,‘22645’,‘22646’,‘22647’,‘22648’,‘22649’,‘22650’,‘22651’,‘22652’,‘22653’,‘22654’,‘22655’,‘22656’,‘22657’,‘22658’,‘22659’,‘22660’,‘22661’,‘22662’,‘22663’,‘22664’,‘22665’,‘22666’,‘22667’,‘22668’,‘22669’,‘22670’,‘22671’,‘22672’,‘22673’,‘22674’,‘22675’,‘22676’,‘22677’,‘22678’,‘22679’,‘22680’,‘22681’,‘22682’,‘22683’,‘22684’,‘22685’,‘22686’,‘22687’,‘22688’,‘22689’,‘22690’,‘22691’,‘22692’,‘22693’,‘22694’,‘22695’,‘22696’,‘22697’,‘22698’))) ORDER BY sphinx_log.ID ASC LIMIT 1000
[2015-10-28 12:47:42]Sql took - 0.0045177936553955 seconds
[2015-10-28 12:47:43]/
vps-XXXXX-x.dattaweb.com[2031895153][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log WHERE (sphinx_log.ID IS NULL OR ((sphinx_log.ID>‘22198’ AND sphinx_log.DC=‘0’) AND sphinx_log.ID NOT IN (‘22199’,‘22200’,‘22201’,‘22202’,‘22203’,‘22204’,‘22205’,‘22206’,‘22207’,‘22208’,‘22209’,‘22210’,‘22211’,‘22212’,‘22213’,‘22214’,‘22215’,‘22216’,‘22217’,‘22218’,‘22219’,‘22220’,‘22221’,‘22222’,‘22223’,‘22224’,‘22225’,‘22226’,‘22227’,‘22228’,‘22229’,‘22230’,‘22231’,‘22232’,‘22233’,‘22234’,‘22235’,‘22236’,‘22237’,‘22238’,‘22239’,‘22240’,‘22241’,‘22242’,‘22243’,‘22244’,‘22245’,‘22246’,‘22247’,‘22248’,‘22249’,‘22250’,‘22251’,‘22252’,‘22253’,‘22254’,‘22255’,‘22256’,‘22257’,‘22258’,‘22259’,‘22260’,‘22261’,‘22262’,‘22263’,‘22264’,‘22265’,‘22266’,‘22267’,‘22268’,‘22269’,‘22270’,‘22271’,‘22272’,‘22273’,‘22274’,‘22275’,‘22276’,‘22277’,‘22278’,‘22279’,‘22280’,‘22281’,‘22282’,‘22283’,‘22284’,‘22285’,‘22286’,‘22287’,‘22288’,‘22289’,‘22290’,‘22291’,‘22292’,‘22293’,‘22294’,‘22295’,‘22296’,‘22297’,‘22298’,‘22299’,‘22300’,‘22301’,‘22302’,‘22303’,‘22304’,‘22305’,‘22306’,‘22307’,‘22308’,‘22309’,‘22310’,‘22311’,‘22312’,‘22313’,‘22314’,‘22315’,‘22316’,‘22317’,‘22318’,‘22319’,‘22320’,‘22321’,‘22322’,‘22323’,‘22324’,‘22325’,‘22326’,‘22327’,‘22328’,‘22329’,‘22330’,‘22331’,‘22332’,‘22333’,‘22334’,‘22335’,‘22336’,‘22337’,‘22338’,‘22339’,‘22340’,‘22341’,‘22342’,‘22343’,‘22344’,‘22345’,‘22346’,‘22347’,‘22348’,‘22349’,‘22350’,‘22351’,‘22352’,‘22353’,‘22354’,‘22355’,‘22356’,‘22357’,‘22358’,‘22359’,‘22360’,‘22361’,‘22362’,‘22363’,‘22364’,‘22365’,‘22366’,‘22367’,‘22368’,‘22369’,‘22370’,‘22371’,‘22372’,‘22373’,‘22374’,‘22375’,‘22376’,‘22377’,‘22378’,‘22379’,‘22380’,‘22381’,‘22382’,‘22383’,‘22384’,‘22385’,‘22386’,‘22387’,‘22388’,‘22389’,‘22390’,‘22391’,‘22392’,‘22393’,‘22394’,‘22395’,‘22396’,‘22397’,‘22398’,‘22399’,‘22400’,‘22401’,‘22402’,‘22403’,‘22404’,‘22405’,‘22406’,‘22407’,‘22408’,‘22409’,‘22410’,‘22411’,‘22412’,‘22413’,‘22414’,‘22415’,‘22416’,‘22417’,‘22418’,‘22419’,‘22420’,‘22421’,‘22422’,‘22423’,‘22424’,‘22425’,‘22426’,‘22427’,‘22428’,‘22429’,‘22430’,‘22431’,‘22432’,‘22433’,‘22434’,‘22435’,‘22436’,‘22437’,‘22438’,‘22439’,‘22440’,‘22441’,‘22442’,‘22443’,‘22444’,‘22445’,‘22446’,‘22447’,‘22448’,‘22449’,‘22450’,‘22451’,‘22452’,‘22453’,‘22454’,‘22455’,‘22456’,‘22457’,‘22458’,‘22459’,‘22460’,‘22461’,‘22462’,‘22463’,‘22464’,‘22465’,‘22466’,‘22467’,‘22468’,‘22469’,‘22470’,‘22471’,‘22472’,‘22473’,‘22474’,‘22475’,‘22476’,‘22477’,‘22478’,‘22479’,‘22480’,‘22481’,‘22482’,‘22483’,‘22484’,‘22485’,‘22486’,‘22487’,‘22488’,‘22489’,‘22490’,‘22491’,‘22492’,‘22493’,‘22494’,‘22495’,‘22496’,‘22497’,‘22498’,‘22499’,‘22500’,‘22501’,‘22502’,‘22503’,‘22504’,‘22505’,‘22506’,‘22507’,‘22508’,‘22509’,‘22510’,‘22511’,‘22512’,‘22513’,‘22514’,‘22515’,‘22516’,‘22517’,‘22518’,‘22519’,‘22520’,‘22521’,‘22522’,‘22523’,‘22524’,‘22525’,‘22526’,‘22527’,‘22528’,‘22529’,‘22530’,‘22531’,‘22532’,‘22533’,‘22534’,‘22535’,‘22536’,‘22537’,‘22538’,‘22539’,‘22540’,‘22541’,‘22542’,‘22543’,‘22544’,‘22545’,‘22546’,‘22547’,‘22548’,‘22549’,‘22550’,‘22551’,‘22552’,‘22553’,‘22554’,‘22555’,‘22556’,‘22557’,‘22558’,‘22559’,‘22560’,‘22561’,‘22562’,‘22563’,‘22564’,‘22565’,‘22566’,‘22567’,‘22568’,‘22569’,‘22570’,‘22571’,‘22572’,‘22573’,‘22574’,‘22575’,‘22576’,‘22577’,‘22578’,‘22579’,‘22580’,‘22581’,‘22582’,‘22583’,‘22584’,‘22585’,‘22586’,‘22587’,‘22588’,‘22589’,‘22590’,‘22591’,‘22592’,‘22593’,‘22594’,‘22595’,‘22596’,‘22597’,‘22598’,‘22599’,‘22600’,‘22601’,‘22602’,‘22603’,‘22604’,‘22605’,‘22606’,‘22607’,‘22608’,‘22609’,‘22610’,‘22611’,‘22612’,‘22613’,‘22614’,‘22615’,‘22616’,‘22617’,‘22618’,‘22619’,‘22620’,‘22621’,‘22622’,‘22623’,‘22624’,‘22625’,‘22626’,‘22627’,‘22628’,‘22629’,‘22630’,‘22631’,‘22632’,‘22633’,‘22634’,‘22635’,‘22636’,‘22637’,‘22638’,‘22639’,‘22640’,‘22641’,‘22642’,‘22643’,‘22644’,‘22645’,‘22646’,‘22647’,‘22648’,‘22649’,‘22650’,‘22651’,‘22652’,‘22653’,‘22654’,‘22655’,‘22656’,‘22657’,‘22658’,‘22659’,‘22660’,‘22661’,‘22662’,‘22663’,‘22664’,‘22665’,‘22666’,‘22667’,‘22668’,‘22669’,‘22670’,‘22671’,‘22672’,‘22673’,‘22674’,‘22675’,‘22676’,‘22677’,‘22678’,‘22679’,‘22680’,‘22681’,‘22682’,‘22683’,‘22684’,‘22685’,‘22686’,‘22687’,‘22688’,‘22689’,‘22690’,‘22691’,‘22692’,‘22693’,‘22694’,‘22695’,‘22696’,‘22697’,‘22698’))) ORDER BY sphinx_log.ID ASC LIMIT 1000
[2015-10-28 12:47:43]Sql took - 0.0030159950256348 seconds
[2015-10-28 12:47:43]conn took - 0.00095605850219727 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2015-10-28 12:47:43]total conn took 0.0033719539642334 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2015-10-28 12:47:43]conn took - 0.00028085708618164 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2015-10-28 12:47:43]total conn took 0.00037002563476562 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2015-10-28 12:47:43]/
vps-XXXXX-x.dattaweb.com[241223857][sphinx_log] / SELECT sphinx_log_server.ID, sphinx_log_server.SERVER, sphinx_log_server.DC, sphinx_log_server.LAST_LOG_ID, sphinx_log_server.CREATED_AT, sphinx_log_server.UPDATED_AT FROM sphinx_log_server WHERE sphinx_log_server.SERVER=‘127.0.0.1’
[2015-10-28 12:47:43]Sql took - 0.00023078918457031 seconds
[2015-10-28 12:47:43]/
vps-XXXXX-x.dattaweb.com[241223857][sphinx_log] */ SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log WHERE (sphinx_log.ID IS NULL OR ((sphinx_log.ID>‘22198’ AND sphinx_log.DC=‘0’) AND 1=1)) ORDER BY sphinx_log.ID ASC LIMIT 1000
[2015-10-28 12:47:43]Sql took - 0.014333963394165 seconds
[2015-10-28 12:47:43]conn took - 0.00031185150146484 seconds to mysql:host=127.0.0.1;port=9312;
[2015-10-28 12:47:43]Sphinx log id 22199 dc [0] executed server id [1] Memory: [15637216]
[2015-10-28 12:47:43]replace into kaltura_caption_item (id,entry_id,caption_asset_id,tags,content,partner_description,language,label,format,str_entry_id,str_caption_asset_id,int_id,caption_params_id,partner_id,version,caption_asset_status,size,is_default,start_time,end_time,created_at,updated_at) values(13686,‘0_irlhxafm’,‘0_pbi1l8c2’,’’,’ “σπασίκλες” ;’,’’,‘German’,‘Gr’,‘1’,‘0_irlhxafm’,‘13686’,13686,0,102,2,2,231169,0,4480287,4481275,1445979953,1445979711)
[2015-10-28 12:47:43]Sql took - 0.0019750595092773 seconds
[2015-10-28 12:47:43]Sphinx log id 22200 dc [0] executed server id [1] Memory: [15637544]
[2015-10-28 12:47:43]replace into kaltura_caption_item (id,entry_id,caption_asset_id,tags,content,partner_description,language,label,format,str_entry_id,str_caption_asset_id,int_id,caption_params_id,partner_id,version,caption_asset_status,size,is_default,start_time,end_time,created_at,updated_at) values(13687,‘0_irlhxafm’,‘0_pbi1l8c2’,’’,’’,’’,‘German’,‘Gr’,‘1’,‘0_irlhxafm’,‘13687’,13687,0,102,2,2,231169,0,4481275,4482315,1445979953,1445979711)
[2015-10-28 12:47:43]Sql took - 0.00031399726867676 seconds

Hi,

Yes, even when archived, the files are rather big. As I said, since they are only needed for debugging purposes, you can just set a cronjob to rid of the archived logs daily.

Hi again Jess!
How can I stop loggin, I don’t need it.
Why in CE 9x I dont seen that problem? But after a failed /bad update, I have to make a fresh install of CE 10.21… and then this problem…
I think that I changed the verbosity of log a time ago, could it be that?
Many thanks.

Hello,

If you only have one machine, as oppose to a cluster, the populate daemon is not needed and you can simply stop it.
That daemon is used to sync the multiple Sphinx instances, in the event there are such. Sphinx is used to offload the MySQL when doing complex full text searches. If you only have one sphinx instance, it is safe to stop the daemon altogether. Otherwise, as I said, just create a cronjob that rids of old logs.