Re: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
First of all let us confirm this issue is fixed in 1.4. 1.4 is stable and a lot of people are using it in production and it is going to be released pretty soon On Mon, Sep 14, 2009 at 8:05 PM, palexv pal...@gmail.com wrote: I am using 1.3 Do you suggest 1.4 from developer trunk? I am concern if it stable. Is it safe to use it in big commerce app? Noble Paul നോബിള് नोब्ळ्-2 wrote: which version of Solr are you using. can you try with a recent one and confirm this? On Mon, Sep 14, 2009 at 7:45 PM, palexv pal...@gmail.com wrote: I know that my issue is related to http://www.nabble.com/dataimporthandler-and-multiple-delta-import-td19160129.html#a19160129 and https://issues.apache.org/jira/browse/SOLR-728 but my case is quite different. As I understand patch at https://issues.apache.org/jira/browse/SOLR-728 prevents concurrent executing of import operation but does NOT put command in a queue. I have only few records to index. When run full reindex - it works very fast. But when I try to rerun this even after a couple of seconds - I am getting Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. At this time, when I check status - it says that status is idle and everything was indexed success. Second run of reindex without exception I can run only after 10 seconds. It does not work for me! If I apply patch from https://issues.apache.org/jira/browse/SOLR-728 - I will unable to reindex in next 10 seconds as well. Any suggestions? -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436605.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436948.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com
RE: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
Easy FIX: use autoReconnect=true for MySQL: jdbc:mysql://localhost:3306/?useUnicode=truecharacterEncoding=UTF-8autoReconnect=true May be it will help; connection is auto-closed after a couple of seconds (usually 10 seconds) by default, for MySQL... connection pooling won't help (their JDBC is already pool based, and server closes connection after some delays) -Fuad (MySQL contributor) -Original Message- From: noble.p...@gmail.com [mailto:noble.p...@gmail.com] On Behalf Of Noble Paul ??? ?? Sent: September-15-09 3:48 AM To: solr-user@lucene.apache.org Subject: Re: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed First of all let us confirm this issue is fixed in 1.4. 1.4 is stable and a lot of people are using it in production and it is going to be released pretty soon On Mon, Sep 14, 2009 at 8:05 PM, palexv pal...@gmail.com wrote: I am using 1.3 Do you suggest 1.4 from developer trunk? I am concern if it stable. Is it safe to use it in big commerce app? Noble Paul നോബിള് नोब्ळ्-2 wrote: which version of Solr are you using. can you try with a recent one and confirm this? On Mon, Sep 14, 2009 at 7:45 PM, palexv pal...@gmail.com wrote: I know that my issue is related to http://www.nabble.com/dataimporthandler-and-multiple-delta-import- td19160129.html#a19160129 and https://issues.apache.org/jira/browse/SOLR-728 but my case is quite different. As I understand patch at https://issues.apache.org/jira/browse/SOLR-728 prevents concurrent executing of import operation but does NOT put command in a queue. I have only few records to index. When run full reindex - it works very fast. But when I try to rerun this even after a couple of seconds - I am getting Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. At this time, when I check status - it says that status is idle and everything was indexed success. Second run of reindex without exception I can run only after 10 seconds. It does not work for me! If I apply patch from https://issues.apache.org/jira/browse/SOLR-728 - I will unable to reindex in next 10 seconds as well. Any suggestions? -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A- No-operations-allowed-after-connection-closed-tp25436605p25436605.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- View this message in context: http://www.nabble.com/Dataimport- MySQLNonTransientConnectionException%3A-No-operations-allowed-after- connection-closed-tp25436605p25436948.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com
Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
I know that my issue is related to http://www.nabble.com/dataimporthandler-and-multiple-delta-import-td19160129.html#a19160129 and https://issues.apache.org/jira/browse/SOLR-728 but my case is quite different. As I understand patch at https://issues.apache.org/jira/browse/SOLR-728 prevents concurrent executing of import operation but does NOT put command in a queue. I have only few records to index. When run full reindex - it works very fast. But when I try to rerun this even after a couple of seconds - I am getting Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. At this time, when I check status - it says that status is idle and everything was indexed success. Second run of reindex without exception I can run only after 10 seconds. It does not work for me! If I apply patch from https://issues.apache.org/jira/browse/SOLR-728 - I will unable to reindex in next 10 seconds as well. Any suggestions? -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436605.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
I am using 1.3 Do you suggest 1.4 from developer trunk? I am concern if it stable. Is it safe to use it in big commerce app? Noble Paul നോബിള് नोब्ळ्-2 wrote: which version of Solr are you using. can you try with a recent one and confirm this? On Mon, Sep 14, 2009 at 7:45 PM, palexv pal...@gmail.com wrote: I know that my issue is related to http://www.nabble.com/dataimporthandler-and-multiple-delta-import-td19160129.html#a19160129 and https://issues.apache.org/jira/browse/SOLR-728 but my case is quite different. As I understand patch at https://issues.apache.org/jira/browse/SOLR-728 prevents concurrent executing of import operation but does NOT put command in a queue. I have only few records to index. When run full reindex - it works very fast. But when I try to rerun this even after a couple of seconds - I am getting Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. At this time, when I check status - it says that status is idle and everything was indexed success. Second run of reindex without exception I can run only after 10 seconds. It does not work for me! If I apply patch from https://issues.apache.org/jira/browse/SOLR-728 - I will unable to reindex in next 10 seconds as well. Any suggestions? -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436605.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436948.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
which version of Solr are you using. can you try with a recent one and confirm this? On Mon, Sep 14, 2009 at 7:45 PM, palexv pal...@gmail.com wrote: I know that my issue is related to http://www.nabble.com/dataimporthandler-and-multiple-delta-import-td19160129.html#a19160129 and https://issues.apache.org/jira/browse/SOLR-728 but my case is quite different. As I understand patch at https://issues.apache.org/jira/browse/SOLR-728 prevents concurrent executing of import operation but does NOT put command in a queue. I have only few records to index. When run full reindex - it works very fast. But when I try to rerun this even after a couple of seconds - I am getting Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed. At this time, when I check status - it says that status is idle and everything was indexed success. Second run of reindex without exception I can run only after 10 seconds. It does not work for me! If I apply patch from https://issues.apache.org/jira/browse/SOLR-728 - I will unable to reindex in next 10 seconds as well. Any suggestions? -- View this message in context: http://www.nabble.com/Dataimport-MySQLNonTransientConnectionException%3A-No-operations-allowed-after-connection-closed-tp25436605p25436605.html Sent from the Solr - User mailing list archive at Nabble.com. -- - Noble Paul | Principal Engineer| AOL | http://aol.com