Hi, I am trying to import a mysql database : sampledatabase.
When I run the full import command http://localhost:8983/solr/db/dataimport?command=full-import in the browser, I get the following error in the terminal after about 1 minute. Oct 16, 2012 3:49:20 PM org.apache.solr.core.SolrCore execute INFO: [db] webapp=/solr path=/dataimport params={command=full-import} status=0 QTime=0 Oct 16, 2012 3:49:20 PM org.apache.solr.common.SolrException log SEVERE: Exception while processing: customer document : SolrInputDocument[{}]:org.apache.solr.handler.dataimport.DataImportHandlerException : Unable to execute query: select contactLastName from customers Processing Document # 1 . . . 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 and packets from server. at sun.reflect.NativeConstructorAccessImpl.newInstance0(Native Method) . . . Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:592) ... 31 more . . . My dataconfig.xml file looks like the following : - <dataConfig> <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:8983/home/demo/snp-comm/sampledatabase" /> - <document> - <entity name="customers" query="select contactLastName from customers"> <field column="contactLastName" name="contactLastName" /> </entity> </document> </dataConfig> Relevant portion of schema.xml : <field name="contactLastName" type="string" indexed="true" stored="true" /> Relevant portion of solarconfig.xml : - <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"> - <lst name="defaults"> <str name="config">data-config.xml</str> </lst> </requestHandler> Kindly let me know what can be the issue. Thanks and regards, Romita Saha Panasonic R&D Center Singapore Blk 1022 Tai Seng Avenue #06-3530 Tai Seng Ind. Est. Singapore 534415 DID: (65) 6550 5383 FAX: (65) 6550 5459 email: romita.s...@sg.panasonic.com
