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 <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
