Yes, having processlist while it's hung might be handy. On Tue, Aug 22, 2017 at 3:45 PM, Nils Carlson <nils.carlson@ludd.ltu.se> wrote:

On 08/22/2017 10:42 PM, Pavel Ivanov wrote:

...

Can you clarify what SHOW SLAVE STATUS blocks on for you?

Not really. Basically, just after performing a failover, I run SHOW SLAVE STATUS on the slave and that can take up to 30 seconds sometimes before the query returns. Once it does return everything looks like normal. I can try to dump the thread status maybe.

/Nils

...

On Sun, Aug 20, 2017 at 9:47 AM, Nils Carlson <nils.carlson@ludd.ltu.se> wrote:

...

Hi Pavel and Kristian,

On 08/10/2017 10:58 PM, Pavel Ivanov wrote:

...

Note also that you don't want to set rpl_semi_sync_master_enabled='ON' on all your slaves, it should be set only on the master. With the setting your slaves' SQL threads will hang waiting for semi-sync ack as well, and they will hang forever if rpl_semi_sync_master_wait_no_slave is set to ON too.

Thank you.

...

On Wed, Aug 9, 2017 at 2:30 AM, Kristian Nielsen <knielsen@knielsen-hq.org> wrote:

...

Hope this helps,

And thank you for all this!

I have updated the resource-agent based on this and run some light testing. I will try to write automated tests soon.

I was also wondering about one thing, the block SHOW SLAVE STATUS command. Is there any way to ensure this doesn't block? Maybe this is something to suggest to the development mailing list?

Thanks again.

Cheers, Nils

...

...

- Kristian.

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp