ddev: Pantheon ddev pull fails after download, during import.

What happened (or feature request):

I tried to do a ddev pull, got the following error:

~/Sites/artist [master*]$ ddev pull
You're about to delete the current database and files and replace with a fresh import. Would you like to continue (y/N): y
Importing database... 
Could not perform import: Failed to run docker-compose [-f /Users/michael/Sites/artist/.ddev/docker-compose.yaml exec -T db bash -c cat /db/*.sql | mysql], err='exit status 1', stdout='ERROR 1227 (42000) at line 6894: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
', stderr='' 

I had just done a ddev start on an existing codebase that I hadn’t used DDEV for previously.

What you expected to happen:

The pull to be complete.

How to reproduce this:

I could share the project with someone, I suppose…

Version: Please include the output of ddev version, docker version and the project’s .ddev/config.yaml.

~/Sites/artist [master*]$ ddev version
domain	ddev.local                     
cli   	v0.13.1                        
web   	drud/nginx-php-fpm-local:v0.9.3
db    	drud/mariadb-local:v0.7.1      
dba   	drud/phpmyadmin:v0.2.0         
router	drud/ddev-router:v0.5.0        
commit	v0.13.1  
~/Sites/artist [master*]$ docker version
Client:
 Version:	17.12.0-ce
 API version:	1.35
 Go version:	go1.9.2
 Git commit:	c97c6d6
 Built:	Wed Dec 27 20:03:51 2017
 OS/Arch:	darwin/amd64

Server:
 Engine:
  Version:	17.12.0-ce
  API version:	1.35 (minimum version 1.12)
  Go version:	go1.9.2
  Git commit:	c97c6d6
  Built:	Wed Dec 27 20:12:29 2017
  OS/Arch:	linux/amd64
  Experimental:	true
~/Sites/artist [master*]$ cat .ddev/config.yaml 
APIVersion: "1"
name: artist
type: drupal7
docroot: ""
php_version: "7.1"
webimage: drud/nginx-php-fpm-local:v0.9.3
dbimage: drud/mariadb-local:v0.7.1
dbaimage: drud/phpmyadmin:v0.2.0
router_http_port: "80"
router_https_port: "8443"
provider: pantheon

# Certain ddev commands can be extended to run tasks before or after the ddev
# command is executed.
# See https://ddev.readthedocs.io/en/latest/users/extending-commands/ for more
# information on the commands that can be extended and the tasks you can define
# for them.
# hooks:
#   post-import-db:
#     - exec: "drush cc all"

Anything else do we need to know:

Nothing comes to mind.

Related source links or issues:

I saw https://github.com/drud/ddev/issues/466, but it doesn’t sound like the same thing.

Please use a complexity rating of 1-5 (5 is high) for a feature request. (High complexity implies more PR planning)

About this issue

  • Original URL
  • State: closed
  • Created 6 years ago
  • Comments: 21 (17 by maintainers)

Commits related to this issue

Most upvoted comments

@texvetadmin @ultimike I think both of your problems should be fixed in today’s v0.19.0 release, and hope you’ll be able to try it out and confirm. @texvetadmin thanks to your generosity in sharing your pantheon project I was already able to give a quick run on yours and it worked out fine. Thanks for that!

Opened drud/mariadb-local#55 to solve this generally.

BTW @texvetadmin I don’t think those long filenames actually cause a failure that would be in your way; take a look and see if most everything you need isn’t there in sites/default/files. Mostly with big sites like that having every single one of the files is a waste. People have requested a ddev pull --database-only in https://github.com/drud/ddev/issues/405, I imagine we’ll get that going.

Closing this one unless we hear otherwise, assuming #693 solves it. Note that this was a D7 site though, which by default would not have the include of settings.local.php, which could cause this kind of breakage. Happy to reopen!