Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am getting error

"Serious session error detected. Please notify administrator, this problem is most probably caused by small value in max_allowed_packet MySQL setting. "

This error generally comes after every 20-25 minutes and when it comes , it logs out the user and then logs in again, starts again and then after sometime the same issue occurs again.

I tried changing max_allowed_packet setting but getting error "access denied; You need SUPER privilege for this operation'. I even tried SET SESSION too but error "SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value"

I have hosted the website on godaddy VPS centos and access it via putty or cpanel. Website is made in moodle 2.0.3 i.e. php.

My developers use to fix this but warned will occur when server restart. As godaddy ppl say move to dedicated and then i can do but as I don't have any money so can't at present. I trying to find how developers used to do for temporary fix that is until server restart.

share|improve this question
    
I have searched on net and tried most of the methods like set max_allowed_packet size... But can't see if the effect has taken place as I m unaware of the location of file where the changes will take place. –  user2298854 Apr 17 '13 at 13:25
    
Do you have root access to mysql server if yes try 'set global max_allowed_packet_size = SOMEVALUE' . –  vasco.debian Apr 17 '13 at 13:37
    
Sidenote: this is why documentation, change management, separation of development and operations duties, and incident tracking are important... –  Chris S Jun 27 '13 at 14:59

1 Answer 1

if you do not change it in the my.cnf file, Login to Mysql and run below command the value will reset when the server restarts, even if you set it globally.

  SET GLOBAL max_allowed_packet=1073741824;
share|improve this answer
    
I already told giving error "access denied;super user privileges required" –  user2298854 Jun 27 '13 at 17:40
    
@user2298854 Please hit the contact us link below to recover your password for your original account, and have your two accounts merged together. –  Michael Hampton Jun 27 '13 at 17:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.