Just spent the last three hours trying to figure out why drush sql-sync won't sync the prod with local. It all started after configuring my aliases and trying to clone production database.
Trial #1: The dump started and afterwards I got the error: "The Drush sql-dump command did not report the path to the dump file produced"
This was an easy fix, since I am using the drush master branch from github, I just done a git pull && composer update to bring drush to latest version both on my Mac and remote server
Trial #2: Query failed - a very dry message.