GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Syntax error or access violation, access denied

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Syntax error or access violation, access denied

    Recently, I have been getting an odd error on both the stable and experimental repositories.
    Code:
    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
    Code:
    [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... http://stackoverflow.com/questions/7...ot-create-user u r problem may be related to this!.

    Comment


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

      Comment


      • #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..?

        Comment

        Working...
        X