Closed mikemadison13 closed 4 years ago
mikemadison13
commented
4 years ago I'm currently experimenting with an incremental Drush update. I had been pinned to 9.5.2 and the Drush 10 release says it should work with Drush above 9.6. So, I'm trying a mid-point to bump up to 9.7.x and then to 10.x and we'll see.
mikemadison13
commented
4 years ago Confirmed. This is an issue with the remote Drush version.
When running Drush 9.5.2 remotely and 10.1.x locally
lando blt sync:db
[Acquia\Blt\Robo\Tasks\DrushTask] Running /app/vendor/bin/drush cache-clear drush --no-interaction --ansi &&
/app/vendor/bin/drush sql-sync @dgc.dev @self --target-dump=/tmp/tmp.target.sql.gz --structure-tables-key=lightweight --create-db --no-interaction --ansi &&
/app/vendor/bin/drush cr --no-interaction --ansi &&
/app/vendor/bin/drush sql-sanitize --no-interaction --ansi in /app/docroot
[success] 'drush' cache was cleared.
Enter passphrase for key '/user/.ssh/id_rsa':
You will destroy data in drupal8 and replace with data from staging-7801.prod.hosting.acquia.com/capitalcampdev.
[notice] Starting to create database on target.
[notice] Starting to dump database on source.
Enter passphrase for key '/user/.ssh/id_rsa':
In ProcessBase.php line 172:
Output is empty.
sql:sync [--no-dump] [--no-sync] [--runner RUNNER] [--create-db] [--db-su DB-SU] [--db-su-pw DB-SU-PW] [--target-dump TARGET-DUMP] [--source-dump [SOURCE-DUMP]] [--extra-dump] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-d|--debug] [-y|--yes] [--no] [--remote-host REMOTE-HOST] [--remote-user REMOTE-USER] [-r|--root ROOT] [-l|--uri URI] [--simulate] [--pipe] [-D|--define DEFINE] [--skip-tables-key SKIP-TABLES-KEY] [--structure-tables-key STRUCTURE-TABLES-KEY] [--tables-key TABLES-KEY] [--skip-tables-list SKIP-TABLES-LIST] [--structure-tables-list STRUCTURE-TABLES-LIST] [--tables-list TABLES-LIST] [--notify] [--druplicon] [--xh-link XH-LINK] [--] <command> <source> <target>
[Acquia\Blt\Robo\Tasks\DrushTask] Exit code 1 Time 01:07
macbookpro-mikemadison:Drupal-GovCon-2017 mike.madison$ drush @dgc.dev status
Drupal version : 8.7.11
Site URI : capitalcampdev.prod.acquia-sites.com
DB driver : mysql
DB hostname : staging-7801
DB port : 3306
DB username : s8093
DB name : capitalcampdev
Database : Connected
Drupal bootstrap : Successful
Default theme : twentynineteen
Admin theme : seven
PHP binary : /usr/local/php7.2/bin/php
PHP config : /usr/local/php7.2/etc/cli/php.ini
PHP OS : Linux
Drush script : /mnt/www/html/capitalcampdev/vendor/drush/drush/drush
Drush version : 9.5.2
Drush temp : /mnt/tmp/capitalcampdev
Drush configs : /etc/drush/drush.yml
/mnt/www/html/capitalcampdev/vendor/drush/drush/drush.yml
/mnt/www/html/capitalcampdev/drush/drush.yml
Install profile : lightning
Drupal root : /mnt/www/html/capitalcampdev/docroot
Site path : sites/default
Files, Public : sites/default/files
Files, Private : /mnt/files/capitalcamp.dev/sites/default/files-private
Files, Temp : /mnt/tmp/capitalcampdev
Connection to staging-7801.prod.hosting.acquia.com closed.When running Drush 9.7.1 remotely and 10.1.x locally
lando blt sync:db
[Acquia\Blt\Robo\Tasks\DrushTask] Running /app/vendor/bin/drush cache-clear drush --no-interaction --ansi &&
/app/vendor/bin/drush sql-sync @dgc.dev @self --target-dump=/tmp/tmp.target.sql.gz --structure-tables-key=lightweight --create-db --no-interaction --ansi &&
/app/vendor/bin/drush cr --no-interaction --ansi &&
/app/vendor/bin/drush sql-sanitize --no-interaction --ansi in /app/docroot
[success] 'drush' cache was cleared.
Enter passphrase for key '/user/.ssh/id_rsa':
You will destroy data in drupal8 and replace with data from staging-7801.prod.hosting.acquia.com/capitalcampdev.
[notice] Starting to create database on target.
[notice] Starting to dump database on source.
Enter passphrase for key '/user/.ssh/id_rsa':
[notice] Copying dump file from source to target.
// Copy new and override existing files at /tmp/tmp.target.sql.gz. The source is
// capitalcamp.dev@staging-7801.prod.hosting.acquia.com:/home/capitalcamp/drush-backups/capitalcampdev/20191219171735/c
// apitalcampdev_20191219_171736.sql.gz?: yes.
Enter passphrase for key '/user/.ssh/id_rsa':
[notice] Starting to import dump file onto target database.
[success] Cache rebuild complete.
The following operations will be performed:
* Truncate sessions table.
* Sanitize text fields associated with users.
* Sanitize user passwords.
* Sanitize user emails.
* Truncate webform submission tables.
[success] Sessions table truncated.
[success] user__field_bio table sanitized.
[success] No text fields for users need sanitizing.
[success] user__field_drupal_org_username table sanitized.
[success] user__field_first_name table sanitized.
[success] user__field_job_title table sanitized.
[success] user__field_last_name table sanitized.
[success] No text fields for users need sanitizing.
[success] user__field_twitter_account table sanitized.
[success] No text fields for users need sanitizing.
[success] User passwords sanitized.
[success] User emails sanitized.
[success] Webform submission tables truncated.
[Acquia\Blt\Robo\Tasks\DrushTask] Done in 01:56
drush @dgc.dev status
Drupal version : 8.7.11
Site URI : http://capitalcampdev.prod.acquia-sites.com
DB driver : mysql
DB hostname : staging-7801
DB port : 3306
DB username : s8093
DB name : capitalcampdev
Database : Connected
Drupal bootstrap : Successful
Default theme : twentynineteen
Admin theme : seven
PHP binary : /usr/local/php7.2/bin/php
PHP config : /usr/local/php7.2/etc/cli/php.ini
PHP OS : Linux
Drush script : /mnt/www/html/capitalcampdev/vendor/drush/drush/drush
Drush version : 9.7.1
Drush temp : /mnt/tmp/capitalcampdev
Drush configs : /etc/drush/drush.yml
/mnt/www/html/capitalcampdev/vendor/drush/drush/drush.yml
/mnt/www/html/capitalcampdev/drush/drush.yml
Install profile : lightning
Drupal root : /mnt/www/html/capitalcampdev/docroot
Site path : sites/default
Files, Public : sites/default/files
Files, Private : /mnt/files/capitalcamp.dev/sites/default/files-private
Files, Temp : /mnt/tmp/capitalcampdev
Connection to staging-7801.prod.hosting.acquia.com closed.@danepowell i would suggest we post a warning somewhere that indicates that you cannot jump directly from Drush 9.5.x to Drush 10.x. Maybe this ticket is sufficient? Otherwise I think we can close this.
See https://github.com/drush-ops/drush/releases/tag/10.0.0-alpha1 for notes re: compatibility with Drush 10.x.
danepowell
commented
4 years ago Thanks for reporting, I've added a warning on this to the BLT 11 release notes: https://support.acquia.com/hc/en-us/articles/360039081454#howtoupgrade
It might also be good to have a dedicated knowledge base entry on this if you're able to create that.
mikemadison13
commented
4 years ago danepowell
commented
4 years ago I noted the "output is empty" message on https://support.acquia.com/hc/en-us/articles/360035203713 since that seemed to be new.
Note sure if this could be prevented with https://github.com/acquia/blt/issues/3685
This may be related to https://github.com/acquia/blt/issues/3658
Describe the bug After upgrading from Drush 9.5.2 to Drush 10.1.1 I can no longer perform
blt sync:dboperations from the cloud.Note that earlier today I updated to BLT 11.x and Drupal 8.7.11 without incident in the Lando VM. All works fine. As soon as I update everything else this starts happening.
To Reproduce Steps to reproduce the behavior, ideally starting from a fresh install of BLT:
lando startand ask me to give you access to the DGC sub if you don't have itcomposer updatelando blt sync:dbExpected behavior Database syncs
Detailed error output
BLT doctor output
System information
Additional context Facepalm.