I have some trouble with CAS 5.3.2 with Postgres.(Large Object)

[SangHyun Kim]

Hi, I have used CAS 5.3.2 with Postgres and JPA.

I have some trouble with LargeObject in Postgres.

When the user login through the CAS, CAS creates TGT.

At that time, object values in ticketgrantingticket table are saved in pg_largeobject in Postgres.

It is not a problem.

But, sometimes something strange happens. 

Data that is big in size are saved in largeobject. So they occupied a lot of capacity.

So I encode the data.

19951203;1;"bvGEQGZyLsnVGbkXqob1PE3Zt\000*AT-198120--2H49jUaoQhxN5MGLf-KjPN6nqoccwP2t\000(AT-8175-XUfw7fKWjRvHE3ipmyPQCLna-ocShKbXt\000)AT-13125-9ztOCQgNZitmDXzU6NyZdFvztWQUE7FHt\000*AT-195068-j7zV5l75HydWzf-AOD-BrFLYDCUbBlFbt\000(AT-1448-5oBG2gSe8F-8WC9hPSRfXe2txoBSQ (...)"

19951203;2;"6M6ricZw95dp49yg1UBs9NByb1NRaBbKt\000*AT-194961-7Ljmsq-UPi4SZn-hd97I26xQf3QAATvMt\000*AT-193837-Gh5rHSYDtwLJS8g6sk8k2t6MltJhlfnFt\000(AT-7017-bX9HBejWZYSp7dx6nVmjxhCynCldgtP-t\000*AT-198327-ajG9ltHCNcDYQhAoZG0g9wvbOM60-9Zct\000(AT-2158-SSsygSvgAtrAILezqn6f (...)"

19951203;3;"T-196281-RCKYtzM3wIK1igOr8SkK9XtEJfI4Okvjt\000)AT-12046-djXPJTLr7kNjmDXcRau3bCiTg2idJFm1t\000(AT-5223-W32Ws-OudqiafxC32dB9inOh7tqtHtBpt\000(AT-9463-gwbc0X1u5MVRvPAReJtzgYHHz-WIXrfCt\000*AT-199470-2kqBdR5S1AU2S6Mqw-y4-O1rhwk-xaL5t\000)AT-12803-e4YuoqhVaRAHY (...)"

19951203;4;"iRvKq6nVt\000(AT-8717-3svmYPuIyKWz0v-fnqDp-2jdnq-TpDsct\000)AT-13291-jOG-heaqIh-xW-ThjVnkE4fNG62AW8Bwt\000*AT-196107-fkcMc4ggTpwD1x99te2wzqizplw8VP79t\000(AT-7186-QO7Xu7GdDiqM-wooprmLq6pj-NgBg3BOt\000*AT-197986-DYFN4acu6exYZzLvFVAlZzbU2xLVzmJJt\000*AT-1979 (...)"

19951203;5;"IamdV-YmApe3t\000)AT-14475-6WMBvxnO-fygpeZmxKty8Kf97veMqvESt\000(AT-6533-iHTKGjiluSGVq879kJWZyIuXaEaX0KlWt\000*AT-194251-KiQR9lhIkd5t63IBHuQFho5U6iEUaNRXt\000*AT-196450-akaP4uVUoLR83Wv4zh1cVSplaOVLD2VDt\000)AT-15310-S2H-vrpFS49LnBfMBHQjSJSAeJ5D0-MPt\000(AT (...)"

.....

It seems to Access Tokens.

Many access token data are connected in one loid.

And the TGT related to these AT has many  number_of_times_used counts. 

Why did this happen?

Thank you...