`ddev import-db` doesn't work with a snapshot #5621

joachim-n · 2023-12-12T11:57:24Z

Is there an existing issue for this?

I have searched the existing issues

Output of `ddev debug test`

Expand `ddev debug test` diagnostic information

Running bash [-c /var/folders/t3/ptwnwfr90m93bpx3k3l2d8vw0000gn/T/test_ddev.sh]
======= Existing project config =========
These config files were loaded for project bi-com-giotrif-static-site: [/Users/joachim/Sites/static-poc/.ddev/config.yaml]
name: bi-com-giotrif-static-site
type: drupal9
docroot: docroot
php_version: 8.1
webserver_type: nginx-fpm
webimage: ddev/ddev-webserver:v1.22.4
additional_hostnames: [bi-com-giotrif-static-tome]
additional_fqdns: []
database: {mariadb 10.4}
project_tld: ddev.site
use_dns_when_possible: true
composer_version: 2
nodejs_version: 18
default_container_timeout: 120
======= Creating dummy project named  tryddevproject-17798 in ../tryddevproject-17798 =========
OS Information: Darwin Joachims-iMac.local 22.6.0 Darwin Kernel Version 22.6.0: Wed Jul  5 22:22:52 PDT 2023; root:xnu-8796.141.3~6/RELEASE_ARM64_T8103 arm64
ProductName:		macOS
ProductVersion:		13.5.1
BuildVersion:		22G90
User information: uid=501(joachim) gid=20(staff) groups=20(staff),12(everyone),61(localaccounts),79(_appserverusr),80(admin),81(_appserveradm),98(_lpadmin),701(com.apple.sharepoint.group.1),33(_appstore),100(_lpoperator),204(_developer),250(_analyticsusers),395(com.apple.access_ftp),398(com.apple.access_screensharing),399(com.apple.access_ssh),400(com.apple.access_remote_ae)
DDEV version:  ITEM             VALUE
 DDEV version     v1.22.4
 architecture     arm64
 db               ddev/ddev-dbserver-mariadb-10.4:v1.22.4
 ddev-ssh-agent   ddev/ddev-ssh-agent:v1.22.4
 docker           24.0.5
 docker-compose   v2.21.0
 docker-platform  colima
 mutagen          0.17.2
 os               darwin
 router           ddev/ddev-traefik-router:v1.22.4
 web              ddev/ddev-webserver:v1.22.4
PROXY settings: HTTP_PROXY='' HTTPS_PROXY='' http_proxy='' NO_PROXY=''
======= DDEV global info =========
Global configuration:
instrumentation-opt-in=true
omit-containers=[]
performance-mode=mutagen
router-bind-all-interfaces=false
internet-detection-timeout-ms=3000
disable-http2=false
use-letsencrypt=false
letsencrypt-email=
table-style=default
simple-formatting=false
use-hardened-images=false
fail-on-hook-fail=false
required-docker-compose-version=v2.21.0
use-docker-compose-from-path=false
project-tld=
xdebug-ide-location=192.168.104.2
no-bind-mounts=false
router=traefik
wsl2-no-windows-hosts-mgt=false
router-http-port=80
router-https-port=443
mailpit-http-port=8025
mailpit-https-port=8026
traefik-monitor-port=10999

======= DOCKER info =========
docker location: lrwxr-xr-x@ 1 joachim  admin  34  3 Sep 10:36 /opt/homebrew/bin/docker -> ../Cellar/docker/24.0.5/bin/docker
Docker Desktop Version: Print: Entry, ":CFBundleShortVersionString", Does Not Exist
Print: Entry, ":CFBundleVersion", Does Not Exist
Docker Desktop for Mac File build Doesn'tDocker Desktop for Mac Exist, build WillDocker Desktop for Mac Create: build /Applications/Docker.app/Contents/Info.plistDocker Desktop for Mac File build Doesn'tDocker Desktop for Mac Exist, build WillDocker Desktop for Mac Create: build /Applications/Docker.app/Contents/Info.plist
docker version:
Client: Docker Engine - Community
 Version:           24.0.5
 API version:       1.43
 Go version:        go1.20.6
 Git commit:        ced0996600
 Built:             Wed Jul 19 19:44:22 2023
 OS/Arch:           darwin/arm64
 Context:           default

