You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by Bob Lannoy <bo...@gmail.com> on 2012/09/06 10:07:52 UTC
Notification problem
Hi,
with regars to my post to the user list
http://mail-archives.apache.org/mod_mbox/incubator-syncope-user/201209.mbox/%3CCANSL76Kniz9AKnChOBUjTX-w3WfGBvKk0S1Guyh9Yv8nJwfo%3Dw%40mail.gmail.com%3E
It's probably best discussed on this list.
I tried the query hint but it's not supported.
Anyone familiar enough with OpenJPA to give some hints?
I found @DataCache(enabled=false) which I added tot the Task class.
Will this have the necessary effect?
best regards
Bob
Re: Notification problem
Posted by Francesco Chicchiriccò <il...@apache.org>.
Hi Bob,
nevertheless to say, I couldn't been able to reproduce your issue;
anyway, I'd think that the fix introduced yesterday in
1.0.2-incubating-SNAPSHOT and 1.1.0-incubating-SNAPSHOT for SYNCOPE-124
and SYNCOPE-202 might affect your use case as well.
Could you please update your environment with one of these updated
snapshosts?
Regards.
On 06/09/2012 15:57, Bob Lannoy wrote:
>> Could you please once again provide full description of your environment and configuration in order to try to reproduce your issue?
> Hi Francesco,
>
> I'm afraid that there is not much to say.
> And as I mentioned it only happens only sometimes.
>
> I just had it again after a few tries:
> - a notification task was created through workflow
> - I got the notification every 2 minutes over and over again
> - in the MySql db I saw the following line in Task table:
> states '69', NULL, 'NotificationTask', NULL, NULL, NULL, NULL, NULL,
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
> '<html>Dear...', 'address@server.com', 'Activation', 'Dear...',
> 'SUMMARY', '1'
> As you can see the last field is executed = 1
> - in the console I see [EXECUTED]
> - core log
> 15:50:00.117 DEBUG org.quartz.core.JobRunShell - Calling execute on
> job DEFAULT.taskNotificationJob
> 15:50:00.117 DEBUG org.apache.syncope.core.scheduling.NotificationJob
> - Waking up...
> 15:50:00.124 DEBUG org.apache.syncope.core.scheduling.NotificationJob
> - Found notification task NotificationTask[69] to be executed:
> starting...
> 15:50:00.137 DEBUG org.apache.syncope.core.scheduling.NotificationJob
> - SMTP details fetched: localhost:25 / :[PASSWORD_NOT_SHOWN]
> 15:50:00.140 DEBUG org.apache.syncope.core.scheduling.NotificationJob
> - About to send e-mails:
> Mail text
> 15:50:00.705 DEBUG org.apache.syncope.core.scheduling.NotificationJob
> - Notification task NotificationTask[69] executed
>
> When a new notification was added it stopped.
> It really feels like a caching issue.
>
> I'm on tomcat 6.0.24 & myqsl 5.1. I have a quite standard Syncope setup.
> I have notifications setup that are coupled to a workflow task and
> they appear nicely in the "Tasks" part of console.
>
> My persistence properties:
> jpa.driverClassName=com.mysql.jdbc.Driver
> jpa.url=jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8
> jpa.username=syncope
> jpa.password=syncope
> jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
> quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
> quartz.sql=tables_mysql_innodb.sql
> logback.sql=mysql.sql
>
> Tomcat JDBC stuff:
> <Resource name="jdbc/syncopeDataSource" auth="Container"
> type="javax.sql.DataSource"
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
> testWhileIdle="true"
> testOnBorrow="true" testOnReturn="true"
> validationQuery="SELECT 1" validationInterval="30000"
> maxActive="50" minIdle="2" maxWait="10000" initialSize="2"
> removeAbandonedTimeout="10"
> removeAbandoned="true" logAbandoned="true" suspectTimeout="10"
> timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"
> jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
> username="syncope" password="syncope"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/>
>
> Anything else you would need?
>
> best regards
>
> Bob
--
Francesco Chicchiriccò
ASF Member, Apache Cocoon PMC and Apache Syncope PPMC Member
http://people.apache.org/~ilgrosso/
Re: Notification problem
Posted by Bob Lannoy <bo...@gmail.com>.
> Could you please once again provide full description of your environment and configuration in order to try to reproduce your issue?
Hi Francesco,
I'm afraid that there is not much to say.
And as I mentioned it only happens only sometimes.
I just had it again after a few tries:
- a notification task was created through workflow
- I got the notification every 2 minutes over and over again
- in the MySql db I saw the following line in Task table:
states '69', NULL, 'NotificationTask', NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
'<html>Dear...', 'address@server.com', 'Activation', 'Dear...',
'SUMMARY', '1'
As you can see the last field is executed = 1
- in the console I see [EXECUTED]
- core log
15:50:00.117 DEBUG org.quartz.core.JobRunShell - Calling execute on
job DEFAULT.taskNotificationJob
15:50:00.117 DEBUG org.apache.syncope.core.scheduling.NotificationJob
- Waking up...
15:50:00.124 DEBUG org.apache.syncope.core.scheduling.NotificationJob
- Found notification task NotificationTask[69] to be executed:
starting...
15:50:00.137 DEBUG org.apache.syncope.core.scheduling.NotificationJob
- SMTP details fetched: localhost:25 / :[PASSWORD_NOT_SHOWN]
15:50:00.140 DEBUG org.apache.syncope.core.scheduling.NotificationJob
- About to send e-mails:
Mail text
15:50:00.705 DEBUG org.apache.syncope.core.scheduling.NotificationJob
- Notification task NotificationTask[69] executed
When a new notification was added it stopped.
It really feels like a caching issue.
I'm on tomcat 6.0.24 & myqsl 5.1. I have a quite standard Syncope setup.
I have notifications setup that are coupled to a workflow task and
they appear nicely in the "Tasks" part of console.
My persistence properties:
jpa.driverClassName=com.mysql.jdbc.Driver
jpa.url=jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.MySQLDictionary
quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
quartz.sql=tables_mysql_innodb.sql
logback.sql=mysql.sql
Tomcat JDBC stuff:
<Resource name="jdbc/syncopeDataSource" auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true" testOnReturn="true"
validationQuery="SELECT 1" validationInterval="30000"
maxActive="50" minIdle="2" maxWait="10000" initialSize="2"
removeAbandonedTimeout="10"
removeAbandoned="true" logAbandoned="true" suspectTimeout="10"
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="syncope" password="syncope"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/>
Anything else you would need?
best regards
Bob
Re: Notification problem
Posted by Francesco Chicchiriccò <il...@apache.org>.
Bob Lannoy <bo...@gmail.com> wrote:
>Hi,
>
>with regars to my post to the user list
>http://mail-archives.apache.org/mod_mbox/incubator-syncope-user/201209.mbox/%3CCANSL76Kniz9AKnChOBUjTX-w3WfGBvKk0S1Guyh9Yv8nJwfo%3Dw%40mail.gmail.com%3E
>It's probably best discussed on this list.
>
>I tried the query hint but it's not supported.
>Anyone familiar enough with OpenJPA to give some hints?
>I found @DataCache(enabled=false) which I added tot the Task class.
>Will this have the necessary effect?
Could you please once again provide full description of your environment and configuration in order to try to reproduce your issue?
Regards.
--
Francesco Chicchiriccò
ASF Member, Apache Cocoon PMC and Apache Syncope PPMC Member
http://people.apache.org/~ilgrosso/