Grouper Users - Open Discussion List

[Jeff McCullough <>]

I’m starting with grouper 2.4 and starting up a 2.5.62 container. The auto 
ddl upgrade was set. It appears to have connected to the oracle db, completed 
the upgrade, and then appears to have gone south. Any ideas what happened and 
how to remedy? 

Thanks,
Jeff


-----------------
grouper-ws;grouper_error.log;;;2022-09-20 17:55:55,847: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - connecting to 
jdbc:oracle:thin:@dba-oracle-dev-10.ist.berkeley.edu:1521:istrdev
grouper-ws;grouper_error.log;;;2022-09-20 17:55:55,848: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - Loading 
oracle.jdbc.driver.OracleDriver using system loader.
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,022: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - Executing 
resource: 
/opt/grouper/grouperWebapp/WEB-INF/ddlScripts/grouperDdl_20220920_17_55_55_826.sql
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,026: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:  CREATE 
TABLE grouper_ddl_worker ( id VARCHAR2(40) NOT NULL, grouper VARCHAR2(40) NOT 
NULL, worker_uuid VARCHAR2(40) NOT NULL, heartbeat DATE, last_updated DATE 
NOT NULL, PRIMARY KEY (id) )
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,094: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,095: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   CREATE 
UNIQUE INDEX grouper_ddl_worker_grp_idx ON grouper_ddl_worker (grouper)
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,104: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,104: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   COMMENT 
ON TABLE grouper_ddl_worker IS 'JVMs register a uuid so only one JVM does the 
DDL upgrades at a time'
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,109: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,109: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   COMMENT 
ON COLUMN grouper_ddl_worker.grouper IS 'this just holds the word grouper, so 
there is only one row here'
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,111: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,112: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   COMMENT 
ON COLUMN grouper_ddl_worker.worker_uuid IS 'random uuid from a jvm to do 
work on the database'
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,114: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,114: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   COMMENT 
ON COLUMN grouper_ddl_worker.heartbeat IS 'while the ddl is
running, keep a heartbeat updated'
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,116: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,117: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - SQL:   COMMENT 
ON COLUMN grouper_ddl_worker.last_updated IS 'when this reco
rd was last updated'
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,119: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 0 rows affected
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,120: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - Committing 
transaction
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,123: 
[localhost-startStop-1] WARN  GrouperAntProject.log(96) -  - 7 of 7 SQL 
statements executed successfully
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,123: 
[localhost-startStop-1] ERROR 
GrouperDdlUtils.runScriptIfShouldAndPrintOutput(904) -  - Script was executed 
successfully

grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,153: 
[localhost-startStop-1] ERROR GrouperDdlUtils.retrieveDdlsFromCache(1166) -  
- maybe the grouper_ddl table isnt there... if that is the
reason its ok.  info level logging will show underlying reason.Problem in 
HibernateSession: null,
Exception in list: (class 
edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDdl), 
ByCriteriaStatic, persistentClass: 'class 
edu.internet2.middleware.grouper.app.loader.db.Hib3GrouperDd
l', criterions: null', cacheable: null, cacheRegion: null, entityName: null, 
tx type: null
grouper-ws;grouper_error.log;;;2022-09-20 17:55:56,153: 
[localhost-startStop-1] ERROR 
GrouperDdlEngine.updateDdlIfNeededWithStaticSql(749) -  - Grouper ddl object 
type 'Grouper' has dbVersion:
 0 (null) and java version: 37 (2.5.51)