Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

wsrep not reporting correctly #6416

Closed
mrcheeky123 opened this issue Sep 18, 2019 · 0 comments
Closed

wsrep not reporting correctly #6416

mrcheeky123 opened this issue Sep 18, 2019 · 0 comments

Comments

@mrcheeky123
Copy link

mrcheeky123 commented Sep 18, 2019

wsrep_ready is 'ON' however status=0, when it should be 1 I believe.


[] [root@hostname telegraf.d]# curl -s localhost:9126/metrics|grep -v \#|grep wsrep_ready
mysql_wsrep_ready{host="host.skybet.net",server="127.0.0.1:3306"} 0

[] [root@hostname telegraf.d]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7640808
Server version: 5.7.26-29-57-log Percona XtraDB Cluster (GPL), Release rel29, Revision 03540a3, WSREP version 31.37, wsrep_31.37

Copyright (c) 2009-2019 Percona LLC and/or its affiliates
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

hostname:[(none)]>select * from performance_schema.global_status where variable_name  like 'wsrep_ready';
+---------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+---------------+----------------+
| wsrep_ready   | ON             |
+---------------+----------------+
1 row in set (0.00 sec)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant