search

drush-ops / drush

Drush is a command-line shell and scripting interface for Drupal, a veritable Swiss Army knife designed to make life easier for those who spend their working hours hacking away at the command prompt.
https://www.drush.org
2.34k stars 1.08k forks source link

Drupal 8 sql-sync fails #1939

Closed yingtho closed 8 years ago

yingtho commented 8 years ago

When i try to sql-sync in drupal 8 it fails, but works fine in drupal 6 and drupal 7. See debug dump below (this is drush 8.0.2) 'ying$ drush sql-sync @prod @dev -y --verbose --debug Using the Drush script found at /Users/ying/.composer/vendor/drush/drush/drush.launcher using pcntl_exec Drush preflight prepare loaded autoloader at [preflight] /Users/ying/.composer/vendor/autoload.php [0.01 sec, 3.03 MB] Starting Drush preflight. [0.01 sec, 3.03 MB] [preflight] Cache HIT cid: 8.0.2-commandfiles-0-6cf2536d811edd34590343857f11edd1 [0.02 sec, 3.1 MB] [debug] Loading drushrc "/private/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [0.06 sec, 6.3 MB] [bootstrap] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.22 sec, 8.64 MB] [debug] Scanning into /etc/drush for /self.alias.drush(8|)rc.php$/ [0.22 sec, 8.64 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.22 sec, 8.64 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /self.alias.drush(8|)rc.php$/ [0.22 sec, 8.64 MB] [debug] Scanning into /Users/ying/.drush for /._aliases.drush(8|)rc.php$/ [0.23 sec, 8.65 MB] [debug] Scanning into /Users/ying/.drush for /self.alias.drush(8|)rc.php$/ [0.25 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /self.alias.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /self.alias.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /self.alias.drush(8|)rc.php$/ [0.27 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /._aliases.drush(8|)rc.php$/ [0.27 sec, 8.66 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /self.alias.drush(8|)rc.php$/ [0.27 sec, 8.66 MB] [debug] Bootstrap to phase 0. [0.28 sec, 8.66 MB] [bootstrap] Bootstrap to phase -1. [0.28 sec, 8.66 MB] [bootstrap] Found command: sql-sync (commandfile=sqlsync) [0.28 sec, 8.67 MB] [bootstrap] Calling drush command init function: drush_sql_sync_init [0.28 sec, 8.68 MB] [bootstrap] Drush bootstrap phase : bootstrap_drupal_root() [0.3 sec, 9.35 MB] [bootstrap] Loading drushrc "/private/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [0.3 sec, 9.35 MB] [bootstrap] Initialized Drupal 8.0.2 root directory at /private/var/www/kinesiskmuseum.dk [0.3 sec, 9.35 MB] [bootstrap] Find command files for phase 1 (max=2) [0.31 sec, 7.06 MB] [debug] Cache HIT cid: 8.0.2-commandfiles-1-d47eba7e3e7652526ac29c1e009ccc9f [0.31 sec, 7.07 MB] [debug] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.31 sec, 7.18 MB] [debug] Scanning into /etc/drush for /self.alias.drush(8|)rc.php$/ [0.31 sec, 7.18 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.31 sec, 7.18 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /self.alias.drush(8|)rc.php$/ [0.32 sec, 7.18 MB] [debug] Scanning into /Users/ying/.drush for /._aliases.drush(8|)rc.php$/ [0.32 sec, 7.18 MB] [debug] Scanning into /Users/ying/.drush for /self.alias.drush(8|)rc.php$/ [0.34 sec, 7.18 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.37 sec, 7.18 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /self.alias.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /self.alias.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /self.alias.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /._aliases.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /self.alias.drush(8|)rc.php$/ [0.37 sec, 7.19 MB] [debug] Drush bootstrap phase : bootstrap_drupal_site() [0.38 sec, 8.09 MB] [bootstrap] Initialized Drupal site default at sites/default [0.38 sec, 8.09 MB] [bootstrap] Find command files for phase 2 (max=2) [0.38 sec, 8.09 MB] [debug] Cache HIT cid: 8.0.2-install_profile-66ecfeb9791a023150773849f1550c5d [0.39 sec, 8.09 MB] [debug] Cache HIT cid: 8.0.2-commandfiles-2-4b61ef228a19df5ad80d17078b12eaa6 [0.39 sec, 8.09 MB] [debug] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.39 sec, 8.09 MB] [debug] Scanning into /etc/drush for /dev.alias.drush(8|)rc.php$/ [0.39 sec, 8.09 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.39 sec, 8.1 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /dev.alias.drush(8|)rc.php$/ [0.4 sec, 8.1 MB] [debug] Scanning into /Users/ying/.drush for /._aliases.drush(8|)rc.php$/ [0.4 sec, 8.1 MB] [debug] Scanning into /Users/ying/.drush for /dev.alias.drush(8|)rc.php$/ [0.42 sec, 8.1 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.44 sec, 8.1 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /dev.alias.drush(8|)rc.php$/ [0.44 sec, 8.1 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.44 sec, 8.1 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /dev.alias.drush(8|)rc.php$/ [0.44 sec, 8.1 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /._aliases.drush(8|)rc.php$/ [0.44 sec, 8.11 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /dev.alias.drush(8|)rc.php$/ [0.45 sec, 8.11 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.45 sec, 8.11 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /dev.alias.drush(8|)rc.php$/ [0.45 sec, 8.11 MB] [debug] Loaded alias @dev from file /private/var/www/kinesiskmuseum.dk/drush/kinesiskmuseum.aliases.drushrc.php [0.57 sec, 10.55 MB] [notice] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.57 sec, 10.55 MB] [debug] Scanning into /etc/drush for /prod.alias.drush(8|)rc.php$/ [0.57 sec, 10.55 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.57 sec, 10.55 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /prod.alias.drush(8|)rc.php$/ [0.58 sec, 10.55 MB] [debug] Scanning into /Users/ying/.drush for /._aliases.drush(8|)rc.php$/ [0.58 sec, 10.56 MB] [debug] Scanning into /Users/ying/.drush for /prod.alias.drush(8|)rc.php$/ [0.61 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/default for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.56 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dev for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dev for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /prod.alias.drush(8|)rc.php$/ [0.63 sec, 10.57 MB] [debug] Loaded alias @prod from file /var/www/kinesiskmuseum.dk/drush/kinesiskmuseum.aliases.drushrc.php [0.64 sec, 10.57 MB] [notice] Calling hook drush_sqlsync_sql_sync_validate [0.64 sec, 10.59 MB] [debug] Backend invoke: ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --verbose --debug --yes --uri=www.kinesiskmuseum.dk --root=/var/www/kinesiskmuseum.dk sql-conf --all 2>&1' 2>&1 [command] [0.64 sec, 10.61 MB] ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --verbose --debug --yes --uri=www.kinesiskmuseum.dk --root=/var/www/kinesiskmuseum.dk sql-conf --all 2>&1' 2>&1 [0.64 sec, 10.61 MB] [notice] Backend invoke: /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk sql-conf --all [command] 2>&1 [1.63 sec, 10.64 MB] /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk sql-conf --all 2>&1 [1.63 sec, [notice] 10.65 MB] You will destroy data in kinesiskmuseum and replace with data from openconcept.dk/kinesiskmuseum. Do you really want to continue? (y/n): y Returned from hook drush_sqlsync_sql_sync_validate [2.19 sec, 10.66 MB] [debug] Calling hook drush_sqlsync_sql_sync [2.19 sec, 10.68 MB] [debug] Starting to dump database on Source. [2.2 sec, 10.69 MB] [ok] Backend invoke: ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --verbose --debug --yes --strict=0 --uri=www.kinesiskmuseum.dk --root=/var/www/kinesiskmuseum.dk sql-dump --gzip [command] --result-file 2>&1' 2>&1 [2.2 sec, 10.7 MB] ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --verbose --debug --yes --strict=0 --uri=www.kinesiskmuseum.dk --root=/var/www/kinesiskmuseum.dk sql-dump --gzip --result-file 2>&1' [notice] 2>&1 [2.2 sec, 10.7 MB] Using the Drush script found at /root/.composer/vendor/drush/drush/drush.launcher using pcntl_exec Drush preflight prepare loaded autoloader at [preflight] /root/.composer/vendor/autoload.php [0.01 sec, 408.66 KB] Starting Drush preflight. [0.01 sec, 410.06 KB] [preflight] Cache HIT cid: 8.0.2-commandfiles-0-44315a93102271f0c2ab44c3410379af [0.01 sec, 442.51 KB] [debug] Loading drushrc "/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [0.05 sec, 534.19 KB] [bootstrap] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /etc/drush for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /root/.drush for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /root/.drush for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.68 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /._aliases.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /self.alias.drush(8|)rc.php$/ [0.12 sec, 2.69 MB] [debug] Bootstrap to phase 0. [3.37 sec, 2.7 MB] [bootstrap] Bootstrap to phase -1. [3.37 sec, 2.71 MB] [bootstrap] Found command: sql-dump (commandfile=sql) [3.37 sec, 2.71 MB] [bootstrap] Calling hook drush_sql_dump [3.38 sec, 2.75 MB] [debug] Drush bootstrap phase : bootstrap_drupal_root() [3.39 sec, 2.96 MB] [bootstrap] Loading drushrc "/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [3.39 sec, 2.97 MB] [bootstrap] Initialized Drupal 8.0.2 root directory at /var/www/kinesiskmuseum.dk [3.39 sec, 2.97 MB] [bootstrap] Find command files for phase 1 (max=3) [3.39 sec, 854.49 KB] [debug] Cache HIT cid: 8.0.2-commandfiles-1-ebfbec8ae08fc56192feee0d67addf64 [3.39 sec, 858.46 KB] [debug] Drush bootstrap phase : bootstrap_drupal_site() [3.41 sec, 986.84 KB] [bootstrap] Initialized Drupal site www.kinesiskmuseum.dk at sites/kinesiskmuseum.dk [3.41 sec, 988.62 KB] [bootstrap] Find command files for phase 2 (max=3) [3.41 sec, 989.59 KB] [debug] Cache HIT cid: 8.0.2-install_profile-a4ea65e4cd23c7dc641060b0b37aef44 [3.41 sec, 992.55 KB] [debug] Cache HIT cid: 8.0.2-commandfiles-2-88fb251116f868c8c0d7e1bb8976d64f [3.41 sec, 994.77 KB] [debug] Drush bootstrap phase : bootstrap_drupal_configuration() [3.41 sec, 992.65 KB] [bootstrap] Find command files for phase 3 (max=3) [3.41 sec, 1.01 MB] [debug] sql-query: SHOW TABLES; [3.42 sec, 1.04 MB] [notice] Executing: mysql --defaults-extra-file=/tmp/drush_VAZKDy --database=kinesiskmuseum --host=localhost --silent < /tmp/drush_VOCZLu batch block_content block_contentbody block_content_field_data block_content_field_revision block_content_revision block_content_revisionbody cache_bootstrap cache_config cache_container cache_data cache_default cache_discovery cache_dynamic_page_cache cache_entity cache_menu cache_render cache_toolbar cachetags comment commentcomment_body comment_entity_statistics comment_field_data config file_managed file_usage flood history key_value key_value_expire menu_link_content menu_link_content_data menu_tree node nodebody nodecomment nodefield_image nodefield_tags node_access node_field_data node_field_revision node_revision node_revisionbody node_revisioncomment node_revisionfield_image node_revisionfield_tags queue router search_dataset search_index search_total semaphore sequences sessions shortcut shortcut_field_data shortcut_set_users taxonomy_index taxonomy_term_data taxonomy_term_field_data taxonomy_term_hierarchy url_alias userroles user__user_picture users users_data users_field_data watchdog Calling system(mysqldump --defaults-extra-file=/tmp/drush_leHWwC kinesiskmuseum --host=localhost --no-autocommit --single-transaction --opt -Q | gzip -f > /root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz); Database dump saved to /root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz [3.66 sec, 1.06 MB] [success] Returned from hook drush_sql_dump [3.66 sec, 1.06 MB] [debug] Command dispatch complete [3.66 sec, 1.02 MB] [notice] Cache HIT cid: 8.0.2-alias-path--696d40f4b6002b045f8c9d17dd4be9f8 [3.67 sec, 1.08 MB] [debug] Cache SET cid: 8.0.2-alias-path--696d40f4b6002b045f8c9d17dd4be9f8 [3.72 sec, 3.36 MB] [debug] Starting to discover temporary files directory on Destination. [3.45 sec, 10.77 MB] [ok] Backend invoke: /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk php-eval 'return [command] drush_find_tmp();' 2>&1 [3.45 sec, 10.78 MB] /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk php-eval 'return [notice] drush_find_tmp();' 2>&1 [3.45 sec, 10.78 MB] Cache HIT cid: 8.0.2-alias-path--9bc8b719b827cf81a1cf8231f9578126 [4.34 sec, 10.82 MB] [debug] Backend invoke: ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --yes --verbose --debug --root=/var/www/kinesiskmuseum.dk --uri=www.kinesiskmuseum.dk core-rsync [command] '\''@prod:/root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz'\'' '\''@dev:/tmp/kinesiskmuseum_20160126_075123.sql.gz'\'' --remove-source-files 2>&1' 2>&1 [4.35 sec, 10.83 MB] ssh -o PasswordAuthentication=no user@example.com 'env COLUMNS=235 drush --backend=2 --yes --verbose --debug --root=/var/www/kinesiskmuseum.dk --uri=www.kinesiskmuseum.dk core-rsync [notice] '\''@prod:/root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz'\'' '\''@dev:/tmp/kinesiskmuseum_20160126_075123.sql.gz'\'' --remove-source-files 2>&1' 2>&1 [4.35 sec, 10.83 MB] Using the Drush script found at /root/.composer/vendor/drush/drush/drush.launcher using pcntl_exec Drush preflight prepare loaded autoloader at [preflight] /root/.composer/vendor/autoload.php [0.01 sec, 408.62 KB] Starting Drush preflight. [0.01 sec, 410.02 KB] [preflight] Cache HIT cid: 8.0.2-commandfiles-0-44315a93102271f0c2ab44c3410379af [0.01 sec, 442.45 KB] [debug] Loading drushrc "/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [0.05 sec, 533.77 KB] [bootstrap] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /etc/drush for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /root/.drush for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /root/.drush for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.66 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /._aliases.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /self.alias.drush(8|)rc.php$/ [0.1 sec, 2.67 MB] [debug] Bootstrap to phase 0. [5.49 sec, 2.68 MB] [bootstrap] Bootstrap to phase -1. [5.49 sec, 2.69 MB] [bootstrap] Found command: core-rsync (commandfile=core) [5.49 sec, 2.69 MB] [bootstrap] Including /root/.composer/vendor/drush/drush/includes/../commands//core/rsync.core.inc [5.49 sec, 2.7 MB] [bootstrap] Calling drush command init function: drush_core_rsync_init [5.5 sec, 2.7 MB] [bootstrap] Drush bootstrap phase : bootstrap_drupal_root() [5.51 sec, 2.92 MB] [bootstrap] Loading drushrc "/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [5.51 sec, 2.92 MB] [bootstrap] Initialized Drupal 8.0.2 root directory at /var/www/kinesiskmuseum.dk [5.51 sec, 2.92 MB] [bootstrap] Find command files for phase 1 (max=2) [5.51 sec, 822.61 KB] [debug] Cache HIT cid: 8.0.2-commandfiles-1-ebfbec8ae08fc56192feee0d67addf64 [5.51 sec, 826.58 KB] [debug] Drush bootstrap phase : bootstrap_drupal_site() [5.52 sec, 954.91 KB] [bootstrap] Initialized Drupal site www.kinesiskmuseum.dk at sites/kinesiskmuseum.dk [5.52 sec, 956.69 KB] [bootstrap] Find command files for phase 2 (max=2) [5.53 sec, 957.66 KB] [debug] Cache HIT cid: 8.0.2-install_profile-a4ea65e4cd23c7dc641060b0b37aef44 [5.53 sec, 960.64 KB] [debug] Cache HIT cid: 8.0.2-commandfiles-2-88fb251116f868c8c0d7e1bb8976d64f [5.53 sec, 962.84 KB] [debug] Calling hook drush_core_rsync [5.53 sec, 990.67 KB] [debug] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [5.53 sec, 998.18 KB] [debug] Scanning into /etc/drush for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 999.23 KB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1000.43 KB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1001.66 KB] [debug] Scanning into /root/.drush for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1002.72 KB] [debug] Scanning into /root/.drush for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1003.73 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1004.91 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1006.45 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1007.65 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1008.84 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dk for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1010.05 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dk for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1011.24 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1012.43 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1013.62 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /._aliases.drush(8|)rc.php$/ [5.53 sec, 1014.83 KB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /prod.alias.drush(8|)rc.php$/ [5.53 sec, 1016.04 KB] [debug] Loaded alias @prod from file /var/www/kinesiskmuseum.dk/drush/kinesiskmuseum.aliases.drushrc.php [5.58 sec, 3.27 MB] [notice] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.27 MB] [debug] Scanning into /etc/drush for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.27 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /root/.composer/vendor/drush/drush/includes/.. for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /root/.drush for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /root/.drush for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/drush for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/all/drush for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dk for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.28 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dk for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.29 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [5.59 sec, 3.29 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/../drush for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.29 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /.*aliases.drush(8|)rc.php$/ [5.59 sec, 3.29 MB] [debug] Scanning into /var/www/kinesiskmuseum.dk/sites/www.kinesiskmuseum.dk for /dev.alias.drush(8|)rc.php$/ [5.59 sec, 3.29 MB] [debug] Loaded alias @dev from file /var/www/kinesiskmuseum.dk/drush/kinesiskmuseum.aliases.drushrc.php [5.59 sec, 3.29 MB] [notice] You will destroy data from /tmp/kinesiskmuseum_20160126_075123.sql.gz and replace with data from user@example.com:/root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz Do you really want to continue? (y/n): y Calling system(rsync -e 'ssh ' -akzv --exclude=".git" --exclude=".gitignore" --exclude=".hg" --exclude=".hgignore" --exclude=".hgrags" --exclude=".bzr" --exclude=".bzrignore" --exclude=".bzrtags" --exclude=".svn" --stats --progress --remove-source-files user@example.com:/root/drush-backups/kinesiskmuseum/20160126075123/kinesiskmuseum_20160126_075123.sql.gz /tmp/kinesiskmuseum_20160126_075123.sql.gz); receiving incremental file list kinesiskmuseum_20160126_075123.sql.gz 410,988 100% 21.77MB/s 0:00:00 (xfr#1, to-chk=0/1)

