search

Rosa-Luxemburgstiftung-Berlin / ansible-mariadb-galera-cluster

MIT License
0 stars 0 forks source link

stop mysql on non-primary nodes fails if service is already stopped #2

Open zerwes opened 2 years ago

zerwes commented 2 years ago

TASK [mariadb-galera-cluster : setup_cluster | stopping mysql to (re)configure cluster (other nodes)] fails

zerwes commented 2 years ago 
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (60 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (59 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (58 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (57 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (56 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (55 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (54 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (53 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (52 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (51 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (50 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (49 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (48 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (47 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (46 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (45 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (44 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (43 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (42 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (41 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (40 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (39 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (38 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (37 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (36 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (35 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (34 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (33 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (32 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (31 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (30 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (29 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (28 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (27 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (26 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (25 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (24 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (23 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (22 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (21 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (20 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (19 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (18 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (17 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (16 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (15 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (14 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (13 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (12 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (11 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (10 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (9 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (8 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (7 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (6 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (5 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (4 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (3 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (2 retries left).
FAILED - RETRYING: [rad02ber1.ber1.rosalux.org]: setup_cluster | stopping mysql to (re)configure cluster (other nodes) (1 retries left).
fatal: [rad02ber1.ber1.rosalux.org]: FAILED! => {"attempts": 60, "changed": false, "name": "mariadb", "state": "stopped", "status": {"ActiveEnterTimestamp": "Mon 2022-03-21 11:26:21 CET", "ActiveEnterTimestampMonotonic": "783436682333", "ActiveExitTimestamp": "Mon 2022-03-21 11:26:46 CET", "ActiveExitTimestampMonotonic": "783461404260", "ActiveState": "failed", "After": "sysinit.target basic.target network.target system.slice systemd-journald.socket", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Mon 2022-03-21 11:29:42 CET", "AssertTimestampMonotonic": "783637845279", "Before": "multi-user.target shutdown.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "CPUAccounting": "yes", "CPUAffinity": "", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "350096000", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_dac_override cap_ipc_lock cap_audit_write", "CleanResult": "success", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Mon 2022-03-21 11:29:42 CET", "ConditionTimestampMonotonic": "783637845276", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "MariaDB 10.5.12 database server", "DevicePolicy": "auto", "Documentation": "\"man:mariadbd(8)\" https://mariadb.com/kb/en/library/systemd/", "DynamicUser": "no", "EffectiveCPUs": "", "EffectiveMemoryNodes": "", "ExecMainCode": "1", "ExecMainExitTimestamp": "Mon 2022-03-21 11:30:16 CET", "ExecMainExitTimestampMonotonic": "783671465017", "ExecMainPID": "315586", "ExecMainStartTimestamp": "Mon 2022-03-21 11:29:43 CET", "ExecMainStartTimestampMonotonic": "783638376871", "ExecMainStatus": "1", "ExecStart": "{ path=/usr/sbin/mariadbd ; argv[]=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/usr/sbin/mariadbd ; argv[]=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartPost": "{ path=/etc/mysql/debian-start ; argv[]=/etc/mysql/debian-start ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartPostEx": "{ path=/etc/mysql/debian-start ; argv[]=/etc/mysql/debian-start ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartPre": "{ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartPreEx": "{ path=/bin/sh ; argv[]=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/lib/systemd/system/mariadb.service", "FreezerState": "running", "GID": "[not set]", "Group": "mysql", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "mariadb.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestamp": "Mon 2022-03-21 11:30:16 CET", "InactiveEnterTimestampMonotonic": "783671465217", "InactiveExitTimestamp": "Mon 2022-03-21 11:29:42 CET", "InactiveExitTimestampMonotonic": "783637846932", "InvocationID": "9924361cc5ca465993b83f213f4332e4", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "32768", "LimitNOFILESoft": "32768", "LimitNPROC": "15522", "LimitNPROCSoft": "15522", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "15522", "LimitSIGPENDINGSoft": "15522", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "0", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimitPercent": "0%", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryCurrent": "[not set]", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "MountFlags": "", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAMask": "", "NUMAPolicy": "n/a", "Names": "mariadb.service mysqld.service mysql.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "main", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "Perpetual": "no", "PrivateDevices": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProcSubset": "all", "ProtectClock": "no", "ProtectControlGroups": "no", "ProtectHome": "yes", "ProtectHostname": "no", "ProtectKernelLogs": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectProc": "default", "ProtectSystem": "full", "RefuseManualStart": "no", "RefuseManualStop": "no", "ReloadResult": "success", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "system.slice sysinit.target", "Restart": "on-abort", "RestartKillSignal": "15", "RestartUSec": "5s", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "exit-code", "RootDirectoryStartOnly": "no", "RootHashSignature": "", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "no", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardInputData": "", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Mon 2022-03-21 11:30:16 CET", "StateChangeTimestampMonotonic": "783671465217", "StateDirectoryMode": "0755", "StatusErrno": "0", "StatusText": "MariaDB server is down", "StopWhenUnneeded": "no", "SubState": "failed", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "[not set]", "TasksMax": "4656", "TimeoutAbortUSec": "15min", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "15min", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "15min", "TimerSlackNSec": "50000", "Transient": "no", "Type": "notify", "UID": "[not set]", "UMask": "0007", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "User": "mysql", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0"}}