MariaDB / MySQL service is unealthy #25118

tristanbes · 2020-01-16T18:40:40Z

tristanbes
Jan 16, 2020

Hello,

I’ve tried multiple combinaison, but it seems I can’t figure out why is mariadb not starting.

I’ve look mutliple examples (such asthis one) but nothing is working (including changing port to 3366);

The output log is :

Status: Downloaded newer image for mariadb:10.4
docker.io/library/mariadb:10.4
/usr/bin/docker create --name 88c5e4e016ef4568bc6bf49cd2b81d61_mariadb104_4b3bb7 --label 488dfb --network github_network_674333f1aba94d138fe92f85cd90c518 --network-alias mysql -p 3306/tcp --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=10s --health-retries=10 -e GITHUB_ACTIONS=true mariadb:10.4
b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
/usr/bin/docker start b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
/usr/bin/docker ps --all --filter id=b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f --filter status=running --no-trunc --format "{{.ID}} {{.Status}}"
b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f Up Less than a second (health: starting)
/usr/bin/docker port b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
3306/tcp -> 0.0.0.0:32768
/usr/bin/docker inspect --format="{{if .Config.Healthcheck}}{{print .State.Health.Status}}{{end}}" b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
starting
mysql service is starting, waiting 2 seconds before checking again.
/usr/bin/docker inspect --format="{{if .Config.Healthcheck}}{{print .State.Health.Status}}{{end}}" b62b9146f0bd1f3512327ee67357e76827c31c03d9f2fd2c9d06c3648b98ce0f
unhealthy
##[error]Failed to initialize, mysql service is unhealthy.
env:

TZ: Europe/Paris

PHP_VERSION: 7.4

NODE_VERSION: 10.x

COMPOSER_ALLOW_SUPERUSER: '1' # https://getcomposer.org/doc/03-cli.md#composer-allow-superuser
Database
MYSQL_ROOT_PASSWORD: symfony

MYSQL_DATABASE: symfony
jobs:

php:

runs-on: ubuntu-latest

services:

mysql:

image: mariadb:10.4

ports:

3306/tcp

options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=10s --health-retries=10

Answered by weide-zhou

Jan 17, 2020

Hi @tristanbes ,

This is due to the top level env setting is not applied to the github services(‘docker create’ command in the execution step). Need to set in ‘jobs.<job_id>.services.env’ level. Code sample below:

env:
    TZ: Europe/Paris
    PHP_VERSION: 7.4
    NODE_VERSION: 10.x
    COMPOSER_ALLOW_SUPERUSER: '1' # https://getcomposer.org/doc/03-cli.md#composer-allow-superuser
jobs:
    php:
        runs-on: ubuntu-latest
        services:
            mysql:
                image: mariadb:10.4
                env:
                  MYSQL_ROOT_PASSWORD: symfony
                  MYSQL_DATABASE: symfony
                ports:
                  - 3306/tcp
                options: --health…

View full answer

weide-zhou · 2020-01-17T02:55:37Z

weide-zhou
Jan 17, 2020

Hi @tristanbes ,

This is due to the top level env setting is not applied to the github services(‘docker create’ command in the execution step). Need to set in ‘jobs.<job_id>.services.env’ level. Code sample below:

env:
    TZ: Europe/Paris
    PHP_VERSION: 7.4
    NODE_VERSION: 10.x
    COMPOSER_ALLOW_SUPERUSER: '1' # https://getcomposer.org/doc/03-cli.md#composer-allow-superuser
jobs:
    php:
        runs-on: ubuntu-latest
        services:
            mysql:
                image: mariadb:10.4
                env:
                  MYSQL_ROOT_PASSWORD: symfony
                  MYSQL_DATABASE: symfony
                ports:
                  - 3306/tcp
                options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=10s --health-retries=10

mariaDB.png1507×544 53 KB

0 replies

tristanbes · 2020-01-17T09:29:20Z

