← Back to team overview

maria-discuss team mailing list archive

Re: Semi-sync replication hangs when changing binlog filename.


This looks pretty weird. If you don't mind more information would be useful
to look at: contents of mariadb-bin.000005 on the master, in particular
what GTID and binlog position the transaction waiting for semi-sync ack has
(confirm that it's 0-1684280839-156 and ends at offset 329); result of
"show status like 'rpl_semi_sync_%'" on both master and slave; contents
of relay-bin.000005 and binlog on the slave, in particular did it really
execute the transaction that is currently hanging on the master? Out of
curiosity: it looks like the slave also acts as a master to someone else.
Can you also verify that the transaction hanging now on the master made it
to that second-level slave?

But to be honest, I don't quite understand how what you show us could
happen, so I'm just asking to look at the info that I would look at if I
were investigating such problem.

On Thu, Jul 28, 2016 at 10:52 PM, Joseph Glanville <jpg@xxxxxxxxx> wrote:

> Hi Pavel.
> Yes, by “binlog filename changes” I mean the master begins writing to a
> new binlog file.
> Output of all the requested commands are in this gist:
> https://gist.github.com/josephglanville/7b96c34bb6e79ace33e56627672b98a5
> Joseph Glanville
> Sent from Polymail
> <https://polymail.io/?utm_source=polymail&utm_medium=referral&utm_campaign=signature>
> On Fri, 29 Jul 2016 at 3:08 PM Pavel Ivanov <Pavel Ivanov
> <Pavel+Ivanov+%3Cpivanof@xxxxxxxxxx%3E>> wrote:
>> By "binlog filename changes" you mean when master starts writing binlogs
>> into a new file? Can you clarify how the replication stalls? What "show
>> processlist" shows at that time on master and on slave? What does "show
>> slave status" show on the slave? On Thu, Jul 28, 2016 at 10:03 PM, Will
>> Fong wrote: > Hi Joseph, > > On Fri, Jul 29, 2016 at 10:11 AM, Joseph
>> Glanville wrote: >> However whenever the binlog filename changes the
>> replication stalls >> indefinitely. > > Interesting! I may have reproduced
>> this, but it was only a quick test. > Let me (or someone else) dig into
>> this more. > > Thanks for reporting this. > -will > > > -- > Will Fong,
>> Senior Support Engineer > MariaDB Corporation > >
>> _______________________________________________ > Mailing list:
>> https://launchpad.net/~maria-discuss > Post to :
>> maria-discuss@xxxxxxxxxxxxxxxxxxx > Unsubscribe :
>> https://launchpad.net/~maria-discuss > More help :
>> https://help.launchpad.net/ListHelp

Follow ups