Leaf Error: Compilation failed due to pending DDL operation


#1

When running an insert on a new cluster I get “mysql.connector.errors.DatabaseError: 1875 (HY000): Leaf Error (ZZ.ZZ.ZZ.ZZ:3306): Compilation failed due to pending DDL operation. You may need to rollback the transaction.”

I’m not sure how to proceed.

After debugging the command that I’m running to seems to be due to a “ON DUPLICATE KEY UPDATE” statement in the INSERT. I’m not having this issue on a separate, staging cluster. Just the new cluster

On the leaf node I’m also not seeing any tables under the primary (non-partition db). I’m not sure if this is related but it is a difference between the two clusters


#2

Oh, well looks like the firewall was blocking leaf connections back to the master. Fixed that and now everything is happy