librnms.log mariadb

From Steven Gregg, 1 Year ago, written in Plain Text.
URL https://p.libren.ms/view/7ac90268
Embed
Download Paste or View Raw
  1.  
  2. ```
  3. /opt/librenms/poller.php 254 2023-03-28 02:31:04 - 1 devices polled in 3.028 secs
  4. /opt/librenms/poller.php 263 2023-03-28 02:31:05 - 1 devices polled in 2.769 secs
  5. /opt/librenms/poller.php 230 2023-03-28 02:31:05 - 1 devices polled in 2.976 secs
  6. /opt/librenms/discovery.php new 2023-03-28 02:35:01 - 0 devices discovered in 0.001 secs
  7. /opt/librenms/discovery.php new 2023-03-28 02:40:01 - 0 devices discovered in 0.001 secs
  8. /opt/librenms/discovery.php new 2023-03-28 02:45:01 - 0 devices discovered in 0.001 secs
  9. /opt/librenms/discovery.php new 2023-03-28 02:50:01 - 0 devices discovered in 0.001 secs
  10. /opt/librenms/discovery.php new 2023-03-28 02:55:02 - 0 devices discovered in 0.001 secs
  11. /opt/librenms/discovery.php new 2023-03-28 03:00:01 - 0 devices discovered in 0.002 secs
  12. /opt/librenms/discovery.php new 2023-03-28 03:05:01 - 0 devices discovered in 0.001 secs
  13. /opt/librenms/discovery.php new 2023-03-28 03:10:01 - 0 devices discovered in 0.002 secs
  14. /opt/librenms/discovery.php new 2023-03-28 03:15:02 - 0 devices discovered in 0.002 secs
  15. /opt/librenms/discovery.php new 2023-03-28 03:20:03 - 0 devices discovered in 0.005 secs
  16. [2023-03-28T03:29:57.056680+13:00] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (18.1, 19.3, 18.8, 3, 3, 0, {"poller_name":"librenms"}, 2>
  17. [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
  18. [previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)"}
  19. [2023-03-28T03:29:57.043718+13:00] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (18.9, 20.8, 19.6, 3, 3, 0, {"poller_name":"librenms"}, 2>
  20. [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
  21. [previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)"}
  22. [2023-03-28T03:29:57.050180+13:00] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (31.7, 31.8, 31.8, 3, 3, 0, {"poller_name":"librenms"}, 2>
  23. [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
  24. [previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)"}
  25. ```
  26.  
  27. etc etc
  28.  
  29. ```
  30. [2023-03-28T03:29:58.224890+13:00] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: update `cache_locks` set `owner` = GcBGnu8TyiBMqiG6, `expiration` = 1679927457 where `key` = laravel_cachealerts and (`owner` = GcBGnu8TyiBMqiG6 or `expiration` <= 16799>
  31. [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)
  32. [previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)"}
  33. [2023-03-28T03:29:58.861725+13:00] production.ERROR: PDOException: SQLSTATE[HY000] [2002] Connection refused in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
  34. Stack trace:
  35. #0 /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO->__construct()
  36. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
  37. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
  38. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
  39. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
  40. #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
  41. #6 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
  42. #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1064): call_user_func()
  43. #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
  44. #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
  45. #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
  46. #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
  47. #12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
  48. #13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
  49. #14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
  50. #15 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run()
  51. #16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
  52. #17 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
  53. #18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
  54. #19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
  55. #20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
  56. #21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
  57. #22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(294): Illuminate\Database\Eloquent\Builder->get()
  58. #23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(474): Illuminate\Database\Eloquent\Builder->first()
  59. #24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(508): Illuminate\Database\Eloquent\Builder->firstOrNew()
  60. #25 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
  61. #26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2132): Illuminate\Database\Eloquent\Model->forwardCallTo()
  62. #27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2144): Illuminate\Database\Eloquent\Model->__call()
  63. #28 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
  64. #29 /opt/librenms/LibreNMS/Config.php(460): LibreNMS\Config::persist()
  65. #30 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
  66. #31 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
  67. #32 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
  68. #33 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
  69. #34 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
  70. #35 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
  71. #36 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\Container\BoundMethod::call()
  72. #37 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(924): Illuminate\Container\Container->call()
  73. #38 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(905): Illuminate\Foundation\Application->bootProvider()
  74. #39 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
  75. #40 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(906): array_walk()
  76. #41 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
  77. #42 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(237): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
  78. #43 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(310): Illuminate\Foundation\Application->bootstrapWith()
  79. #44 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
  80. #45 /opt/librenms/includes/init.php(88): LibreNMS\Util\Laravel::bootCli()
  81. #46 /opt/librenms/poller.php(35): require('...')
  82. #47 {main}
  83. Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [2002] Connection refused in /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  84. Stack trace:
  85. #0 /opt/librenms/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(44): Doctrine\DBAL\Driver\PDO\Exception::new()
  86. #1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
  87. #2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
  88. #3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
  89. #4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
  90. #5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
  91. #6 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
  92. #7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1064): call_user_func()
  93. #8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
  94. #9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
  95. #10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
  96. #11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
  97. #12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
  98. #13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
  99. #14 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
  100. #15 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run()
  101. #16 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
  102. #17 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
  103. #18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
  104. #19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
  105. #20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
  106. #21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
  107. #22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(294): Illuminate\Database\Eloquent\Builder->get()
  108. #23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(474): Illuminate\Database\Eloquent\Builder->first()
  109. #24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(508): Illuminate\Database\Eloquent\Builder->firstOrNew()
  110. #25 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
  111. #26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2132): Illuminate\Database\Eloquent\Model->forwardCallTo()
  112. #27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2144): Illuminate\Database\Eloquent\Model->__call()
  113. #28 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
  114. #29 /opt/librenms/LibreNMS/Config.php(460): LibreNMS\Config::persist()
  115. #30 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
  116. #31 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
  117. #32 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
  118. #33 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
  119. #34 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
  120. #35 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
  121. #36 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\Container\BoundMethod::call()
  122. #37 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(924): Illuminate\Container\Container->call()
  123. #38 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(905): Illuminate\Foundation\Application->bootProvider()
  124. #39 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
  125. #40 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(906): array_walk()
  126. #41 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
  127. #42 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(237): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
  128. #43 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(310): Illuminate\Foundation\Application->bootstrapWith()
  129. #44 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
  130. #45 /opt/librenms/includes/init.php(88): LibreNMS\Util\Laravel::bootCli()
  131. #46 /opt/librenms/poller.php(35): require('...')
  132. #47 {main}
  133. ```
  134.  
  135. etc
  136.  


Reply to "librnms.log mariadb"