tristanbes
Jan 17, 2020
Author

Thank you very much. I didn’t know that.

0 replies

aryashreep · 2020-04-12T13:30:16Z

aryashreep
Apr 12, 2020

Hi @weide-zhou @tristanbes

I have tried this but it is not working. Could you please check.

# This is a basic workflow to help you get started with Actions name: Automated Drupal8 CICD Controls when the action will run. Triggers the workflow on push or pull request events but only for the master branch on: push: branches: [master] pull_request: branches: [master] env: PHP_VERSION: 7.3 COMPOSER_ALLOW_SUPERUSER: '1' # https://getcomposer.org/doc/03-cli.md#composer-allow-superuser A workflow run is made up of one or more jobs that can run sequentially or in parallel jobs: This workflow contains a single job called "service" services: # The type of runner that the job will run on runs-on: ubuntu-latest strategy: matrix: php_version: ['7.3'] # Enable the mysql services services: mariadb: image: mariadb:latest ports: - 3306 env: MYSQL_HOST: mysql MYSQL_USER: root MYSQL_PASSWORD: root MYSQL_DATABASE: drupal8 MYSQL_ROOT_PASSWORD: root options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=10s --health-retries=10 steps: - name: Check out the code uses: actions/checkout@v2 with: fetch-depth: 1 - name: Verify MySQL connection from host run: sudo apt-get install -y mysql-client - name: Set up PHP ${{ matrix.php_version }} uses: shivammathur/setup-php@v2 with: php-version: ${{ matrix.php_version }} - name: Install Composer dependencies run: composer install --dev phpunit: runs-on: ubuntu-latest strategy: matrix: php_version: ['7.3'] services: mariadb: image: mariadb:latest ports: - 3306 env: MYSQL_HOST: mysql MYSQL_USER: root MYSQL_PASSWORD: root MYSQL_DATABASE: drupal8 MYSQL_ROOT_PASSWORD: root options: --health-cmd="mysqladmin ping" --health-interval=5s --health-timeout=2s --health-retries=3 steps: - name: Set up PHP ${{ matrix.php_version }} uses: shivammathur/setup-php@v2 with: php-version: ${{ matrix.php_version }} - name: Check out the code uses: actions/checkout@v2 with: fetch-depth: 1 - name: Install Composer dependencies run: composer install --dev - name: Verify MySQL connection from container run: | sudo apt-get update sudo apt-get install -y mysql-client mysqladmin ping mysql -hmysql -uroot -proot -e "CREATE DATABASE IF NOT EXISTS drupal8;" mysql -hmysql -uroot -proot -e "SHOW DATABASES" mysql -hmysql -uroot -proot drupal8 < scripts/database/dumps/drupal8.sql mysql -hmysql -uroot -proot -e "USE drupal8; SHOW TABLES;"

log.JPG727×469 65.7 KB

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

GitHub Community

MariaDB / MySQL service is unealthy #25118

{{title}}

Database

Replies: 3 comments

{{title}}

{{title}}

{{title}}

Controls when the action will run. Triggers the workflow on push or pull request

events but only for the master branch

A workflow run is made up of one or more jobs that can run sequentially or in parallel

This workflow contains a single job called "service"

Select a reply

Navigation Menu

GitHub Community

MariaDB / MySQL service is unealthy #25118

tristanbes Jan 16, 2020

Database

Replies: 3 comments

weide-zhou Jan 17, 2020

tristanbes Jan 17, 2020 Author

aryashreep Apr 12, 2020

Controls when the action will run. Triggers the workflow on push or pull request

events but only for the master branch

A workflow run is made up of one or more jobs that can run sequentially or in parallel

This workflow contains a single job called "service"

tristanbes
Jan 16, 2020

weide-zhou
Jan 17, 2020

tristanbes
Jan 17, 2020
Author

aryashreep
Apr 12, 2020