Neo4j schema test27
Every Go service creates the constraints and indexes for the labels it owns when it boots, by reading
the live schema (main #16243). A constraint the data
violates does not fail the boot: a standby _idx index stands in and the object reads
DEGRADED until the rows are fixed — often by a data migration that needs a person.
This page shows what each service found on its latest boot, what is blocking each degraded object, and how the
clusters compare. UNEXPECTED objects (in the database, not in the model) are informational —
usually an older key waiting on its two-release retirement — and never make a service unhealthy.
Newest boot 33 h ago. Convergence runs only at boot, so a report is what the service found when it last started — data fixed since then shows on its next boot.
Services 14
One row per owning service, unhealthy first. The bar is every object the service owns, by what convergence found.
| service | state | objects | not in place | data migrations | reported | earlier boots |
|---|---|---|---|---|---|---|
| workplansvc | unhealthy |
36 objects
|
3 degraded 3 undeclared |
2 / 2
applied · counted
2 applied on earlier boots (counted, not listed)
|
38 h ago
boot · pod cltkx
|
|
| studiosvc | unhealthy |
109 objects
|
2 degraded 19 undeclared |
10 / 10
applied · counted
10 applied on earlier boots (counted, not listed)
|
40 h ago
boot · pod l6x49
|
|
| execsvc | unhealthy |
194 objects
|
1 degraded 7 undeclared |
8 / 8
applied · counted
8 applied on earlier boots (counted, not listed)
|
33 h ago
boot · pod k54gl
|
|
| advpsvc | healthy |
36 objects
|
— | none declared | 14 days ago
boot · pod j7s65
|
|
| budgetsvc | healthy |
8 objects
|
— | none declared | 8 days ago
boot · pod zwphf
|
|
| docsvc | healthy |
100 objects
|
20 undeclared |
6 / 6
applied · counted
6 applied on earlier boots (counted, not listed)
|
38 h ago
boot · pod 22fkg
|
|
| enrollsvc | healthy |
30 objects
|
— | none declared | 2 days ago
boot · pod fxbfc
|
|
| finsvc | healthy |
27 objects
|
— | none declared | 14 days ago
boot · pod qrc22
|
|
| notifsvc | healthy |
23 objects
|
— | none declared | 14 days ago
boot · pod 5k9ps
|
|
| onboardingsvc | healthy |
80 objects
|
3 undeclared |
3 / 3
applied · counted
3 applied on earlier boots (counted, not listed)
|
2 days ago
boot · pod cwwhk
|
|
| patientsvc | healthy |
47 objects
|
— | none declared | 7 days ago
boot · pod 2p6jf
|
|
| regsvc | healthy |
22 objects
|
— | none declared | 7 days ago
boot · pod bnpbr
|
|
| schedsvc | healthy |
15 objects
|
— | none declared | 13 days ago
boot · pod lgzdg
|
|
| tusker | healthy |
18 objects
|
— |
1 / 1
applied · counted
1 applied on earlier boots (counted, not listed)
|
7 days ago
boot · pod w5vq8
|
Objects not in place 6
Each one, with how much of its data violates the key, the migration that would heal it, and whether other clusters have the same problem — degraded on production as well usually means the declared key is wrong, not the data.
Training_activityId_name_orgId_scopeId_status_deltimestamp
DEGRADEDexecsvcactivityIdnameorgIdscopeIdstatusdeltimestampMedia_archivedtimestamp_name_orgid_scopeid_smoversion_state_version_deltimestamp
DEGRADEDstudiosvcarchivedtimestampnameorgidscopeidsmoversionstateversiondeltimestampWorkPlanInstance_name_orgid_scopeId_deltimestamp
DEGRADEDworkplansvcnameorgidscopeIddeltimestampWorkplanCfg_name_orgid_deltimestamp
DEGRADEDworkplansvcnameorgiddeltimestampWorkPlanType_name_orgid_deltimestamp
DEGRADEDworkplansvcnameorgiddeltimestampResponseSet_archivedtimestamp_name_orgid_scopeid_shared_smoversion_state_variablename_version_deltimestamp
DEGRADEDstudiosvcarchivedtimestampnameorgidscopeidsharedsmoversionstatevariablenameversiondeltimestampCreated and retired on the latest boots 7
What convergence changed. A created constraint that replaced a standby index is a degraded object that healed — its data was fixed and the boot made the real constraint. Retired objects were declared obsolete by their owner and dropped.
| object | change | service | label | properties | when |
|---|---|---|---|---|---|
| WorkplanInstanceEvent_orgId | created | workplansvc | WorkplanInstanceEvent | orgId |
38 h ago |
| WorkplanJob_orgid | created | workplansvc | WorkplanJob | orgid |
38 h ago |
| Report_orgid | created | enrollsvc | Report | orgid |
2 days ago |
| Filter_orgid | created | enrollsvc | Filter | orgid |
2 days ago |
| ChartReviewDecision_orgid | created | enrollsvc | ChartReviewDecision | orgid |
2 days ago |
| ChartReviewList_orgid | created | enrollsvc | ChartReviewList | orgid |
2 days ago |
| ChartReviewKeyword_orgid | created | enrollsvc | ChartReviewKeyword | orgid |
2 days ago |
Every cluster 7
Objects not in place per service and cluster (green = healthy). A problem on one dev cluster is stale data; the same one on production is the model. Click a cell for that cluster.
| service | master | automation | nexus | production | delta | test27 | test26 |
|---|---|---|---|---|---|---|---|
| advpsvc | · | ✓ | · | · | · | ✓ | ✓ |
| authz | · | · | · | · | · | · | 3 |
| budgetsvc | · | · | · | · | · | ✓ | · |
| docsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| enrollsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| execsvc | 1 | ✓ | ✓ | ✓ | ✓ | 1 | 1 |
| finsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| notifsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| onboardingsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| patientsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| regsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| schedsvc | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| studiosvc | ✓ | ✓ | ✓ | ✓ | ✓ | 2 | ✓ |
| tusker | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
| workplansvc | ✓ | ✓ | ✓ | ✓ | ✓ | 3 | ✓ |
Undeclared objects 52
In the database, absent from the data model. Never dropped automatically: each is a pending retirement
(declare it in schema_retired.go with its ReplacedBy) or something created outside the model. Not unhealthy.
docsvc — 20
| object | label | properties |
|---|---|---|
| Document_orgId_studyId | Document | orgIdstudyId |
| Document_orgId_template | Document | orgIdtemplate |
| Document_visitId | Document | visitId |
| Document_template | Document | template |
| Document_studyId_status | Document | studyIdstatus |
| Document_status_archived | Document | statusarchived |
| Document_needsAttention | Document | needsAttention |
| Document_studyId_visitId | Document | studyIdvisitId |
| Document_patientId | Document | patientId |
| Document_studyId_archived | Document | studyIdarchived |
| Document_orgId_archived | Document | orgIdarchived |
| Document_studyId_patientId | Document | studyIdpatientId |
| Document_systemTemplateKey | Document | systemTemplateKey |
| Document_status | Document | status |
| Document_studyId_userId | Document | studyIduserId |
| Document_orgId_status | Document | orgIdstatus |
| Document_studyId_siteId | Document | studyIdsiteId |
| Document_fileName | Document | fileName |
| Document_aiEnabled_needsAttention | Document | aiEnabledneedsAttention |
| Document_blindedAccess | Document | blindedAccess |
execsvc — 7
| object | label | properties |
|---|---|---|
| Visit_name_nodeId_treeId_deltimestamp | Visit | namenodeIdtreeIddeltimestamp |
| DocumentSet_name_nodeId_treeId_deltimestamp | DocumentSet | namenodeIdtreeIddeltimestamp |
| Activity_name_nodeId_treeId_deltimestamp | Activity | namenodeIdtreeIddeltimestamp |
| Questionnaire_name_nodeId_treeId_deltimestamp | Questionnaire | namenodeIdtreeIddeltimestamp |
| Question_name_nodeId_treeId_deltimestamp | Question | namenodeIdtreeIddeltimestamp |
| DocOverlay_docId_name_nodeId_treeId_deltimestamp | DocOverlay | docIdnamenodeIdtreeIddeltimestamp |
| ParticipantDocUpload_carePlanId_docUploadId_nodeId_deltimestamp | ParticipantDocUpload | carePlanIddocUploadIdnodeIddeltimestamp |
onboardingsvc — 3
| object | label | properties |
|---|---|---|
| CredentialCheckVersion_orgId_deltimestamp_idx | CredentialCheckVersion | orgIddeltimestamp |
| MemberLabelScopeIdScopeTypeIndex | MemberLabel | scopeIdscopeType |
| MemberLabelGroupScopeIdScopeTypeIndex | MemberLabelGroup | scopeIdscopeType |
studiosvc — 19
| object | label | properties |
|---|---|---|
| MediaSet_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | MediaSet | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| TaskList_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | TaskList | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| TodoV2_state_title_version_deltimestamp | TodoV2 | statetitleversiondeltimestamp |
| DocumentSetV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | DocumentSetV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| DocReview_orgid_scopeid_state_title_version_deltimestamp | DocReview | orgidscopeidstatetitleversiondeltimestamp |
| Table_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | Table | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| Statement_orgid_scopeid_smoversion_state_title_version_deltimestamp | Statement | orgidscopeidsmoversionstatetitleversiondeltimestamp |
| ControlV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | ControlV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| DocOverlayV2_orgid_scopeid_state_title_version_deltimestamp | DocOverlayV2 | orgidscopeidstatetitleversiondeltimestamp |
| ESign_archivedtimestamp_scopeid_state_title_version_deltimestamp | ESign | archivedtimestampscopeidstatetitleversiondeltimestamp |
| VisitV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | VisitV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| WorkflowV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | WorkflowV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| TaskConfig_orgid_scopeid_state_title_version_deltimestamp | TaskConfig | orgidscopeidstatetitleversiondeltimestamp |
| CheckList_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | CheckList | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| PrePostVisitV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | PrePostVisitV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| Trigger_state_version_deltimestamp_scope_operation_orgid | Trigger | stateversiondeltimestampscopeoperationorgid |
| ProtocolVersionV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | ProtocolVersionV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| ScreenerV2_archivedtimestamp_name_orgid_scopeid_smoversion_state_type_version_deltimestamp | ScreenerV2 | archivedtimestampnameorgidscopeidsmoversionstatetypeversiondeltimestamp |
| DocUpload_orgid_scopeid_state_title_version_deltimestamp | DocUpload | orgidscopeidstatetitleversiondeltimestamp |
workplansvc — 3
| object | label | properties |
|---|---|---|
| WorkplanCfg_budgetTemplateId | WorkplanCfg | budgetTemplateId |
| WorkPlanType_budgetTemplateId | WorkPlanType | budgetTemplateId |
| WorkPlanTemplate_budgetTemplateId | WorkPlanTemplate | budgetTemplateId |