[jira] [Updated] (SOLR-5954) Slower dataimport process caused by not reusing jdbc connections
[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Miller updated SOLR-5954:
--
Priority: Blocker (was: Minor)
Fix Version/s: (was: 4.9)
4.8
We should put this regression into 4.8.
> 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
[jira] [Updated] (SOLR-5954) Slower dataimport process caused by not reusing jdbc connections
[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Miller updated SOLR-5954:
--
Fix Version/s: (was: 4.7.2)
5.0
4.9
> 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.8, 4.9, 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
[jira] [Updated] (SOLR-5954) Slower dataimport process caused by not reusing jdbc connections
[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raja Nagendra Kumar updated SOLR-5954:
--
Attachment: (was: SOLR-5954)
> 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.8, 4.7.2
>
> 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
[jira] [Updated] (SOLR-5954) Slower dataimport process caused by not reusing jdbc connections
[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raja Nagendra Kumar updated SOLR-5954:
--
Attachment: SOLR-5954
> 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.8, 4.7.2
>
> 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
[jira] [Updated] (SOLR-5954) Slower dataimport process caused by not reusing jdbc connections
[
https://issues.apache.org/jira/browse/SOLR-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mark Miller updated SOLR-5954:
--
Attachment: SOLR-5954.patch
> 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
>Priority: Minor
> Fix For: 4.8, 4.7.2
>
> 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
