Comment 4 for bug 1613343

Revision history for this message
sundarkh (sundar-kh) wrote :

Mainline Kilo 2743
-------------------

nodeg21 : mysql error.log

160929 3:45:24 [Note] WSREP: Member 2 (nodeg33) synced with group.
160929 3:46:01 [ERROR] Slave SQL: Error 'Operation CREATE USER failed for 'cmon'@'10.204.217.57'' on query. Default database: ''. Query: 'CREATE USER 'cmon'@'10.204.217.57' IDENTIFIED BY 'cmon'', Error_code: 1396
160929 3:46:01 [Warning] WSREP: RBR event 1 Query apply warning: 1, 496
160929 3:46:01 [Warning] WSREP: Ignoring error for TO isolated action: source: 9fe69bb7-8631-11e6-9425-ef3754594a7c version: 2 local: 0 state: APPLYING flags: 65 conn_id: 1153 trx_id: -1 seqnos (l: 508, g: 496, s: 495, d: 495, ts: 1475145961587347290)
160929 3:46:20 [ERROR] Slave SQL: Error 'Operation CREATE USER failed for 'cmon'@'10.204.217.73'' on query. Default database: ''. Query: 'CREATE USER 'cmon'@'10.204.217.73' IDENTIFIED BY 'cmon'', Error_code: 1396
160929 3:46:20 [Warning] WSREP: RBR event 1 Query apply warning: 1, 751
160929 3:46:20 [Warning] WSREP: Ignoring error for TO isolated action: source: c74c7ecc-8631-11e6-a3ad-8ae742b1b71f version: 2 local: 0 state: APPLYING flags: 65 conn_id: 661 trx_id: -1 seqnos (l: 763, g: 751, s: 750, d: 750, ts: 1475145980266684893)

root@nodeg21:~# ps -aux | grep mysql
root 16966 0.0 0.0 4440 660 ? S 03:43 0:00 /bin/sh /usr/bin/mysqld_safe --wsrep_cluster_address=gcomm://
mysql 18218 3.6 1.2 12551280 405460 ? Sl 03:43 43:42 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-cluster-address=gcomm:// --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1
root 31047 0.0 0.0 10464 936 pts/17 S+ 23:31 0:00 grep --color=auto mysql
root@nodeg21:~#