colinmollenhour / mariadb-galera-swarm

MariaDb Galera Cluster container based on official mariadb image which can auto-bootstrap and recover cluster state.
https://hub.docker.com/r/colinmollenhour/mariadb-galera-swarm
Apache License 2.0
223 stars 102 forks source link

can't seed 10.4 version #98

Closed oliverlj closed 2 years ago

oliverlj commented 4 years ago

Hello the seed on version 10.4 doesn't work

compose.yml

version: '3.8'

networks:
  back:
    driver: overlay
    driver_opts:
      encrypted: ''

secrets:
  mysql_root_password:
    file: secrets/mysql_root_password
    name: mysql-root-password-df93b6474e7d96cdcacc66cb385c15f1b9bea805
  xtrabackup_password:
    file: secrets/xtrabackup_password
    name: xtrabackup-password-8ef07a797c0463a0a74f7ad5cb637392e5b452e4

services:
  db-seed:
    image: "colinmollenhour/mariadb-galera-swarm:10.4.11-2020-01-06"
    stop_grace_period: 30s
    command: seed
    deploy:
      replicas: 1
    environment:
      - MYSQL_DATABASE=fritzy
      - MYSQL_PASSWORD_FILE=/run/secrets/mysql_password
      - MYSQL_ROOT_HOST=10.255.%.%
      - MYSQL_ROOT_PASSWORD_FILE=/run/secrets/mysql_root_password
      - MYSQL_ROOT_SOCKET_AUTH=1
      - XTRABACKUP_PASSWORD_FILE=/run/secrets/xtrabackup_password
    networks:
      - back
    secrets:
      - mysql_root_password
      - xtrabackup_password
    volumes:
      - /mnt/ha/fritzy/db-seed-{{.Task.Slot}}-data:/var/lib/mysql

  db:
    image: "colinmollenhour/mariadb-galera-swarm:10.4.11-2020-01-06"
    command: node tasks.db,tasks.db-seed
    stop_grace_period: 30s
    environment:
      - HEALTHY_WHILE_BOOTING=1
      - XTRABACKUP_PASSWORD_FILE=/run/secrets/xtrabackup_password
    networks:
      - back
    volumes:
      - /mnt/ha/fritzy/db-{{.Task.Slot}}-data:/var/lib/mysql
    deploy:
      replicas: 0
    secrets:
      - xtrabackup_password

Logs

...------======------... MariaDB Galera Start Script ...------======------...,
Got NODE_ADDRESS=10.255.5.6,
Generating cluster bootstrap script...,
/usr/local/bin/start.sh: ignoring /docker-entrypoint-initdb.d/*,
,
Starting seed node,
===|mysqld.sh|===: Starting a new cluster...,
===|mysqld.sh|===: Initializing MariaDb data directory...,
Tailing /tmp/mysql-console/fifo...,
2020-06-14 18:33:12 0 [Warning] You need to use --log-bin to make --binlog-format work.,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
,
,
Two all-privilege accounts were created.,
One is root@localhost, it has no password, but you need to,
be system 'root' user to connect. Use, for example, sudo mysql,
The second is root@localhost, it has no password either, but,
you need to be the system 'root' user to connect.,
After connecting you can set the password, if you would need to be,
able to connect as any of these users with a password and without sudo,
,
See the MariaDB Knowledgebase at http://mariadb.com/kb or the,
MySQL manual for more instructions.,
,
Please report any problems at http://mariadb.org/jira,
,
The latest information about MariaDB is available at http://mariadb.org/.,
You can find additional information about the MySQL part at:,
http://dev.mysql.com,
Consider joining MariaDB's strong and vibrant community:,
https://mariadb.org/get-involved/,
,
===|mysqld.sh|===: Loading timezone info...,
2020-06-14 18:33:20 0 [Note] mysqld (mysqld 10.4.11-MariaDB-1:10.4.11+maria~bionic) starting as process 107 ...,
2020-06-14 18:33:20 0 [Warning] You need to use --log-bin to make --binlog-format work.,
2020-06-14 18:33:20 0 [Note] InnoDB: Using Linux native AIO,
2020-06-14 18:33:20 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins,
2020-06-14 18:33:20 0 [Note] InnoDB: Uses event mutexes,
2020-06-14 18:33:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11,
2020-06-14 18:33:20 0 [Note] InnoDB: Number of pools: 1,
2020-06-14 18:33:20 0 [Note] InnoDB: Using SSE2 crc32 instructions,
2020-06-14 18:33:20 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts),
2020-06-14 18:33:20 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M,
2020-06-14 18:33:20 0 [Note] InnoDB: Completed initialization of buffer pool,
2020-06-14 18:33:20 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().,
2020-06-14 18:33:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.,
2020-06-14 18:33:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables,
2020-06-14 18:33:20 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...,
2020-06-14 18:33:20 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.,
2020-06-14 18:33:20 0 [Note] InnoDB: Waiting for purge to start,
2020-06-14 18:33:20 0 [Note] InnoDB: 10.4.11 started; log sequence number 61095; transaction id 21,
2020-06-14 18:33:20 0 [Note] Plugin 'FEEDBACK' is disabled.,
2020-06-14 18:33:20 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool,
2020-06-14 18:33:20 0 [Note] InnoDB: Buffer pool(s) load completed at 200614 18:33:20,
2020-06-14 18:33:21 0 [Note] Reading of all Master_info entries succeeded,
2020-06-14 18:33:21 0 [Note] Added new Master_info '' to hash table,
2020-06-14 18:33:21 0 [Note] mysqld: ready for connections.,
Version: '10.4.11-MariaDB-1:10.4.11+maria~bionic'  socket: '/tmp/mysql.sock'  port: 0  mariadb.org binary distribution,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
/usr/local/bin/run-upgrades.sh: waiting for server to become available...,
Received TERM|INT signal.,
Shutting down...,
ERROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115),
start.sh: Trapped error on line 1,
csib commented 4 years ago

Hi

Try it without the MYSQL_ROOT_HOST=10.255.%.%.