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 [email protected]      Ellen  Zimmermann 1547491982 1661807696
2     update project_pis        1  3161 [email protected]      Ellen  Zimmermann 1547491982 1661807696
3     update project_pis        1  4359                [email protected]     Meghan      Arwood 1547491982 1661807696
4     update project_pis        1  4360                [email protected]     Meghan      Arwood 1547491982 1661807696
5     update project_pis        1  4492                  [email protected] François       Modave 1661806032 1661807696
6     update project_pis        1  5832        [email protected]   Nikolaus Gravenstein 1547491982 1661807696
7     update project_pis        1  5861            [email protected]     Melody    Saunders 1623089901 1661807696
8     update project_pis        1  5882   [email protected]  Fernandez   Rosemarie 1606260874 1661807696
9     update project_pis        1  9064               [email protected]      Barry       Byrne 1598293105 1661807696
10    update project_pis        1 10653               [email protected]       Phil     Poekert 1627921679 1661807696
11    update project_pis        1 10658             [email protected]     Robert      Leeman 1661806032 1661807696
12    update project_pis        1 10665           [email protected]     Ansley       Gayle 1628175818 1661807696
13    update project_pis        1 10685                  [email protected]    Melinda     Rajoria 1628706482 1661807696
14    update project_pis        1 10701                   [email protected]   Dominick       Lemas 1628885955 1661807696
15    update project_pis        1 10717                  [email protected]   Adrienne     Provost 1629246093 1661807696
   diff_type      reason priority   pid                             email  firstname    lastname    created    updated
1     update project_pis        1  3160 [email protected]      Ellen  Zimmermann 1547491982 1661806566
2     update project_pis        1  3161 [email protected]      Ellen  Zimmermann 1547491982 1661806566
3     update project_pis        1  4359                [email protected]     Meghan      Arwood 1547491982 1661806566
4     update project_pis        1  4360                [email protected]     Meghan      Arwood 1547491982 1661806566
5     update project_pis        1  4492                  [email protected] François       Modave 1661806032 1661806566
6     update project_pis        1  5832        [email protected]   Nikolaus Gravenstein 1547491982 1661806566
7     update project_pis        1  5861            [email protected]     Melody    Saunders 1623089901 1661806566
8     update project_pis        1  5882   [email protected]  Fernandez   Rosemarie 1606260874 1661806566
9     update project_pis        1  9064               [email protected]      Barry       Byrne 1598293105 1661806566
10    update project_pis        1 10653               [email protected]       Phil     Poekert 1627921679 1661806566
11    update project_pis        1 10658             [email protected]     Robert      Leeman 1661806032 1661806566
12    update project_pis        1 10665           [email protected]     Ansley       Gayle 1628175818 1661806566
13    update project_pis        1 10685                  [email protected]    Melinda     Rajoria 1628706482 1661806566
14    update project_pis        1 10701                   [email protected]   Dominick       Lemas 1628885955 1661806566
15    update project_pis        1 10717                  [email protected]   Adrienne     Provost 1629246093 1661806566
   diff_type                          reason priority   pid                             email  firstname      lastname         username    created    updated
1     update                     project_pis        1  1353    [email protected]         CR         Conti                  1547491982 1661806032
2     update                     project_pis        1  1370              [email protected]       Adam         Woods                  1547491982 1661806032
3     update                     project_pis        1  1396      [email protected]       Carl        Pepine                  1547491982 1661806032
4     update                     project_pis        1  3140                  [email protected]     JOANNE        LAGMAY                  1547491982 1661806032
5     update                     project_pis        1  3160 [email protected]      Ellen    Zimmermann             <NA> 1547491982 1661806032
6     update                     project_pis        1  3161 [email protected]      Ellen    Zimmermann             <NA> 1547491982 1661806032
7     update                     project_pis        1  3211 [email protected]      Ellen    Zimmermann                  1547491982 1661806032
8     update                     project_pis        1  4359                [email protected]     Meghan        Arwood             <NA> 1547491982 1661806032
9     update                     project_pis        1  4360                [email protected]     Meghan        Arwood             <NA> 1547491982 1661806032
10    update                     project_pis        1  4361                [email protected]     Meghan        Arwood                  1547491982 1661806032
11    update                     project_pis        1  4397     [email protected]    Jeffrey     Goldhagen                  1547491982 1661806032
12    update                     project_pis        1  4400                      [email protected]    Richard            Yi                  1547491982 1661806032
13    update                     project_pis        1  4401                      [email protected]    Richard            Yi                  1547491982 1661806032
14    update                     project_pis        1  4411     [email protected]      James         Wymer                  1547491982 1661806032
15    update                     project_pis        1  4471                     [email protected]       asdf          asdf                  1547491982 1661806032
16    update                     project_pis        1  4493        [email protected]   Nikolaus   Gravenstein                  1547491982 1661806032
17    update                     project_pis        1  4525            [email protected]    Mutasim     Abu-Hasan                  1623089901 1661806032
18    update                     project_pis        1  5832        [email protected]   Nikolaus   Gravenstein             <NA> 1547491982 1661806032
19    update                     project_pis        1  5861            [email protected]     Melody      Saunders             <NA> 1623089901 1661806032
20    update                     project_pis        1  5882   [email protected]  Fernandez     Rosemarie             <NA> 1606260874 1661806032
21    update                     project_pis        1  7336       [email protected]    Karthik       Tanneru                  1566689648 1661806032
22    update                     project_pis        1  9064               [email protected]      Barry         Byrne             <NA> 1598293105 1661806032
23    update                     project_pis        1  9072            [email protected]    Demetra      Christou                  1598448590 1661806032
24    update                     project_pis        1 10653               [email protected]       Phil       Poekert             <NA> 1627921679 1661806032
25    update                     project_pis        1 10665           [email protected]     Ansley         Gayle             <NA> 1628175818 1661806032
26    update                     project_pis        1 10685                  [email protected]    Melinda       Rajoria             <NA> 1628706482 1661806032
27    update                     project_pis        1 10686               [email protected]       Mary Bratsch-Hines                  1628732847 1661806032
28    update                     project_pis        1 10694   [email protected]    Bhavana         Patel                  1628795273 1661806032
29    update                     project_pis        1 10697               [email protected]    Corinne        Manley                  1628874190 1661806032
30    update                     project_pis        1 10701                   [email protected]   Dominick         Lemas             <NA> 1628885955 1661806032
31    update                     project_pis        1 10706           [email protected]      Haley         Lewis                  1629133160 1661806032
32    update                     project_pis        1 10717                  [email protected]   Adrienne       Provost             <NA> 1629246093 1661806032
33    update                     project_pis        1 10720       [email protected]    Melissa       Parsons                  1629324629 1661806032
34    update                     project_pis        1 10736                     [email protected]     Reilly          Lord                  1629424540 1661806032
35    update                     project_pis        1 10741                  [email protected]     Joanne        Lagmay                  1629734007 1661806032
36    update                     project_pis        1 10753         [email protected]   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                  [email protected] François         Modave             <NA> 1661806032 1661806032
48    insert                     project_pis        1 10658             [email protected]     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