search

401ode / GetOutdoorsRI

Site promote the use of Rhode Island's public outdoor resources and increase public engagement
0 stars 2 forks source link

MySQL Error #51

Open theryankelly opened 8 years ago

theryankelly commented 8 years ago

Fix fatal error in database query

theryankelly commented 8 years ago

errorconfigadmin6_3_2016

nickatomlin commented 8 years ago

As suggested, I changed the 'max_allowed_packet' size to 500M in /etc/mysql/my.cnf. The value was previously set to

max_allowed_packet = 32M

which is a relatively large size. However, some help forums still recommended increasing the allowed size to 500M. If the problem persists, let me know.

Source: http://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away

nickatomlin commented 8 years ago

The issue persists: error-2006

nickatomlin commented 8 years ago

A combination of setting 'max_allowed_packet=500M' in my.cnf and restarting the MySQL server with 'service mysql restart' seems to have resolved this issue and significantly improved performance issues.

nickatomlin commented 8 years ago

After some time passed, the error returned and the performance issues lapsed to their old state: it s-back back3

nickatomlin commented 8 years ago

Another issue leading to Error 2006, this time citing IP addresses. Possibly caused by logging in on a different computer? screen shot 2016-06-07 at 2 29 38 pm