Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id BAD75200C3C for ; Mon, 3 Apr 2017 17:59:51 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id B960F160B8F; Mon, 3 Apr 2017 15:59:51 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 0A4F8160B76 for ; Mon, 3 Apr 2017 17:59:50 +0200 (CEST) Received: (qmail 35865 invoked by uid 500); 3 Apr 2017 15:59:49 -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 Delivered-To: moderator for solr-user@lucene.apache.org Received: (qmail 26161 invoked by uid 99); 3 Apr 2017 15:56:08 -0000 X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=asX65WCWbTFGy9kDBtXxfi9ADkuzPORSNh+rUdJ7y9w=; b=s9KCTHkDYjb1HlRsJmfVQCjmfG1ga5if2IIa/06Oo/7BLOEvZAUD5olKW8Dhn5BhDo GvHssCPD50bA/7yAF6zYobBTLL3GgzqkYQcKPL3kh2tLsdVNJmHhmSXXtyOIX8MsjvD+ VyP5lfmps0Pfkp7Wr2S1Fuy0Mk9BOLMghLIrI59G5f9Wbu3IT1FhSMiR4Ph8hejL6SM6 i5hjiow5QKcn5Kl+qx0nhRuaBnxLJt6o9Ec3zxFUJ3ymWvsBeUuvzAHh9O86gfir54qL orO9ejJONdKV7UNP3P/HVe7sMW9pbfouoCM4ZFU0q1dNNBL7gcZECidtS4AVOnyc98lZ kSlw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=asX65WCWbTFGy9kDBtXxfi9ADkuzPORSNh+rUdJ7y9w=; b=g1Ll3LYYQ3YVJmQVKqcQM+yPmz52UKGnyWvjiCr++JC4Urk+//VZq5butv8apDfK6D EJ+K/HEFu2tQIdwuqVjdkoRcDvwKvRyp7FiuzfiJOH7aa01LPn82noAIU5iTFlnBXusR Y0uLnZqYoosJjbb1Jt3jj8Dr/hXr+6SzGj4V4IpFLZHKBYbA9hKK9HIokitLT6zIhgtv MH6ij1yH44h0IEfEWKImHOnAj4k1ttG31ONjbhqwfaznRL3+FxXZ1wGkbeXj0WLpK+YI EKy0KLEcwYkl21ld/4T4VUGNmB7PIL02zuOfceyB34LNougJVm0D7eWvJGWDgf7lNDyf /hTQ== X-Gm-Message-State: AFeK/H2hNI/Tq3uzXLUwci1FKFMPh6+bO6fV0/frgV7xoKk+d+uO5MwA9ZjcTalDKUTHdgMRiqytBo/j1V0LKw== X-Received: by 10.84.241.2 with SMTP id a2mr22784527pll.53.1491234965017; Mon, 03 Apr 2017 08:56:05 -0700 (PDT) MIME-Version: 1.0 From: Islam Omar Date: Mon, 3 Apr 2017 17:55:44 +0200 Message-ID: Subject: Solr 6.4.1 Issue To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary=f403045eddbc5ddcd4054c453283 archived-at: Mon, 03 Apr 2017 15:59:51 -0000 --f403045eddbc5ddcd4054c453283 Content-Type: text/plain; charset=UTF-8 Hi All , I have a trouble problem when doing *full import in solr 6.4.1 using MySQL DB , the problem is : * i need to create 1 core which will be around 9,500,000 documents , when i do full import with *batchSize* *= -1* in datasource , everything was ok but when the solr finish fetching data from database it *can't stop* running full import command and continue trying to fetch another data. *the log throws this exception * Caused by: org.apache.solr.handler.dataimport.DataImportHandlerException: java.sql.SQLException: Operation not allowed after ResultSet closed at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:61) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:464) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:377) at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:133) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:75) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:244) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:475) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414) ... 7 more Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:803) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6985) at com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2232) at com.mysql.jdbc.StatementImpl.getMoreResults(StatementImpl.java:2216) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:458) *Best regards* , *Islam omar* *Java developer* --f403045eddbc5ddcd4054c453283--