Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Re: [JIRA] (GRP-1633) make creation of include/exclude group structure by loader jobs transactional

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: [JIRA] (GRP-1633) make creation of include/exclude group structure by loader jobs transactional


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Scott Koranda <>, "" <>, grouper-users <>
  • Subject: [grouper-users] Re: [JIRA] (GRP-1633) make creation of include/exclude group structure by loader jobs transactional
  • Date: Wed, 29 Nov 2017 16:55:18 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:EmRfihF5Nh/S5Hmf4z9ET51GYnF86YWxBRYc798ds5kLTJ76p8u6bnLW6fgltlLVR4KTs6sC0LuG9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQtFiT6+bL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYj9qEcBohalHwagGP/jxyVUinPq3aA31fkqHwHc3AwnGtIDqHrYotf1NaYTT++11rHExijdYvNWwzf96ZPIfh48qvyLWLJ/bcrRyEkuFgzblFWdso3lPyiJ2egXrmib9/RvVeSpi2I9tQ5+vyWvy94qh4LUiIwVzVXE+j94wIYzPdC4SUh7YcK6H5tKsSGVKZd2Tt04T252pSk616UKuZ+9fCgW1psn3RjfZOKbc4SW+B7vTvieLiplhH9jZbmxhA6y/FC+xuLmSsW4zVNHojdYntXRs30N2RPe5tSbRvZ4/EquxzmC2x7W5+xBP0w4ibTXJ4Y8zrM+ipYfq0DOEjLslEnokaObcl8o9vWq5unmZLjtu4WSOJVuig7kN6Qjgsy/Dvo8MggJR2WV4fix2rr/8UHkWblHk/85nrfAvJDdPssUuLS1AwhI0oY/8Bm/CCqm0NIFknUdNFJFYhWHj5T3NF7SPPD4DPC/g1K2nDds2vDGIrnhApLKLnjAirvuYbF960tExAoyy9BQ+Y5UB6kfLP3pRkP9qdnVAgIkPwCpxuvnBtpw2p8CVW+KAKKWLqzfvUGN6+8qPeWAeJEZtC74K/c/5v7uiXE5mUUafamsxZYXbWy3HvRmIkSYf3XsmMwMEWYRvgUiVuDqlUWCXiBVZ3a0Ra4z+Cw0CJ++AYfZWo+tmKCB3Du8HpBOaWBGEFeMEWrwd4qaQfcAcT+SItR/nTweTrisUIsh1RC1tA/m0LprMPDY+iwetZL/ytd1/evTmg8u9TBqFciSzXyCT3wn1l8PEgQ927xj6W960F6F3aEw1+dbEsZa4f9AehwiNZPGzudzD9v1RQ3becqRDl2hR4PiSXsqTtM1ztkmb1t+FpOvgg2Jl36xA74RmrqjCIE3/+TR02WnY45y0XHbzKQ7ykQ9T9FUfTmpnKli7wXJQpPSnl+Cv6esaakG2iPRriGOwXfY729CVwslG4XUT30FIgP9rc74/QmKG7qlCaU1PxFpyNWJbLZSZ9vvy1hKWaGwa5zlf2utljLoVl6zzbSWYd+vIj1F0Q==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

https://bugs.internet2.edu/jira/browse/GRP-1633


This is fixed in patch: 2.3.0 api #87


Defaults to have include/exclude happen in a transaction (can disable if you like), and defaults to not fix include/exclude by loader (afraid this might negatively affect people who edit include/exclude after creation and expects it not to be changed.  Plus, with transactions, should be good now.

include/exclude (loader or not) will run in transactions now, to use previous nontransactional behavior, set this to false in grouper.properties

# if should use transaction in include/exclude
grouperIncludeExcludeUseTransaction = true

to make the loader fix include/excludes, change this in grouper-loader.properties (by default it does not do this)

# fix include excludes on each run
loader.fixIncludeExcludes = false

Try it out and let me know how it goes.

Thanks
Chris


From: Scott Koranda <> on behalf of Scott Koranda <>
Sent: Friday, November 24, 2017 9:13 AM
To: Hyzer, Chris;
Subject: Fwd: [JIRA] (GRP-1633) make creation of include/exclude group structure by loader jobs transactional
 
Hi,

I think we talked about this issue informally, but there was not a JIRA
ticket to track it. So I created one.

Please let me know if the RFE is not clear or if I am incorrect and a
ticket already exists (I searched but could not find one).

Thanks,

Scott

P.S. Despite my JIRA account being tied to the email address
'', this is NOT a LIGO issue. I have another
client (a university) making this request.

This is the same deployment that is restarting the Grouper loader once
every day, and the restart causes the incomplete include/exclude group
structure now and then.

----- Forwarded message from "Scott Koranda (JIRA)" <> -----

Date: Fri, 24 Nov 2017 14:10:01 +0000 (UTC)
From: "Scott Koranda (JIRA)" <>
To:
Subject: [JIRA] (GRP-1633) make creation of include/exclude group structure by
        loader jobs transactional

Scott Koranda created GRP-1633:
----------------------------------

             Summary: make creation of include/exclude group structure by loader jobs transactional
                 Key: GRP-1633
                 URL: https://bugs.internet2.edu/jira/browse/GRP-1633
             Project: Grouper
          Issue Type: Improvement
      Security Level: Standard (Standard bug, may impact functionality but does not represent a security vulnerability)
          Components: grouperLoader
    Affects Versions: 2.3.0
            Reporter: Scott Koranda
            Assignee: Chris Hyzer
            Priority: Major


A grouper loader job may be configured to create the includes/excludes group structure. For example 

students_systemOfRecord
students includes
students excludes
students system of record and includes
students

The creation of the groups, however, is not transactional. If the loader process is killed or dies while the groups are being created the group structure can be incomplete with one or more of the groups missing. When the loader is restarted and that job run again the incomplete group structure is not detected and healed, but at the same time the creation of the group structure is skipped going forward, particularly if the creation of the SOR group did complete.

This is an RFE so that the creation of the group structure is transactional–the creation of the group structure should succeed completely or fail completely. Further, when the loader job next runs the creation of the group structure should be tried again if it did not succeed previously.



--
This message was sent by Atlassian JIRA
(v7.5.2#75007)

----- End forwarded message -----


  • [grouper-users] Re: [JIRA] (GRP-1633) make creation of include/exclude group structure by loader jobs transactional, Hyzer, Chris, 11/29/2017

Archive powered by MHonArc 2.6.19.

Top of Page