Aborted connection 155 to db on Postfix Mail Server

Started by ReaHaas, September 06, 2021, 11:23:42 PM

Previous topic - Next topic

ReaHaas

Hi,
i have problem with my cwp server.
I think this is the reason why i can't send or receive any email.
This massage appear on Postfix Mail Server:

[Warning] Aborted connection 155 to db: 'root_cwp' user: 'root' host: 'localhost' (Got an error reading communication packets)
[Warning] Aborted connection 154 to db: 'postfix_policyd' user: 'root' host: 'localhost' (Got an error reading communication packets)
[Warning] Aborted connection 153 to db: 'postfix' user: 'postfix' host: 'localhost' (Got an error reading communication packets)


How to solve this problem?
Thank you for your respon :)

venty

Hi,

Does anyone offer a solution to this issue?

Thanks in advance!

BR
Venty

overseer

In / etc / my.cnf add this under [mysqld]
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=3600
net_write_timeout=3600

Restart mariadb.

venty

Quote from: overseer on June 04, 2025, 12:56:20 PM
In / etc / my.cnf add this under [mysqld]
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=3600
net_write_timeout=3600

Restart mariadb.

Hi,

Thank you very much for the answer .....

You recommend that I enter a code in a place within a file /etc/my.cnf ... In a file, I can't find the place where to enter the code, please help? I am with AL9...

Thanks in advance!

BR
Venty

overseer



overseer

You can put it in / etc /my.cnf.d/server.cnf if that's how you have things configured. Classically, there is a section in my.cnf.

venty

Hi,

appeared again...

.... mariadbd[4869]: 2025-06-04 19:31:08 3126 [Warning] Aborted connection 3126 to db: 'postfix' user: 'postfix' host: 'localhost' (Got an error reading communication packets)

venty

Quote from: overseer on June 04, 2025, 12:56:20 PM
In / etc / my.cnf add this under [mysqld]
innodb_buffer_pool_size=100M
max_allowed_packet=1024M
net_read_timeout=3600
net_write_timeout=3600

Restart mariadb.

Hi,

thank you very much for the answers...
I put the code where you told me..., the number of times this message appears has decreased, but it still appears - can I touch any of the values ​​to minimize this error...

Thanks in advance!

BR
Venty

overseer

Have you run a MySQL Tuner on your server so it could recommend settings for you?
https://github.com/major/MySQLTuner-perl