Best practice forum (Archived)

max_allowed_packets error

 
Gary Thomson
max_allowed_packets error
by Gary Thomson - Thursday, 13 February 2014, 6:49 AM
 

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

Ciaran Irvine (Core Developer)
Re: max_allowed_packets error
by Ciaran Irvine (Core Developer) - Sunday, 16 February 2014, 3:10 PM
 

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.