Skip to main content
Solved

Error restore MySQL XtraBackup


Forum|alt.badge.img+1

The following content is output in the job log:

‘ERROR 3546 (YH000) at line 24: @@GLOBAL.GTID_PURGED cannot be changed the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED’

I hope everyone can provide a solution. Thank you!

Best answer by Orazan

Is this a standby server that  you are restoring to?

View original
Did this answer your question?

3 replies

Forum|alt.badge.img+15
  • Vaulter
  • 630 replies
  • Answer
  • July 13, 2023

Is this a standby server that  you are restoring to?


Forum|alt.badge.img+1
  • Author
  • Bit
  • 2 replies
  • July 13, 2023
Orazan wrote:

Is this a standby server that  you are restoring to?

No, I'm doing backup and recovery testing


Forum|alt.badge.img+1
  • Author
  • Bit
  • 2 replies
  • July 13, 2023
Orazan wrote:

Is this a standby server that  you are restoring to?

Have you added parameter configurations to xtrabackup?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings