web show Error connecting to database

[Justtestbot]

The problem

Hello All
When I was logging into the web, I encountered an error message and was unable to open the webpage correctly. I found that it might be an issue related to SQL communication. How can this be resolved? Thank you.

This problem first occurred on January 27, 2024 (UTC+8) in the early morning. After restarting my LibreNMS VM, the issue was temporarily resolved. However, the next day in the early morning (which is now), the problem recurred. This time, I tried to restart the MariaDB service alone but encountered an error and couldn't restart MariaDB. Therefore, I had no choice but to reboot the entire VM again.

Output of ./validate.php

librenms@XXX-librenms:/home/user1$ /opt/librenms/validate.php
===========================================
Component | Version
--------- | -------
LibreNMS  | 24.1.0-51-g30953c386 (2024-01-31T22:56:59+08:00)
DB Schema | 2024_01_09_211518_custom_map_node_maplink (287)
PHP       | 8.1.2-1ubuntu2.14
Python    | 3.10.12
Database  | MariaDB 10.6.16-MariaDB-0ubuntu0.22.04.1
RRDTool   | 1.7.2
SNMP      | 5.9.1
===========================================

[OK]    Composer Version: 2.6.6
[OK]    Dependencies up-to-date.
[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
[INFO]  fping FAILURES can be ignored if running LibreNMS in a jail without ::1. You may want to test it manually: fping ::1
[FAIL]  /usr/bin/fping6 could not be executed. /usr/bin/fping6 must have CAP_NET_RAW capability (getcap) or suid. Selinux exclusions may be required.
 (/usr/bin/fping6: can't create socket (must run as root?))
[FAIL]  /usr/bin/fping6 should have CAP_NET_RAW!
        [FIX]:
        setcap cap_net_raw+ep /usr/bin/fping6
[OK]    rrd_dir is writable
[OK]    rrdtool version ok

What was the last working version of LibreNMS?

No response

Anything in the logs that might be useful for us?

/opt/librenms/logs$ tail -n 50 librenms.log
#31 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#32 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#33 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#34 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#35 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
#36 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1012): array_walk()
#37 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#38 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#39 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#40 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
#41 /opt/librenms/includes/init.php(90): LibreNMS\Util\Laravel::bootCli()
#42 /opt/librenms/alerts.php(34): require('...')
#43 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [1040] Too many connections (Connection: mysql, SQL: select * from `config` where (`config_name` = snmp.unescape) limit 1) in /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822
Stack trace:
#0 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(776): Illuminate\Database\Connection->runQueryCallback()
#1 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Connection.php(424): Illuminate\Database\Connection->run()
#2 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2752): Illuminate\Database\Connection->select()
#3 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2740): Illuminate\Database\Query\Builder->runSelect()
#4 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3294): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2741): Illuminate\Database\Query\Builder->onceWithColumns()
#6 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(737): Illuminate\Database\Query\Builder->get()
#7 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(721): Illuminate\Database\Eloquent\Builder->getModels()
#8 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(333): Illuminate\Database\Eloquent\Builder->get()
#9 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(566): Illuminate\Database\Eloquent\Builder->first()
#10 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(598): Illuminate\Database\Eloquent\Builder->firstOrCreate()
#11 /opt/librenms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->updateOrCreate()
#12 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2334): Illuminate\Database\Eloquent\Model->forwardCallTo()
#13 /opt/librenms/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2346): Illuminate\Database\Eloquent\Model->__call()
#14 /opt/librenms/LibreNMS/Config.php(262): Illuminate\Database\Eloquent\Model::__callStatic()
#15 /opt/librenms/LibreNMS/Config.php(474): LibreNMS\Config::persist()
#16 /opt/librenms/LibreNMS/Config.php(61): LibreNMS\Config::processConfig()
#17 /opt/librenms/app/Providers/ConfigServiceProvider.php(27): LibreNMS\Config::load()
#18 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Providers\ConfigServiceProvider->boot()
#19 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#20 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure()
#21 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod()
#22 /opt/librenms/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\Container\BoundMethod::call()
#23 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1030): Illuminate\Container\Container->call()
#24 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1011): Illuminate\Foundation\Application->bootProvider()
#25 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}()
#26 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1012): array_walk()
#27 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17): Illuminate\Foundation\Application->boot()
#28 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(263): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap()
#29 /opt/librenms/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(447): Illuminate\Foundation\Application->bootstrapWith()
#30 /opt/librenms/LibreNMS/Util/Laravel.php(44): Illuminate\Foundation\Console\Kernel->bootstrap()
#31 /opt/librenms/includes/init.php(90): LibreNMS\Util\Laravel::bootCli()
#32 /opt/librenms/alerts.php(34): require('...')
#33 {main}



MariaDB [(none)]> show full processlist;
+------+----------+-----------+----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------+----------+
| Id   | User     | Host      | db       | Command | Time | State        | Info                                                                                                                                | Progress |
+------+----------+-----------+----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------+----------+
|   31 | librenms | localhost | librenms | Execute | 5993 | Update       | INSERT IGNORE INTO `syslog` (`device_id`,`program`,`facility`,`priority`,`level`,`tag`,`msg`,`timestamp`)  VALUES (?,?,?,?,?,?,?,?) |    0.000 |
| 6398 | librenms | localhost | librenms | Execute | 6253 | Updating     | DELETE FROM `syslog` WHERE seq >= ? AND timestamp < DATE_SUB(NOW(), INTERVAL ? DAY)                                                 |    0.000 |
| 7332 | librenms | localhost | librenms | Execute | 5988 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7333 | librenms | localhost | librenms | Execute | 5986 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7334 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7335 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7336 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7337 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7338 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7339 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7340 | librenms | localhost | librenms | Execute | 5926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7341 | librenms | localhost | librenms | Execute | 5866 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7342 | librenms | localhost | librenms | Execute | 5806 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7343 | librenms | localhost | librenms | Execute | 5746 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7344 | librenms | localhost | librenms | Execute | 5686 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7345 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7346 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7347 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7348 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7349 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7350 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7351 | librenms | localhost | librenms | Execute | 5626 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7352 | librenms | localhost | librenms | Execute | 5567 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7353 | librenms | localhost | librenms | Execute | 5507 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7354 | librenms | localhost | librenms | Execute | 5447 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7355 | librenms | localhost | librenms | Execute | 5387 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7356 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7357 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7358 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7359 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7360 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7361 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7362 | librenms | localhost | librenms | Execute | 5327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7363 | librenms | localhost | librenms | Execute | 5267 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7364 | librenms | localhost | librenms | Execute | 5267 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7365 | librenms | localhost | librenms | Execute | 5207 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7366 | librenms | localhost | librenms | Execute | 5147 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7367 | librenms | localhost | librenms | Execute | 5087 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7368 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7369 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7370 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7371 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7372 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7373 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7374 | librenms | localhost | librenms | Execute | 5027 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7375 | librenms | localhost | librenms | Execute | 4966 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7376 | librenms | localhost | librenms | Execute | 4906 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7377 | librenms | localhost | librenms | Execute | 4846 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7378 | librenms | localhost | librenms | Execute | 4786 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7379 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7380 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7381 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7382 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7383 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7384 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7385 | librenms | localhost | librenms | Execute | 4726 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7386 | librenms | localhost | librenms | Execute | 4666 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7387 | librenms | localhost | librenms | Execute | 4606 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7388 | librenms | localhost | librenms | Execute | 4546 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7389 | librenms | localhost | librenms | Execute | 4486 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7390 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7391 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7392 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7393 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7394 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7395 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7396 | librenms | localhost | librenms | Execute | 4426 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7397 | librenms | localhost | librenms | Execute | 4367 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7398 | librenms | localhost | librenms | Execute | 4307 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7399 | librenms | localhost | librenms | Execute | 4247 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7400 | librenms | localhost | librenms | Execute | 4187 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7401 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7402 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7403 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7404 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7405 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7406 | librenms | localhost | librenms | Execute | 4127 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7407 | librenms | localhost | librenms | Execute | 4126 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7408 | librenms | localhost | librenms | Execute | 4067 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7409 | librenms | localhost | librenms | Execute | 4007 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7410 | librenms | localhost | librenms | Execute | 3947 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7411 | librenms | localhost | librenms | Execute | 3887 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7412 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7413 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7414 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7415 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7416 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7417 | librenms | localhost | librenms | Execute | 3827 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7418 | librenms | localhost | librenms | Execute | 3826 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7419 | librenms | localhost | librenms | Execute | 3767 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7420 | librenms | localhost | librenms | Execute | 3707 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7421 | librenms | localhost | librenms | Execute | 3647 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7422 | librenms | localhost | librenms | Execute | 3587 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7423 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7424 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7425 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7426 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7427 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7428 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7429 | librenms | localhost | librenms | Execute | 3527 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7430 | librenms | localhost | librenms | Execute | 3466 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7431 | librenms | localhost | librenms | Execute | 3406 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7432 | librenms | localhost | librenms | Execute | 3346 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7433 | librenms | localhost | librenms | Execute | 3286 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7434 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7435 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7436 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7437 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7438 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7439 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7440 | librenms | localhost | librenms | Execute | 3227 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7441 | librenms | localhost | librenms | Execute | 3167 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7442 | librenms | localhost | librenms | Execute | 3107 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7443 | librenms | localhost | librenms | Execute | 3047 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7444 | librenms | localhost | librenms | Execute | 2987 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7445 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7446 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7447 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7448 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7449 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7450 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7451 | librenms | localhost | librenms | Execute | 2926 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7452 | librenms | localhost | librenms | Execute | 2867 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7453 | librenms | localhost | librenms | Execute | 2807 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7454 | librenms | localhost | librenms | Execute | 2747 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7455 | librenms | localhost | librenms | Execute | 2687 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7456 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7457 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7458 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7459 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7460 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7461 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7462 | librenms | localhost | librenms | Execute | 2627 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7463 | librenms | localhost | librenms | Execute | 2567 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7464 | librenms | localhost | librenms | Execute | 2507 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7465 | librenms | localhost | librenms | Execute | 2447 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7466 | librenms | localhost | librenms | Execute | 2387 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7467 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7468 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7469 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7470 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7471 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7472 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7473 | librenms | localhost | librenms | Execute | 2327 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7474 | librenms | localhost | librenms | Execute | 2267 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7475 | librenms | localhost | librenms | Execute | 2207 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7476 | librenms | localhost | librenms | Execute | 2147 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7477 | librenms | localhost | librenms | Execute | 2087 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7478 | librenms | localhost | librenms | Execute | 2026 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7479 | librenms | localhost | librenms | Execute | 2026 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 7480 | librenms | localhost | librenms | Execute | 2026 | Sending data | select `config_name`, `config_value` from `config`                                                                                  |    0.000 |
| 8719 | root     | localhost | NULL     | Query   |    0 | starting     | show full processlist                                                                                                               |    0.000 |
+------+----------+-----------+----------+---------+------+--------------+-------------------------------------------------------------------------------------------------------------------------------------+----------+
152 rows in set (0.001 sec)

MariaDB [(none)]> show variables like '%max_connections%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| extra_max_connections | 1     |
| max_connections       | 151   |
+-----------------------+-------+
2 rows in set (0.001 sec)

MariaDB [(none)]> show global status like 'Max_used_connections';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 152   |
+----------------------+-------+
1 row in set (0.001 sec)

MariaDB [(none)]> show variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.001 sec)