My memory is vague, but I think I've seen something similar with older versions of Solr.
Is it possible that you have significant database import and there's a big segments merge happening in the middle causing blocking in dih indexing process (and reading records from database as well), since long inactivity in communication with db server and timeout as a result. If this is the case then you can either increase timeout limit on db server (don't remember the actual parameter) or upgrade Solr to newer version that doesn't have such long pauses (4.0 beta?). On Thu, Aug 16, 2012 at 12:37 PM, Jienan Duan <jnd...@gmail.com> wrote: > Hi all: > I have resolved this problem by configuring a jndi datasource in tomcat. > But I still want to find out why it throw an exception in DIH when I > configure datasource in data-configure.xml but a jndi resource. > > Regards. > > 2012/8/16 Jienan Duan <jnd...@gmail.com> > >> Hi all: >> I'm using DataImportHandler load data from MySQL. >> It works fine on my develop machine and online environment. >> But I got an exception on test environment: >> >>> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: >>>> Communications link failure >>> >>> >>>> The last packet sent successfully to the server was 0 milliseconds ago. >>>> The driver has not received any packets from the server. >>> >>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>>> Method) >>> >>> at >>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >>> >>> 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.SQLError.createCommunicationsException(SQLError.java:1074) >>> >>> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) >>> >>> at >>>> com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2132) >>> >>> ... 26 more >>> >>> Caused by: java.net.ConnectException: Connection timed out >>> >>> at java.net.PlainSocketImpl.socketConnect(Native Method) >>> >>> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351) >>> >>> at >>>> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213) >>> >>> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200) >>> >>> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) >>> >>> at java.net.Socket.connect(Socket.java:529) >>> >>> at java.net.Socket.connect(Socket.java:478) >>> >>> at java.net.Socket.<init>(Socket.java:375) >>> >>> at java.net.Socket.<init>(Socket.java:218) >>> >>> at >>>> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) >>> >>> at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) >>> >>> ... 27 more >>> >>> This make me confused,because the test env and online env almost >> same:Tomcat runs on a Linux Server with JDK6,MySql5 runs on another. >> Even I wrote a simple JDBC test class it works,a jsp file with JDBC code >> also works.Only DataImportHandler failed. >> I'm trying to read Solr source code and found that it seems Solr has it's >> own ClassLoader.I'm not sure if it goes wrong with Tomcat on some specific >> configuration. >> Dose anyone know how to fix this problem? Thank you very much. >> >> Best Regards. >> >> Jienan Duan >> >> -- >> ------------------------------------------------------ >> 不走弯路，就是捷径。 >> http://www.jnan.org/ >> >> > > > -- > ------------------------------------------------------ > 不走弯路，就是捷径。 > http://www.jnan.org/
