cleanup_project_ownership_table.R keeps "fixing" the same 15 records

[pbchase]

There is something funny in the data or maybe in the script cleanup_project_ownership_table.R because every time it runs it "fixes" the same 15 records. The first run was fruitful, but subsequent runs should have been completely quiet. This script:

library(tidyverse)
library(lubridate)
library(dotenv)
library(redcapcustodian)
library(rcc.ctsit)
library(DBI)
library(RMariaDB)

load_dot_env("prod.env")

log_conn <- connect_to_log_db(drv=RMariaDB::MariaDB())

dbListTables(log_conn)

job_summaries <- tbl(log_conn, "rcc_job_log") %>%
  arrange(desc(id)) %>%
  filter(script_name == "cleanup_project_ownership_table") %>%
  select(job_summary_data) %>%
  collect() %>%
  pull(job_summary_data)

for (log in job_summaries) {
  print(jsonlite::fromJSON(log))
}

Produces the data below. The most recent run is at the top.

Please figure out why this job does not produce null result on the subsequent runs.

   diff_type      reason priority   pid                             email  firstname    lastname    created    updated
1     update project_pis        1  3160 Ellen.Zimmermann@medicine.ufl.edu      Ellen  Zimmermann 1547491982 1661807696
2     update project_pis        1  3161 Ellen.Zimmermann@medicine.ufl.edu      Ellen  Zimmermann 1547491982 1661807696
3     update project_pis        1  4359                arwood@cop.ufl.edu     Meghan      Arwood 1547491982 1661807696
4     update project_pis        1  4360                arwood@cop.ufl.edu     Meghan      Arwood 1547491982 1661807696
5     update project_pis        1  4492                  modavefp@ufl.edu François       Modave 1661806032 1661807696
6     update project_pis        1  5832        ngravenstein@anest.ufl.edu   Nikolaus Gravenstein 1547491982 1661807696
7     update project_pis        1  5861            melodysaunders@ufl.edu     Melody    Saunders 1623089901 1661807696
8     update project_pis        1  5882   Rosemarie.Fernandez@jax.ufl.edu  Fernandez   Rosemarie 1606260874 1661807696
9     update project_pis        1  9064               barry.byrne@ufl.edu      Barry       Byrne 1598293105 1661807696
10    update project_pis        1 10653               poekert@coe.ufl.edu       Phil     Poekert 1627921679 1661807696
11    update project_pis        1 10658             robert.leeman@ufl.edu     Robert      Leeman 1661806032 1661807696
12    update project_pis        1 10665           agay0003@shands.ufl.edu     Ansley       Gayle 1628175818 1661807696
13    update project_pis        1 10685                  mrajoria@ufl.edu    Melinda     Rajoria 1628706482 1661807696
14    update project_pis        1 10701                   djlemas@ufl.edu   Dominick       Lemas 1628885955 1661807696
15    update project_pis        1 10717                  aprovost@ufl.edu   Adrienne     Provost 1629246093 1661807696
   diff_type      reason priority   pid                             email  firstname    lastname    created    updated
