You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Tayfun Gökmen HALAÇ <ta...@yahoo.com> on 2012/04/27 09:38:40 UTC
Joseki on mysql auto-reconnection
Hi,
Apache user group mailer rejects my mails for this question. Could you reply the message below?
http://tech.groups.yahoo.com/group/jena-dev/message/48219
Thank you in advance.
Tayfun
Re: Joseki on mysql auto-reconnection
Posted by Andy Seaborne <an...@apache.org>.
On 27/04/12 17:01, Tayfun Gökmen HALAÇ wrote:
> Andy,
>
> Do you have any comments on Joseki SPARQL processor?
Message are answered on a "when I can basis"
My expeirnece was that if autoreconnect is enabled, then the first call
after a long idle period still failed. Retrying was necessary.
But you still need autoreconnect.
Andy
>
> P.S. Thank you Paolo. I am already a member. I managed to send.
>
> Best,
>
> Tayfun
>
>
> ----- Original Message -----
> From: Tayfun Gökmen HALAÇ<ta...@yahoo.com>
> To: "jena-users@incubator.apache.org"<je...@incubator.apache.org>
> Cc:
> Sent: Friday, April 27, 2012 10:53 AM
> Subject: Re: Joseki on mysql auto-reconnection
>
> Hi,
>
> Sorry for the same message. There is a problem about my message format. It gets 552 spam core exceeded. I am trying plain text message below.
>
> --
>
>
> I have a question about Joseki. (http://tech.groups.yahoo.com/group/jena-dev/message/48219)
>
> The problem is about Joseki's query execution retry for timed out connection in mysql. In org.joseki.processors.SPARQL, execQueryProtected() method retries query execution if it catches a QueryStageException and finds a cause of mysql connection within that exception. But, the exception for timed out connection comes within a JenaException if you look at logs (an info log). Also, one cannot see the warning log of "Execution failure (retryable)".
>
> Thus, I checked out the source code (3.4.5-SNAPSHOT from github) and modified. I added the same retry code in QueryStageException catch to JenaException catch. (the code below)
>
> if (attempts == 0&& causeLooksRetryable(ex)) {
> attempts++;
> log.warn("Execution failure (retryable) : retry: " + attempts);
> execQueryProtected(request, response, dataset, attempts);
> return;
> }
>
> Now, I can see the log of "Execution failure (retryable)", and SPARQL processor retries to execute the query once again. But, how does calling execQueryProtected() method again rebuild the connection? There is nothing to get a new connection in the code, and therefore the same exception occurs in the second call too.
>
> Best regards,
>
> Tayfun Gokmen Halac
>
>
>
> ________________________________
> From: Tayfun Gökmen HALAÇ<ta...@yahoo.com>
> To: "jena-users@incubator.apache.org"<je...@incubator.apache.org>
> Sent: Friday, April 27, 2012 10:38 AM
> Subject: Joseki on mysql auto-reconnection
>
>
> Hi,
>
> Apache user group mailer rejects my mails for this question. Could you reply the message below?
>
> http://tech.groups.yahoo.com/group/jena-dev/message/48219
>
> Thank you in advance.
>
> Tayfun
>
Re: Joseki on mysql auto-reconnection
Posted by Tayfun Gökmen HALAÇ <ta...@yahoo.com>.
Andy,
Do you have any comments on Joseki SPARQL processor?
P.S. Thank you Paolo. I am already a member. I managed to send.
Best,
Tayfun
----- Original Message -----
From: Tayfun Gökmen HALAÇ <ta...@yahoo.com>
To: "jena-users@incubator.apache.org" <je...@incubator.apache.org>
Cc:
Sent: Friday, April 27, 2012 10:53 AM
Subject: Re: Joseki on mysql auto-reconnection
Hi,
Sorry for the same message. There is a problem about my message format. It gets 552 spam core exceeded. I am trying plain text message below.
--
I have a question about Joseki. (http://tech.groups.yahoo.com/group/jena-dev/message/48219)
The problem is about Joseki's query execution retry for timed out connection in mysql. In org.joseki.processors.SPARQL, execQueryProtected() method retries query execution if it catches a QueryStageException and finds a cause of mysql connection within that exception. But, the exception for timed out connection comes within a JenaException if you look at logs (an info log). Also, one cannot see the warning log of "Execution failure (retryable)".
Thus, I checked out the source code (3.4.5-SNAPSHOT from github) and modified. I added the same retry code in QueryStageException catch to JenaException catch. (the code below)
if (attempts == 0 && causeLooksRetryable(ex)) {
attempts++;
log.warn("Execution failure (retryable) : retry: " + attempts);
execQueryProtected(request, response, dataset, attempts);
return;
}
Now, I can see the log of "Execution failure (retryable)", and SPARQL processor retries to execute the query once again. But, how does calling execQueryProtected() method again rebuild the connection? There is nothing to get a new connection in the code, and therefore the same exception occurs in the second call too.
Best regards,
Tayfun Gokmen Halac
________________________________
From: Tayfun Gökmen HALAÇ <ta...@yahoo.com>
To: "jena-users@incubator.apache.org" <je...@incubator.apache.org>
Sent: Friday, April 27, 2012 10:38 AM
Subject: Joseki on mysql auto-reconnection
Hi,
Apache user group mailer rejects my mails for this question. Could you reply the message below?
http://tech.groups.yahoo.com/group/jena-dev/message/48219
Thank you in advance.
Tayfun
Re: Joseki on mysql auto-reconnection
Posted by Tayfun Gökmen HALAÇ <ta...@yahoo.com>.
Hi,
Sorry for the same message. There is a problem about my message format. It gets 552 spam core exceeded. I am trying plain text message below.
--
I have a question about Joseki. (http://tech.groups.yahoo.com/group/jena-dev/message/48219)
The problem is about Joseki's query execution retry for timed out connection in mysql. In org.joseki.processors.SPARQL, execQueryProtected() method retries query execution if it catches a QueryStageException and finds a cause of mysql connection within that exception. But, the exception for timed out connection comes within a JenaException if you look at logs (an info log). Also, one cannot see the warning log of "Execution failure (retryable)".
Thus, I checked out the source code (3.4.5-SNAPSHOT from github) and modified. I added the same retry code in QueryStageException catch to JenaException catch. (the code below)
if (attempts == 0 && causeLooksRetryable(ex)) {
attempts++;
log.warn("Execution failure (retryable) : retry: " + attempts);
execQueryProtected(request, response, dataset, attempts);
return;
}
Now, I can see the log of "Execution failure (retryable)", and SPARQL processor retries to execute the query once again. But, how does calling execQueryProtected() method again rebuild the connection? There is nothing to get a new connection in the code, and therefore the same exception occurs in the second call too.
Best regards,
Tayfun Gokmen Halac
________________________________
From: Tayfun Gökmen HALAÇ <ta...@yahoo.com>
To: "jena-users@incubator.apache.org" <je...@incubator.apache.org>
Sent: Friday, April 27, 2012 10:38 AM
Subject: Joseki on mysql auto-reconnection
Hi,
Apache user group mailer rejects my mails for this question. Could you reply the message below?
http://tech.groups.yahoo.com/group/jena-dev/message/48219
Thank you in advance.
Tayfun
Re: Joseki on mysql auto-reconnection
Posted by Paolo Castagna <ca...@googlemail.com>.
Hi Tayfun,
are you subscribed to the jena-users@incubator.apache.org mailing list?
Subscribing to the list is very easy, simply send an email to:
- jena-users-subscribe@incubator.apache.org
using the email account you want to subscribe with.
For more info on how get help with Jena, please, read:
- http://incubator.apache.org/jena/help_and_support/
Please, subscribe to jena-users@incubator.apache.org and send your
question here.
Paolo
Tayfun Gökmen HALAÇ wrote:
> Hi,
>
> Apache user group mailer rejects my mails for this question. Could you reply the message below?
>
> http://tech.groups.yahoo.com/group/jena-dev/message/48219
>
> Thank you in advance.
>
> Tayfun