Aborted connection to db: 'querybook2' user: 'test' host: 'x.x.x.x' (Got an error reading communication packets)

[anton-kazanov]

Greetings to you all!

I'm trying to deploy the QueryBook using your official Helm chart.
Making some fixes in helm/values.yaml (see at the bottom) I deployed the querybook into the dev cluster.
Now, I see something strange in the logs of mysql pod:
2023-11-13 17:16:47 233 [Warning] Aborted connection 233 to db: 'unconnected' user: 'unauthenticated' host: '10.x.x.x' (This connection closed normally without authentication) 2023-11-13 17:17:16 234 [Warning] Aborted connection 234 to db: 'querybook2' user: 'test' host: '10.x.x.x' (Got an error reading communication packets) 2023-11-13 17:17:17 235 [Warning] Aborted connection 235 to db: 'unconnected' user: 'unauthenticated' host: '10.x.x.x' (This connection closed normally without authentication)

I'm interested only in default connection for user 'test' which should work, but doesn't.
I tried to connect to DB using 'mysql' command which are inside of the pod with mysql and it works (show me the MariaDB [querybook2]> console):
mysql -h mysql-querybook -P 3306 -u test -ppassw0rd -D querybook2 --default-character-set=utf8mb4

My helm/values.yaml:

worker:
  replicaCount: 1
  name: worker-querybook
  image:
    repository: querybook/querybook
    pullPolicy: IfNotPresent
    tag: latest
  resources:
    requests:
      memory: 700Mi
      cpu: 700m
    limits:
      memory: 1000Mi
      cpu: 1

scheduler:
  replicaCount: 1
  name: scheduler-querybook
  image:
    repository: querybook/querybook
    pullPolicy: IfNotPresent
    tag: latest
  resources:
    requests:
      memory: '200Mi'
      cpu: '100m'
    limits:
      memory: '200Mi'
      cpu: '100m'

web:
  replicaCount: 1
  name: web-querybook
  image:
    repository: querybook/querybook
    pullPolicy: IfNotPresent
    tag: latest
  service:
    serviceType: ClusterIP
    servicePort: 80
    containerPort: 10001
  resources:
    requests:
      memory: 1Gi
      cpu: 1
    limits:
      memory: 3Gi
      cpu: 1

mysql:
  enabled: true
  replicaCount: 1
  name: mysql-querybook
  image:
    repository: mariadb
    pullPolicy: IfNotPresent
    tag: "10.5.4"
  dbsetting:
    database: querybook2
    # host: mysql:3306
    host: mysql-querybook
    pwd: passw0rd
    rootpwd: hunter2
    user: test
  service:
    serviceType: ClusterIP
    servicePort: 3306
  resources:
    requests:
      memory: '500Mi'
      cpu: '300m'
    limits:
      memory: '500Mi'
      cpu: '300m'

redis:
  enabled: true
  replicaCount: 1
  name: redis-querybook
  image:
    repository: redis
    pullPolicy: IfNotPresent
    tag: "5.0.9"
  service:
    serviceType: ClusterIP
    servicePort: 6380
  resources:
    requests:
      memory: '1Gi'
      cpu: '300m'
    limits:
      memory: '1Gi'
      cpu: '300m'

elasticsearch:
  enabled: true
  replicaCount: 1
  name: elasticsearch-querybook
  image:
    repository: docker.elastic.co/elasticsearch/elasticsearch
    pullPolicy: IfNotPresent
    tag: "v7.17.3"
  extraEnvs:
    - name: ES_JAVA_OPTS
      value: -Xms512m -Xmx512m
    - name: bootstrap.memory_lock
      value: 'false'
    - name: cluster.name
      value: docker-cluster
    - name: discovery.type
      value: single-node
  service:
    serviceType: ClusterIP
    servicePort: 9200
  resources:
    requests:
      memory: '1Gi'
      cpu: '200m'
    limits:
      memory: '1Gi'
      cpu: '200m'

# assigning pods to node configs. will be applied to all the querybook pods
nodeSelector: {}
affinity: {}
tolerations: []
podAnnotations: {}

ingress:
  enabled: true
  ingressClassName: ~
  annotations: {}
  path: /*
  pathType: ImplementationSpecific
  hosts:
  - <my-URL-for-ingress>
  tls: []
  # - secretName: <your-querybook-tls-secret>
  #   hosts:
  #     - <your-querybook-app-domain>

extraEnv:
  PUBLIC_URL: https://<my-URL-for-ingress>
  # any other Querybook configuration env. variables can be injected from here

secret:
  flask_secret_key: <flask-key>
  # database_conn: mysql+pymysql://test:passw0rd@mysql-querybook:3306/querybook2?charset=utf8mb4
  database_conn: mysql+pymysql://test:passw0rd@mysql-querybook/querybook2?charset=utf8mb4
  redis_url:  redis://redis-querybook:6380/0
  elasticsearch_host: elasticsearch-querybook:9200

# existingSecret -- Use an existing Secret which contains the above secret values in the same format and base64 encoded.
## If set, this parameter takes precedence over "secret".
existingSecret: