Syntax error or access violation, access denied

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Recently, I have been getting an odd error on both the stable and experimental repositories.

Syntax error or access violation: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

The error generally shows up after the mysql server has not received any queries for a while
After the error is shown, reloading the page will load the web application normally.

my.cnf

[mysqld]

# mysql general option
bind-address = 127.0.0.1
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#innodb_use_native_aio=0

# galera related options
wsrep_provider=/usr/lib/libgalera_smm.so
wsrep_cluster_name="sandyd"
#wsrep_cluster_address="gcomm://"
wsrep_cluster_address="gcomm://172.16.2.101,172.16.2.102,172.16.1.103"
wsrep_sst_auth=root:<removed>
wsrep_certify_nonPK=1
wsrep_convert_LOCK_to_trx=0
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_sst_method=rsync
wsrep_node_address=172.16.2.103
wsrep_node_name=TaylorSwift
wsrep_slave_threads=8
innodb_autoinc_lock_mode=2
2

check here… [URL]MySQL: ERROR 1227 (42000): Access denied - Cannot CREATE USER - Stack Overflow u r problem may be related to this!.

3

That isnt it, as said, it goes away after a page reload

4

hmm… but the error clearly says its a permission/privilege issue.

How often do you get this error…? r u getting this in mysql prompt…? and what the mysql error log says…(/var/log/mysql…)?

do u get this error on all nodes…?