select * from `migrations_lock` - Unknown storage engine 'InnoDB' #1349

focher · 2021-08-24T13:48:01Z

focher
Aug 24, 2021

I recently moved the database image from 10.4 to latest in the docker-compose.yml file.

image: 'jc21/mariadb-aria:latest'

When I try to start nginx-proxy-manager now with docker-compose up I get the following.

[~/docker/nginx] # docker-compose up     
Starting nginx    ... done
Starting web      ... done
Starting nginx-db ... done
Attaching to nginx, nginx-db, web
nginx-db | [i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh
nginx-db | [i] mysqld already present, skipping creation
nginx-db | [i] MySQL directory already present, skipping creation
nginx-db | 2021-08-24 13:39:20 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 1 ...
nginx-db | 2021-08-24 13:39:20 0 [Note] Plugin 'InnoDB' is disabled.
nginx-db | 2021-08-24 13:39:20 0 [Note] Plugin 'FEEDBACK' is disabled.
nginx-db | 2021-08-24 13:39:20 0 [Note] Server socket created on IP: '::'.
web    | 2021-08-24 13:39:20: (server.c.1513) server started (lighttpd/1.4.57)
nginx  | [s6-init] making user provided files available at /var/run/s6/etc...exited 0.
nginx-db | 2021-08-24 13:39:20 0 [Warning] 'user' entry '@nginx-db' ignored in --skip-name-resolve mode.
nginx-db | 2021-08-24 13:39:20 0 [Warning] 'proxies_priv' entry '@% root@nginx-db' ignored in --skip-name-resolve mode.
nginx-db | 2021-08-24 13:39:20 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
nginx-db | 2021-08-24 13:39:20 0 [Note] Reading of all Master_info entries succeeded
nginx-db | 2021-08-24 13:39:20 0 [Note] Added new Master_info '' to hash table
nginx-db | 2021-08-24 13:39:20 0 [Note] /usr/bin/mysqld: ready for connections.
nginx-db | Version: '10.4.15-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
nginx  | [s6-init] ensuring user provided files have correct perms...exited 0.
nginx  | [fix-attrs.d] applying ownership & permissions fixes...
nginx  | [fix-attrs.d] done.
nginx  | [cont-init.d] executing container initialization scripts...
nginx  | [cont-init.d] 01_perms.sh: executing... 
nginx  | Changing ownership of /data/logs to 0:0
nginx  | [cont-init.d] 01_perms.sh: exited 0.
nginx  | [cont-init.d] 01_s6-secret-init.sh: executing... 
nginx  | [cont-init.d] 01_s6-secret-init.sh: exited 0.
nginx  | [cont-init.d] done.
nginx  | [services.d] starting services
nginx  | [services.d] done.
nginx  | ❯ Enabling IPV6 in hosts: /etc/nginx/conf.d
nginx  |   ❯ /etc/nginx/conf.d/default.conf
nginx  |   ❯ /etc/nginx/conf.d/include/assets.conf
nginx  |   ❯ /etc/nginx/conf.d/include/block-exploits.conf
nginx  |   ❯ /etc/nginx/conf.d/include/force-ssl.conf
nginx  |   ❯ /etc/nginx/conf.d/include/ip_ranges.conf
nginx  |   ❯ /etc/nginx/conf.d/include/letsencrypt-acme-challenge.conf
nginx  |   ❯ /etc/nginx/conf.d/include/proxy.conf
nginx  |   ❯ /etc/nginx/conf.d/include/ssl-ciphers.conf
nginx  |   ❯ /etc/nginx/conf.d/include/resolvers.conf
nginx  |   ❯ /etc/nginx/conf.d/production.conf
nginx  | ❯ Enabling IPV6 in hosts: /data/nginx
nginx  |   ❯ /data/nginx/proxy_host/1.conf
nginx  |   ❯ /data/nginx/proxy_host/7.conf
nginx  | [8/24/2021] [1:39:23 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:24 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:25 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:26 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:27 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:28 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:29 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
nginx  | [8/24/2021] [1:39:30 PM] [Global   ] › ✖  error     select * from `migrations_lock` - ER_UNKNOWN_STORAGE_ENGINE: Unknown storage engine 'InnoDB'
...

I made no other changes. Before I blow away the whole thing and start fresh, wondering if there's a quick fix.