Re: Notification problem

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