Issues

Select view

Select search mode

 
40 of 40

Connection closed unexpectedly erros

Done

Description

Greetings,

We have got a couple of XtraDB clusters deployed with percona pxc operator v1.7.0 and we have got php applications which leverages rhge XtraDB clusters, the setup is working fine in general, but it throws `Connection closed unexpectedly` errors in our apps every now and then and it has to perform a retry for making it work as seen below, any idea what might be wrong here? the clusters are using HAProxy load balancers, any pointers on fixing this would be much appreciated, thanks!

 

```

SQL retry 'Connection closed unexpectedly' on: rooms, SELECT * FROM participants WHERE (`user_id` = 4956456743)

```

Environment

Kubernetes: self hosted (v1.21.4)

Smart Checklist

Details

Assignee

Reporter

Needs QA

Yes

Components

Affects versions

Priority

Smart Checklist

Created October 18, 2022 at 4:43 AM
Updated June 27, 2023 at 1:17 PM
Resolved June 27, 2023 at 1:17 PM

Activity

Aaditya DubeyJune 27, 2023 at 1:16 PM

Hi ,

We still haven't heard any news from you. So I assume issue is not persists anymore. If you disagree just reply and create a follow-up report.

Aaditya DubeyApril 26, 2023 at 11:58 AM

Hi ,

Thank you for the report.
Please let us know if issue still persists.

Slava SarzhanMarch 14, 2023 at 12:14 PM

Hi , do you have this issue now? 

Prathyush RomOctober 18, 2022 at 5:25 AM

we are not using any custom haproxy configurations, below are the timeout values from the default configs.

 

    defaults
      log global
      mode tcp
      retries 10
      timeout client 28800s
      timeout connect 100500
      timeout server 28800s