You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by palexv <pa...@gmail.com> on 2009/09/14 16:15:22 UTC
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
Posted by Fuad Efendi <fu...@efendi.ca>.
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.paul@gmail.com [mailto:noble.paul@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 <pa...@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 <pa...@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
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
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 <pa...@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 <pa...@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
Posted by palexv <pa...@gmail.com>.
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 <pa...@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
Posted by Noble Paul നോബിള് नोब्ळ् <no...@corp.aol.com>.
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 <pa...@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