Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-4798

error creating stem on fk_grouper_st_v_pr_st

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • None
    • None
    • None

    Description

      Exception in thread "main" java.lang.RuntimeException: sql: insert into grouper_stem_view_privilege (member_uuid, stem_uuid, object_type) values (?, ?, 'S'), args: ArrayList size: 2: [0]: 04960af703974feabce09f959e344106
      [1]: 09ff118ec1734624b6c40b1a904c3521
      ,
      Problem creating child stem: Stem[displayName=penn:seas:test:apps:aws:provisioning,name=penn:seas:test:apps:aws:provisioning,uuid=cb458dcfe5714c519bf2b2e395a157c6,creator=c602a577-6346-4937-802d-22a0aff529c1,modifier=c602a577-6346-4937-802d-22a0aff529c1], extn: test4, dExtn: test4, uuid: null, sql: insert into grouper_stem_view_privilege (member_uuid, stem_uuid, object_type) values (?, ?, 'S'), args: ArrayList size: 2: [0]: 04960af703974feabce09f959e344106
      [1]: 09ff118ec1734624b6c40b1a904c3521
      ,
      Problem in HibernateSession: HibernateSession (48971262): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (77136cf3),
      Problem in HibernateSession: HibernateSession (76ac3ad0): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (77136cf3)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2361)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeSql(GcDbAccess.java:2390)
      	at edu.internet2.middleware.grouper.stem.StemViewPrivilege.addStemPrivilegeIfNeeded(StemViewPrivilege.java:435)
      	at edu.internet2.middleware.grouper.Stem.internal_grantPriv(Stem.java:1553)
      	at edu.internet2.middleware.grouper.Stem.grantPriv(Stem.java:1467)
      	at edu.internet2.middleware.grouper.rules.RuleThenEnum$11.fireRule(RuleThenEnum.java:887)
      	at edu.internet2.middleware.grouper.rules.RuleThen.fireRule(RuleThen.java:241)
      	at edu.internet2.middleware.grouper.rules.RuleEngine$2.callback(RuleEngine.java:471)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
      	at edu.internet2.middleware.grouper.rules.RuleEngine.fireRule(RuleEngine.java:453)
      	at edu.internet2.middleware.grouper.Stem$9.callback(Stem.java:2919)
      	at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:722)
      	at edu.internet2.middleware.grouper.Stem.internal_addChildStem(Stem.java:2866)
      	at edu.internet2.middleware.grouper.Stem.addChildStem(Stem.java:619)
      	at edu.internet2.middleware.grouper.StemSave$1$1.callback(StemSave.java:507)
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1000)
      	at edu.internet2.middleware.grouper.StemSave$1.callback(StemSave.java:604)
      	at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)
      	at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:722)
      	at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)
      	at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)
      	at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)
      	at edu.internet2.middleware.grouper.StemSave.save(StemSave.java:375)
      	at Test50gsh.main(Test50gsh.java:8)
      Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "grouper_stem_view_privilege" violates foreign key constraint "fk_grouper_st_v_pr_st"
        Detail: Key (stem_uuid)=(09ff118ec1734624b6c40b1a904c3521) is not present in table "grouper_stems".
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
      	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496)
      	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413)
      	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
      	at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:152)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:462)
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2350)
      	... 23 more
       
       

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: