When I click in pattern tab, I get following exception :
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {menu_links} WHERE menu_name = :menu_name AND module = :module AND link_path = :path; Array ( [:menu_name] => management [:module] => system [:path] => admin ) in toolbar_get_menu_tree() (line 279 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\modules\toolbar\toolbar.module).

This error occured on server, but I saved all that and install on local and I get same error, so I think there is a problem in files or DB.
In fact I have more details in local :
PDOException: There is already an active transaction in _drupal_session_write() (line 206 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\includes\session.inc).
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 9281142154eb7b797c08bd8.34816782 ) in lock_release_all() (line 269 of C:\Program Files\EasyPHP 3.0\www\CMS\MM02\includes\lock.inc).

It's not my first drupal website and I never got such an error. I have that error only for that tab, nothing else.

After on local, I installed the new version 7.1.0 but nothing change.

How to get rid of that problem?

Comments

Dave Reid’s picture

Category: bug » support
Status: Active » Postponed (maintainer needs more info)

Both errors do not seem to indicate a problem in Pathauto at all but seems to be a problem with your database.

sahuni’s picture

well, after investigation, I found that problem comes from entity_token module, which is needed for Rules. I installed these modules 1 week ago.
Without entity_token, it's OK.
Searching more, I found that it works also with entity_token and new token version : token-7.x-1.0-beta7.
For good measure, I updated also pathauto with new version : pathauto-7.x-1.0.

But I must say that activing patterns tab must be something very hard for Drupal, at the limit of failure.
The page appears quickly, but needs 30 seconds to finish it's job.
If I remove entity_token, it's much better. So I think a problem persists.
Do you think I must post on Entity project issue queue?

Dave Reid’s picture

Status: Postponed (maintainer needs more info) » Fixed

The maintainers of entity_token are well aware that it creates way too many tokens and basically overwhelms the token tree UI to the point where PHP runs out of memory or freezes browsers trying to process the tree table - and have not given any indication that they will change that (or remove the dependency for rules). We're doing as much as we can from within Token to increase performance but that's all we can control.

Status: Fixed » Closed (fixed)

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

molave’s picture

Hello,

Same thing happened to me just now. I have the following modules installed:

Rules (7.x-2.0)
Entity token (7.x-1.0-rc1)
Token (7.x-1.0-beta7)

So I installed module Pathauto (7.x-1.0) for the first time. The process went okay. But after installing (and clearing the cache) I could not access the Patterns tab...

  • List
  • Patterns - does not display
  • Settings
  • Bulk Update
  • Delete Aliases

...and only get the Uncaught Exception error as described above.

Just to get Pathauto to work, I'm going to remove Rules, and then remove Entity token. But obviously this is not a solution. I will do this on a dev site only.

Anyone have another idea?

Thanks

Technician’s picture

I have same problem. Installed modules: Pathauto (7.x-1.0), Token (7.x-1.0rc1), Entity tokens (7.x-1.0-rc1), Rules (7.x-2.0).

I think that error not in pathauto module. Because when i try change Code Fields in Display Suite (they use tokens also), i get exactly the same exception message:

Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => ru [:source] => Name [:context] => ) in locale() (line 683 of ...\modules\locale\locale.module).
Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT s.lid, t.translation, s.version FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = :language WHERE s.source = :source AND s.context = :context AND s.textgroup = 'default'; Array ( [:language] => ru [:source] => %type: !message in %function (line %line of %file). [:context] => ) in locale() (line 683 of ...\modules\locale\locale.module).

bneel’s picture

Set max_allowed_packet=100M in your my.ini
Than restart mysql.

Technician’s picture

Set max_allowed_packet=100M in your my.ini
Than restart mysql.

Thank you! It helps.

seren10pity’s picture

Status: Closed (fixed) » Active

Same problem since Drupal core update from 7.12 to 7.14.
It included several updates on Locale module, also in database if I remember well. SoI think it can come from that, maybe token or pathauto needs to be upgrated to fit the new locale database configuration ; but I'm not able to invertigate further in the code of the modules to see exactly what causes problems.

  • drupal core 7.14
  • pathauto 7.x-1.1
  • token 7.x-1.1

Hope it helps ;)

jasom’s picture

#7 worked, thank you. Just to document issue: my site is on localhost (xampp)

Dave Reid’s picture

Status: Active » Closed (fixed)

Restoring status.

vegantriathlete’s picture

For anybody who comes across this thread, I have written a blog post that explains the steps I took to address this on AWS RDS.

fietserwin’s picture

Or, if you e.g. are at shared hosting and cannot change this parameter: try #1281408: Add a compressing serializer decorator.

loophole080’s picture