1     update project_pis        1  3160 Ellen.Zimmermann@medicine.ufl.edu      Ellen  Zimmermann 1547491982 1661806566
2     update project_pis        1  3161 Ellen.Zimmermann@medicine.ufl.edu      Ellen  Zimmermann 1547491982 1661806566
3     update project_pis        1  4359                arwood@cop.ufl.edu     Meghan      Arwood 1547491982 1661806566
4     update project_pis        1  4360                arwood@cop.ufl.edu     Meghan      Arwood 1547491982 1661806566
5     update project_pis        1  4492                  modavefp@ufl.edu François       Modave 1661806032 1661806566
6     update project_pis        1  5832        ngravenstein@anest.ufl.edu   Nikolaus Gravenstein 1547491982 1661806566
7     update project_pis        1  5861            melodysaunders@ufl.edu     Melody    Saunders 1623089901 1661806566
8     update project_pis        1  5882   Rosemarie.Fernandez@jax.ufl.edu  Fernandez   Rosemarie 1606260874 1661806566
9     update project_pis        1  9064               barry.byrne@ufl.edu      Barry       Byrne 1598293105 1661806566
10    update project_pis        1 10653               poekert@coe.ufl.edu       Phil     Poekert 1627921679 1661806566
11    update project_pis        1 10658             robert.leeman@ufl.edu     Robert      Leeman 1661806032 1661806566
12    update project_pis        1 10665           agay0003@shands.ufl.edu     Ansley       Gayle 1628175818 1661806566
13    update project_pis        1 10685                  mrajoria@ufl.edu    Melinda     Rajoria 1628706482 1661806566
14    update project_pis        1 10701                   djlemas@ufl.edu   Dominick       Lemas 1628885955 1661806566
15    update project_pis        1 10717                  aprovost@ufl.edu   Adrienne     Provost 1629246093 1661806566
   diff_type                          reason priority   pid                             email  firstname      lastname         username    created    updated
