wodby / mariadb

MariaDB docker container image
https://wodby.com/stacks/mariadb
GNU General Public License v2.0
49 stars 31 forks source link

MariaDB container fail to launch with persistant DB #34

Open webmasterpf opened 3 years ago

webmasterpf commented 3 years ago

Hello,

I can't run my docker drupal 8 stack because of the mariaDB container issue. This is the log:

2021-03-25 13:37:10 0 [Note] mysqld (mysqld 10.4.13-MariaDB) starting as process 1 ...,
2021-03-25 13:37:10 0 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive,
2021-03-25 13:37:10 0 [Note] InnoDB: Using Linux native AIO,
2021-03-25 13:37:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins,
2021-03-25 13:37:10 0 [Note] InnoDB: Uses event mutexes,
2021-03-25 13:37:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11,
2021-03-25 13:37:10 0 [Note] InnoDB: Number of pools: 1,
2021-03-25 13:37:10 0 [Note] InnoDB: Using SSE2 crc32 instructions,
2021-03-25 13:37:10 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts),
2021-03-25 13:37:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M,
2021-03-25 13:37:10 0 [Note] InnoDB: Completed initialization of buffer pool,
2021-03-25 13:37:10 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().,
2021-03-25 13:37:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.,
2021-03-25 13:37:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables,
2021-03-25 13:37:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...,
2021-03-25 13:37:10 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 95,
2021-03-25 13:37:10 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space,
2021-03-25 13:37:10 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary,
2021-03-25 13:37:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error,
2021-03-25 13:37:10 0 [Note] InnoDB: FTS optimize thread exiting.,
2021-03-25 13:37:15 0 [Note] InnoDB: Starting shutdown...,
2021-03-25 13:37:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1",
2021-03-25 13:37:16 0 [ERROR] Plugin 'InnoDB' init function returned error.,
2021-03-25 13:37:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.,
2021-03-25 13:37:16 0 [Note] Plugin 'FEEDBACK' is disabled.,
2021-03-25 13:37:16 0 [ERROR] Unknown/unsupported storage engine: InnoDB,
2021-03-25 13:37:16 0 [ERROR] Aborting,

and this is the docker-compose.yml part about mariadb:

services:
  mariadb:
    image: wodby/mariadb:$MARIADB_TAG
    container_name: "${PROJECT_NAME}_mariadb"
    stop_grace_period: 30s
    ports:
    - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: $DB_ROOT_PASSWORD
      MYSQL_DATABASE: $DB_NAME
      MYSQL_USER: $DB_USER
      MYSQL_PASSWORD: $DB_PASSWORD
    volumes:
      - ./bdd-backups:/docker-entrypoint-initdb.d # Place init .sql file(s) here.
      - ./bdds:/var/lib/mysql # Use bind mount. Stocker les bdds dans un dossier du projet.
#    networks:
#      - drupal8-multi_reseau_dg

I think I don't set volumes right. Folder tree is like: multid8

Thanks for help

grooverdan commented 2 years ago

https://jira.mariadb.org/browse/MDEV-20594 - your underlying storage system doesn't support prealloc.

grooverdan commented 2 years ago

Fixed https://jira.mariadb.org/browse/MDEV-16015 - 10.4.16