[docker] mariadbd (initiated by: unknown): Normal shutdown

[lynnwho12]

Hi when I try to using the docker with auto-install-modules or mode, it failes. the docker log said

mariadbd (initiated by: unknown): Normal shutdown

[root@VM-0-8-centos basic-example]# docker logs bd4005d17100 > docker.log
2024-06-03 02:32:11+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
2024-06-03 2:32:14 0 [Note] Starting MariaDB 11.4.2-MariaDB-ubu2404 source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 91
2024-06-03 2:32:14 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-06-03 2:32:14 0 [Note] InnoDB: Number of transaction pools: 1
2024-06-03 2:32:14 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-06-03 2:32:14 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-06-03 2:32:14 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-06-03 2:32:14 0 [Note] InnoDB: Completed initialization of buffer pool
2024-06-03 2:32:14 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-06-03 2:32:14 0 [Note] InnoDB: End of log at LSN=47763
2024-06-03 2:32:14 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-06-03 2:32:14 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-06-03 2:32:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-06-03 2:32:14 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-06-03 2:32:14 0 [Note] InnoDB: log sequence number 47763; transaction id 14
2024-06-03 2:32:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-06-03 2:32:14 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-06-03 2:32:16 0 [Warning] 'user' entry 'root@bd4005d17100' ignored in --skip-name-resolve mode.
2024-06-03 2:32:16 0 [Warning] 'proxies_priv' entry '@% root@bd4005d17100' ignored in --skip-name-resolve mode.
2024-06-03 2:32:16 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-06-03 2:32:16 0 [Note] mariadbd: ready for connections.
Version: '11.4.2-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
2024-06-03 2:32:17 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2024-06-03 2:32:17 0 [Note] InnoDB: FTS optimize thread exiting.
2024-06-03 2:32:17 0 [Note] InnoDB: Starting shutdown...
2024-06-03 2:32:17 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-06-03 2:32:17 0 [Note] InnoDB: Buffer pool(s) dump completed at 240603 2:32:17
2024-06-03 2:32:17 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-06-03 2:32:17 0 [Note] InnoDB: Shutdown completed; log sequence number 47763; transaction id 15
2024-06-03 2:32:17 0 [Note] mariadbd: Shutdown complete

2024-06-03 2:32:17 0 [Note] Starting MariaDB 11.4.2-MariaDB-ubu2404 source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 1
2024-06-03 2:32:17 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-06-03 2:32:17 0 [Note] InnoDB: Number of transaction pools: 1
2024-06-03 2:32:17 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-06-03 2:32:17 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-06-03 2:32:17 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-06-03 2:32:17 0 [Note] InnoDB: Completed initialization of buffer pool
2024-06-03 2:32:17 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-06-03 2:32:17 0 [Note] InnoDB: End of log at LSN=47763
2024-06-03 2:32:17 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-06-03 2:32:17 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-06-03 2:32:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-06-03 2:32:17 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-06-03 2:32:17 0 [Note] InnoDB: log sequence number 47763; transaction id 14
2024-06-03 2:32:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-06-03 2:32:17 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-06-03 2:32:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-06-03 2:32:17 0 [Note] InnoDB: Buffer pool(s) load completed at 240603 2:32:17
2024-06-03 2:32:18 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-06-03 2:32:18 0 [Note] Server socket created on IP: '::'.
2024-06-03 2:32:18 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-06-03 2:32:18 0 [Note] mariadbd: ready for connections.
Version: '11.4.2-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution

[jokesterfr]

Ok, unhealthy mariadb.
Seems we recently discovered this issue, it's tied to the way we monitor the healthiness of mariadb in the docker-compose.yml.

I refer to this:

    image: mariadb:lts
    healthcheck:
      test:
        [
          "CMD",
          "mysqladmin",
          "ping",
          "--host=localhost",
          "--user=root",
          "--password=prestashop",
        ]
      interval: 10s
      timeout: 10s
      retries: 5

LTS version of mariadb recently changed.
Can you test this:

    image: mariadb:lts
    healthcheck:
      test:
        [
          "CMD",
          "healthcheck.sh",
          "--connect",
        ]
      interval: 5s
      timeout: 10s
      retries: 5

I will update the examples documentation.

[jokesterfr]

@lynnwho12 kind ping, if you can check this resolves your issue

[lynnwho12]

Thanks for your hard working, the new code works now

…

2024年6月5日 17:34，Clément Désiles ***@***.***> 写道： @lynnwho12 <https://github.com/lynnwho12> kind ping, if you can check this resolves your issue — Reply to this email directly, view it on GitHub <#110 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AG4FA5JCG6QNXPMGECRVZLLZF3LRHAVCNFSM6AAAAABIVVIO4KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBZGMZTIOBXGY>. You are receiving this because you were mentioned.