Server:
 Engine:
  Version:          24.0.5
  API version:      1.43 (minimum version 1.12)
  Go version:       go1.20.7
  Git commit:       24.0.5-0ubuntu1
  Built:            Wed Aug 16 21:32:36 2023
  OS/Arch:          linux/arm64
  Experimental:     false
 containerd:
  Version:          1.7.2
  GitCommit:
 runc:
  Version:          1.1.7-0ubuntu2
  GitCommit:
 docker-init:
  Version:          0.19.0
  GitCommit:
DOCKER_DEFAULT_PLATFORM=notset
======= Mutagen Info =========
Mutagen is installed in ddev, version=0.17.2
--------------------------------------------------------------------------------
Name: accounts-8
Identifier: sync_5tsTUFSQRmVdDNeMiH9D6ffmITFeqeqDP4jzL7xyht5
Labels:
	com.ddev.config-hash: c212281329fb24762a96e1b7a37a19ed84868866
	com.ddev.volume-signature: Users-joachim-colima-default-1699954946
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/web/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/accounts-8
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: Yes
	Synchronizable contents:
		8971 directories
		34371 files (213 MB)
		4 symbolic links
	Transition problems:
		vendor/mikey179/vfsstream: unable to create directory: file exists
Beta:
	URL: docker://ddev-accounts-8-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: Yes
	Synchronizable contents:
		8998 directories
		34443 files (214 MB)
		4 symbolic links
Status: Watching for changes
--------------------------------------------------------------------------------
Name: contrib-development
Identifier: sync_hQjzoJqb3sJfK8LjiZH72OzkhsT2lksNfVip9o6n8GA
Labels:
	com.ddev.config-hash: c212281329fb24762a96e1b7a37a19ed84868866
	com.ddev.volume-signature: Users-joachim-colima-default-1699954987
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/web/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/contrib-development
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: Yes
Beta:
	URL: docker://ddev-contrib-development-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: Connecting to beta
--------------------------------------------------------------------------------
Name: drupal-core-development-project
Identifier: sync_qiST6hih0HJj5sQzcDjb0s7lOGC3oC3VAnjqN2ddvrq
Labels:
	com.ddev.config-hash: c212281329fb24762a96e1b7a37a19ed84868866
	com.ddev.volume-signature: Users-joachim-colima-default-1699956103
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/web/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/drupal-core-development-project
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: Yes
Beta:
	URL: docker://ddev-drupal-core-development-project-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: Connecting to beta
--------------------------------------------------------------------------------
Name: bi-com-careers
Identifier: sync_Db9yhpTRlJ36C8XEH56XBUcv62eL2dWMhwZVGkMVuvH
Labels:
	com.ddev.config-hash: 654a7799e053320033f4baa45c0f9c345f2546e4
	com.ddev.volume-signature: Users-joachim-colima-default-1699960464
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/docroot/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/bi-com-sources/bi-com-careers
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: No
Beta:
	URL: docker://ddev-bi-com-careers-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: [Paused]
--------------------------------------------------------------------------------
Name: dcb-development
Identifier: sync_d979ZILRhJ3tq9d5MdhAoXWIbmfmRum7LlHZIKt1qMK
Labels:
	com.ddev.config-hash: c212281329fb24762a96e1b7a37a19ed84868866
	com.ddev.volume-signature: Users-joachim-colima-default-1700475861
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/web/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/dcb-development
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: No
Beta:
	URL: docker://ddev-dcb-development-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: [Paused]
--------------------------------------------------------------------------------
Name: bi-com-refactor
Identifier: sync_VuOHnN2obmSxOrZ88xxneIT0Njty5HURtmNseBcnjU0
Labels:
	com.ddev.config-hash: 654a7799e053320033f4baa45c0f9c345f2546e4
	com.ddev.volume-signature: Users-joachim-colima-default-1700478921
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/docroot/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/bi-com-refactor
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: No
Beta:
	URL: docker://ddev-bi-com-refactor-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: [Paused]
