There is a question about missing transactions

[rusuly]

There is a question about missing transactions

[ElderJames]

Anyway, thanks again.

[rusuly]

Hello James,

I assume you configured a new replica server(since there is a gap in GTIDs, 1-4050).
Could you please check gtid_executed and gtid_purged

select @@gtid_executed;
select @@gtid_purged;

If you configured your replica correctly the gtid_purged must be “1d8dab31-b1c3-11e9-bd4f-00155d452816:1-4050”

Have you also tried FromGtid(“1d8dab31-b1c3-11e9-bd4f-00155d452816:4051-4051”)?

[ElderJames]

Thank you for comment.

mysql> select @@gtid_executed;
+---------------------------------------------+
| @@gtid_executed |
+---------------------------------------------+
| 1d8dab31-b1c3-11e9-bd4f-00155d452816:1-4097 |
+---------------------------------------------+
1 row in set (0.04 sec)

mysql> select @@gtid_purged;
+---------------------------------------------+
| @@gtid_purged |
+---------------------------------------------+
| 1d8dab31-b1c3-11e9-bd4f-00155d452816:1-4050 |
+---------------------------------------------+
1 row in set (0.01 sec)

[rusuly]

Ok, could you then try

• FromGtid(“1d8dab31-b1c3-11e9-bd4f-00155d452816:4051-4051”)
• FromGtid(“1d8dab31-b1c3-11e9-bd4f-00155d452816:4051-4096”)

[ElderJames]

I tried them but got the same error.😂

[rusuly]

Ok, silly question, did you change the connection string(hostname) to your new replica?

[ElderJames]

No,I am using localhost to connect the MySQL on my dev PC.

[rusuly]

Did you make a backup of your database and restore it on a new replica or you are just using the master server.
I just want to understand how your events got purged(because of expiration or because you configured a new replica)

[ElderJames]

Just using the master server.
I used to manually delete the binlog file when I needed to change the configuration. I don't know if that's the reason.

[rusuly]

maybe something got corrupt(it's better you use PURGE BINARY LOGS in such cases)

you can try to reset GTID history and clear binlog but make sure you understand the reset master command

[ElderJames]

It work! So Amazing! Thanks a lot 🎁
There's a lot I don't know about binlog but I learned a lot from you.

[rusuly]

AH, I JUST REALIZED what the problem was.
The correct answer was

FromGtid(“1d8dab31-b1c3-11e9-bd4f-00155d452816:1-4050”)`

In the FromGtid method you must pass your current state(your gtid_executed state).
This way you tell the server that you already executed transactions from 1 to 4050 so it will send you remaining interval from 4051 to 4097

You should have passed the @@gtid_purged value to the FromGtid which is equal to FromStart()

FromGtid(@@gtid_purged) => FromStart()
FromGtid(@@gtid_executed) => FromEnd()

[ElderJames]

Exactly, it works finally.