Best practice forum (Archived)

max_allowed_packets error

 
? ?
max_allowed_packets error
de ? ? - Thursday, 13 de February de 2014, 06:49
 

Hi, since enabling mysql transaction logging totara is returning " Can not write database session - please verify max_allowed_packet is at least 4M!, referer: http://svytotara.com/user/editadvanced.php?id=12032&course=1", this appears in the the apache error log. I've increased max_allowed_packet in my.cnf to its maximum ( 1GB ) and still getting the error. If I disable transaction logging then totara works fine. Although its actually totara throwing the error and not mysql in lib/sessionlib.php. I can't determine what sessionlib.php is trying to check before throwing this error and howto resolve my problem. Thanks in advance for any replies.

 

Gaz

? ?
Re: max_allowed_packets error
de ? ? - Sunday, 16 de February de 2014, 15:10
 

Hi Gary,

Could you turn on debugging and give us the full error including stack trace?

This thread on the Moodle forums seems related https://moodle.org/mod/forum/discuss.php?d=220978

Though the thread only really suggests making sure both mysql and apache were restarted after making the change.