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