Good Morning,
after a MariaDB database issues I had to export and re-import my LibreNMW database.
./daily.sh
Re-running /opt/librenms/daily.sh as librenms user
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Caching Mac OUI data OK
sudo -u librenms /opt/librenms/validate.php
Component | Version |
---|---|
LibreNMS | 21.10.0-95-g1ff48018f |
DB Schema | 2021_10_20_224207_increase_length_of_attrib_type_column (224) |
PHP | 7.4.25 |
Python | 3.9.2 |
MySQL | 10.5.12-MariaDB-0+deb11u1 |
RRDTool | 1.7.2 |
SNMP | NET-SNMP 5.9 |
====================================
[OK] Composer Version: 2.1.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
Since then, I am having issues when using the Traffic Bills GUI.
- [Accurate Graphs] are not showing any graphs
- [Transfer Graphs] Whoops, looks like something went wrong. Check your librenms.log.
Any ideas would be aprecciated.
Thank you,
Wolfgang
Logfile is showing this:
[2021-11-07 17:19:04] production.ERROR: count(): Argument #1 ($value) must be of type Countable|array, null given {“userId”:1,“exception”:"[object] (TypeError(code: 0): count(): Argument #1 ($value) must be of type Countable|array, null given at /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php:2578)
[stacktrace]
#0 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(2578): count()
#1 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1459): Amenadiel\JpGraph\Graph\Graph->GetLinesYMinMax()
#2 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1647): Amenadiel\JpGraph\Graph\Graph->doAutoScaleYAxis()
#3 /opt/librenms/includes/html/graphs/bill/historicbits.inc.php(140): Amenadiel\JpGraph\Graph\Graph->Stroke()
#4 /opt/librenms/includes/html/graphs/graph.inc.php(44): include(’…’)
#5 /opt/librenms/html/graph.php(29): require(’…’)
#6 {main}
"}
[2021-11-07 17:19:04] production.ERROR: count(): Argument #1 ($value) must be of type Countable|array, null given {“userId”:1,“exception”:"[object] (TypeError(code: 0): count(): Argument #1 ($value) must be of type Countable|array, null given at /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php:2578)
[stacktrace]
#0 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(2578): count()
#1 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1459): Amenadiel\JpGraph\Graph\Graph->GetLinesYMinMax()
#2 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1647): Amenadiel\JpGraph\Graph\Graph->doAutoScaleYAxis()
#3 /opt/librenms/includes/html/graphs/bill/historicbits.inc.php(140): Amenadiel\JpGraph\Graph\Graph->Stroke()
#4 /opt/librenms/includes/html/graphs/graph.inc.php(44): include(’…’)
#5 /opt/librenms/html/graph.php(29): require(’…’)
#6 {main}
"}
[2021-11-07 17:19:04] production.ERROR: count(): Argument #1 ($value) must be of type Countable|array, null given {“userId”:1,“exception”:"[object] (TypeError(code: 0): count(): Argument #1 ($value) must be of type Countable|array, null given at /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php:2578)
[stacktrace]
#0 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(2578): count()
#1 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1459): Amenadiel\JpGraph\Graph\Graph->GetLinesYMinMax()
#2 /opt/librenms/vendor/amenadiel/jpgraph/src/graph/Graph.php(1647): Amenadiel\JpGraph\Graph\Graph->doAutoScaleYAxis()
#3 /opt/librenms/includes/html/graphs/bill/historicbits.inc.php(140): Amenadiel\JpGraph\Graph\Graph->Stroke()
#4 /opt/librenms/includes/html/graphs/graph.inc.php(44): include(’…’)
#5 /opt/librenms/html/graph.php(29): require(’…’)
#6 {main}
"}
/opt/librenms/poller.php 18 2021-11-07 17:19:07 - 1 devices polled in 5.155 secs
[2021-11-07 17:19:09] production.ERROR: Division by zero {“userId”:1,“exception”:"[object] (DivisionByZeroError(code: 0): Division by zero at /opt/librenms/includes/html/pages/bill/transfer.inc.php:72)
[stacktrace]
#0 /opt/librenms/includes/html/pages/bill.inc.php(132): include()
#1 /opt/librenms/app/Http/Controllers/LegacyController.php(54): require(’…’)
#2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\LegacyController->index()
#3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction()
#4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Router.php(695): Illuminate\Routing\Route->run()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#8 /opt/librenms/app/Http/Middleware/LoadUserPreferences.php(30): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\Http\Middleware\LoadUserPreferences->handle()
#10 /opt/librenms/app/Http/Middleware/VerifyTwoFactor.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\Http\Middleware\VerifyTwoFactor->handle()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle()
#14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#15 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle()
#16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Session/Middleware/AuthenticateSession.php(58): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#17 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\AuthenticateSession->handle()
#18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(44): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Auth\Middleware\Authenticate->handle()
#20 /opt/librenms/app/Http/Middleware/LegacyExternalAuth.php(42): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\Http\Middleware\LegacyExternalAuth->handle()
#22 /opt/librenms/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle()
#24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#25 /opt/librenms/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest()
#26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle()
#27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#28 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle()
#29 /opt/librenms/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#30 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle()
#31 /opt/librenms/app/Http/Middleware/CheckInstalled.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#32 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): App\Http\Middleware\CheckInstalled->handle()
#33 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#34 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Router.php(697): Illuminate\Pipeline\Pipeline->then()
#35 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Router.php(672): Illuminate\Routing\Router->runRouteWithinStack()
#36 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Router.php(636): Illuminate\Routing\Router->runRoute()
#37 /opt/librenms/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\Routing\Router->dispatchToRoute()
#38 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(166): Illuminate\Routing\Router->dispatch()
#39 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#40 /opt/librenms/vendor/genealabs/laravel-caffeine/src/Http/Middleware/LaravelCaffeineDripMiddleware.php(11): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): GeneaLabs\LaravelCaffeine\Http\Middleware\LaravelCaffeineDripMiddleware->handle()
#42 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#43 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#44 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#45 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#46 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#47 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#48 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#49 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle()
#50 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#51 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#52 /opt/librenms/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#53 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle()
#54 /opt/librenms/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#55 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Http\Middleware\TrustProxies->handle()
#56 /opt/librenms/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#57 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(141): Illuminate\Pipeline\Pipeline->then()
#58 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#59 /opt/librenms/html/index.php(52): Illuminate\Foundation\Http\Kernel->handle()
#60 {main}
"}