Z-Push MariaDB aborted connection
-
Hy all!
I have some warnings in my database log:
[Warning] Aborted connection 155 to db: ‘db’ user: ‘*user’ host: ‘localhost’ (Got an error reading communication packets)
It occurs in every 3 min. I have the latest stable z-push, PHP 7.2.6-1, MariaDB 10.3.7 and apache webserver on my Ubuntu 18.04 LTS server with 32GB ram. The backend is IMAPBackend, and IPC-memcached is installed.
Has anyone warning like this?
NKelemen18
-
Hi NKelemen18,
what makes you think Z-Push is causing this? Are you using SQL StateMachine? Are there any errors/hints in Z-Push log?
Manfred
-
Hi Manfred,
I can’t find any relevant entry in z-push log files. The error log entry in my first comment is from journalctl mysql log, the db is my z-push instance’s database and the user is the MySQL user used by (only) z-push. A few minutes ago I installed the 18.04 final release, But the warnings didn’t disappear. And yes I’m using SQL StateMachine. Should I switch back to File StateMachine?
This warnings not affects my DB, but the warnings brother me.Thanks for your reply.
Norbert -
Hi NKelemen18,
the only thing I can think of is because Z-Push uses persistent connections to the database and they are being dropped at some point. You could try setting PDO::ATTR_PERSISTENT to false in the sqlstatemachine config and check if these messages still appear in the mysql log.
Manfred
-
Dear Manfred,
This fixed my problem, thank you :)
Probably I will try to play with timeout values in MariaDB config,Best regards,
NKelemen18