Homer fails to capture after a few days of running

[arainero]

Hello,

It appears that Homer stops capturing data after being ran for a few days. If I do a docker-compose down and docker-compose up Homer starts to capture and display new data again. Old data is still accessible.

I do not know for certain, but I suspect it has to do with rotation. Any advice would be appreciated.

[lmangani]

Hi @arainero this sounds definitely like rotation - we're working this issue, for now in order to confirm could you execute the rotation script manually inside the container?

[arainero]

Executing /opt/homer_mysql_rotate.pl in the homer-cron container appears to have resolved this issue for now.

[lmangani]

If anyone feels brave enough to give take this for a spin and improve it, I hacked together a test image at sipcapture/homer-nocron which should just do fine with a dynamic sleep timer instead of an actual cron job for something so simple, should hot-swap replace homer-cron in a compose

[DJM0]

I'm having the same issue. I'm having to run /opt/homer_mysql_rotate.pl every week or so, I'm guessing the cron isn't actually running but I can't see any obvious errors.

@lmangani I'm going to give sipcapture/homer-nocron a go.

[lmangani]

Hi @davidmaitland please let me know your results, this seems to be a common issue it could solve, but needs some hands to test

[DJM0]

@lmangani it's stuck in a restart loop at the moment. Any ideas? Let me know if you want me to create a new issue for this.

2017-11-06T17:50:20.461575626Z Use of uninitialized value $partstep in array element at /opt/homer_mysql_rotate.pl line 255.
2017-11-06T17:50:20.461631050Z Use of uninitialized value $partstep in array element at /opt/homer_mysql_rotate.pl line 256.
2017-11-06T17:50:20.462681146Z Use of uninitialized value $partstep in numeric gt (>) at /opt/homer_mysql_rotate.pl line 511.
2017-11-06T17:50:20.462700393Z Use of uninitialized value $partstep in numeric gt (>) at /opt/homer_mysql_rotate.pl line 511.
2017-11-06T17:50:20.548744061Z Use of uninitialized value $partstep in array element at /opt/homer_mysql_rotate.pl line 255.
2017-11-06T17:50:20.548771980Z Use of uninitialized value $partstep in array element at /opt/homer_mysql_rotate.pl line 256.
2017-11-06T17:50:20.549698607Z Use of uninitialized value $partstep in numeric gt (>) at /opt/homer_mysql_rotate.pl line 511.
2017-11-06T17:50:20.549713034Z Use of uninitialized value $partstep in numeric gt (>) at /opt/homer_mysql_rotate.pl line 511.
2017-11-06T17:50:20.566747361Z bash: sleep_until: command not found

[lmangani]

@davidmaitland if you could post that in the homer-nocron repo we can quickly resolve it, thanks!

[arainero]

I don't know if this is related or not, but I haven't had this issue occur again after changing adding "define('RTCP_TABLE_PARTITION', 0);" to webapp/preferences.php.