Under some rare conditions with Junos Space 24.1+ "reset mysql replication" may hang indefinitely

All of the following MUST be true for this KB to be a match:

• Mysql database replication shows out of sync
• Performing "reset mysql replication" is running for more than 4 times as long as a recent normal Database backup takes to complete (check backup times, or manual backup job start/end times)
• While "reset mysql replication" is in progress:
  • running mysql command: mysql "show processlist" on the non-vip space node
    • shows  "Waiting for table metadata lock" info column for the same ID line at least 5 minutes.
• Running mysql cli command: "XA RECOVER CONVERT XID;" shows output on one space node (check both)

If everything listed in Symptoms is true.

Please open a support case for assistance verifying and clearing this error condition, and reporting the occurance to development.

This is believed to be caused when Junos Space is in the middle of a database operation, when Space inter-node communication is lost, or unexpected process shutdown (power loss)