Skip to content

db container fails to up on Windows 10 (Cannot change permissions of the file 'ca.pem') #149

@ricfio

Description

@ricfio

Hi @eko @automatix ,
the db container up fails on Windows 10, after the adding of volumes in docker-compose.yml for db container.

It works if you remove volumes from docker-compose.yml in db service

Here the problem:
2021-05-09T18:26:14.032799Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it

Here all logs:

2021-05-09 18:26:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.

2021-05-09 18:26:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2021-05-09 18:26:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.

2021-05-09 18:26:06+00:00 [Note] [Entrypoint]: Initializing database files

2021-05-09T18:26:06.279302Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.22) initializing of server in progress as process 44

2021-05-09T18:26:06.325180Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive

2021-05-09T18:26:06.332646Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2021-05-09T18:26:10.198859Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

mysqld: Cannot change permissions of the file 'ca.pem' (OS errno 1 - Operation not permitted)

2021-05-09T18:26:14.031148Z 0 [ERROR] [MY-010295] [Server] Could not set file permission for ca.pem

2021-05-09T18:26:14.032799Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.

2021-05-09T18:26:14.034428Z 0 [ERROR] [MY-010119] [Server] Aborting

2021-05-09T18:26:16.424416Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22) MySQL Community Server - GPL.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions