DataImportHandler - "too many connections" MySQL error after upgrade to Solr 1.4 release

[Bojan Šmid <bo...@gmail.com>]

Hi all,

  I had DataImportHandler working perfectly on Solr 1.4 nightly build from
June 2009. I upgraded the Solr to 1.4 release and started getting errors:


Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:
Server connection failure during transaction. Due to underlying exception:
'com.mysql.jdbc.except
ions.MySQLNonTransientConnectionException: Too many connections'.


  This is the same machine, the same setup (except new Solr) that never had
problems. The error doesn't pop-up at the beginning, DIH runs for few hours
and then breaks (after few millions of rows are processed).

  Solr is the only process using MySQL, max_connections on MySQL is set to
100, so it seems like there might exist some connection leak in DIH. Few
more informations on the setup:
  MySQL version 5.0.67
  driver: mysql-connector-java-5.0.8-bin.jar
  Java: 1.6.0_14
  connection URL parameters : autoReconnect=true, batchSize=-1
  OS : CentOS 5.2

  Did anyone else had similar problems with 1.4 release?


  Regards