Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8FD9210AC5 for ; Mon, 3 Feb 2014 14:30:06 +0000 (UTC) Received: (qmail 55291 invoked by uid 500); 3 Feb 2014 14:30:01 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 55243 invoked by uid 500); 3 Feb 2014 14:30:01 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 55234 invoked by uid 99); 3 Feb 2014 14:30:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Feb 2014 14:30:01 +0000 X-ASF-Spam-Status: No, hits=2.6 required=5.0 tests=FSL_HELO_BARE_IP_2,RCVD_IN_DNSWL_NONE,RCVD_NUMERIC_HELO,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gcjsu-solr-user@m.gmane.org designates 80.91.229.3 as permitted sender) Received: from [80.91.229.3] (HELO plane.gmane.org) (80.91.229.3) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Feb 2014 14:29:55 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1WAKWj-0001ro-18 for solr-user@lucene.apache.org; Mon, 03 Feb 2014 15:29:33 +0100 Received: from 193.111.167.68 ([193.111.167.68]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 03 Feb 2014 15:29:33 +0100 Received: from newsgroups by 193.111.167.68 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 03 Feb 2014 15:29:33 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: solr-user@lucene.apache.org From: "Peter Sch�tt" Subject: Strange Error Message while Full Import Date: Mon, 3 Feb 2014 14:29:08 +0000 (UTC) Lines: 89 Message-ID: X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 193.111.167.68 User-Agent: Xnews/5.04.25 X-Virus-Checked: Checked by ClamAV on apache.org Hallo, when I do a full import of a SOLR index I become a strange error message: org.apache.solr.handler.dataimport.DataImportHandlerException: java.sql.SQLRecoverableException: Closed Resultset: next It is only a simple query select FIRMEN_ID, FIRMIERUNG, FIRMENKENNUNG, PZN, DEBITORNUMMER, ADRESS_ID from DAT_FIRMA This error seems to be a subsequent error but there is no other cause in the stacktrace. Thanks for any hints. Ciao Peter Sch�tt P.S. The error stacktrace Feb 03, 2014 2:11:01 PM org.apache.solr.common.SolrException log SEVERE: getNext() failed for query 'select FIRMEN_ID, FIRMIERUNG, FIRMENKENNUNG, PZN, DEBITORNUMMER, ADRESS_ID from DAT_FIRMA':org.apache.solr.handler.dataimport.DataImportHandlerException : java.sql.SQLRecoverableException: Closed Resultset: next at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd Throw(DataImportHandlerException.java:63) at org.apache.solr.handler.dataimport.PreparedStatementJdbcDataSource$Re sultSetIterator.hasnext(PreparedStatementJdbcDataSource.java:404) at org.apache.solr.handler.dataimport.PreparedStatementJdbcDataSource$Re sultSetIterator.access$600(PreparedStatementJdbcDataSource.java:256) at org.apache.solr.handler.dataimport.PreparedStatementJdbcDataSource$Re sultSetIterator$1.hasNext(PreparedStatementJdbcDataSource.java:324) at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(Entity ProcessorBase.java:116) at org.apache.solr.handler.dataimport.PreparedStatementSqlEntityProcesso r.handleQuery(PreparedStatementSqlEntityProcessor.java:119) at org.apache.solr.handler.dataimport.PreparedStatementSqlEntityProcesso r.nextRow(PreparedStatementSqlEntityProcessor.java:124) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent ityProcessorWrapper.java:243) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument (DocBuilde r.java:465) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument (DocBuilde r.java:404) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump (DocBuilder.j ava:319) at org.apache.solr.handler.dataimport.DocBuilder.execute (DocBuilder.java :227) at org.apache.solr.handler.dataimport.DataImporter.doFullImport (DataImpo rter.java:422) at org.apache.solr.handler.dataimport.DataImporter.runCmd (DataImporter.j ava:487) at org.apache.solr.handler.dataimport.DataImporter$1.run (DataImporter.ja va:468) Caused by: java.sql.SQLRecoverableException: Closed Resultset: next at oracle.jdbc.driver.OracleResultSetImpl.next (OracleResultSetImpl.java: 214) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next (DelegatingResult Set.java:207) at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next (DelegatingResult Set.java:207) at org.apache.solr.handler.dataimport.PreparedStatementJdbcDataSource$Re sultSetIterator.hasnext(PreparedStatementJdbcDataSource.java:396) ... 13 more