Houston I think we have a problem. In my log file I see this:

[#|2012-01-10T06:36:10.441-0700|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=215;_ThreadName
=Thread-2;|2012-01-10 06:36:10,441 INFO 
[org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] - 
<Beginning ticket cleanup.>
|#]

But a few lines later I see this exception:

[#|2012-01-10T06:36:10.462-0700|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=215;_ThreadName=Thread-2;|2012-01-10
 06:36:10,460 ERROR [org.quartz.core.JobRunShell] - <Job 
DEFAULT.ticketRegistryCleanerJobDetail threw an unhandled Exception: >
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: 
Invocation of method 'clean' on target class [class 
org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner] failed; 
nested exception is java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot 
be cast to java.sql.Timestamp
        at 
org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:273)
        at 
org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to 
java.sql.Timestamp
        at 
com.sun.rowset.CachedRowSetImpl.getTimestamp(CachedRowSetImpl.java:2262)
        at 
com.sun.rowset.CachedRowSetImpl.getTimestamp(CachedRowSetImpl.java:2713)
        at 
org.springframework.jdbc.support.rowset.ResultSetWrappingSqlRowSet.getTimestamp(ResultSetWrappingSqlRowSet.java:515)
        at 
org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.canAcquire(JdbcLockingStrategy.java:330)

I think this explains why our ticket registry has 2 million rows. I'll take a 
look at the source to see if I can fix this problem. Hopefully I just have a 
config error that will fix this issue.

-Bryan

-----Original Message-----
From: Marvin Addison [mailto:[email protected]] 
Sent: Tuesday, January 10, 2012 6:54 AM
To: [email protected]
Subject: Re: [cas-user] CAS slow today

> Ok following the link you sent I see that do have a ticketRegistery.xml file 
> in my overlay build.

What you have looks reasonable.  If you have wiring problems, I'd expect 
deployment errors that I assume you're not having.  So let's assume it's wired 
correctly.  You should do some careful log review to determine whether the 
cleaner is running.  It has very obvious log entries.

If it's not running, then I'd recommend you check to see whether you have a 
Quartz scheduler driving periodicTicketRegistryCleanerTrigger.
Newer versions of CAS use
org.jasig.cas.util.AutowiringSchedulerFactoryBean to scan for triggers anywhere 
in the Spring context and install them.  In any case make sure you have 
something that's driving the trigger.

M

--
You are currently subscribed to [email protected] as: 
[email protected] To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

-- 
You are currently subscribed to [email protected] as: 
[email protected]
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/cas-user

Reply via email to