search

sclorg / mysql-container

MySQL container images based on Red Hat Software Collections and intended for OpenShift and general usage. Users can choose between Red Hat Enterprise Linux, Fedora, and CentOS based images.
http://softwarecollections.org
Apache License 2.0
128 stars 201 forks source link

Openshift Pod logs print "Got an error reading communication packets" #274

Closed imranrazakhan closed 4 years ago

imranrazakhan commented 4 years ago

in pods logs i am continuously seeing "Got an error reading communication packets" but everything is working as expected MYSQL 5.7

2019-10-30T21:38:55.333670Z 362671 [Note] Got an error reading communication packets
2019-10-30T21:38:56.180151Z 362673 [Note] Got an error reading communication packets
2019-10-30T21:38:57.333473Z 362674 [Note] Got an error reading communication packets
2019-10-30T21:38:59.360179Z 362675 [Note] Got an error reading communication packets
2019-10-30T21:39:01.335256Z 362676 [Note] Got an error reading communication packets
2019-10-30T21:39:03.333497Z 362678 [Note] Got an error reading communication packets
2019-10-30T21:39:05.333605Z 362679 [Note] Got an error reading communication packets
2019-10-30T21:39:06.180080Z 362680 [Note] Got an error reading communication packets
2019-10-30T21:39:07.333535Z 362681 [Note] Got an error reading communication packets
2019-10-30T21:39:09.333675Z 362683 [Note] Got an error reading communication packets
2019-10-30T21:39:11.333500Z 362686 [Note] Got an error reading communication packets
2019-10-30T21:39:13.333547Z 362687 [Note] Got an error reading communication packets
2019-10-30T21:39:15.333605Z 362689 [Note] Got an error reading communication packets
2019-10-30T21:39:16.180061Z 362690 [Note] Got an error reading communication packets
2019-10-30T21:39:17.333555Z 362691 [Note] Got an error reading communication packets
2019-10-30T21:39:19.333496Z 362692 [Note] Got an error reading communication packets
2019-10-30T21:39:21.333538Z 362694 [Note] Got an error reading communication packets
2019-10-30T21:39:23.333611Z 362695 [Note] Got an error reading communication packets
yannickcornaille commented 4 years ago

I experience exactly the same behavior. If I deactivate the OpenShift livenessProbe the log disappears, but it is not a solution. I also tried to increase the livenessProbe timeout (timeoutSeconds) but I still get this log.

imranrazakhan commented 4 years ago

I changed to use MySQL Official Docker and done following changes

Current:

      readinessProbe:
        tcpSocket:
          port: 3306
        initialDelaySeconds: 20
        periodSeconds: 2
        timeoutSeconds: 1

So it was pinging every two seconds on 3306 port, i changed it to below and its resolved the issue, 

 readinessProbe:
        exec:
          command:
          - sh
          - -c
          - "mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}"
        initialDelaySeconds: 5
        periodSeconds: 2
        timeoutSeconds: 1
hhorak commented 4 years ago

Fixed by #289.