Return-Path: <dev-return-255295-archive-asf-public=cust-asf.ponee.io@lucene.apache.org>
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 01D6A200B65
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Wed,  3 Aug 2016 08:17:23 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 00494160AA8; Wed,  3 Aug 2016 06:17:23 +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 1D0AF160AAC
	for <archive-asf-public@cust-asf.ponee.io>; Wed,  3 Aug 2016 08:17:21 +0200 (CEST)
Received: (qmail 31247 invoked by uid 500); 3 Aug 2016 06:17:21 -0000
Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@lucene.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@lucene.apache.org>
List-Post: <mailto:dev@lucene.apache.org>
List-Id: <dev.lucene.apache.org>
Reply-To: dev@lucene.apache.org
Delivered-To: mailing list dev@lucene.apache.org
Received: (qmail 31101 invoked by uid 99); 3 Aug 2016 06:17:20 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Aug 2016 06:17:20 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id 89BDA2C0D61
	for <dev@lucene.apache.org>; Wed,  3 Aug 2016 06:17:20 +0000 (UTC)
Date: Wed, 3 Aug 2016 06:17:20 +0000 (UTC)
From: "Mikhail Khludnev (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Message-ID: <JIRA.12983826.1467042016000.208021.1470205040561@Atlassian.JIRA>
In-Reply-To: <JIRA.12983826.1467042016000@Atlassian.JIRA>
References: <JIRA.12983826.1467042016000@Atlassian.JIRA> <JIRA.12983826.1467042016714@arcas>
Subject: [jira] [Closed] (SOLR-9256) Solr 6.x DataImportHandler fails with
 postgreSQL dataSource with multiple joined entities
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Wed, 03 Aug 2016 06:17:23 -0000


     [ https://issues.apache.org/jira/browse/SOLR-9256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mikhail Khludnev closed SOLR-9256.
----------------------------------

> Solr 6.x DataImportHandler fails with postgreSQL dataSource with multiple joined entities
> -----------------------------------------------------------------------------------------
>
>                 Key: SOLR-9256
>                 URL: https://issues.apache.org/jira/browse/SOLR-9256
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: update
>    Affects Versions: 6.0, 6.0.1
>         Environment: Solr 6.0, 6.0.1 Single Instance or SolrCloud with postgreSQL 9.4 Server on Java Version 1.8.0_91 runtime
>            Reporter: Benjamin Richter
>             Fix For: 6.0.2, 6.1, 6.1.1, 6.2, master (7.0)
>
>         Attachments: SOLR-9256.patch
>
>
> h1. solr-data-config.xml
> {code:xml}
> <dataConfig>
>   <dataSource name="jdbc" driver="org.postgresql.Driver" url="jdbc:postgresql://host:5432/database" user="username" password="password" readOnly="true" autoCommit="false" />
>   <document>
>     <entity name="outer" dataSource="jdbc" pk="id" query="SELECT id, a FROM table_a ORDER BY id ASC">
> 		<field column="id" name="id" />
> 		<field column="a" name="a" />
> 	
> 		<entity name="inner_one" query="SELECT a_id, b FROM table_b"
> 				cacheKey="a_id" cacheLookup="outer.id" cacheImpl="SortedMapBackedCache">
> 			<field column="b" name="b" />
> 		</entity>
> 		
> 		<entity name="inner_two" query="SELECT a_id, c FROM table_c ORDER BY a_id ASC"
> 				cacheKey="a_id" cacheLookup="outer.id" join="zipper">
> 			<field column="c" name="c" />
> 		</entity>
> 	</entity>
>   </document>
> </dataConfig>
> {code}
> This works up to SOLR 5.5.2 (latest 5.x) but fails in SOLR 6.x.
> Exception:
> org.apache.solr.handler.dataimport.DataImportHandlerException: org.postgresql.util.PSQLException: Dieses ResultSet ist geschlossen.
>         at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:61)
>         at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(JdbcDataSource.java:434)
>         at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator$1.hasNext(JdbcDataSource.java:350)
>         at com.google.common.collect.Iterators$PeekingImpl.hasNext(Iterators.java:1216)
>         at org.apache.solr.handler.dataimport.Zipper.supplyNextChild(Zipper.java:65)
>         at org.apache.solr.handler.dataimport.EntityProcessorBase.getNext(EntityProcessorBase.java:127)
>         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:514)
>         at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414)
>         at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:329)
>         at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:232)
>         at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:416)
>         at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:480)
>         at org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:200)
>         at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:155)
>         at org.apache.solr.core.SolrCore.execute(SolrCore.java:2053)
>         at org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:652)
>         at org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:460)
>         at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:229)
>         at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:184)
>         at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1668)
>         at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
>         at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
>         at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
>         at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
>         at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1160)
>         at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
>         at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
>         at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1092)
>         at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
>         at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)
>         at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
>         at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
>         at org.eclipse.jetty.server.Server.handle(Server.java:518)
>         at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:308)
>         at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)
>         at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
>         at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
>         at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
>         at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceAndRun(ExecuteProduceConsume.java:246)
>         at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:156)
>         at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:654)
>         at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:572)
>         at java.lang.Thread.run(Thread.java:745)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org