search

partkeepr / PartKeepr

Open Source Inventory Management
http://www.partkeepr.org
GNU General Public License v3.0
1.38k stars 401 forks source link

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away #624

Closed vvpost closed 8 years ago

vvpost commented 8 years ago

After taking care of all of the dependencies, the installation was finally done. I signed in and started adding 3 categories in 5 minutes and then the following error appeared.

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

And when I tried to refresh and sign-in, it did not work. The full report was something like this 

Response Status Code
==================================
500

Response
==================================
An Exception was thrown while handling: Internal Server Error

Server Configuration
==================================
doctrine_orm_version: 2.5.4
doctrine_dbal_version: 2.5.2
doctrine_common_version: 2.6.0-DEV
php_version: 5.6.19
auto_start_session: true
maxUploadSize: 2097152
availableImageFormats: JPG,GIF,PNG
max_users: unlimited
authentication_provider: PartKeepr.Auth.HTTPBasicAuthenticationProvider
tip_of_the_day_uri: https://partkeepr.org/tips/%s
password_change: true

When I restart Apache and MySQL and try signing in again, I am able to sign-in. But when I try to add a category, MySQL dies again. Not sure what the problem here is. From time to time, I am able to add one or two items, but MySQL dies pretty frequently. Any idea why? Thanks.

vvpost commented 8 years ago

Figured out what the issue is. Basically moving to a higher config machine (higher RAM) solved this issue.