Realtime ERROR

Home » Asterisk Users » Realtime ERROR
Asterisk Users 2 Comments

Hi Guys,

I have recently moved my database servers to a different database cluster that runs on haproxy.

Every minute or so I get the following error in asterisk

MySQL RealTime: Ping failed (2006). Trying an explicit reconnect

The strange thing is if I do realtime mysql status

It shows as connected just the timer resets.

Any idea why this is occurring?

2 thoughts on - Realtime ERROR

  • Am 25.09.2014 um 16:24 schrieb Andrew Colin:
    Hi Andrew,

    what balancing algorithm you use in haproxy.cfg ?
    balance source balance roundrobin or balance leastconn

  • Hi Rainer,

    I am using roundrobin

    From: Rainer Piper [mailto:rainer.piper@soho-piper.de]
    Sent: Thursday, September 25, 2014 6:21 PM
    To: Andrew Colin; Asterisk Users Mailing List – Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime ERROR

    Am 25.09.2014 um 16:24 schrieb Andrew Colin:

    Hi Guys,

    I have recently moved my database servers to a different database cluster that runs on haproxy.

    Every minute or so I get the following error in asterisk

    MySQL RealTime: Ping failed (2006). Trying an explicit reconnect

    The strange thing is if I do realtime mysql status

    It shows as connected just the timer resets.

    Any idea why this is occurring?

    Hi Andrew,

    what balancing algorithm you use in haproxy.cfg ?
    balance source balance roundrobin or balance leastconn