Nov  7 21:09:15 debian10 systemd[1]: Starting MariaDB 10.4.8 database server...
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] /usr/sbin/mysqld (mysqld 10.4.8-MariaDB-1:10.4.8+maria~buster-log) starting as process 25331 ...
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Using Linux native AIO
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Uses event mutexes
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Number of pools: 1
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Completed initialization of buffer pool
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Waiting for purge to start
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: 10.4.8 started; log sequence number 139827; transaction id 21
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] Plugin 'FEEDBACK' is disabled.
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] InnoDB: Buffer pool(s) load completed at 191107 21:09:16
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] Server socket created on IP: '127.0.0.1'.
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] Reading of all Master_info entries succeeded
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] Added new Master_info '' to hash table
Nov  7 21:09:16 debian10 mysqld[25331]: 2019-11-07 21:09:16 0 [Note] /usr/sbin/mysqld: ready for connections.
Nov  7 21:09:16 debian10 mysqld[25331]: Version: '10.4.8-MariaDB-1:10.4.8+maria~buster-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
Nov  7 21:09:16 debian10 /etc/mysql/debian-start[25366]: Upgrading MySQL tables if necessary.
Nov  7 21:09:16 debian10 systemd[1]: Started MariaDB 10.4.8 database server.
Nov  7 21:09:16 debian10 systemd[1]: Reloading.
Nov  7 21:09:16 debian10 systemd[1]: /lib/systemd/system/memcached.service:13: PIDFile= references path below legacy directory /var/run/, updating /var/run/memcached/memcached.pid → /run/memcached/memcached.pid; please update the unit file accordingly.
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Looking for 'mysql' as: /usr/bin/mysql
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 1/7: Checking and upgrading mysql database
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Processing databases
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.column_stats                                 OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.columns_priv                                 OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.db                                           OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.event                                        OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.func                                         OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.global_priv                                  OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.gtid_slave_pos                               OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.help_category                                OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.help_keyword                                 OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.help_relation                                OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.help_topic                                   OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.index_stats                                  OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.innodb_index_stats                           OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.innodb_table_stats                           OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.plugin                                       OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.proc                                         OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.procs_priv                                   OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.proxies_priv                                 OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.roles_mapping                                OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.servers                                      OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.table_stats                                  OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.tables_priv                                  OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.time_zone                                    OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.time_zone_leap_second                        OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.time_zone_name                               OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.time_zone_transition                         OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.time_zone_transition_type                    OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.transaction_registry                         OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 2/7: Installing used storage engines... Skipped
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 3/7: Fixing views
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Processing databases
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: information_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql.user                                         OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: performance_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 4/7: Running 'mysql_fix_privilege_tables'
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 5/7: Fixing table and database names
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Processing databases
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: information_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: mysql
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: performance_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 6/7: Checking and upgrading tables
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Processing databases
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: information_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: performance_schema
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: Phase 7/7: Running 'FLUSH PRIVILEGES'
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25370]: OK
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25556]: Checking for insecure root accounts.
Nov  7 21:09:18 debian10 /etc/mysql/debian-start[25564]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Nov  7 21:09:21 debian10 ansible-apt: Invoked with dpkg_options=force-confdef,force-confold autoremove=False force=False force_apt_get=False install_recommends=None package=['mariadb-client'] autoclean=False name=mariadb-client purge=False allow_unauthenticated=False state=present upgrade=None update_cache=True default_release=None only_upgrade=False deb=None cache_valid_time=0
Nov  7 21:09:26 debian10 ansible-apt: Invoked with dpkg_options=force-confdef,force-confold autoremove=False force=False force_apt_get=False install_recommends=None package=['galera-4'] autoclean=False name=galera-4 purge=False allow_unauthenticated=False state=present upgrade=None update_cache=True default_release=None only_upgrade=False deb=None cache_valid_time=0
Nov  7 21:09:30 debian10 ansible-apt: Invoked with dpkg_options=force-confdef,force-confold autoremove=False force=False force_apt_get=False install_recommends=None package=['python-mysqldb'] autoclean=False name=python-mysqldb purge=False allow_unauthenticated=False state=present upgrade=None update_cache=True default_release=None only_upgrade=False deb=None cache_valid_time=0
Nov  7 21:09:37 debian10 ansible-apt: Invoked with dpkg_options=force-confdef,force-confold autoremove=False force=False force_apt_get=False install_recommends=None package=['rsync'] autoclean=False name=rsync purge=False allow_unauthenticated=False state=present upgrade=None update_cache=True default_release=None only_upgrade=False deb=None cache_valid_time=0
Nov  7 21:09:40 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=mysql -NBe "DELETE FROM mysql.user WHERE User=''" removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:41 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=mysql -NBe "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')" removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:41 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=mysql -NBe "DROP DATABASE IF EXISTS test" removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:41 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=mysql -NBe "DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%'" removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:41 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=mysql -NBe "FLUSH PRIVILEGES" removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:42 debian10 ansible-command: Invoked with creates=None executable=None _uses_shell=False _raw_params=systemctl stop apparmor removes=None argv=None warn=True chdir=None stdin=None
Nov  7 21:09:42 debian10 systemd[1]: Stopping Load AppArmor profiles...
Nov  7 21:09:42 debian10 systemd[1]: apparmor.service: Succeeded.
Nov  7 21:09:42 debian10 systemd[1]: Stopped Load AppArmor profiles.
Nov  7 21:09:42 debian10 ansible-stat: Invoked with checksum_algorithm=sha1 get_checksum=True follow=False checksum_algo=sha1 path=/etc/mysql/mariadb.conf.d/60-server.cnf get_md5=None get_mime=True get_attributes=True
Nov  7 21:09:42 debian10 ansible-copy: Invoked with directory_mode=None force=True remote_src=None _original_basename=60-server.cnf.j2 owner=root follow=False local_follow=None group=root unsafe_writes=None serole=None content=NOT_LOGGING_PARAMETER setype=None dest=/etc/mysql/mariadb.conf.d/60-server.cnf selevel=None regexp=None validate=None src=/home/ansible/.ansible/tmp/ansible-tmp-1573160982.4973607-147391712316636/source checksum=a72ed7986adb674e37569f2dfa06a73a1c946b08 seuser=None delimiter=None mode=0644 attributes=None backup=False
Nov  7 21:09:43 debian10 ansible-systemd: Invoked with no_block=False force=None name=mysql enabled=None daemon_reload=False state=stopped masked=None scope=None user=None
Nov  7 21:09:43 debian10 systemd[1]: Stopping MariaDB 10.4.8 database server...
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] Event Scheduler: Purging the queue. 0 events
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] InnoDB: FTS optimize thread exiting.
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] InnoDB: Starting shutdown...
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Nov  7 21:09:43 debian10 mysqld[25331]: 2019-11-07 21:09:43 0 [Note] InnoDB: Buffer pool(s) dump completed at 191107 21:09:43
Nov  7 21:09:44 debian10 mysqld[25331]: 2019-11-07 21:09:44 0 [Note] InnoDB: Shutdown completed; log sequence number 139836; transaction id 26
Nov  7 21:09:44 debian10 mysqld[25331]: 2019-11-07 21:09:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Nov  7 21:09:44 debian10 mysqld[25331]: 2019-11-07 21:09:44 0 [Note] /usr/sbin/mysqld: Shutdown complete
Nov  7 21:09:44 debian10 systemd[1]: mariadb.service: Succeeded.
Nov  7 21:09:44 debian10 systemd[1]: Stopped MariaDB 10.4.8 database server.
Nov  7 21:09:48 debian10 ansible-systemd: Invoked with no_block=False force=None name=mariadb enabled=None daemon_reload=True state=restarted user=None scope=None masked=None
Nov  7 21:09:48 debian10 systemd[1]: Reloading.
Nov  7 21:09:48 debian10 systemd[1]: /lib/systemd/system/memcached.service:13: PIDFile= references path below legacy directory /var/run/, updating /var/run/memcached/memcached.pid → /run/memcached/memcached.pid; please update the unit file accordingly.
Nov  7 21:09:49 debian10 systemd[1]: Starting MariaDB 10.4.8 database server...
Nov  7 21:09:52 debian10 mysqld[27938]: WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] /usr/sbin/mysqld (mysqld 10.4.8-MariaDB-1:10.4.8+maria~buster-log) starting as process 28160 ...
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:09:52 debian10 mysqld[28160]: wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
Nov  7 21:09:52 debian10 mysqld[28160]: wsrep loader: [INFO] wsrep_load(): Galera 26.4.2(r4498) by Codership Oy <info@codership.com> loaded successfully.
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: CRC-32C: using hardware acceleration.
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: GCache DEBUG: opened preamble:
Nov  7 21:09:52 debian10 mysqld[28160]: Version: 0
Nov  7 21:09:52 debian10 mysqld[28160]: UUID: 00000000-0000-0000-0000-000000000000
Nov  7 21:09:52 debian10 mysqld[28160]: Seqno: -1 - -1
Nov  7 21:09:52 debian10 mysqld[28160]: Offset: -1
Nov  7 21:09:52 debian10 mysqld[28160]: Synced: 0
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = asldb02; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Start replication
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Connecting with bootstrap option: 0
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: protonet asio version 0
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Using CRC-32C for message checksums.
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: backend: asio
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: restore pc from disk failed
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: GMCast version 0
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: EVS version 1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: gcomm: connecting to group 'imovies_db_cluster', peer 'asldb01:,asldb02:'
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') connection established to f0ceed19 tcp://127.0.0.1:4567
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') connection established to ee096787 tcp://10.0.0.31:4567
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: EVS version upgrade 0 -> 1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: declaring ee096787 at tcp://10.0.0.31:4567 stable
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: PC protocol upgrade 0 -> 1
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: Node ee096787 state prim
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: view(view_id(PRIM,ee096787,2) memb {
Nov  7 21:09:52 debian10 mysqld[28160]: #011ee096787,0
Nov  7 21:09:52 debian10 mysqld[28160]: #011f0ceed19,0
Nov  7 21:09:52 debian10 mysqld[28160]: } joined {
Nov  7 21:09:52 debian10 mysqld[28160]: } left {
Nov  7 21:09:52 debian10 mysqld[28160]: } partitioned {
Nov  7 21:09:52 debian10 mysqld[28160]: })
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: save pc into disk
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: discarding pending addr without UUID: tcp://127.0.1.1:4567
Nov  7 21:09:52 debian10 mysqld[28160]: 2019-11-07 21:09:52 0 [Note] WSREP: discarding pending addr proto entry 0x563c8dc2cbd0
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: gcomm: connected
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Opened channel 'imovies_db_cluster'
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Starting applier thread 1
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: STATE EXCHANGE: sent state msg: f11effa9-01a2-11ea-9a1e-3f50e4493b85
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: STATE EXCHANGE: got state msg: f11effa9-01a2-11ea-9a1e-3f50e4493b85 from 0 (asldb01)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 2 [Note] WSREP: Starting rollbacker thread 2
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: STATE EXCHANGE: got state msg: f11effa9-01a2-11ea-9a1e-3f50e4493b85 from 1 (asldb02)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Quorum results:
Nov  7 21:09:53 debian10 mysqld[28160]: #011version    = 5,
Nov  7 21:09:53 debian10 mysqld[28160]: #011component  = PRIMARY,
Nov  7 21:09:53 debian10 mysqld[28160]: #011conf_id    = 1,
Nov  7 21:09:53 debian10 mysqld[28160]: #011members    = 1/2 (joined/total),
Nov  7 21:09:53 debian10 mysqld[28160]: #011act_id     = 1,
Nov  7 21:09:53 debian10 mysqld[28160]: #011last_appl. = 0,
Nov  7 21:09:53 debian10 mysqld[28160]: #011protocols  = 1/10/4 (gcs/repl/appl),
Nov  7 21:09:53 debian10 mysqld[28160]: #011vote policy= 0,
Nov  7 21:09:53 debian10 mysqld[28160]: #011group UUID = ee0b084e-01a2-11ea-9543-6ba0311fae15
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Writing down CC checksum: e13cb19c da4449fb 41fabaa2 71540d69 at offset 176
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Flow-control interval: [23, 23]
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Trying to continue unpaused monitor
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: ####### processing CC 2, local, ordered
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: ####### drain monitors upto -1
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: REPL Protocols: 10 (5, 3)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: ####### My UUID: f0ceed19-01a2-11ea-a90c-c3e719881ef9
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Server asldb02 connected to cluster at position ee0b084e-01a2-11ea-9543-6ba0311fae15:2 with ID f0ceed19-01a2-11ea-a90c-c3e719881ef9
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Server status change disconnected -> connected
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: State transfer required:
Nov  7 21:09:53 debian10 mysqld[28160]: #011Group state: ee0b084e-01a2-11ea-9543-6ba0311fae15:2
Nov  7 21:09:53 debian10 mysqld[28160]: #011Local state: 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Server status change connected -> joiner
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address 'asldb02' --datadir '/var/lib/mysql/' --parent '28160' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1'
Nov  7 21:09:53 debian10 rsyncd[28223]: rsyncd version 3.1.3 starting, listening on port 4444
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Prepared SST request: rsync|asldb02:4444/rsync_sst
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:0 (proto: 10), state transfer needed: yes
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Service thread queue flushed.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:0, protocol version: 5
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 2, STRv: 3
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: IST receiver addr using tcp://asldb02:4568
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Prepared IST receiver for 0-2, listening at: tcp://127.0.1.1:4568
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Member 1.0 (asldb02) requested state transfer from '*any*'. Selected 0.0 (asldb01)(SYNCED) as donor.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2)
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Requesting state transfer: success, donor: 0
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: Resetting GCache seqno map due to different histories.
Nov  7 21:09:53 debian10 mysqld[28160]: 2019-11-07 21:09:53 1 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0 -> ee0b084e-01a2-11ea-9543-6ba0311fae15:2
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: forgetting ee096787 (tcp://10.0.0.31:4567)
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Node f0ceed19 state prim
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: view(view_id(PRIM,f0ceed19,3) memb {
Nov  7 21:09:54 debian10 mysqld[28160]: #011f0ceed19,0
Nov  7 21:09:54 debian10 mysqld[28160]: } joined {
Nov  7 21:09:54 debian10 mysqld[28160]: } left {
Nov  7 21:09:54 debian10 mysqld[28160]: } partitioned {
Nov  7 21:09:54 debian10 mysqld[28160]: #011ee096787,0
Nov  7 21:09:54 debian10 mysqld[28160]: })
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: save pc into disk
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: forgetting ee096787 (tcp://10.0.0.31:4567)
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: f2356f21-01a2-11ea-b591-6a11ca81143b
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: STATE EXCHANGE: sent state msg: f2356f21-01a2-11ea-b591-6a11ca81143b
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: STATE EXCHANGE: got state msg: f2356f21-01a2-11ea-b591-6a11ca81143b from 0 (asldb02)
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Warning] WSREP: Quorum: No node with complete state:
Nov  7 21:09:54 debian10 mysqld[28160]: #011Version      : 5
Nov  7 21:09:54 debian10 mysqld[28160]: #011Flags        : 0x1
Nov  7 21:09:54 debian10 mysqld[28160]: #011Protocols    : 1 / 10 / 4
Nov  7 21:09:54 debian10 mysqld[28160]: #011State        : JOINER
Nov  7 21:09:54 debian10 mysqld[28160]: #011Desync count : 0
Nov  7 21:09:54 debian10 mysqld[28160]: #011Prim state   : JOINER
Nov  7 21:09:54 debian10 mysqld[28160]: #011Prim UUID    : f11effa9-01a2-11ea-9a1e-3f50e4493b85
Nov  7 21:09:54 debian10 mysqld[28160]: #011Prim  seqno  : 2
Nov  7 21:09:54 debian10 mysqld[28160]: #011First seqno  : -1
Nov  7 21:09:54 debian10 mysqld[28160]: #011Last  seqno  : 2
Nov  7 21:09:54 debian10 mysqld[28160]: #011Commit cut   : 0
Nov  7 21:09:54 debian10 mysqld[28160]: #011Last vote    : -1.0
Nov  7 21:09:54 debian10 mysqld[28160]: #011Vote policy  : 0
Nov  7 21:09:54 debian10 mysqld[28160]: #011Prim JOINED  : 1
Nov  7 21:09:54 debian10 mysqld[28160]: #011State UUID   : f2356f21-01a2-11ea-b591-6a11ca81143b
Nov  7 21:09:54 debian10 mysqld[28160]: #011Group UUID   : ee0b084e-01a2-11ea-9543-6ba0311fae15
Nov  7 21:09:54 debian10 mysqld[28160]: #011Name         : 'asldb02'
Nov  7 21:09:54 debian10 mysqld[28160]: #011Incoming addr: 'AUTO'
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Warning] WSREP: No re-merged primary component found.
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Warning] WSREP: No bootstrapped primary component found.
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [ERROR] WSREP: gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():891: Failed to establish quorum.
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Quorum results:
Nov  7 21:09:54 debian10 mysqld[28160]: #011version    = 5,
Nov  7 21:09:54 debian10 mysqld[28160]: #011component  = NON-PRIMARY,
Nov  7 21:09:54 debian10 mysqld[28160]: #011conf_id    = -1,
Nov  7 21:09:54 debian10 mysqld[28160]: #011members    = 1/1 (joined/total),
Nov  7 21:09:54 debian10 mysqld[28160]: #011act_id     = -1,
Nov  7 21:09:54 debian10 mysqld[28160]: #011last_appl. = 0,
Nov  7 21:09:54 debian10 mysqld[28160]: #011protocols  = -1/-1/-1 (gcs/repl/appl),
Nov  7 21:09:54 debian10 mysqld[28160]: #011vote policy= 1,
Nov  7 21:09:54 debian10 mysqld[28160]: #011group UUID = 00000000-0000-0000-0000-000000000000
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Writing down CC checksum: 6a169a13 e0e24e4f 64893edb 3b694aa0 at offset 120
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Flow-control interval: [16, 16]
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Trying to continue unpaused monitor
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Received NON-PRIMARY.
Nov  7 21:09:54 debian10 mysqld[28160]: 2019-11-07 21:09:54 0 [Note] WSREP: Shifting JOINER -> OPEN (TO: 2)
Nov  7 21:09:55 debian10 mysqld[28160]: 2019-11-07 21:09:55 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') turning message relay requesting off
Nov  7 21:09:57 debian10 mysqld[28160]: 2019-11-07 21:09:57 0 [Note] WSREP: (f0ceed19, 'tcp://0.0.0.0:4567') connection established to ee096787 tcp://10.0.0.31:4567
Nov  7 21:09:57 debian10 mysqld[28160]: 2019-11-07 21:09:57 0 [Warning] WSREP: discarding established (time wait) ee096787 (tcp://10.0.0.31:4567)
Nov  7 21:09:59 debian10 mysqld[28160]: 2019-11-07 21:09:59 0 [Note] WSREP:  cleaning up ee096787 (tcp://10.0.0.31:4567)
Nov  7 21:11:22 debian10 systemd[1]: mariadb.service: Start operation timed out. Terminating.
Nov  7 21:11:22 debian10 mysqld[28160]: Terminated
Nov  7 21:11:22 debian10 mysqld[28160]: WSREP_SST: [INFO] Joiner cleanup. rsync PID: 28223 (20191107 21:11:22.441)
Nov  7 21:11:22 debian10 rsyncd[28223]: sent 0 bytes  received 0 bytes  total size 0
Nov  7 21:11:22 debian10 mysqld[28160]: WSREP_SST: [INFO] Joiner cleanup done. (20191107 21:11:22.963)
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [ERROR] WSREP: Process was aborted.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address 'asldb02' --datadir '/var/lib/mysql/' --parent '28160' --binlog '/var/log/mysql/mariadb-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1: 10 (No child processes)
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [ERROR] WSREP: Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 3 [Note] WSREP: SST received
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 3 [Note] WSREP: SST received: 00000000-0000-0000-0000-000000000000:-1
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [ERROR] WSREP: Application received wrong state:
Nov  7 21:11:22 debian10 mysqld[28160]: #011Received: 00000000-0000-0000-0000-000000000000
Nov  7 21:11:22 debian10 mysqld[28160]: #011Required: ee0b084e-01a2-11ea-9543-6ba0311fae15
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [ERROR] WSREP: Application state transfer failed. This is unrecoverable condition, restart required.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: ReplicatorSMM::abort()
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: Closing send monitor...
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: Closed send monitor.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: gcomm: terminating thread
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: gcomm: joining thread
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: gcomm: closing backend
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: PC protocol downgrade 1 -> 0
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: view((empty))
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: gcomm: closed
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Received self-leave message.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Writing down CC checksum: f78e97b7 63025ff6 9255addb 29a5ac29 at offset 64
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Flow-control interval: [0, 0]
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Trying to continue unpaused monitor
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1)
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 0 [Note] WSREP: RECV thread exiting 0: Success
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: recv_thread() joined.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: Closing replication queue.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: Closing slave action queue.
Nov  7 21:11:22 debian10 mysqld[28160]: 2019-11-07 21:11:22 1 [Note] WSREP: /usr/sbin/mysqld: Terminated.
Nov  7 21:11:22 debian10 systemd[1]: mariadb.service: Main process exited, code=killed, status=6/ABRT
Nov  7 21:11:22 debian10 systemd[1]: mariadb.service: Failed with result 'timeout'.
Nov  7 21:11:22 debian10 systemd[1]: Failed to start MariaDB 10.4.8 database server.
Nov  7 21:12:23 debian10 systemd[1]: session-27.scope: Succeeded.
Nov  7 21:12:33 debian10 systemd[1]: Stopping User Manager for UID 1001...