Re: MySQL Exception: Communications link failure WITH DataImportHandler

2012-08-16 Thread Jienan Duan
It happens immediately upon connection,the jdbc string is correct. This problem only happens when DIH trying get a connection to mysql,the network and database server are fine. So I guess it caused by some security configuration on the server and that config has blocked the connection. But other ap

Re: MySQL Exception: Communications link failure WITH DataImportHandler

2012-08-16 Thread Gora Mohanty
On 16 August 2012 14:07, Jienan Duan 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. [...] When does this error happ

Re: MySQL Exception: Communications link failure WITH DataImportHandler

2012-08-16 Thread Alexey Serba
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 lon

Re: MySQL Exception: Communications link failure WITH DataImportHandler

2012-08-16 Thread Jienan Duan
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 > Hi all: > I'm using DataImportHandler load data

MySQL Exception: Communications link failure WITH DataImportHandler

2012-08-15 Thread Jienan Duan
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 success