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
- Make mariadb root user work, drop tables before import, fixes #852, fixes #853, fixes #810, fixes #670 (#891) — committed to ddev/ddev by rfay 6 years ago
@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!