select * from migrations_lock - Unknown storage engine 'InnoDB'

[focher]

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.

[jc21]

See this issue: jc21/docker-mariadb-aria#8

You'll need to use the jc21/mariadb-aria:10.4.15-innodb image.