Ad Widget

**Markku** · 31-05-2021, 20:47

Hi, database says that you have too many connections. Are you sure you haven't overly configured your Zabbix server, like the number of trappers or unreachable pollers?

If you know your Zabbix server is configured appropriately, you need to search for increasing the connection limit on your MariaDB.

Markku

**[email protected]** · 01-06-2021, 01:02

Hi Qais,

What is in the database logs?

If in the zabbix configuration the number of server processes that connect to the database system is larger that the maximum allowed connections to the database (i.e. History Syncers, Pollers etc...).

To resolve this you can do:

Lower the number of configured processes connecting to the database.
Increase the max connections allowed to the database (MySQL /etc/my.cnf max_connections)
Use database connection pooling software (PostgreSQL we use pgbouncer, MySQL im not sure of as we dont use this database)

As a note it may be more efficient to use connection pooling when there are a large number of connections (example details: https://stackoverflow.blog/2020/10/1...ection-pooling)

Cheers
James

**Qais** · 01-06-2021, 15:22

Thank you, James, Markku

The reason was that I configured the number of trappers and unreachable pollers as you said.
The issue solved by increasing the max connection number in the MySQL configuration file.

again thanks for your response,

**jolalla** · 01-06-2021, 15:26

Hello all

I need your help. Please.

Install a new zabbix server with the following features:
Centos7
Zabbix version: 5.0
Mysql: 15.1 Distrib: 10.4.19 Maria DB
PHP 7.2

it's a fresh install so i have nothing to back up because i haven't added any hosts yet.
On the centos server create a partition for the DB (/ data). I followed the instructions on how to change the mysql database directory. I validated it with @@ datadir inside mysql and it was correct in:
: / data / mysql

But the web interface is not working for me now. shows me error:

Database error
No such file or directory

I went to the php.ini configuration file located at:
/etc/opt/remi/php72/php.ini and there add the new socket path and it looks like this:

pdo_mysql.default_socket=/data/mysql/mysql.sock

mysqli.default_socket =/data/mysql/mysql.sock

And restart the service httpd But it still doesn't work for me, what else should I modify?

Thank you very much for your help.

I leave here the error message that gives me and how is the directory of the DB after having changed it to the new partition.

Attached Files

**jolalla** · 01-06-2021, 15:39

you're right Markku.. Thanks, I'll create a new topic and excuse me.

Ad Widget

Zabbix down connection to database failed: [1040] Too many connections

Zabbix down connection to database failed: [1040] Too many connections

Comment

Comment

Comment

Comment

Comment