Grouper Users - Open Discussion List

[Francesco Malvezzi <>]

hi everybody,

our grouper stores data on Oracle.

It looks sometimes the DNS has a failure and it has to drop connection 
to DB. When DNS is working again, grouper logs are full of these lines:

grouper-daemon;grouper_error.log;2023-02-07T06:18:13,440: [Thread-27] 
ERROR Grou
perLogger.error(77) - [] - Error in cache database thread
java.lang.RuntimeException: java.sql.SQLRecoverableException: Closed 
Connection,
sql: select nanos_since_1970 from grouper_cache_overall where 
overall_cache = 0,

        at 
edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResult
Set(GcDbAccess.java:2362) ~[grouperClient-2.6.19.jar:2.6.19]
        at 
edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcD
bAccess.java:1759) ~[grouperClient-2.6.19.jar:2.6.19]
        at 
edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcD
bAccess.java:1633) ~[grouperClient-2.6.19.jar:2.6.19]
        at 
edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.select(GcDbAcc
ess.java:1583) ~[grouperClient-2.6.19.jar:2.6.19]
        at 
edu.internet2.middleware.grouper.cache.GrouperCacheDatabase.retrieveI
ncremental(GrouperCacheDatabase.java:488) ~[grouper-2.6.19.jar:2.6.19]
        at 
edu.internet2.middleware.grouper.cache.GrouperCacheDatabase$1.run(Gro
uperCacheDatabase.java:383) [grouper-2.6.19.jar:2.6.19]
        at java.lang.Thread.run(Thread.java:750) [?:1.8.0_352]
Caused by: java.sql.SQLRecoverableException: Closed Connection,
sql: select nanos_since_1970 from grouper_cache_overall where 
overall_cache = 0,

        at 
oracle.jdbc.driver.PhysicalConnection.prepareStatementInternal(Physic
alConnection.java:1812) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
        at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnec
tion.java:1763) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
        at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnec
tion.java:1755) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
        at 
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnec
tion.java:1663) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]
        at 
com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxy
Connection.java:387) ~[c3p0-0.9.5.4.jar:0.9.5.4]
        at 
edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResult
Set(GcDbAccess.java:2307) ~[grouperClient-2.6.19.jar:2.6.19]
        ... 6 more

till service is restarted.

ui and ws work just fine even if their logs are full of these messages.

The problem is the PIT is not updated and consumer services that expect 
to be informed of group changes miss this information.

I suspect it is something in cache config that it is just plain default 
(grouper.cache.properties override fine is empty).

Can you please nudge me toward the missing piece of documentation I am 
needing?

thank you,

Francesco