[ https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13971468#comment-13971468 ]
ASF subversion and git services commented on SOLR-5954: ------------------------------------------------------- Commit 1587924 from markrmil...@apache.org in branch 'dev/branches/lucene_solr_4_8' [ https://svn.apache.org/r1587924 ] SOLR-5954: Slower DataImportHandler process caused by not reusing jdbc connections. > Slower dataimport process caused by not reusing jdbc connections > ---------------------------------------------------------------- > > Key: SOLR-5954 > URL: https://issues.apache.org/jira/browse/SOLR-5954 > Project: Solr > Issue Type: Bug > Components: contrib - DataImportHandler > Affects Versions: 4.7.1 > Reporter: Paco Garcia > Assignee: Mark Miller > Priority: Blocker > Fix For: 4.8, 5.0 > > Attachments: SOLR-5954.patch > > > Hi, > SOLR-5734 introduced a regression that causes that the connections used in > the dataimport process were closed and reopen in every sql. > The change to nanoTime in the method getConnection of JdbcDataSource.java > forgot to convert the timeout used to reuse the connection. > The constant CONN_TIME_OUT must be changed to nanos to be compared. > (*1000*1000) > private Connection getConnection() throws Exception { > long currTime = System.nanoTime(); > if (currTime - connLastUsed > CONN_TIME_OUT) {<<<<<<<<<<<<<<< > synchronized (this) > { Connection tmpConn = factory.call(); closeConnection(); connLastUsed = > System.nanoTime(); return conn = tmpConn; } > } else > { connLastUsed = currTime; return conn; } > } > private static final long CONN_TIME_OUT = 10 * 1000; // 10 seconds > Regards -- This message was sent by Atlassian JIRA (v6.2#6252) --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org