{"action":"created","issue":{"url":"https://api.github.com/repos/drush-ops/drush/issues/2194","repository_url":"https://api.github.com/repos/drush-ops/drush","labels_url":"https://api.github.com/repos/drush-ops/drush/issues/2194/labels{/name}","comments_url":"https://api.github.com/repos/drush-ops/drush/issues/2194/comments","events_url":"https://api.github.com/repos/drush-ops/drush/issues/2194/events","html_url":"https://github.com/drush-ops/drush/issues/2194","id":156637409,"number":2194,"title":"gunzip fails - unknown suffix -- ignored","user":{"login":"frederickjh","id":864159,"avatar_url":"https://avatars.githubusercontent.com/u/864159?v=3","gravatar_id":"","url":"https://api.github.com/users/frederickjh","html_url":"https://github.com/frederickjh","followers_url":"https://api.github.com/users/frederickjh/followers","following_url":"https://api.github.com/users/frederickjh/following{/other_user}","gists_url":"https://api.github.com/users/frederickjh/gists{/gist_id}","starred_url":"https://api.github.com/users/frederickjh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frederickjh/subscriptions","organizations_url":"https://api.github.com/users/frederickjh/orgs","repos_url":"https://api.github.com/users/frederickjh/repos","events_url":"https://api.github.com/users/frederickjh/events{/privacy}","received_events_url":"https://api.github.com/users/frederickjh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-05-25T00:16:24Z","updated_at":"2016-05-25T11:06:29Z","closed_at":null,"body":"Hi!\r\n\r\nTrying to get **http-sync** for **sql-sync** working. Database is in place and can be download via browser. The downloaded file can be unzip.\r\n\r\nHowever trying to automate this via drush is failing on the gunzip command. A temp filename is used without an extension. This makes gzip sick and it vomits the error message: **gzip: /tmp/download_filedhBLdK: unknown suffix -- ignored**\r\n\r\nDownloading the file via wget the file can be gunzipped with the same command drush is using, however remove the extension and I get the same error as above.\r\n\r\nI tried setting the **target-dump** option in the alias file and on the command line but it seems it is ignored by **http-sync**. Debug output from the command run `drush --debug sql-sync @xxxx.test @xxxxx.dev` follows.\r\n\r\nAny advice on how to proceed would be appreciated! \r\nFrederick\r\n\r\ndrush version is 7.3.0 on both local dev and remote test environments.\r\n\r\n<pre>Returned from hook drush_sync_via_http_pre_sql_sync [42.02 sec, 12.68 MB]                                                                                             [debug]\r\nCalling hook drush_sqlsync_sql_sync [42.02 sec, 12.68 MB]                                                                                                             [debug]\r\nStarting to import dump file onto Destination database. [42.04 sec, 12.69 MB]                                                                                     [ok]\r\nBackend invoke: /usr/bin/php -d memory_limit=\"512M\" -d error_reporting=\"E_ALL|E_NOTICE|E_STRICT\" -d display_errors=\"stderr\" -d date.timezone=\"\"Europe/Zurich\"\" -d   [command]\r\nmax_execution_time=\"0\"  /root/.composer/vendor/drush/drush/drush.php --php=/usr/bin/php --php-options='-d memory_limit=\"512M\" -d\r\nerror_reporting=\"E_ALL|E_NOTICE|E_STRICT\" -d display_errors=\"stderr\" -d date.timezone=\"\"Europe/Zurich\"\" -d max_execution_time=\"0\" '  --backend=2 --debug\r\n--strict=0 --verbose --root=/var/www --uri=xxxxx.docker  sql-query   --http-sync=http://foo.net/bar/database-dump.sql.gz\r\n--http-sync-user=xxxxxx --http-sync-password=xxxx --target-dump=/tmp/download_filedhBLdK --no-ordered-dump --no-cache\r\n--structure-tables-key=common --no-dump --no-sync --dump=/tmp/download_filedhBLdK --file=/tmp/download_filedhBLdK --file-delete 2>&1 [42.05 sec, 12.71 MB]\r\n/usr/bin/php -d memory_limit=\"512M\" -d error_reporting=\"E_ALL|E_NOTICE|E_STRICT\" -d display_errors=\"stderr\" -d date.timezone=\"\"Europe/Zurich\"\" -d                    [notice]\r\nmax_execution_time=\"0\"  /root/.composer/vendor/drush/drush/drush.php --php=/usr/bin/php --php-options='-d memory_limit=\"512M\" -d\r\nerror_reporting=\"E_ALL|E_NOTICE|E_STRICT\" -d display_errors=\"stderr\" -d date.timezone=\"\"Europe/Zurich\"\" -d max_execution_time=\"0\" '  --backend=2 --debug\r\n--strict=0 --verbose --root=/var/www --uri=xxxxx.docker  sql-query   --http-sync=http://foo.net/bar/database-dump.sql.gz\r\n--http-sync-user=xxxxx --http-sync-password=xxxxxxx --target-dump=/tmp/download_filedhBLdK --no-ordered-dump --no-cache\r\n--structure-tables-key=common --no-dump --no-sync --dump=/tmp/download_filedhBLdK --file=/tmp/download_filedhBLdK --file-delete 2>&1 [42.05 sec, 12.71 MB]\r\nDrush preflight prepare loaded autoloader at                         [preflight]\r\n/root/.composer/vendor/autoload.php [0.1 sec, 2.18 MB]\r\nStarting Drush preflight. [0.1 sec, 2.19 MB]                                                                                                                      [preflight]\r\nLoading drushrc \"/root/.drush/drushrc.php\" into \"home.drush\" scope. [0.1 sec, 2.19 MB]                                                                            [bootstrap]\r\nCache HIT cid: 7.2.0-commandfiles-0-81cc86c1995ab7206f383ec28ad43baf [0.11 sec, 2.26 MB]                                                                              [debug]\r\nLoading drushrc \"/var/www/sites/all/drush/drushrc.php\" into \"drupal\" scope. [0.19 sec, 6.23 MB]                                                                   [bootstrap]\r\nBootstrap to phase 0. [42.48 sec, 9.42 MB]                                                                                                                        [bootstrap]\r\nBootstrap to phase -1. [42.48 sec, 9.43 MB]                                                                                                                       [bootstrap]\r\nFound command: sql-query (commandfile=sql) [42.48 sec, 9.43 MB]                                                                                                   [bootstrap]\r\nLoading drushrc \"/root/.drush/deploy.drushrc.php\" into \"home.drush\" scope. [42.48 sec, 9.44 MB]                                                                   [bootstrap]\r\nCalling hook drush_sql_query [42.49 sec, 9.75 MB]                                                                                                                     [debug]\r\nDrush bootstrap phase : bootstrap_drupal_root() [42.5 sec, 10.11 MB]                                                                                              [bootstrap]\r\nLoading drushrc \"/var/www/sites/all/drush/drushrc.php\" into \"drupal\" scope. [42.5 sec, 10.11 MB]                                                                  [bootstrap]\r\nInitialized Drupal 7.43 root directory at /var/www [42.53 sec, 10.11 MB]                                                                                          [bootstrap]\r\nFind command files for phase 1 (max=3) [42.54 sec, 7.13 MB]                                                                                                           [debug]\r\nCache HIT cid: 7.2.0-commandfiles-1-1f4766544295518520af90de29460557 [42.54 sec, 7.13 MB]                                                                             [debug]\r\nDrush bootstrap phase : bootstrap_drupal_site() [42.54 sec, 7.14 MB]                                                                                              [bootstrap]\r\nInitialized Drupal site meosch.docker at sites/default [42.54 sec, 7.14 MB]                                                                                       [bootstrap]\r\nFind command files for phase 2 (max=3) [42.55 sec, 7.14 MB]                                                                                                           [debug]\r\nCache MISS cid: 7.2.0-install_profile-66ecfeb9791a023150773849f1550c5d [42.55 sec, 7.15 MB]                                                                           [debug]\r\nCache HIT cid: 7.2.0-commandfiles-2-adcbc259623838c285e92ee0febd23c7 [42.55 sec, 7.16 MB]                                                                             [debug]\r\nDrush bootstrap phase : bootstrap_drupal_configuration() [42.62 sec, 8.57 MB]                                                                                     [bootstrap]\r\nFind command files for phase 3 (max=3) [42.63 sec, 8.59 MB]                                                                                                           [debug]\r\nExecuting: gunzip /tmp/download_filedhBLdK\r\n  gzip: /tmp/download_filedhBLdK: unknown suffix -- ignored\r\nFailed to gunzip input file. [42.66 sec, 12.76 MB]                                                                                                                [error]\r\nQuery failed. [42.66 sec, 12.76 MB]                                                                                                                               [error]\r\nReturned from hook drush_sql_query [42.66 sec, 8.7 MB]                                                                                                                [debug]\r\nCommand dispatch complete [42.66 sec, 8.64 MB]                                                                                                                       [notice]\r\n Timer  Cum (sec)  Count  Avg (msec) \r\n page   0.036      1      35.63\r\nCache HIT cid: 7.2.0-alias-path--8bf32223596c4e7624f626b4fa56d306 [42.66 sec, 8.77 MB]                                                                                [debug]\r\nReturned from hook drush_sqlsync_sql_sync [42.82 sec, 12.72 MB]                                                                                                       [debug]\r\nCommand dispatch complete [42.82 sec, 12.63 MB]                                                                                                                      [notice]</pre>"},"comment":{"url":"https://api.github.com/repos/drush-ops/drush/issues/comments/221541665","html_url":"https://github.com/drush-ops/drush/issues/2194#issuecomment-221541665","issue_url":"https://api.github.com/repos/drush-ops/drush/issues/2194","id":221541665,"user":{"login":"frederickjh","id":864159,"avatar_url":"https://avatars.githubusercontent.com/u/864159?v=3","gravatar_id":"","url":"https://api.github.com/users/frederickjh","html_url":"https://github.com/frederickjh","followers_url":"https://api.github.com/users/frederickjh/followers","following_url":"https://api.github.com/users/frederickjh/following{/other_user}","gists_url":"https://api.github.com/users/frederickjh/gists{/gist_id}","starred_url":"https://api.github.com/users/frederickjh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frederickjh/subscriptions","organizations_url":"https://api.github.com/users/frederickjh/orgs","repos_url":"https://api.github.com/users/frederickjh/repos","events_url":"https://api.github.com/users/frederickjh/events{/privacy}","received_events_url":"https://api.github.com/users/frederickjh/received_events","type":"User","site_admin":false},"created_at":"2016-05-25T11:06:28Z","updated_at":"2016-05-25T11:06:28Z","body":"I think maybe the best idea is to ditch the --gzip option and let the rsync compression do its magic and save the CPU cycles. That is what I finally did."}}
{"actor":{"display_login":"frederickjh"}}