1     update                     project_pis        1  1353    richard.conti@medicine.ufl.edu         CR         Conti                  1547491982 1661806032
2     update                     project_pis        1  1370              ajwoods@phhp.ufl.edu       Adam         Woods                  1547491982 1661806032
3     update                     project_pis        1  1396      Carl.Pepine@medicine.ufl.edu       Carl        Pepine                  1547491982 1661806032
4     update                     project_pis        1  3140                  jplagmay@ufl.edu     JOANNE        LAGMAY                  1547491982 1661806032
5     update                     project_pis        1  3160 Ellen.Zimmermann@medicine.ufl.edu      Ellen    Zimmermann             <NA> 1547491982 1661806032
6     update                     project_pis        1  3161 Ellen.Zimmermann@medicine.ufl.edu      Ellen    Zimmermann             <NA> 1547491982 1661806032
7     update                     project_pis        1  3211 Ellen.Zimmermann@medicine.ufl.edu      Ellen    Zimmermann                  1547491982 1661806032
8     update                     project_pis        1  4359                arwood@cop.ufl.edu     Meghan        Arwood             <NA> 1547491982 1661806032
9     update                     project_pis        1  4360                arwood@cop.ufl.edu     Meghan        Arwood             <NA> 1547491982 1661806032
10    update                     project_pis        1  4361                arwood@cop.ufl.edu     Meghan        Arwood                  1547491982 1661806032
11    update                     project_pis        1  4397     jeffrey.goldhagen@jax.ufl.edu    Jeffrey     Goldhagen                  1547491982 1661806032
12    update                     project_pis        1  4400                      ryi1@ufl.edu    Richard            Yi                  1547491982 1661806032
13    update                     project_pis        1  4401                      ryi1@ufl.edu    Richard            Yi                  1547491982 1661806032
14    update                     project_pis        1  4411     james.wymer@neurology.ufl.edu      James         Wymer                  1547491982 1661806032
15    update                     project_pis        1  4471                     asdf@asdf.com       asdf          asdf                  1547491982 1661806032
16    update                     project_pis        1  4493        ngravenstein@anest.ufl.edu   Nikolaus   Gravenstein                  1547491982 1661806032
17    update                     project_pis        1  4525            mabuhasan@peds.ufl.edu    Mutasim     Abu-Hasan                  1623089901 1661806032
18    update                     project_pis        1  5832        ngravenstein@anest.ufl.edu   Nikolaus   Gravenstein             <NA> 1547491982 1661806032
19    update                     project_pis        1  5861            melodysaunders@ufl.edu     Melody      Saunders             <NA> 1623089901 1661806032
20    update                     project_pis        1  5882   Rosemarie.Fernandez@jax.ufl.edu  Fernandez     Rosemarie             <NA> 1606260874 1661806032
21    update                     project_pis        1  7336       karthik.tanneru@jax.ufl.edu    Karthik       Tanneru                  1566689648 1661806032
22    update                     project_pis        1  9064               barry.byrne@ufl.edu      Barry         Byrne             <NA> 1598293105 1661806032
23    update                     project_pis        1  9072            ddchristou@hhp.ufl.edu    Demetra      Christou                  1598448590 1661806032
24    update                     project_pis        1 10653               poekert@coe.ufl.edu       Phil       Poekert             <NA> 1627921679 1661806032
25    update                     project_pis        1 10665           agay0003@shands.ufl.edu     Ansley         Gayle             <NA> 1628175818 1661806032
26    update                     project_pis        1 10685                  mrajoria@ufl.edu    Melinda       Rajoria             <NA> 1628706482 1661806032
27    update                     project_pis        1 10686               bratsch@coe.ufl.edu       Mary Bratsch-Hines                  1628732847 1661806032
28    update                     project_pis        1 10694   Bhavana.Patel@neurology.ufl.edu    Bhavana         Patel                  1628795273 1661806032
29    update                     project_pis        1 10697               amanley@coe.ufl.edu    Corinne        Manley                  1628874190 1661806032
30    update                     project_pis        1 10701                   djlemas@ufl.edu   Dominick         Lemas             <NA> 1628885955 1661806032
31    update                     project_pis        1 10706           haley.lewis@jax.ufl.edu      Haley         Lewis                  1629133160 1661806032
32    update                     project_pis        1 10717                  aprovost@ufl.edu   Adrienne       Provost             <NA> 1629246093 1661806032
33    update                     project_pis        1 10720       Melissa.Parsons@jax.ufl.edu    Melissa       Parsons                  1629324629 1661806032
34    update                     project_pis        1 10736                     rlord@ufl.edu     Reilly          Lord                  1629424540 1661806032
35    update                     project_pis        1 10741                  jplagmay@ufl.edu     Joanne        Lagmay                  1629734007 1661806032
36    update                     project_pis        1 10753         chandana.lall@jax.ufl.edu   Chandana          Lall                  1629835242 1661806032
37    update            unsuspended_creators        2 10704                              <NA>       <NA>          <NA>     amoghagarwal 1629126123 1661806032
38    update            unsuspended_creators        2 10745                              <NA>       <NA>          <NA>         verdonem 1629792221 1661806032
39    update            unsuspended_creators        2 10750                              <NA>       <NA>          <NA>          colembl 1629826458 1661806032
40    update            unsuspended_creators        2 10760                              <NA>       <NA>          <NA>         annawang 1629912578 1661806032
41    update unsuspended_high_privilege_user        3  7343                              <NA>       <NA>          <NA>         andreasz 1566828350 1661806032
42    update unsuspended_high_privilege_user        3 10724                              <NA>       <NA>          <NA>        agmueller 1629382075 1661806032
43    update                     any_creator        5  7338                              <NA>       <NA>          <NA>          bocau15 1566771949 1661806032
44    update                     any_creator        5 10677                              <NA>       <NA>          <NA> lyndseylivermore 1628541780 1661806032
45    update                     any_creator        5 10778                              <NA>       <NA>          <NA>          athaper 1630247620 1661806032
46    update         any_high_privilege_user        6  7252                              <NA>       <NA>          <NA>       ftavassoli 1565112798 1661806032
47    insert                     project_pis        1  4492                  modavefp@ufl.edu François         Modave             <NA> 1661806032 1661806032
48    insert                     project_pis        1 10658             robert.leeman@ufl.edu     Robert        Leeman             <NA> 1661806032 1661806032
49    insert         any_high_privilege_user        6    54                              <NA>       <NA>          <NA>        jkjgaidos 1661806032 1661806032
50    insert         any_high_privilege_user        6    55                              <NA>       <NA>          <NA>        jkjgaidos 1661806032 1661806032