RE: Dataimport MySQLNonTransientConnectionException: No operations allowed after connection closed
Easy FIX: use autoReconnect=true for MySQL: jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=UTF-8&autoReconnect=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 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 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
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 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 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
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 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 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
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.
