[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 https://github.com/PrestaShop/prestashop-flashlight/issues/110#issuecomment-2149334876, or unsubscribe https://github.com/notifications/unsubscribe-auth/AG4FA5JCG6QNXPMGECRVZLLZF3LRHAVCNFSM6AAAAABIVVIO4KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCNBZGMZTIOBXGY. You are receiving this because you were mentioned.