Skip to content

Instantly share code, notes, and snippets.

@Kriptonium

Kriptonium/gist:001248ec06c31698cb9147547a2de8e9

Created December 27, 2016 06:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Kriptonium/001248ec06c31698cb9147547a2de8e9 to your computer and use it in GitHub Desktop.
Save Kriptonium/001248ec06c31698cb9147547a2de8e9 to your computer and use it in GitHub Desktop.
Download ZIP
Galera cluster status
Raw
gistfile1.txt
$ systemctl status mariadb | less
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2016-12-20 02:49:56 UTC; 1 weeks 0 days ago
Process: 6730 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6621 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 6618 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 6697 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─6697 /usr/sbin/mysqld --wsrep-new-cluster --wsrep_start_position=b25b7457-c209-11e6-81f9-d6658609e9a1:9535098
Dec 27 06:06:46 krip_galera1 mysqld[6697]: 2016-12-27 6:06:46 139865366722304 [Warning] WSREP: Failed to report last committed 32844690, -4 (Interrupted system call)
Dec 27 06:06:53 krip_galera1 mysqld[6697]: 2016-12-27 6:06:53 139865366722304 [Warning] WSREP: Failed to report last committed 32845390, -4 (Interrupted system call)
Dec 27 06:06:58 krip_galera1 mysqld[6697]: 2016-12-27 6:06:58 139865366722304 [Warning] WSREP: Failed to report last committed 32845876, -4 (Interrupted system call)
Dec 27 06:07:05 krip_galera1 mysqld[6697]: 2016-12-27 6:07:05 139865366722304 [Warning] WSREP: Failed to report last committed 32846361, -4 (Interrupted system call)
Dec 27 06:07:10 krip_galera1 mysqld[6697]: 2016-12-27 6:07:10 139865366722304 [Warning] WSREP: Failed to report last committed 32846673, -4 (Interrupted system call)
Dec 27 06:07:13 krip_galera1 mysqld[6697]: 2016-12-27 6:07:13 139865366722304 [Warning] WSREP: Failed to report last committed 32847140, -4 (Interrupted system call)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment