I experienced this issue recently while syncing a database from an Acquia hosted dev environment to my local environment. This error led me to investigate the dump file which I found included global transaction identifier (GTID) sets. I was able to work around this issue by suppressing the GTID sets using the --set-gtid-purged=OFF option for the mysqldump command. Combining that option with the drush sql-sync command allows a successful sync.
drush sql-sync @dev @self --extra-dump=--set-gtid-purged=OFF