--------------------------------------------------------------------------------
Name: thewsd
Identifier: sync_7TGEeJ031WWxhOK22TYwQ91F5VOctar8L8FNIIHzJcm
Labels:
	com.ddev.config-hash: c212281329fb24762a96e1b7a37a19ed84868866
	com.ddev.volume-signature: Users-joachim-colima-default-1701084210
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/web/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/thewsd
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: Yes
Beta:
	URL: docker://ddev-thewsd-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: No
Status: Connecting to beta
--------------------------------------------------------------------------------
Name: bi-com-giotrif-static-site
Identifier: sync_YhoMLdenq2OLifVo5I42vCU6NhhOIiA75YRHF6SaZIc
Labels:
	com.ddev.config-hash: 654a7799e053320033f4baa45c0f9c345f2546e4
	com.ddev.volume-signature: Users-joachim-colima-default-1701858949
Configuration:
	Synchronization mode: Two Way Resolved
	Hashing algorithm: Default (SHA-1)
	Maximum allowed entry count: Default (2⁶⁴−1)
	Maximum staging file size: Default (18 EB)
	Symbolic link mode: POSIX Raw
	Ignore VCS mode: Default (Propagate)
	Ignores:
		/.git
		/.tarballs
		/.ddev/db_snapshots
		/.ddev/.importdb*
		.DS_Store
		.idea
		/docroot/sites/default/files
	Permissions mode: Default (Portable)
Alpha:
	URL: /Users/joachim/Sites/static-poc
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
	Connected: Yes
	Synchronizable contents:
		12190 directories
		49603 files (1.0 GB)
		4 symbolic links
Beta:
	URL: docker://ddev-bi-com-giotrif-static-site-web/var/www/html
		DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
	Configuration:
		Watch mode: Default (Portable)
		Watch polling interval: Default (10 seconds)
		Probe mode: Default (Probe)
		Scan mode: Default (Accelerated)
		Stage mode: Neighboring
		File mode: Default (0600)
		Directory mode: Default (0700)
		Default file/directory owner: Default
		Default file/directory group: Default
		Compression: Default (DEFLATE)
	Connected: Yes
	Synchronizable contents:
		12185 directories
		49601 files (1.0 GB)
		4 symbolic links
Conflicts:
	(alpha) html/image-captcha-generate/.DS_Store (<non-existent> -> Untracked content)
	(beta)  html/image-captcha-generate (Directory -> <non-existent>)
Status: Watching for changes
--------------------------------------------------------------------------------
======= Docker Info =========
Docker platform: colima
Colima version: 0.6.1
Using Docker context: default (unix:///Users/joachim/.colima/default/docker.sock)
docker-compose: v2.21.0
Using DOCKER_HOST=unix:///Users/joachim/.colima/default/docker.sock
Docker version: 24.0.5
Able to run simple container that mounts a volume.
Able to use internet inside container.
Docker disk space:
Filesystem                Size      Used Available Use% Mounted on
overlay                  95.8G     25.5G     70.3G  27% /

Unable to create project at project root '/Users/joachim/Sites/drupal-core-composer': project root /Users/joachim/Sites/drupal-core-composer does not exist
Unable to create project at project root '/Users/joachim/Sites/test-composer-fucking-upgrade': project root /Users/joachim/Sites/test-composer-fucking-upgrade does not exist
 Container ddev-accounts-8-web  Stopped
 Container ddev-accounts-8-db  Stopped
 Container ddev-accounts-8-web  Stopped
 Container ddev-accounts-8-db  Stopped
 Container ddev-accounts-8-db  Removed
 Container ddev-accounts-8-web  Removed
 Network ddev-accounts-8_default  Removed
Project accounts-8 has been stopped.
 Container ddev-bi-com-giotrif-static-site-web  Stopped
 Container ddev-bi-com-giotrif-static-site-db  Stopped
 Container ddev-bi-com-giotrif-static-site-web  Stopped
 Container ddev-bi-com-giotrif-static-site-db  Stopped
 Container ddev-bi-com-giotrif-static-site-web  Removed
 Container ddev-bi-com-giotrif-static-site-db  Removed
 Network ddev-bi-com-giotrif-static-site_default  Removed
Project bi-com-giotrif-static-site has been stopped.
 Container ddev-contrib-development-db  Stopped
 Container ddev-contrib-development-web  Stopped
 Container ddev-contrib-development-db  Removed
 Container ddev-contrib-development-web  Removed
 Network ddev-contrib-development_default  Removed
Project contrib-development has been stopped.
 Container ddev-drupal-core-development-project-web  Stopped
 Container ddev-drupal-core-development-project-db  Stopped
 Container ddev-drupal-core-development-project-db  Removed
 Container ddev-drupal-core-development-project-web  Removed
 Network ddev-drupal-core-development-project_default  Removed
Project drupal-core-development-project has been stopped.
 Container ddev-thewsd-tempstorage-1  Stopping
 Container ddev-thewsd-proxyservice-1  Stopping
 Container ddev-thewsd-htmlcodesniffer-1  Stopping
 Container ddev-thewsd-urlfetching-1  Stopping
 Container ddev-thewsd-proxydefault-1  Stopping
 Container ddev-thewsd-athenapdf-1  Stopping
 Container ddev-thewsd-sitemap-1  Stopping
 Container ddev-thewsd-imagetestworker-1  Stopping
 Container ddev-thewsd-urlfetcher-1  Stopping
 Container ddev-thewsd-crawler-1  Stopping
 Container ddev-thewsd-servicediscovery-1  Stopping
 Container ddev-thewsd-sitemapgenerator-1  Stopping
 Container ddev-thewsd-h1worker-1  Stopping
 Container ddev-thewsd-imagetestworker-1  Stopped
 Container ddev-thewsd-urlfetcher-1  Stopped
 Container ddev-thewsd-urlfetching-1  Stopped
 Container ddev-thewsd-proxydefault-1  Stopped
 Container ddev-thewsd-tempstorage-1  Stopped
 Container ddev-thewsd-proxyservice-1  Stopped
 Container ddev-thewsd-sitemap-1  Stopped
 Container ddev-thewsd-athenapdf-1  Stopped
 Container ddev-thewsd-htmlcodesniffer-1  Stopped
 Container ddev-thewsd-servicediscovery-1  Stopped
 Container ddev-thewsd-sitemapgenerator-1  Stopped
 Container ddev-thewsd-h1worker-1  Stopped
 Container ddev-thewsd-crawler-1  Stopped
 Container ddev-thewsd-rabbit1-1  Stopping
 Container ddev-thewsd-rabbit1-1  Stopped


 [OK] Task `stop` executed successfully!


Going to remove ddev-thewsd-h1worker-1, ddev-thewsd-imagetestworker-1, ddev-thewsd-crawler-1, ddev-thewsd-urlfetcher-1, ddev-thewsd-proxydefault-1, ddev-thewsd-servicediscovery-1, ddev-thewsd-rabbit1-1, ddev-thewsd-sitemapgenerator-1, ddev-thewsd-urlfetching-1, ddev-thewsd-sitemap-1, ddev-thewsd-tempstorage-1, ddev-thewsd-proxyservice-1, ddev-thewsd-htmlcodesniffer-1, ddev-thewsd-athenapdf-1
 Container ddev-thewsd-athenapdf-1  Removing
 Container ddev-thewsd-rabbit1-1  Removing
 Container ddev-thewsd-sitemapgenerator-1  Removing
 Container ddev-thewsd-proxydefault-1  Removing
 Container ddev-thewsd-crawler-1  Removing
 Container ddev-thewsd-urlfetching-1  Removing
 Container ddev-thewsd-urlfetcher-1  Removing
 Container ddev-thewsd-sitemap-1  Removing
 Container ddev-thewsd-h1worker-1  Removing
 Container ddev-thewsd-tempstorage-1  Removing
 Container ddev-thewsd-servicediscovery-1  Removing
 Container ddev-thewsd-imagetestworker-1  Removing
 Container ddev-thewsd-htmlcodesniffer-1  Removing
 Container ddev-thewsd-proxyservice-1  Removing
 Container ddev-thewsd-htmlcodesniffer-1  Removed
 Container ddev-thewsd-athenapdf-1  Removed
 Container ddev-thewsd-proxyservice-1  Removed
 Container ddev-thewsd-imagetestworker-1  Removed
 Container ddev-thewsd-urlfetching-1  Removed
 Container ddev-thewsd-servicediscovery-1  Removed
 Container ddev-thewsd-sitemapgenerator-1  Removed
 Container ddev-thewsd-tempstorage-1  Removed
 Container ddev-thewsd-crawler-1  Removed
 Container ddev-thewsd-h1worker-1  Removed
 Container ddev-thewsd-proxydefault-1  Removed
 Container ddev-thewsd-sitemap-1  Removed
 Container ddev-thewsd-urlfetcher-1  Removed
 Container ddev-thewsd-rabbit1-1  Removed

 [OK] Task `rm` executed successfully!


 Container ddev-thewsd-frontend-1  Stopped
 Container ddev-thewsd-test_report_creator-1  Stopped
 Container ddev-thewsd-test_report_creator-1  Removed
 Container ddev-thewsd-frontend-1  Removed
 Container ddev-thewsd-web  Stopped
 Container ddev-thewsd-web  Removed
 Container ddev-thewsd-db  Stopped
 Container ddev-thewsd-redis-1  Stopped
 Container ddev-thewsd-db  Removed
 Container ddev-thewsd-redis-1  Removed
 Network ddev-thewsd_default  Removed
Failed to stop project thewsd:
API error (500): Could not kill running container 48d9d2604506aa40677da8ccc10f265350de2dd474815ec8dbfe936bd5e2ef9a, cannot remove - container 48d9d2604506 PID 6403 is zombie and can not be killed. Use the --init option when creating containers to run an init inside the container that forwards signals and reaps processes
Existing docker containers:
CONTAINER ID   IMAGE                               COMMAND                  CREATED       STATUS                    PORTS                                                                                                          NAMES
48d9d2604506   ddev/ddev-traefik-router:v1.22.4    "/entrypoint.sh --co…"   2 hours ago   Up 2 hours (healthy)      127.0.0.1:80->80/tcp, 127.0.0.1:443->443/tcp, 127.0.0.1:8025-8026->8025-8026/tcp, 127.0.0.1:10999->10999/tcp   ddev-router
f25c81ae5e6a   ddev/ddev-ssh-agent:v1.22.4-built   "/entry.sh ssh-agent"    2 hours ago   Up 2 hours (healthy)                                                                                                                     ddev-ssh-agent
6588c53a69c3   ddev/ddev-webserver:v1.22.4         "sh -c 'mkdir -p /mn…"   6 days ago    Exited (137) 6 days ago                                                                                                                  CopyIntoVolume_hcfhvgevbeaa
d98eef9b134d   factorial/multibasebox:2.0.0        "docker-entrypoint.s…"   2 weeks ago   Created                                                                                                                                  haproxy
68ac9d1d9d20   andyshinn/dnsmasq                   "dnsmasq -k --addres…"   2 weeks ago   Up 2 hours                0.0.0.0:5300->53/tcp, 0.0.0.0:5300->53/udp, :::5300->53/tcp, :::5300->53/udp                                   dnsmasq
Starting tryddevproject-17798...
Building project images...
Project images built in 0s.
 Network ddev-tryddevproject-17798_default  Created
 Container ddev-tryddevproject-17798-db  Created
 Container ddev-tryddevproject-17798-web  Created
 Container ddev-tryddevproject-17798-db  Started
 Container ddev-tryddevproject-17798-web  Started
You have Mutagen enabled and your 'php' project type doesn't have `upload_dirs` set.
For faster startup and less disk usage, set upload_dirs to where your user-generated files are stored.
If this is intended you can disable this warning with `ddev config --disable-upload-dirs-warning`.
Starting Mutagen sync process...
Mutagen sync flush completed in 1s.
For details on sync status 'ddev mutagen st tryddevproject-17798 -l'
Waiting for web/db containers to become ready: [web db]
Starting ddev-router if necessary...
 Container ddev-router  Created
 Container ddev-router  Started
Waiting for additional project containers to become ready...
All project containers are now ready.
Successfully started tryddevproject-17798
Project can be reached at https://tryddevproject-17798.ddev.site https://127.0.0.1:32771
======== Curl of site from inside container:
HTTP/1.1 200 OK
Server: nginx
Date: Tue, 12 Dec 2023 11:55:04 GMT
Content-Type: text/html; charset=UTF-8
Connection: keep-alive
Vary: Accept-Encoding

======== curl -I of http://tryddevproject-17798.ddev.site from outside:
HTTP/1.1 200 OK
Content-Type: text/html; charset=UTF-8
Date: Tue, 12 Dec 2023 11:55:05 GMT
Server: nginx
Vary: Accept-Encoding

======== full curl of http://tryddevproject-17798.ddev.site from outside:
Success accessing database... db via TCP/IP
ddev is working. You will want to delete this project with 'ddev delete -Oy tryddevproject-17798'
======== Project ownership on host:
drwxr-xr-x@ 4 joachim  staff  128 12 Dec 11:53 ../tryddevproject-17798
======== Project ownership in container:
drwxr-xr-x 4 joachim dialout 4096 Dec 12 11:54 /var/www/html
======== In-container filesystem:
Filesystem     Type 1K-blocks     Used Available Use% Mounted on
/dev/root      ext4 100476656 26470216  73990056  27% /var/www
======== curl again of tryddevproject-17798 from host:
Success accessing database... db via TCP/IP
ddev is working. You will want to delete this project with 'ddev delete -Oy tryddevproject-17798'
Thanks for running the diagnostic. It was successful.
Please provide the output of this script in a new gist at gist.github.com
Running ddev launch in 5 seconds

Please run cleanup after debugging with 'ddev debug testcleanup'

Expected Behavior

Either import the DB or tell me to use 'snapshot restore'?

Actual Behavior

I didn't know about 'snapshot restore' so I tried doing:

ddev import-db --file=.ddev/db_snapshots/bi-com-giotrif-static-site_20231212113511-mariadb_10.4.gz

I got:

ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.
 144KiB 0:00:00 [25.6MiB/s] [>                                                                                  ]  1%
Error: failed to import database 'db' for bi-com-giotrif-static-site: failed to import database: exit status 1
stdout:
stderr:
Usage:
  ddev import-db [project] [flags]

Steps To Reproduce

do ddev snapshot
Try to do ddev import-db with the snapshot file

Anything else?

No response

The text was updated successfully, but these errors were encountered:

tyler36 · 2023-12-12T23:59:17Z

AFAIK,

ddev snapshot creates a binary copy of the database.
ddev import-db imports a previously exported databases.

They both deal with database representations but in completely different formats which are not compatible.

Snapshots are much faster to create (ddev snapshot --name="") and restore (ddev snapshot restore) so I generally use them locally.

joachim-n mentioned this issue Dec 12, 2023

feat: add detail about restore command to snapshot command output, fixes #5621 #5622

Merged

stasadev closed this as completed in 2c03155 Dec 13, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

`ddev import-db` doesn't work with a snapshot #5621

`ddev import-db` doesn't work with a snapshot #5621

joachim-n commented Dec 12, 2023

tyler36 commented Dec 12, 2023 •

edited

ddev import-db doesn't work with a snapshot #5621

ddev import-db doesn't work with a snapshot #5621

Comments

joachim-n commented Dec 12, 2023

Is there an existing issue for this?

Output of ddev debug test

Expected Behavior

Actual Behavior

Steps To Reproduce

Anything else?

tyler36 commented Dec 12, 2023 • edited

`ddev import-db` doesn't work with a snapshot #5621

`ddev import-db` doesn't work with a snapshot #5621

Output of `ddev debug test`

tyler36 commented Dec 12, 2023 •

edited