[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13969974#comment-13969974
]
ASF subversion and git services commented on SOLR-5954:
-------------------------------------------------------
Commit 1587707 from [email protected] in branch 'dev/branches/branch_4x'
[ https://svn.apache.org/r1587707 ]
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: Minor
> Fix For: 4.7.2, 4.8
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
