Wait for MariaDB service to be ready through VIP error

[Maroš Varchola]

The problem is, that even if the Mariadb database is fully running, reachable and loggable from ip 192.168.0.200, the haproxy 192.168.0.199 not correctly proxy requests to 192.168.0.200 with this error:

fatal: [localhost]: FAILED! => {"attempts": 6, "changed": false, "cmd": ["docker", "exec", "mariadb", "mysql", "-h", "192.168.0.199", "-P", "3307", "-u", "root", "-pRJQAihupg9j8iVEdD3FstlFt6lAH61Hlwb6ZARSA", "-e", "show databases;"], "delta": "0:00:00.157388", "end": "2022-02-03 23:06:00.035050", "msg": "non-zero return code", "rc": 1, "start": "2022-02-03 23:05:59.877662", "stderr": "ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11", "stderr_lines": ["ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11"], "stdout": "", "stdout_lines": []}

Inventory is the basic all-in-one with internal and external ips set, internal+external+backend tls enabled too

Thank you for your answers!

kolla-ansible version: 13.1.0
OS: Ubuntu 20.04.3 LTS
Server ip: 192.168.0.200 /24
Server hostname: srv0
domain name 1: sunray.sk
domain name 2: lan

PS: inventory file in the attachments

[Maroš Varchola (marosvarchola)]

For better debugging, here is the haproxy mariadb.cfg

path: /etc/kolla/haproxy/services.d/mariadb.cfg