looks like you are not being able to connect to database , pls see if you get similar exception when you try to connect from other clients
On Tue, May 31, 2011 at 3:01 PM, tiffany <tiffany.c...@future.co.jp> wrote: > Hi all, > > I'm using DIH and getting the following error. > My Solr version is Solr3.1. > > ===== > ... > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could > not create connection to database server. Attempted reconnect 3 times. > Giving up. > at sun.reflect.GeneratedConstructorAccessor98.newInstance(Unknown > Source) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2364) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) > at sun.reflect.GeneratedConstructorAccessor94.newInstance(Unknown > Source) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:128) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:363) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240) > ... 11 more > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data > source rejected establishment of connection, message from server: "Too > many > connections" > at sun.reflect.GeneratedConstructorAccessor98.newInstance(Unknown > Source) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > at com.mysql.jdbc.Util.getInstance(Util.java:381) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1104) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2292) > ... 24 more > > ===== > > My dataSource setting is something like this: > > <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" > url="jdbc:mysql://database01/test?autoReconnect=true" user="xxx" > password="xxx" batchSize="-1" /> > > Any idea to solve this problem? > > Thank you! > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/DIH-Exception-with-Too-many-connections-tp3005213p3005213.html > Sent from the Solr - User mailing list archive at Nabble.com. > -- Chandan Tamrakar * *
