PDOException when enabling a taxonomy term field with multiple values

I've set the timeout to 600 seconds but the pdo exception shows immediately so I guess the issue doesn't have to do with timeouts.

But:

If I select a field in the index of the solr config wich contains only 10 or so tax terms = no problem.

But if the Vocabulary contains 2000 terms then I get the PDO exeption.
(after a few seconds - so no timeout issue - I guess)

There are more than 130000 tax - terms in about 25 vocabulary's in the system in total. This amount is going to grow when I import a few more databases from different systems in the near future.

The wait_timeout MySQL session variable is at default with 28800 seconds (not ms, but seconds)

I'll set up the debugging session as you suggest. Thanks for pointing me in the direction to look for. Keep you posted!!

Regards,
C.

A little debugging shows this has nothing to do with facets. ( the breakpoint in the suggested function isn't reached)

To simulate this error you have to:

go to search api -> index -> enable 'indexed' for field type 'taxonomy term'

If the taxonomy term enabled is linked to a vocabulary with a lot of terms*
and you flush caches (in this example) or go to views you'll get:
-----------------------------------------------------------------------------------------------------------
Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => menu [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:217:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename FROM {registry} WHERE name = :name AND type = :type; Array ( [:name] => SearchApiViewsHandlerField [:type] => interface ) ";s:9:"%function";s:22:"_registry_check_code()";s:5:"%file";s:36:"/var/www/html/includes/bootstrap.inc";s:5:"%line";i:2800;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://www.solr-deplate.be/admin_menu/flush-cache?destination=node [:db_insert_placeholder_7] => http://www.solr-deplate.be/ [:db_insert_placeholder_8] => 178.116.195.171 [:db_insert_placeholder_9] => 1303533858 ) in dblog_watchdog() (line 155 of /var/www/html/modules/dblog/dblog.module).
Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT lid, location FROM {locales_source} WHERE source = :source AND textgroup = 'default'; Array ( [:source] => An AJAX HTTP error occurred. ) in _locale_parse_js_file() (line 1326 of /var/www/html/includes/locale.inc).
Uncaught exception thrown in shutdown function.

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] => 5207681474db25925b195b4.04305377 ) in lock_release_all() (line 247 of /var/www/html/includes/lock.inc).

-----------------------------------------------------------------------------------------------------------
* containing from about 450 terms in the vocabulary trows the error in my system

great, this is the right direction. Although i haven't looked at your patch file method change, uploading it removed the pdoexeption and made the fields available in the facets sections. Enabling them as facets didn't give any problems.

I can flush caches and open views.

maybe you couldn't reproduce this error because the total amount of all terms of all vocabularies isn't > 100000 items like I have?

I shall commit further tests, search results, etc. have to reindex first, etc. Reindexing > 2000 items at a time doesn't seem to behave, anyway still better than the default search method provided by drupal. Keep you posted! Great work!

Regards,

chris.

Works for me. Thanks.

Sorry for reopening this, but this error has returned after installing the latest dev.

Not sure were Fago changed #9, can't trace it anyway. I'm willing to look for a solution if you guys can point me in the right direction.

Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => menu [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:217:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT filename FROM {registry} WHERE name = :name AND type = :type; Array ( [:name] => SearchApiViewsHandlerField [:type] => interface ) ";s:9:"%function";s:22:"_registry_check_code()";s:5:"%file";s:36:"/var/www/html/includes/bootstrap.inc";s:5:"%line";i:2800;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://www.solr-deplate.be/admin_menu/flush-cache?destination=admin [:db_insert_placeholder_7] => http://www.solr-deplate.be/?q=admin [:db_insert_placeholder_8] => 178.116.192.250 [:db_insert_placeholder_9] => 1306076890 ) in dblog_watchdog() (line 155 of /var/www/html/modules/dblog/dblog.module).
Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT lid, location FROM {locales_source} WHERE source = :source AND textgroup = 'default'; Array ( [:source] => An AJAX HTTP error occurred. ) in _locale_parse_js_file() (line 1326 of /var/www/html/includes/locale.inc).
Uncaught exception thrown in shutdown function.

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] => 14277394dd926e3e27650.49141803 ) in lock_release_all() (line 247 of /var/www/html/includes/lock.inc).

Adding some extra info in case somebody has similar issues, I've increased the allowed packet size in my.cnf ( centos 5.5) - (or my.ini on some other OS's)

[mysqld]
max_allowed_packet = 512M

This has removed the "PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" completely.