Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Cache reconnection config

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Cache reconnection config

Chronological Thread 
  • From: Francesco Malvezzi <>
  • To:
  • Cc:
  • Subject: Re: [grouper-users] Cache reconnection config
  • Date: Tue, 7 Feb 2023 18:15:11 +0100

On 07/02/23 17:19, Bruce Timberlake wrote:
On Tue, Feb 7, 2023 at 5:13 AM Francesco Malvezzi <
> wrote:

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]
perLogger.error(77) - [] - Error in cache database thread
java.lang.RuntimeException: java.sql.SQLRecoverableException: Closed
sql: select nanos_since_1970 from grouper_cache_overall where
overall_cache = 0,

We have had this issue ourselves since we deployed Grouper. The standard
answer we have received has been "just restart the container" but it'd be
nice to get a source of the problem identified TBH. We've poked at some
settings, but nothing obvious has revealed itself to us so far. So for
now, we have a Splunk alert for the error and the on-call person who gets
the notification does a 'docker restart grouper-daemon' on the affected
server(s) and moves on with life :)

a suboptimal solution is better than no solution! Thank you so much for your pragmatic input that saves me so many pointless researches,


Archive powered by MHonArc 2.6.24.

Top of Page