===========================================
| Component | Version |
|---|---|
| LibreNMS | 24.9.1-41-g76c26dc59 (2024-10-16T23:11:42+02:00) |
| DB Schema | 2024_10_06_002633_ports_vlans_table_add_port_id_index (301) |
| PHP | 8.3.3-1+ubuntu20.04.1+deb.sury.org+1 |
| Python | 3.10.12 |
| Database | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1 |
| RRDTool | 1.7.2 |
| SNMP | 5.9.1 |
| =========================================== |
[OK] Composer Version: 2.8.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK] Database and column collations are correct
[OK] Database schema correct
[OK] MySQL and PHP time match
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached
Hello Community,
We are facing an issue with our billing, specifically with the billing history. The billing history remains empty for the most recently created bills, while all other bills are still functioning correctly.
We have nearly 1200 billings set up on our Libre system. In the meantime, we’ve discovered that the file /opt/librenms/billing-calculate.php is likely responsible for the history. As we currently understand it, this script runs through all billings every hour and updates the history. We found that this process takes between 10 and 15 seconds per billing, and before all billings can be updated, the process starts over again, leaving the most recently created billings out.
Is it normal for this query to take so long? Are we generally on the right track, or could there be another issue?
Since we plan to switch from an old accounting system to Libre Billing for billing our customers by the end of the year, we hope there is a quick solution.
Thank you very much for your help.