Problem with Watched Folder endpoint

alexandros173

12-11-2010

Hi,

We have a problem with a watched folder endpoint. The watched folder is set in a directory in a linux server. The directory then is mapped to a windows directory where files arrive from time to time. Everything works fine until the watched folder service stops for no particular reason. After that we need to restart the service from the admin UI console.

I found in another post something related to the MySql database losing connection with livecycle after some inactivity, but I'm not sure if this is our case or even how to solve the problem.

Here's what we found in the log

2010-11-11 17:10:31,890 INFO  [com.adobe.idp.dsc.provider.service.file.write.impl.FileResultHandlerImpl] FileResultHandlerImpl ----- preserved- source ----/data/livecycle/lc_wrk/edi/stage/Wx130df02e731a9c7b14738905/C0158_208.dat--- to ---/data/livecycle/lc_wrk/edi/preserve/ /C0158_208.dat

2010-11-11 20:39:46,366 INFO  [com.adobe.idp.scheduler.jobstore.DSCJobStoreTX] Handling 1 trigger(s) that missed their scheduled fire-time.

2010-11-11 20:40:22,056 ERROR [com.adobe.idp.scheduler.jobstore.DSCJobStoreTX] Error retrieving job, setting trigger state to ERROR.

org.quartz.JobPersistenceException: Couldn't retrieve job: Prepared statement needs to be re-prepared [See nested exception: java.sql.SQLException: Prepared statement needs to be re-prepared]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1338)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2789)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$37.execute(JobStoreSupport.java:2757)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3662)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2751)

at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:313)

Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)

at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:255)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobListeners(StdJDBCDelegate.java:843)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1319)

... 5 more

2010-11-11 20:40:22,061 ERROR [org.quartz.core.ErrorLogger] An error occured while firing trigger 'WatchedFolder.WatchedFolder:1107'

org.quartz.JobPersistenceException: Couldn't retrieve job: Prepared statement needs to be re-prepared [See nested exception: java.sql.SQLException: Prepared statement needs to be re-prepared]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1338)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2789)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$37.execute(JobStoreSupport.java:2757)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3662)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggerFired(JobStoreSupport.java:2751)

at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:313)

Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)

at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)

at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:90)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:255)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectJobListeners(StdJDBCDelegate.java:843)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1319)

... 5 more

2010-11-11 20:56:46,550 INFO  [com.adobe.idp.scheduler.jobstore.DSCJobStoreTX] Handling 1 trigger(s) that missed their scheduled fire-time.

thanks

View Entire Topic