Number of files: 1 (reg: 1) Number of created files: 1 (reg: 1) Number of deleted files: 0 Number of regular files transferred: 1 Total file size: 410,988 bytes Total transferred file size: 410,988 bytes Literal data: 410,988 bytes Matched data: 0 bytes File list size: 65 File list generation time: 0.001 seconds File list transfer time: 0.000 seconds Total bytes sent: 164 Total bytes received: 409,185

sent 164 bytes received 409,185 bytes 818,698.00 bytes/sec total size is 410,988 speedup is 1.00 Returned from hook drush_core_rsync [5.82 sec, 3.3 MB] [debug] Command dispatch complete [5.82 sec, 3.27 MB] [notice] Cache HIT cid: 8.0.2-alias-path--696d40f4b6002b045f8c9d17dd4be9f8 [5.82 sec, 3.28 MB] [debug] Cache SET cid: 8.0.2-alias-path--696d40f4b6002b045f8c9d17dd4be9f8 [5.82 sec, 3.28 MB] [debug] Copying dump file from Source to Destination. [5.55 sec, 10.92 MB] [ok] Starting to import dump file onto Destination database. [5.55 sec, 10.92 MB] [ok] Backend invoke: /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --strict=0 --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk [command] sql-query --file=/tmp/kinesiskmuseum_20160126_075123.sql.gz --file-delete 2>&1 [5.55 sec, 10.93 MB] /usr/local/bin/php /Users/ying/.composer/vendor/drush/drush/drush.php --php=/usr/local/bin/php --backend=2 --verbose --debug --yes --strict=0 --uri=kinesiskmuseum.dev --root=/var/www/kinesiskmuseum.dk sql-query [notice] --file=/tmp/kinesiskmuseum_20160126_075123.sql.gz --file-delete 2>&1 [5.55 sec, 10.94 MB] Drush preflight prepare loaded autoloader at [preflight] /Users/ying/.composer/vendor/autoload.php [0.01 sec, 3.03 MB] Starting Drush preflight. [0.01 sec, 3.03 MB] [preflight] Cache HIT cid: 8.0.2-commandfiles-0-6cf2536d811edd34590343857f11edd1 [0.02 sec, 3.1 MB] [debug] Loading drushrc "/private/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [0.04 sec, 6.3 MB] [bootstrap] Scanning into /etc/drush for /._aliases.drush(8|)rc.php$/ [0.2 sec, 8.64 MB] [debug] Scanning into /etc/drush for /self.alias.drush(8|)rc.php$/ [0.2 sec, 8.64 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /._aliases.drush(8|)rc.php$/ [0.2 sec, 8.64 MB] [debug] Scanning into /Users/ying/.composer/vendor/drush/drush/includes/.. for /self.alias.drush(8|)rc.php$/ [0.2 sec, 8.65 MB] [debug] Scanning into /Users/ying/.drush for /._aliases.drush(8|)rc.php$/ [0.2 sec, 8.65 MB] [debug] Scanning into /Users/ying/.drush for /self.alias.drush(8|)rc.php$/ [0.22 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /._aliases.drush(8|)rc.php$/ [0.24 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/../drush for /self.alias.drush(8|)rc.php$/ [0.24 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /._aliases.drush(8|)rc.php$/ [0.24 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/drush for /self.alias.drush(8|)rc.php$/ [0.24 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /._aliases.drush(8|)rc.php$/ [0.24 sec, 8.65 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/all/drush for /self.alias.drush(8|)rc.php$/ [0.24 sec, 8.66 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dev for /.*aliases.drush(8|)rc.php$/ [0.24 sec, 8.66 MB] [debug] Scanning into /private/var/www/kinesiskmuseum.dk/sites/kinesiskmuseum.dev for /self.alias.drush(8|)rc.php$/ [0.24 sec, 8.66 MB] [debug] Bootstrap to phase 0. [5.86 sec, 8.67 MB] [bootstrap] Bootstrap to phase -1. [5.86 sec, 8.67 MB] [bootstrap] Found command: sql-query (commandfile=sql) [5.86 sec, 8.67 MB] [bootstrap] Calling hook drush_sql_query [5.86 sec, 8.72 MB] [debug] Drush bootstrap phase : bootstrap_drupal_root() [5.88 sec, 9.39 MB] [bootstrap] Loading drushrc "/private/var/www/kinesiskmuseum.dk/drush/drushrc.php" into "drupal" scope. [5.88 sec, 9.39 MB] [bootstrap] Initialized Drupal 8.0.2 root directory at /private/var/www/kinesiskmuseum.dk [5.88 sec, 9.39 MB] [bootstrap] Find command files for phase 1 (max=3) [5.89 sec, 7.1 MB] [debug] Cache HIT cid: 8.0.2-commandfiles-1-d47eba7e3e7652526ac29c1e009ccc9f [5.89 sec, 7.1 MB] [debug] Drush bootstrap phase : bootstrap_drupal_site() [5.9 sec, 8.1 MB] [bootstrap] Initialized Drupal site kinesiskmuseum.dev at sites/kinesiskmuseum.dev [5.9 sec, 8.1 MB] [bootstrap] Find command files for phase 2 (max=3) [5.9 sec, 8.11 MB] [debug] Cache HIT cid: 8.0.2-install_profile-da063d77e313584e23b8ab9689216c53 [5.9 sec, 8.11 MB] [debug] Cache HIT cid: 8.0.2-commandfiles-2-49cdca211fc31e74bdf500f69538e0ca [5.9 sec, 8.11 MB] [debug] Drush bootstrap phase : bootstrap_drupal_configuration() [5.9 sec, 8.11 MB] [bootstrap] Find command files for phase 3 (max=3) [5.91 sec, 8.34 MB] [debug] finfo::file(/tmp/kinesiskmuseum_20160126_075123.sql.gz): failed to open stream: No such file or directory drush.inc:892 [5.92 sec, 8.47 MB] [warning] Examining /tmp/kinesiskmuseum_20160126_075123.sql.gz headers. [5.92 sec, 8.47 MB] [debug] fopen(/tmp/kinesiskmuseum_20160126_075123.sql.gz): failed to open stream: No such file or directory drush.inc:904 [5.92 sec, 8.47 MB] [warning] Unable to open /tmp/kinesiskmuseum_20160126_075123.sql.gz. [5.92 sec, 8.47 MB] [warning] Examining /tmp/kinesiskmuseum_20160126_075123.sql.gz extension. [5.92 sec, 8.47 MB] [debug] Executing: mysql --defaults-extra-file=/private/tmp/drush_o3FV80 --database=kinesiskmuseum --host=localhost --silent < /tmp/kinesiskmuseum_20160126_075123.sql.gz sh: /tmp/kinesiskmuseum_20160126_075123.sql.gz: No such file or directory Query failed. [5.92 sec, 10.99 MB] [error] Returned from hook drush_sql_query [5.92 sec, 8.47 MB] [debug] Command dispatch complete [5.92 sec, 8.44 MB] [notice] Cache HIT cid: 8.0.2-alias-path--871bb04c83830070c9179fc042b8147f [5.93 sec, 8.73 MB] [debug] Cache SET cid: 8.0.2-alias-path--871bb04c83830070c9179fc042b8147f [6.07 sec, 11.16 MB] [debug] Returned from hook drush_sqlsync_sql_sync [6.08 sec, 10.87 MB] [debug] Command dispatch complete [6.08 sec, 10.83 MB] [notice]'

weitzman commented 8 years ago

Make that the source machine and user has access to the gzip command. If thats not the problem, please post the contents of both the source and target aliases.

weitzman commented 8 years ago

Closing, but still post here if there is more info to share.