error creating stems

Paul Rubenis
3:28 PM
Currently, we have having issues like this:
022-09-13T13:39:13,649: [ajp-nio-127.0.0.1-8009-exec-2] WARN UiV2Stem.newStemSubmit(2661) - [] - Error creating stem: '3ccjuu5ub'/'person'/'umnldap', null
java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (GROUPER.FK_GROUPER_ST_V_PR_ST) violated - parent key not found
,
sql: insert into grouper_stem_view_privilege (member_uuid, stem_uuid, object_type) values (?, ?, 'S'), args: ArrayList size: 2: [0]: 639a7be1ac8546efafc097c7d91c81e1
[1]: 7f7b0909fff54817a2823d255891b44c
,
Problem creating child stem: Stem[displayName=test,name=test,uuid=90eac48c6ef84254afc7892e472abf4b,creator=cb73815c737d46f2b58f5202597f8153], extn: paulr_foobar, dExtn: paulr_foobar, uuid: null, java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (GROUPER.FK_GROUPER_ST_V_PR_ST) violated - parent key not found
,
sql: insert into grouper_stem_view_privilege (member_uuid, stem_uuid, object_type) values (?, ?, 'S'), args: ArrayList size: 2: [0]: 639a7be1ac8546efafc097c7d91c81e1
[1]: 7f7b0909fff54817a2823d255891b44c
,
Problem in HibernateSession: HibernateSession (182d3ee6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (65c8c1ae),
Exception rolling back in exception catch: org.hibernate.TransactionException: Unable to rollback against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:120)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:250)
at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:89)
at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:559)
at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:710)
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)
3:30
We try to create a new subfolder and it fails with the above after a long timeout...or sometimes simply stops spinning and no error is displayed in the UI...just the same 'New Folder' creation view...