Unknown/unsupported storage engine: InnoDB

angelxmoreno commented 5 years ago

Getting an error Unknown/unsupported storage engine: InnoDB. This is my compose file snippet

mysql:
    container_name: ${APP_NAME}-mysql
    image: yobasystems/alpine-mariadb
    ports:
    - 8806:3306/tcp
    volumes:
    - './docker/data/mysql:/var/lib/mysql'
    environment:
    - MYSQL_ROOT_PASSWORD=${APP_NAME}
    - MYSQL_DATABASE=${APP_NAME}
    - MYSQL_USER=${APP_NAME}
    - MYSQL_PASSWORD=${APP_NAME}

dominictayloruk commented 5 years ago

Host info? Docker info?

angelxmoreno commented 5 years ago

Host Info: MacOs High Sierra Docker Info:

Containers: 19
 Running: 6
 Paused: 0
 Stopped: 13
Images: 61
Server Version: 18.06.1-ce
Storage Driver: overlay2
 Backing Filesystem: extfs
 Supports d_type: true
 Native Overlay Diff: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
 Volume: local
 Network: bridge host ipvlan macvlan null overlay
 Log: awslogs fluentd gcplogs gelf journald json-file logentries splunk syslog
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Init Binary: docker-init
containerd version: 468a545b9edcd5932818eb9de8e72413e616e86e
runc version: 69663f0bd4b60df09991c08812a60108003fa340
init version: fec3683
Security Options:
 seccomp
  Profile: default
Kernel Version: 4.9.93-linuxkit-aufs
Operating System: Docker for Mac
OSType: linux
Architecture: x86_64
CPUs: 2
Total Memory: 1.952GiB
Name: linuxkit-025000000001
ID: ES3Z:FKKG:FRQY:KV7O:TP3B:4HGB:WV2A:OYMV:PULI:OION:JDKU:OEZO
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): true
 File Descriptors: 80
 Goroutines: 127
 System Time: 2018-11-09T03:05:19.6913979Z
 EventsListeners: 4
HTTP Proxy: gateway.docker.internal:3128
HTTPS Proxy: gateway.docker.internal:3129
Registry: https://index.docker.io/v1/
Labels:
Experimental: true
Insecure Registries:
 127.0.0.0/8
Live Restore Enabled: false

dominictayloruk commented 5 years ago

This is a permissions error on the host mapped volume.

If you go into Finder > Choose the folder > Right click > Get Info > Sharing & Permissions (At the bottom) > Click the padlock, Unlock and enter your password > Everyone > Read & Write

sharing

dominictayloruk commented 5 years ago

Your permissions in the folder ./docker/data/mysql are the ones you need read & write access

ixre commented 5 years ago

i have got this error too:

2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Uses event mutexes
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Using Linux native AIO
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Number of pools: 1
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Using SSE2 crc32 instructions
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-12-05  2:19:42 140219419040648 [Note] InnoDB: Completed initialization of buffer pool
2018-12-05  2:19:42 140219177523944 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-12-05  2:19:42 140219419040648 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 0 pages than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2018-12-05  2:19:42 140219419040648 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2018-12-05  2:19:43 140219419040648 [Note] InnoDB: Starting shutdown...
2018-12-05  2:19:43 140219419040648 [ERROR] Plugin 'InnoDB' init function returned error.
2018-12-05  2:19:43 140219419040648 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-12-05  2:19:43 140219419040648 [Note] Plugin 'FEEDBACK' is disabled.
2018-12-05  2:19:43 140219419040648 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-12-05  2:19:43 140219419040648 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-12-05  2:19:43 140219419040648 [ERROR] Aborting

yobasystems / alpine-mariadb

Unknown/unsupported storage engine: InnoDB #16