[MDEV-29260] Server crashes when running migration queries inside Docker on Windows - Jira

XML

Word

Printable

I have a Laravel application inside Docker container, which crashes when trying to run migrations.
docker-compose.yml:

mysql:

    container_name: web__mysql

    build:

      context: .

      dockerfile: ./.docker/services/mysql/Dockerfile

    restart: unless-stopped

    tty: true

    ports:

      - "3306:3306"

    volumes:

      - ./.docker/services/mysql/data:/var/lib/mysql

    environment:

      MARIADB_DATABASE: db

      MARIADB_USER: web

      MARIADB_PASSWORD: password

      MARIADB_ROOT_PASSWORD: root

      SERVICE_TAGS: dev

      SERVICE_NAME: mysql

      TZ: Europe/Riga

    networks:

      - app

Dockerfile:

FROM mariadb:latest

ENV TZ=Europe/Riga

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

No matter which version I pick, everytime i run migrations, the database server crashes with this error:

InnoDB: preallocating 147456 bytes for file ./db/events_places.ibd failed with error 2

This always happens on this query:

alter table `events_places` add unique `events_places_place_id_event_id_unique`(`place_id`, `event_id`))

If you need all queries that were run before that, I can provide. In attachment there is log from Docker terminal.

relates to

MDEV-28580 Server crash when creating an index after adding a foreign key

MDEV-29015 InnoDB: Assertion failure in file /home/buildbot/buildbot/build/mariadb-10.3.35/storage/innobase/fil/fil0fil.cc line 968

MDEV-34938 Under Windows Subsystem for Linux, InnoDB crashes on ALTER TABLE or OPTIMIZE TABLE

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.