Bad Gateway on Login Page

[SteveDevDev]

I get Bad Gateway when trying to sign in. I have tried several different things but none of it is working to resolve the issue.

Docker-compose.yaml

version: "3"
services:
  app:
    image: jc21/nginx-proxy-manager:latest
    restart: always
    ports:
      # Public HTTP Port:
      - '80:80'
      # Public HTTPS Port:
      - '443:443'
      # Admin Web Port:
      - '81:81'
    volumes:
      - /opt/nginx-proxy/config.json:/app/config/production.json
      - /opt/nginx-proxy/nginx.conf:/etc/nginx/nginx.conf
      - app-data:/data
      - app-letsencrypt:/etc/letsencrypt
    depends_on:
      - db
  db:
    image: jc21/mariadb-aria:10.4.15-innodb
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: 'password'
      MYSQL_DATABASE: 'npm'
      MYSQL_USER: 'npm'
      MYSQL_PASSWORD: 'password'
#    networks:
#      default:
#        ipv4_address: 10.10.10.2
    volumes:
      - app-sql:/var/lib/mysql


volumes:
  app-data:
     driver_opts:
           type: none
           device: /opt/nginx-proxy/data
           o: bind  
  app-letsencrypt:
     driver_opts:
           type: none
           device: /opt/nginx-proxy/letsencrypt
           o: bind
  app-sql:
     driver_opts:
           type: none
           device: /opt/nginx-proxy/sql
           o: bind
networks:
  default:
#    external:
#      name: dockernet

Logs
docker-compose logs

app_1  | [cont-init.d] executing container initialization scripts...
app_1  | [cont-init.d] 01_perms.sh: executing... 
app_1  | Changing ownership of /data/logs to 0:0
app_1  | [cont-init.d] 01_perms.sh: exited 0.
app_1  | [cont-init.d] 01_s6-secret-init.sh: executing... 
app_1  | [cont-init.d] 01_s6-secret-init.sh: exited 0.
app_1  | [cont-init.d] done.
app_1  | [services.d] starting services
app_1  | [services.d] done.
app_1  | � Enabling IPV6 in hosts: /etc/nginx/conf.d
app_1  |   � /etc/nginx/conf.d/include/force-ssl.conf
app_1  |   � /etc/nginx/conf.d/include/proxy.conf
app_1  |   � /etc/nginx/conf.d/include/block-exploits.conf
app_1  |   � /etc/nginx/conf.d/include/ip_ranges.conf
app_1  |   � /etc/nginx/conf.d/include/assets.conf
app_1  |   � /etc/nginx/conf.d/include/ssl-ciphers.conf
app_1  |   � /etc/nginx/conf.d/include/letsencrypt-acme-challenge.conf
app_1  |   � /etc/nginx/conf.d/include/resolvers.conf
app_1  |   � /etc/nginx/conf.d/default.conf
app_1  |   � /etc/nginx/conf.d/production.conf
app_1  | � Enabling IPV6 in hosts: /data/nginx
app_1  |   � /data/nginx/proxy_host/8.conf
app_1  |   � /data/nginx/proxy_host/17.conf
app_1  |   � /data/nginx/proxy_host/11.conf
app_1  |   � /data/nginx/proxy_host/16.conf
app_1  |   � /data/nginx/proxy_host/2.conf
app_1  |   � /data/nginx/proxy_host/15.conf
app_1  |   � /data/nginx/proxy_host/14.conf
app_1  |   � /data/nginx/proxy_host/10.conf
app_1  |   � /data/nginx/proxy_host/18.conf
app_1  |   � /data/nginx/proxy_host/12.conf
app_1  |   � /data/nginx/proxy_host/1.conf
app_1  |   � /data/nginx/proxy_host/7.conf
app_1  |   � /data/nginx/proxy_host/9.conf
app_1  |   � /data/nginx/proxy_host/19.conf
app_1  |   � /data/nginx/proxy_host/13.conf
app_1  |   � /data/nginx/proxy_host/3.conf
app_1  |   � /data/nginx/proxy_host/20.conf
app_1  |   � /data/nginx/proxy_host/5.conf
app_1  |   � /data/nginx/proxy_host/6.conf
app_1  | [1/12/2022] [3:33:53 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:07 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:08 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:09 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:10 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:10 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:11 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:11 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:12 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:12 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:13 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:13 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:14 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:14 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:15 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:16 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:17 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables
app_1  | [1/12/2022] [3:34:17 PM] [Global   ] › ✖  error     select * from `migrations_lock` - UNKNOWN_CODE_PLEASE_REPORT: Table 'npm.migrations_lock' doesn't exist in engine
app_1  | [1/12/2022] [3:34:18 PM] [Global   ] › ℹ  info      Manual db configuration already exists, skipping config creation from environment variables

db logs

[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh
[i] mysqld already present, skipping creation
[i] MySQL directory already present, skipping creation
2022-01-12 15:33:39 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 1 ...
2022-01-12 15:33:40 0 [Note] InnoDB: Using Linux native AIO
2022-01-12 15:33:40 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-01-12 15:33:40 0 [Note] InnoDB: Uses event mutexes
2022-01-12 15:33:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-12 15:33:40 0 [Note] InnoDB: Number of pools: 1
2022-01-12 15:33:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-01-12 15:33:40 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2022-01-12 15:33:40 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-01-12 15:33:40 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-12 15:33:40 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-01-12 15:33:40 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
2022-01-12 15:33:40 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
2022-01-12 15:33:41 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-01-12 15:33:41 0 [Note] InnoDB: New log files created, LSN=47065
2022-01-12 15:33:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-01-12 15:33:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-12 15:33:41 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-12 15:33:41 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-01-12 15:33:41 0 [Note] InnoDB: Waiting for purge to start
2022-01-12 15:33:41 0 [Note] InnoDB: 10.4.15 started; log sequence number 47116; transaction id 9
2022-01-12 15:33:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-01-12 15:33:41 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-01-12 15:33:41 0 [Note] InnoDB: Buffer pool(s) load completed at 220112 15:33:41
2022-01-12 15:33:41 0 [Note] Server socket created on IP: '::'.
2022-01-12 15:33:41 0 [Warning] 'user' entry '@937e32409673' ignored in --skip-name-resolve mode.
2022-01-12 15:33:41 0 [Warning] 'proxies_priv' entry '@% root@937e32409673' ignored in --skip-name-resolve mode.
2022-01-12 15:33:41 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2022-01-12 15:33:41 0 [Note] Reading of all Master_info entries succeeded
2022-01-12 15:33:41 0 [Note] Added new Master_info '' to hash table
2022-01-12 15:33:41 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '10.4.15-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
2022-01-12 15:38:17 8 [Warning] Aborted connection 8 to db: 'npm' user: 'npm' host: '192.168.160.3' (Got an error reading communication packets)
2022-01-12 15:38:26 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal shutdown
2022-01-12 15:38:26 0 [Note] InnoDB: FTS optimize thread exiting.
2022-01-12 15:38:26 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-01-12 15:38:26 0 [Note] InnoDB: Starting shutdown...
2022-01-12 15:38:26 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-01-12 15:38:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 220112 15:38:26
2022-01-12 15:38:28 0 [Note] InnoDB: Shutdown completed; log sequence number 47125; transaction id 9
2022-01-12 15:38:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-12 15:38:28 0 [Note] /usr/bin/mysqld: Shutdown complete

[ameinild]

I've also experienced this earlier, and the only solution for me was to reinstall the container and database from scratch. I used the "Aria" version of MariaDB though.

[SteveDevDev]

I was hoping to avoid that.... but that's probably the direction I'll go.