[sr-dev] mysql_ping in db_mysql_submit_query

[Daniel-Constantin Mierla]

On 11.09.19 21:20, Juha Heinanen wrote:
> Juha Heinanen writes:
>
>> Unfortunately udp receiver hangs also without mysql_ping.  Now hang
>> happens in insert (below).
>>
>> Will try next without cluster if regular insert would work.
> So far no hang when acc is not using cluster db_url.
>
> Cluster has two connections with mode "5s5s".
>
> If I have understood correctly, underlying db_mysql module is not aware
> of the cluster.  If so, how could use of cluster cause hang in
> libmariadb?

Are the two connections going to the same mysql server? Or different ones?

Are you able to see from the logs if writing to the first connection
failed and it tried to the second one?

db_cluster does some basic operations here, in the way that tries to use
the first connection and if the underlying module returns error, it
tries via the second one. It doesn't do anything specific for the
connector module and the connector module should not be aware of the
db_cluster.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training, Oct 21-23, 2019, Berlin, Germany -- https://asipto.com/u/kat