[postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (25 seconds so far)

[4n70w4]

λ docker-postal\examples (master -> origin) λ docker-compose up

...
postal-clamav          | Wed Feb 19 08:45:24 2020 -> Set stacksize to 1048576
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (20 seconds so far)
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (25 seconds so far)
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (30 seconds so far)
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (35 seconds so far)
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-db              | [INFO] ** [mariadb] Starting MariaDB 10.4.11
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (40 seconds so far)

[tiredofit]

Something is crashing in your MariaDB container.. Can you add DEBUG_MODE=TRUE to the MariaDB environment variables and post here?

[4n70w4]

postal-db              | 2020-02-20  0:38:55 0 [Note] /usr/bin/mysqld (mysqld 10.4.11-MariaDB) starting as process 3173 ...
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Using Linux native AIO
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Uses event mutexes
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Number of pools: 1
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
postal-db              | 2020-02-20  0:38:55 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: Completed initialization of buffer pool
postal-db              | 2020-02-20  0:38:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
postal-db              | 2020-02-20  0:38:55 0 [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!
postal-db              | 2020-02-20  0:38:55 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
postal-app             | [WARN] ** [postal] MySQL/MariaDB Server 'postal-db' is not accessible, retrying.. (120 seconds so far)
postal-db              | 2020-02-20  0:38:56 0 [Note] InnoDB: Starting shutdown...
postal-db              | 2020-02-20  0:38:57 0 [ERROR] Plugin 'InnoDB' init function returned error.
postal-db              | 2020-02-20  0:38:57 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
postal-db              | 2020-02-20  0:38:57 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
postal-db              | 2020-02-20  0:38:57 0 [ERROR] Unknown/unsupported storage engine: InnoDB
postal-db              | 2020-02-20  0:38:57 0 [ERROR] Aborting

[tiredofit]

Thanks - What host operating system are you running Docker on? This looks familiar to some of the stuff we were seeing a few years back when running on Windows systems.

Can you make sure you are trying with a fresh database (deleting any of the exported volumes) as well?

[4n70w4]

Windows 10 Enterprise

It was a launch with clean volumes.

For example mariadb:10.4 from https://github.com/Mailtrain-org/mailtrain/blob/development/docker-compose.yml starts ok.

[tiredofit]

OK, definitely related then. There's not much different between my mariadb image and the official other than a few performance tweaks - You can certainly get by using the official MariaDB image if that works for you. It also may be related to volume declarations, where as my example dictates directly to a file system location. Regardless, let me know if it works.

[4n70w4]

Mariadb justified by something? Under Docker on Windows, it works unstably and much slower than a clean MySql.

[tiredofit]

I'm not sure I follow your comment?

[shyim]

I have the same issue on Debian 10 Buster