JPA Backed Ticket Registry - TGT cleanup problem

Scott Battaglia scott.battaglia at gmail.com
Thu Mar 27 13:32:43 EDT 2008 

Okay I might know what it is.  There's no transaction annotation on the
DefaultTicketRegistryCleaner.

Try adding an @Transactional(readOnly = false) to the clean method of the
default cleaner impl.  Its most likely not participating in the session.

I'll open a JIRA issue for this.

-Scott

On Thu, Mar 27, 2008 at 1:19 PM, Robert Oschwald <roos at symentis.com> wrote:

> Scott,
>
> the tickets seem to be returned correctly from the store.
> The Ticket cleaner also detects the expired tickets, but for whatever
> reason, they are not cleaned
> (Sorry, this is a long output).
> I'm missing the hibernate "delete" statements for the two expired
> tickets the cleaner found:
>
>
> 2008-03-27 18:03:30,687 [DefaultQuartzScheduler_Worker-0] [] INFO
> org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner -
> Starting cleaning of expired tickets from ticket registry at [Thu Mar 27
> 18:03:30 CET 2008]
> Hibernate: select ticketgran0_.ID as ID2_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_,
> ticketgran0_.CREATION_TIME as CREATION3_2_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_, ticketgran0_.EXPIRED as
> EXPIRED2_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran0_
> Hibernate: select servicetic0_.ID as ID1_,
> servicetic0_.NUMBER_OF_TIMES_USED as NUMBER2_1_,
> servicetic0_.CREATION_TIME as CREATION3_1_,
> servicetic0_.EXPIRATION_POLICY as EXPIRATION4_1_,
> servicetic0_.LAST_TIME_USED as LAST5_1_,
> servicetic0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_1_,
> servicetic0_.ticketGrantingTicket_ID as ticketG10_1_,
> servicetic0_.FROM_NEW_LOGIN as FROM7_1_,
> servicetic0_.TICKET_ALREADY_GRANTED as TICKET8_1_, servicetic0_.SERVICE
> as SERVICE1_ from SERVICETICKET servicetic0_
> 2008-03-27 18:03:30,789 [DefaultQuartzScheduler_Worker-0] [] INFO
> org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner - 2
> found to be removed.  Removing now.
> Hibernate: select ticketgran0_.ID as ID2_1_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_1_,
> ticketgran0_.CREATION_TIME as CREATION3_2_1_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_1_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_1_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_1_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_1_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_1_, ticketgran0_.EXPIRED as
> EXPIRED2_1_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_1_,
> ticketgran1_.ID as ID2_0_, ticketgran1_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_0_, ticketgran1_.CREATION_TIME as CREATION3_2_0_,
> ticketgran1_.EXPIRATION_POLICY as EXPIRATION4_2_0_,
> ticketgran1_.LAST_TIME_USED as LAST5_2_0_,
> ticketgran1_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_0_,
> ticketgran1_.ticketGrantingTicket_ID as ticketG10_2_0_,
> ticketgran1_.AUTHENTICATION as AUTHENTI7_2_0_, ticketgran1_.EXPIRED as
> EXPIRED2_0_, ticketgran1_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_0_
> from TICKETGRANTINGTICKET ticketgran0_ left outer join
> TICKETGRANTINGTICKET ticketgran1_ on
> ticketgran0_.ticketGrantingTicket_ID=ticketgran1_.ID where
> ticketgran0_.ID=?
> Hibernate: select ticketgran0_.ID as ID2_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_,
> ticketgran0_.CREATION_TIME as CREATION3_2_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_, ticketgran0_.EXPIRED as
> EXPIRED2_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran0_ where
> ticketgran0_.ticketGrantingTicket_ID=?
> Hibernate: select ticketgran0_.ID as ID2_1_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_1_,
> ticketgran0_.CREATION_TIME as CREATION3_2_1_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_1_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_1_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_1_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_1_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_1_, ticketgran0_.EXPIRED as
> EXPIRED2_1_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_1_,
> ticketgran1_.ID as ID2_0_, ticketgran1_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_0_, ticketgran1_.CREATION_TIME as CREATION3_2_0_,
> ticketgran1_.EXPIRATION_POLICY as EXPIRATION4_2_0_,
> ticketgran1_.LAST_TIME_USED as LAST5_2_0_,
> ticketgran1_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_0_,
> ticketgran1_.ticketGrantingTicket_ID as ticketG10_2_0_,
> ticketgran1_.AUTHENTICATION as AUTHENTI7_2_0_, ticketgran1_.EXPIRED as
> EXPIRED2_0_, ticketgran1_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_0_
> from TICKETGRANTINGTICKET ticketgran0_ left outer join
> TICKETGRANTINGTICKET ticketgran1_ on
> ticketgran0_.ticketGrantingTicket_ID=ticketgran1_.ID where
> ticketgran0_.ID=?
> Hibernate: select servicetic0_.ID as ID1_,
> servicetic0_.NUMBER_OF_TIMES_USED as NUMBER2_1_,
> servicetic0_.CREATION_TIME as CREATION3_1_,
> servicetic0_.EXPIRATION_POLICY as EXPIRATION4_1_,
> servicetic0_.LAST_TIME_USED as LAST5_1_,
> servicetic0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_1_,
> servicetic0_.ticketGrantingTicket_ID as ticketG10_1_,
> servicetic0_.FROM_NEW_LOGIN as FROM7_1_,
> servicetic0_.TICKET_ALREADY_GRANTED as TICKET8_1_, servicetic0_.SERVICE
> as SERVICE1_ from SERVICETICKET servicetic0_ where
> servicetic0_.ticketGrantingTicket_ID=?
> Hibernate: select ticketgran0_.ID as ID2_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_,
> ticketgran0_.CREATION_TIME as CREATION3_2_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_, ticketgran0_.EXPIRED as
> EXPIRED2_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran0_ where
> ticketgran0_.ticketGrantingTicket_ID=?
> Hibernate: select servicetic0_.ID as ID1_,
> servicetic0_.NUMBER_OF_TIMES_USED as NUMBER2_1_,
> servicetic0_.CREATION_TIME as CREATION3_1_,
> servicetic0_.EXPIRATION_POLICY as EXPIRATION4_1_,
> servicetic0_.LAST_TIME_USED as LAST5_1_,
> servicetic0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_1_,
> servicetic0_.ticketGrantingTicket_ID as ticketG10_1_,
> servicetic0_.FROM_NEW_LOGIN as FROM7_1_,
> servicetic0_.TICKET_ALREADY_GRANTED as TICKET8_1_, servicetic0_.SERVICE
> as SERVICE1_ from SERVICETICKET servicetic0_ where
> servicetic0_.ticketGrantingTicket_ID=?
> Hibernate: select ticketgran_.ID, ticketgran_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_, ticketgran_.CREATION_TIME as CREATION3_2_,
> ticketgran_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran_.LAST_TIME_USED as LAST5_2_,
> ticketgran_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran_.AUTHENTICATION as AUTHENTI7_2_, ticketgran_.EXPIRED as
> EXPIRED2_, ticketgran_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran_ where ticketgran_.ID=?
> Hibernate: select ticketgran_.ID, ticketgran_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_, ticketgran_.CREATION_TIME as CREATION3_2_,
> ticketgran_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran_.LAST_TIME_USED as LAST5_2_,
> ticketgran_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran_.AUTHENTICATION as AUTHENTI7_2_, ticketgran_.EXPIRED as
> EXPIRED2_, ticketgran_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran_ where ticketgran_.ID=?
> Hibernate: select ticketgran0_.ID as ID2_1_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_1_,
> ticketgran0_.CREATION_TIME as CREATION3_2_1_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_1_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_1_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_1_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_1_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_1_, ticketgran0_.EXPIRED as
> EXPIRED2_1_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_1_,
> ticketgran1_.ID as ID2_0_, ticketgran1_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_0_, ticketgran1_.CREATION_TIME as CREATION3_2_0_,
> ticketgran1_.EXPIRATION_POLICY as EXPIRATION4_2_0_,
> ticketgran1_.LAST_TIME_USED as LAST5_2_0_,
> ticketgran1_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_0_,
> ticketgran1_.ticketGrantingTicket_ID as ticketG10_2_0_,
> ticketgran1_.AUTHENTICATION as AUTHENTI7_2_0_, ticketgran1_.EXPIRED as
> EXPIRED2_0_, ticketgran1_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_0_
> from TICKETGRANTINGTICKET ticketgran0_ left outer join
> TICKETGRANTINGTICKET ticketgran1_ on
> ticketgran0_.ticketGrantingTicket_ID=ticketgran1_.ID where
> ticketgran0_.ID=?
> Hibernate: select ticketgran0_.ID as ID2_,
> ticketgran0_.NUMBER_OF_TIMES_USED as NUMBER2_2_,
> ticketgran0_.CREATION_TIME as CREATION3_2_,
> ticketgran0_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran0_.LAST_TIME_USED as LAST5_2_,
> ticketgran0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran0_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran0_.AUTHENTICATION as AUTHENTI7_2_, ticketgran0_.EXPIRED as
> EXPIRED2_, ticketgran0_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran0_ where
> ticketgran0_.ticketGrantingTicket_ID=?
> Hibernate: select servicetic0_.ID as ID1_,
> servicetic0_.NUMBER_OF_TIMES_USED as NUMBER2_1_,
> servicetic0_.CREATION_TIME as CREATION3_1_,
> servicetic0_.EXPIRATION_POLICY as EXPIRATION4_1_,
> servicetic0_.LAST_TIME_USED as LAST5_1_,
> servicetic0_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_1_,
> servicetic0_.ticketGrantingTicket_ID as ticketG10_1_,
> servicetic0_.FROM_NEW_LOGIN as FROM7_1_,
> servicetic0_.TICKET_ALREADY_GRANTED as TICKET8_1_, servicetic0_.SERVICE
> as SERVICE1_ from SERVICETICKET servicetic0_ where
> servicetic0_.ticketGrantingTicket_ID=?
> Hibernate: select ticketgran_.ID, ticketgran_.NUMBER_OF_TIMES_USED as
> NUMBER2_2_, ticketgran_.CREATION_TIME as CREATION3_2_,
> ticketgran_.EXPIRATION_POLICY as EXPIRATION4_2_,
> ticketgran_.LAST_TIME_USED as LAST5_2_,
> ticketgran_.PREVIOUS_LAST_TIME_USED as PREVIOUS6_2_,
> ticketgran_.ticketGrantingTicket_ID as ticketG10_2_,
> ticketgran_.AUTHENTICATION as AUTHENTI7_2_, ticketgran_.EXPIRED as
> EXPIRED2_, ticketgran_.SERVICES_GRANTED_ACCESS_TO as SERVICES9_2_ from
> TICKETGRANTINGTICKET ticketgran_ where ticketgran_.ID=?
> 2008-03-27 18:03:30,948 [DefaultQuartzScheduler_Worker-0] [] INFO
> org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleaner -
> Finished cleaning of expired tickets from ticket registry at [Thu Mar 27
> 18:03:30 CET 2008]
>
> I set the sessionExpirationPolicy and the rememberMeExpirationPolicy to
> 7200 Milliseconds for this test.
>
> Here is my JPA config. I use the same dataSource as for the
> ServiceRegistry.
> Note that I use the MySQLInnoDBDialect, other settings are pretty much
> the default.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <beans xmlns="http://www.springframework.org/schema/beans"
>        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>        xmlns:p="http://www.springframework.org/schema/p"
>         xmlns:tx="http://www.springframework.org/schema/tx"
>         xsi:schemaLocation="http://www.springframework.org/schema/beans
> http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
>         http://www.springframework.org/schema/tx
> http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">
>
>        <!-- Ticket Registry -->
>        <bean id="ticketRegistry"
> class="org.jasig.cas.ticket.registry.JpaTicketRegistry">
>                <constructor-arg index="0" ref="entityManagerFactory" />
>        </bean>
>
>        <bean id="entityManagerFactory"
> class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBea
> n">
>                <property name="dataSource"
> ref="serviceRegistryDataSource"/>
>                <property name="jpaVendorAdapter">
>                        <bean
> class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
>                                <property name="generateDdl"
> value="true"/>
>                                <property name="showSql" value="true" />
>                        </bean>
>                </property>
>                <property name="jpaProperties">
>                        <props>
>                                <prop
> key="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</prop>
>                                <prop
> key="hibernate.hbm2ddl.auto">update</prop>
>                        </props>
>                </property>
>        </bean>
>
>        <bean id="transactionManager"
> class="org.springframework.orm.jpa.JpaTransactionManager"
>                p:entityManagerFactory-ref="entityManagerFactory" />
>
>        <tx:annotation-driven transaction-manager="transactionManager"/>
>
>        <!--Quartz -->
>        <bean id="ticketRegistryCleaner"
> class="org.jasig.cas.ticket.registry.support.DefaultTicketRegistryCleane
> r"
>                p:ticketRegistry-ref="ticketRegistry" />
>
>        <bean id="jobDetailTicketRegistryCleaner"
> class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFact
> oryBean"
>                p:targetObject-ref="ticketRegistryCleaner"
>                p:targetMethod="clean" />
>
>        <bean id="triggerJobDetailTicketRegistryCleaner"
> class="org.springframework.scheduling.quartz.SimpleTriggerBean"
>                p:jobDetail-ref="jobDetailTicketRegistryCleaner"
>                p:startDelay="20000"
>                p:repeatInterval="5000000" />
>
>        <bean id="scheduler"
> class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
>                <property name="triggers">
>                        <list>
>                                <ref
> local="triggerJobDetailTicketRegistryCleaner" />
>                        </list>
>                </property>
>        </bean>
> </beans>
>
> >Can you run it through Eclipse using the remote debug support with
> Tomcat.
> >Then set a break point in the grant service ticket method of the
> >CentralAuthenticationServiceImpl for after the TGT is retrieved and
> view the
> >TGT returned just to make sure the storage to the database isn't
> screwing up
> >any of the values.
>
> -Scott
>
>
> _______________________________________________
> Yale CAS mailing list
> cas at tp.its.yale.edu
> http://tp.its.yale.edu/mailman/listinfo/cas
>



-- 
-Scott Battaglia
PGP Public Key Id: 0x383733AA
LinkedIn: http://www.linkedin.com/in/scottbattaglia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://tp.its.yale.edu/pipermail/cas/attachments/20080327/e4ae7b58/attachment.html

More information about the cas mailing list