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
Comment #2
serving CreditAttribution: serving commentedComment #3
howdytom CreditAttribution: howdytom commentedI 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.
Comment #4
serving CreditAttribution: serving commentedThank 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
Comment #5
serving CreditAttribution: serving commentedSolution :
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
Comment #6
howdytom CreditAttribution: howdytom as a volunteer commentedI am glad it worked out for you. I am going to mark this issue as fixed.