This is a very good write up, thank you. Unfortunately I only found this after I already figured it all out myself, I published my root cause analysis here: `update`: error: failed to synchronize all databases (unexpected error) - #48 by TNE
PS: I literally just went looking for posts to mark solutions under with my root cause analysis and then found this hah