On Fri, Jan 30, 2015 at 9:01 AM, Aniket Bhoi <aniket.b...@gmail.com> wrote:
> Hi, > > I have Apache Solr hosted on Tomcat 6. > > There have been no changes to the code on Tomcat whatsoever.However for the > last few days I now see this error in the Log files: > > SEVERE: Full Import failed > Throwable occurred: > org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to > execute query: SELECT ID, ENTRY_TYPE_REF, PROFILE_REF, ITEM_REF, TITLE, > ABSTRACT, SOLUTION, SOLUTION_HTML, FREE_TEXT, DATE_UPDATED, ENTRY_TYPE, > PROFILE_TYPE, SERVICE_TYPE FROM INFRA_KO_V Processing Document # 1 > at > > org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:72) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:251) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:208) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:39) > at > > org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:58) > at > > org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:71) > at > > org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:233) > at > > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:579) > at > > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:260) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:184) > at > > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334) > at > > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:392) > at > > org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:373) > *Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver > could not establish a secure connection to SQL Server by using Secure > Sockets Layer (SSL) encryption. Error: "SQL Server did not return a > response. The connection has been closed.".* > at > > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368) > at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1412) > at > > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1058) > at > > com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833) > at > > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716) > at > > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:160) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:361) > at > > org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:39) > at > > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:238) > ... 11 more > *Caused by: java.io.IOException: SQL Server did not return a response. The > connection has been closed.* > at > > com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:513) > at > > com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:570) > at > > com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:562) > at > > com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:757) > at > > com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:745) > at com.ibm.jsse2.b.a(b.java:286) > at com.ibm.jsse2.b.a(b.java:67) > at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:313) > at com.ibm.jsse2.SSLSocketImpl.h(SSLSocketImpl.java:63) > at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:316) > at com.ibm.jsse2.SSLSocketImpl.startHandshake(SSLSocketImpl.java:220) > at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1379) > ... 20 more > > I can confirmthat there has been no change to firewall settings etc . > > Need help on this. > > Regards > Aniket > Assuming no changes on the calling side (Application/OS), is it possible that the Windows MS SQL server has been recently patched and restarted. There are periodic OS, security updates to Windows and sometimes they involve Certificates (i.e. SSL). It could be that a previously allowed Certificate is no longer working due to expiration, encryption length no longer being sufficient, etc...
