I have the exact same problem as in How to solve "Query failed" error in drush sql-sync output?, exact same output. That user found the answer as the password in settings.php was wrong, but my password is correct and it still doesn’t work. Can anyone please help?
drush sql-query --strict=0 --file=/tmp/mob_20191203_224013.sql.gz --file-delete --uri=mob --root=/home/fc/1/de/mob/web -vvv
[preflight] Config paths: /home/fc/1/de/mob/vendor/drush/drush/drush.yml,/home/fc/1/de/mob/drush/drush.yml
[preflight] Alias paths: /home/fc/1/de/mob/web/drush/sites,/home/fc/1/de/mob/drush/sites
[preflight] Commandfile search paths: /home/fc/1/de/mob/vendor/drush/drush/src,/home/fc/1/de/mob/drush
[bootstrap] Starting bootstrap to max [0.04 sec, 8.57 MB]
[bootstrap] Drush bootstrap phase: bootstrapDrupalRoot() [0.04 sec, 8.57 MB]
[bootstrap] Change working directory to /home/fc/1/de/mob/web [0.04 sec, 8.57 MB]
[bootstrap] Initialized Drupal 8.7.10 root directory at /home/fc/1/de/mob/web [0.04 sec, 8.76 MB]
[bootstrap] Drush bootstrap phase: bootstrapDrupalSite() [0.04 sec, 9.06 MB]
[bootstrap] Initialized Drupal site mob at sites/default [0.04 sec, 9.29 MB]
[bootstrap] Drush bootstrap phase: bootstrapDrupalConfiguration() [0.04 sec, 9.29 MB]
[debug] Add service modifier [0.04 sec, 9.45 MB]
[info] Executing: command -v mysql [0.05 sec, 9.91 MB]
[info] Executing: mysql --defaults-file=/tmp/drush_IsKDek --database=mob --host=localhost --silent -A < /tmp/mob_20191203_224013.sql.gz [0.05 sec, 9.96 MB]
In SqlCommands.php line 199:
[Exception]
Query failed.
/tmp/mob_20191203_224013.sql.gz exists, /tmp/drush_IsKDek does not
Drush is 9.7.1, Mint 19.2, alias
loc:
root: /home/fc/1/de/mob/web
uri: mob
options:
command-specific:
sql-sync:
sanitize: true
structure-tables:
common:
- cache_advagg
- cache_bootstrap
- cache_config
- cache_container
- cache_data
- cache_default
- cache_discovery
- cache_dynamic_page_cache
- cache_entity
- cache_menu
- cache_page
- cache_render
- cache_toolbar
- watchdog
- history
- sessions
os: Linux
paths:
dump-dir: /tmp
files: sites/default/files