Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] PIT table issue prevents changelog temp to changelog

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] PIT table issue prevents changelog temp to changelog


Chronological Thread 
  • From: Scott Koranda <>
  • To: Shilen Patel <>
  • Cc: grouper-users <>
  • Subject: Re: [grouper-users] PIT table issue prevents changelog temp to changelog
  • Date: Fri, 18 Jan 2019 13:30:38 -0600
  • Ironport-phdr: 9a23:fZ/qGRUDpn4jmcwimR4v6v9oqYnV8LGtZVwlr6E/grcLSJyIuqrYbBOPt8tkgFKBZ4jH8fUM07OQ7/iwHzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba9xIRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KpwVhTmlDkIOCI48GHPi8x/kqRboA66pxdix4LYeZyZOOZicq/Ye94RWGhPUdtLVyFZDI2yb5UBAfcCM+ZWoIbyu0YBoxS8CgaiH+7v1jxFi2Xq0aEmyeksEwfL1xEgEdIUt3TUqc34OroOXuCy0KnI0SjIYfZR2Tfn8ofIdA0uruuRVr93asrRyk4vFxnfgVWWtIPqJSiY1usIs2eB7upgUfijhHIgqwF0uzWiwNonhIfOhoIQ0F/E9CN5zZ46Jd2iT057fMakH4VKty2ALYR2WtsiTmd1syg50r0LoYC3cSkWxJklwhPfZf+KfJOU7h/mW+ucIjZ1iX1gdb6hmxq/9E2txfDyW8S1yFpGszZJn9bWunwT2RHf99KLRuV980qhwzqDyg/e5v1CLEspj6TUMYQhzaQ1lpcLsUTMACv2mELuga+TbEok++yo5/3mYrXhu5OQLoB1hRzwP6kvgMC/DuM4Mg8BX2if5+uwzqHs/Ur8QLlSj/02lLfWsIzCKMgFp6O1Hw1Y34Mt6xu8FDiqzNEVkHYEIV9Edx+KipblN03LLf39EPiyjVWhnC9ux//cP73hBpvNLmLEkLfkZbt98E1cyA0pzd9F4ZJbF6sOLen8Wk/0rtPYDxs5PxaozObgDdVxzpkeVn6XAq+FLKPStkeF5u01I+mLeY8VoCjyK+I86/7zln82h0UdfbKy0JsTaXC4BehmI16HbXb2g9cBF3sKsRQkTOzsllKCTSBfa2ysUK0h+zFoQL6hWLzDR4SghvS51Tu2GtUCfWBHDl2KOXv1dIjCVvsRPnG8OMhkxwcPUqS9A6wmzxiouAayn6FkKfDd/CERnZ3m3dlxoebUkEdhpnRPE82B3jTVHClPlWQSSmpzhfgnrA==

> That method looks for duplicates and tries to delete the newest one (with
> the assumption that the oldest one is more likely to be used). But it’s
> possible that the one it tried to delete has foreign keys instead.
> (Hopefully they both don’t have foreign keys.) Your logs should confirm
> that assumption.
>
> If that’s correct, then query the table:
>
> select * From grouper_pit_members where
> source_id='ca99ceee00b44698b407c8ced5a8bddb' and active='T'
>
> You should find 2 (or maybe more) rows. Delete the one that isn’t
> id=639e1720af7f48c38d1940f63f4d4b7d.
>
> See if that resolves it?

I was able to delete the row.

The error message is now different:

groovy:000> loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");
ERROR java.lang.RuntimeException:
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in
HibernateSession: HibernateSession (259647f2): notNew, notReadonly,
READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITGroupSet,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName:
null, tx type: null,
Exception in save: edu.internet2.middleware.grouper.pit.PITGroupSet,
edu.internet2.middleware.grouper.hibernate.ByObject@53ec379a,
Problem in HibernateSession: HibernateSession (7a7fdc1a): notNew,
notReadonly, READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITGroupSet,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName:
null, tx type: null,
Exception in save: edu.internet2.middleware.grouper.pit.PITMembership,
edu.internet2.middleware.grouper.hibernate.ByObject@5f6dd89c,
Problem in HibernateSession: HibernateSession (609f136b): notNew,
notReadonly, READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate:
edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic, query: ',
cacheable: null, cacheRegion: null, entityName: null, tx type: null,
Problem in HibernateSession: HibernateSession (7a7698f4): new, notReadonly,
READ_WRITE_NEW, notActiveTransaction, session (6ed2aa8a)
at
edu.internet2.middleware.grouper.app.loader.GrouperLoader.runOnceByJobName
(GrouperLoader.java:1625)
at edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob.invoke
(loaderRunOneJob.java:95)
at
edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob$invoke.call (Unknown
Source)
at groovysh_evaluate.loaderRunOneJob (groovysh_evaluate:4)

Thanks,

Scott K



Archive powered by MHonArc 2.6.19.

Top of Page