For 1 month now, i am forced to reboot my servers each day, because when daily.h runs, memory start increasing until beginning swapping.
Please, paste output from ./validate.php
Also manually run ./daily.sh to check where is it “stucking”
I do not have the idea to do this manually 
./validate.php :
| Component | Version |
|---|---|
| LibreNMS | 1.62-111-gd4225806a |
| DB Schema | 2020_04_13_150500_add_last_error_fields_to_bgp_peers (430) |
| PHP | 7.2.24-0ubuntu0.18.04.4 |
| MySQL | 10.1.44-MariaDB-0ubuntu0.18.04.1 |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.7.3 |
| ==================================== |
[OK] Composer Version: 1.10.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
And ./daily.sh
The scripts blocks during “Cleaning up DB” and it’s the process “php /opt/librenms/daily.php -f recalculate_device_dependencies” that is blocking
I started to implement dependancies few weeks before the problem.
I am in a distributed environnement, with :
- Main server : Web + SQL + Poller
- Dedicated RRD Server
- 6 Pollers
After verification, each poller has the same device dependencies check process blocking.
Question : Each time daily.sh is launched, the cleanup DB process is launched. Is there a way to tell “daily.sh” to do the cleanup DB only on the main server, and not on the pollers ?
Thanks to @pointybird reply on this post ./daily.sh - Cleaning UP DB is suddenly taking a long time
RESOLVED : I had 2 devices that point each other as a dependency. Once resolved, everything was OK
1 Like