Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Docs for how to remove a change log consumer ?

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Docs for how to remove a change log consumer ?


Chronological Thread 
  • From: "Black, Carey M." <>
  • To: "" <>
  • Subject: [grouper-users] Docs for how to remove a change log consumer ?
  • Date: Wed, 30 Jan 2019 19:21:17 +0000
  • Accept-language: en-US
  • Authentication-results: spf=pass (sender IP is 128.146.138.10) smtp.mailfrom=osu.edu; internet2.edu; dkim=pass (signature was verified) header.d=osu.edu;internet2.edu; dmarc=pass action=none header.from=osu.edu;
  • Authentication-results-original: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:oOGUmxMH8Q9EmW1A36sl6mtUPXoX/o7sNwtQ0KIMzox0I/74rarrMEGX3/hxlliBBdydt6oUzbKO+4nbGkU4qa6bt34DdJEeHzQksu4x2zIaPcieFEfgJ+TrZSFpVO5LVVti4m3peRMNQJW2aFLduGC94iAPERvjKwV1Ov71GonPhMiryuy+4ZLebxlLiTanfb9+MAi9oBnMuMURnYZsMLs6xAHTontPdeRWxGdoKkyWkh3h+Mq+/4Nt/jpJtf45+MFOTav1f6IjTbxFFzsmKHw65NfqtRbYUwSC4GYXX3gMnRpJBwjF6wz6Xov0vyDnuOdxxDWWMMvrRr0yRD+s7bpkSAXwhSkHKTA37X3XhMJzgqJavB2vqBNwzpXIYIGMKPZyYr/Rcc8ESWdHQ81fVzZBAoS5b4YXAeYMIOJYoJPhqFsNtRe1GBehC/n1yjBWhn79wKo03/4vHQrb2wEvBNYOv27Io9X2LqseTP65wafTwDXEdPNWxC3x55bVfRA8uPyBW697f8nJyUQ3CQ/KlEmcpZHgMj+Iy+gBrm2W7+RvWO6zl2Iqrg9xrSagy8ojj4TEg4AYxk3Y+ilh3oo4Kse0RFBnbdOnCpdcqT+WOoVsTs8/QWxluz42yrMYtpO4YCQHzZEqywDcZvCacoWF5w/vWPiNLTtkgX9pZa6ziA22/EWly+DwS9S730hMoyFYiNfDrGoN2AbW6sWfSvty4EOh2TGX2g7L9uxKJlw4mbTCJ5A82rA8i4MfsUPYESDogkn2i7KWdlk/9eiv9uTnZKjpqoWEN49ujQH+LrohldCjAeQ5NQgOWXKX+eOh1L3/+U35R7JKjv4snqbFt5DaINwXpq+/AwBLzoYu8wizAC263NgFmHQLMU9JdA+CgojnNFzCPOz0APKxg1uynzpmyPXLM7jjD5nQMnfPiLLhcqx8605Yxgoz19df55dMB74aJPL8QFP+tN/CAhMkLQC5zf3qCNJm1oMDQ26AHLKWML7KvV+S+u0vO/WMZJMSuDvlJPgl/fnujWIhmVADZ6mlxIYXaGumEfR8OEWUen7sgtYaEWcWpQoyVu3qiFueUTFNfXayWbwz5i0lBI68E4jMW52t0/S923LxEYdRe3hLEBWRCnrybK2FXesBciSfPpUnnzAZH/D1RJUmyAmjrkrn0Ld9NcLV/DEVr5TuyIIz6uHOw0Ic7ztxWo6312iGTCU8tWoSSi5++eY16Rh3zl6I0u4h2adwEsdOof5FT1FpZtbn0+VmBoWqCUr6ddCTRQP+GI/0CCwtTt83394Falp8HNPnlB3Ywi62GOZEzu6QHJJh6qvHxDCxPMt7x3vcnIgZx1g9CpIVZSv/2vA5rlODQdeR0iD7372vabxa2SfM8GmZym/bu1pFFgN8TPaNXHYDa1HQoMijoE7OUuzmBbcmN15ZwNWZYutRa9LvhElbXvqrJ93FK3y8gWa+BBuEh9buJIrncmkQxmPRXU8fjkYe8WvVNA4iCz2nrn6ESjFiCAGnb0bl6+IrsHqgVQc9xB2LaEs00b2z91YViPWQRulV0KgDvXImsCgyEVqgjN8=

Q1) Are there any docs on what should be done to clean up after a change log
consumer is "decommissioned"?

I recently changed the name of a change log consumer and now I have a
remnants of data in the Grouper DB that has the old name value. (and another
row for a CLC that I stopped using after a proof of concept testing with it.
) Which lead me to the question above.

NOTE: At a minimum, I can see that row(s) are left in:
grouper_change_log_consumer

Q2) Are there any other references that I have not found yet?
Q3) Is it "ok" ( and expected ) to delete rows from
grouper_change_log_consumer table when they are permanently orphaned?
Q4) Is there any way to do this without resorting to SQL? (AKA: A grouper
API call that is the "planned way" to clean this up? Even a manual
method/process to kick off?)
Q5) Are there any Grouper API's around the CLC for things like:
] add/remove/rename
] status ( things like number of events not yet processed, per CLC or
) for a given CLC) )

I know there are ways to force a "run" (via a gsh function:
loaderRunOneJob("CHANGE_LOG_<name_goes_here>"); ) Looking for the "rest of
the story".... :)


Thanks in advance.

--
Carey Matthew





Archive powered by MHonArc 2.6.19.

Top of Page