[Maria-discuss] New Question: Galera errors in mysqld.log but works OK
Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a 3 node Galera cluster that I am testing. It generally works OK, and I have been doing various failure / recovery tests as part of a certification project. I continuously get 3 error messages even though it is working OK. I'd like to eliminate any unnecessary error messages so that DBAs would not taking time to resolve this in a production situation. Here is a sampling of the three errors: I included a bit before and after the error for context: 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 26, members = 3/3 (joined/total), act_id = 8017357, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = db762c6b-e246-11e5-90df-4adee5e6b24e 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Flow-control interval: [28, 28] 2016-04-06 11:01:22 140290187433728 [Note] WSREP: New cluster view: global state: db762c6b-e246-11e5-90df-4adee5e6b24e:8017357, view# 27: Primary, number of nodes: 3, my index: 2, protocol version 3 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Process completed with error: /opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306: 1 (Operation not permitted) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 11:01:22 140290187433728 [Note] WSREP: REPL Protocols: 7 (3, 2) 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 11:01:22 140290187433728 [Note] WSREP: Assign initial position for certification: 8017357, protocol version: 3 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 16:18:22 140287930267392 [Note] WSREP: (8180e0ba, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.242.60.235:4567 I grepped for just one of the errors so you can get an idea of the frequency: 2016-04-06 1:58:15 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Donor" 2016-04-06 3:40:41 140287908230912 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced" 2016-04-06 9:28:48 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 9:29:00 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 10:05:09 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 10:07:34 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 11:01:10 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306,7971bcf3-fb9d-11e5-a402-96244ac79f12/zlxv8400.vci.att.com/10.242.60.235:3306,8180e0ba-fb2b-11e5-8251-a3c484f45bc7/zlx70605.vci.att.com/130.9.221.46:3306" mysql@zlx70605 /opt/app/mysql -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/
participants (1)
-
AskMonty KB