Hi,

Using Solr search on one of my project. On development server somebody delete rules about access port for Solr,
which cause that Solr server was unreachable from Drupal installation.

Until version 1.8 that was not problem, but with latest upgrade entire Drupal installation was hit with mysql deadlocks.
Cron was stuck, and Solr is unreachable which caused slow site and constant error: Lock wait timeout exceeded; try restarting transaction
(changes to mysql configuration, or drupal has not helped, until disable solr server in search api)

Same problem occur on two different server (development / stage enviroment)

example of output from cron:

advagg_cron - 0.02
autoslave_cron - 0.01
backup_migrate_cron - 83.95
ctools_cron - 0.7
dblog_cron - 0.98
feeds_cron - 0.66
field_cron - 155.28
googleanalytics_cron - 0.01
ip2country_cron - 0.4
job_scheduler_cron - 8.51
l10n_update_cron - 0.02
message_cron - 26.08
vallic_mtl_cron - 292.12
node_cron - 0.56
oauthconnector_cron - 0.54
oauth_common_cron - 1.62
redirect_cron - 0.01
search_cron - 9064.24
search_api_cron - WD search_api: SearchApiException while deleting items from server Solr: "0" Status: Request failed: Connection timed out[error]
in SearchApiSolrConnection->checkResponse() (line 541 of
/srv/www/vallic_test/web/sites/all/modules/search_api_solr/includes/solr_connection.inc).
WD php: PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: UPDATE[error]
{variable} SET value=:db_update_placeholder_0
WHERE ( (name = :db_condition_placeholder_0) ); Array
(
[:db_update_placeholder_0] => b:1;
[:db_condition_placeholder_0] => drupal_http_request_fails
)
in variable_set() (line 991 of /srv/www/vallic_test/web/includes/bootstrap.inc).

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: UPDATE {variable} SET value=:db_update_placeholder_0
WHERE ( (name = :db_condition_placeholder_0) ); Array
(
[:db_update_placeholder_0] => b:1;
[:db_condition_placeholder_0] => drupal_http_request_fails
)
in variable_set() (line 991 of /srv/www/vallic_test/web/includes/bootstrap.inc).
Drush command terminated abnormally due to an unrecoverable error. [error]

Comments

valic’s picture

Issue summary: View changes
drunken monkey’s picture

Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

I cannot reproduce this problem, for me this doesn't happen. (However, I also get "Connection refused" instead of "Connection timed out", so maybe it's also specific to the low-level server configuration?)
Could you please try with the latest versions of both this module and the Search API?
Also, please make sure you don't have any illegal configuration through Features (or similar) – e.g., indexes on disabled servers or the like.

If that all doesn't help then please try to get stack traces of the occurring errors to see from where that code is called.

Naveen Moses’s picture

I also got this same issue in my instance. Is anyone have solution for this issue.

drunken monkey’s picture

@ Naveen Moses: See my questions in #2.

OanaIlea’s picture

Status: Postponed (maintainer needs more info) » Closed (outdated)