> 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...', '[email protected]', '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

Reply via email to