Hello

Installed demo store on Centos 7. Exploring the site.

http://centos7dev.example.com/drupal7/cmks/admin/structure/taxonomy/bran...

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {commerce_flat_rate_service}; Array ( ) in commerce_flat_rate_commerce_shipping_service_info() (line 120 of /home/abc/www/drupal7/commerce_kickstart-7.x-2.51/profiles/commerce_kickstart/modules/contrib/commerce_flat_rate/commerce_flat_rate.module).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ff.* FROM {filter_format} ff WHERE (status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] => 1 ) in filter_formats() (line 434 of /home/abc/www/drupal7/commerce_kickstart-7.x-2.51/modules/filter/filter.module).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] => ck2SRWCfH4WrAUbVsz59tB8gDQFCGa-JNLg5WZZg1ek [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /home/abc/www/drupal7/commerce_kickstart-7.x-2.51/includes/session.inc).

I get the error in:

Home Administration Site settings Advanced settings Structure Taxonom

and then click any "edit vocabulary" I get the error above.

Clicking "Brand" Then List Manage fields Manage display tabs work fine. Edit tab is the one giving the error.

I increased max_allowed_packet= in my.cnf . It didn't help

I increased php.ini memory . It didn't help

Other parts of the commerce kickstart demo seem to work fine.

I have many other drupal distros on this test server. All work without giving such error.

Any Ideas guys?

S

Comments

serving created an issue. See original summary.

serving’s picture

Component: Testing » Code
howdytom’s picture

I am not able to reproduce your error messages on 4x commerce kickstart installations running CK 7.x-2.50 and CK 7.x-2.51. Also, tested with a clean CK demo store installation. This looks like a configuration issue with your local dev environment.

Make sure that you’ve restarted the MySQL service after editing my.cnf. Take a look at your server, php and mysql error logs.

serving’s picture

Thank you for you reply.

The server has more than 30 Drupal sites (6,7,8 and many distros) running on it without a hitch. Only the link above is giving such error .

Weird thing isn't it.

:)

I really don't know what to do after all the things I tried before posting this.

Yours,

S

serving’s picture

Solution :

Change in the my.ini or ~/.my.cnf file by including the single line under [mysqld] section in your file:

max_allowed_packet=100M
then restart the MySQL service and you are done.
( https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-pa... )

The line _must be_ under mysqld line .. Not end of the file. Mariadb /etc/my.cnf file

Solved.

S

howdytom’s picture

Status: Active » Fixed

I am glad it worked out for you. I am going to mark this issue as fixed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.