Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Can we discuss this on slack?  Did you get this resolved?

---

From: <> on behalf of Jeff McCullough <>
Sent: Tuesday, September 20, 2022 10:06 PM
To: <>
Subject: [grouper-users] fun with DDL upgrade

 

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)