{"action":"closed","issue":{"url":"https://api.github.com/repos/acquia/blt/issues/638","repository_url":"https://api.github.com/repos/acquia/blt","labels_url":"https://api.github.com/repos/acquia/blt/issues/638/labels{/name}","comments_url":"https://api.github.com/repos/acquia/blt/issues/638/comments","events_url":"https://api.github.com/repos/acquia/blt/issues/638/events","html_url":"https://github.com/acquia/blt/issues/638","id":187872734,"number":638,"title":"blt local:sync fails on db import","user":{"login":"extensibleseth","id":19933830,"avatar_url":"https://avatars.githubusercontent.com/u/19933830?v=3","gravatar_id":"","url":"https://api.github.com/users/extensibleseth","html_url":"https://github.com/extensibleseth","followers_url":"https://api.github.com/users/extensibleseth/followers","following_url":"https://api.github.com/users/extensibleseth/following{/other_user}","gists_url":"https://api.github.com/users/extensibleseth/gists{/gist_id}","starred_url":"https://api.github.com/users/extensibleseth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/extensibleseth/subscriptions","organizations_url":"https://api.github.com/users/extensibleseth/orgs","repos_url":"https://api.github.com/users/extensibleseth/repos","events_url":"https://api.github.com/users/extensibleseth/events{/privacy}","received_events_url":"https://api.github.com/users/extensibleseth/received_events","type":"User","site_admin":false},"labels":[{"id":365209878,"url":"https://api.github.com/repos/acquia/blt/labels/question","name":"question","color":"f9d0c4","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":18,"created_at":"2016-11-08T00:53:39Z","updated_at":"2017-02-15T01:38:38Z","closed_at":"2017-02-15T01:38:38Z","body":"I'm running a manual local:sync and it fails at 'Starting to import dump file onto Destination database.' The query in drush_sql_query isn't set, but I haven't been able to get much deeper than that.\r\n\r\nI'm running BLT on WSL and I've got the local site running in DrupalVM. \r\n\r\n`\r\n\r\n    Buildfile: /mnt/c/Users/shendrick/Projects/EA/vendor/acquia/blt/phing/build.xml\r\n\r\n    blt > setup:drupal:settings:\r\n\r\n    [echo] Making /mnt/c/Users/shendrick/Projects/EA/docroot/sites/default writable.\r\n    [chmod] Changed file mode on '/mnt/c/Users/shendrick/Projects/EA/docroot/sites/default' to 755\r\n    [echo] Making /mnt/c/Users/shendrick/Projects/EA/docroot/sites/default/settings.php writable.\r\n    [chmod] Changed file mode on '/mnt/c/Users/shendrick/Projects/EA/docroot/sites/default/settings.php' to 644\r\n    [echo] Ensuring that blt.settings.php is required by settings.php\r\n    [exec] require DRUPAL_ROOT . \"/../vendor/acquia/blt/settings/blt.settings.php\";\r\n    [echo] Generating local settings files.\r\n\r\n    blt > local:sync:\r\n\r\n    'drush' cache was cleared.                                                                                                                                                                                                                 [success]\r\n    Do you really want to drop all tables in the database drupal? (y/n): y\r\n    You will destroy data in drupal and replace with data from 192.168.100.223/ea_alt_db.\r\n    Do you really want to continue? (y/n): y\r\n    Starting to create database on Destination.                                                                                                                                                                                            [ok]\r\n    Creating database drupal. Any possible existing database will be dropped! \r\n    Do you really want to continue? (y/n): y\r\n    Starting to dump database on Source.                                                                                                                                                                                               [ok]\r\n    Database dump saved to /home/tsmith/drush-backups/ea_alt_db/20161108004433/ea_alt_db_20161108_004434.sql.gz                                                                                                                        [success]\r\n    Starting to discover temporary files directory on Destination.                                                                                                                                                                     [ok]\r\n    You will delete files in /tmp/ea_alt_db_20161108_004434.sql.gz and replace with data from tsmith@192.168.100.223:/home/tsmith/drush-backups/ea_alt_db/20161108004433/ea_alt_db_20161108_004434.sql.gz\r\n    Do you really want to continue? (y/n): y\r\n    Copying dump file from Source to Destination.                                                                                                                                                                                          [ok]\r\n    Starting to import dump file onto Destination database.                                                                                                                                                                            [ok]\r\n    env COLUMNS=238 /mnt/c/Users/shendrick/Projects/EA/docroot/../vendor/bin//drush.launcher  --backend=2 --yes --verbose --strict=0 --root=/mnt/c/Users/shendrick/Projects/EA/docroot --uri=http://local.eablted8.com  sql-query --structure-tables-key=lightweight --create-db --file=/tmp/ea_alt_db_20161108_011054.sql.gz --file-delete 2>&1         [notice]\r\n    Executing: gzip -d /tmp/ea_alt_db_20161108_011054.sql.gz\r\n    Executing: mysql --defaults-extra-file=/tmp/drush_DooJkQ --database=drupal --host=localhost --port=3306 --silent  < /tmp/ea_alt_db_20161108_011054.sql\r\n    Query failed.                                                                                                                                                                                                                      [error]\r\n\r\n    BUILD FAILED\r\n    /mnt/c/Users/shendrick/Projects/EA/vendor/acquia/blt/phing/tasks/local-sync.xml:21:25: Drush exited with code 1\r\n\r\n    Total time: 16.2753 seconds\r\n`\r\n\r\n"}}
{"actor":{"display_login":"grasmash"}}