Neo4j schema test26
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 43 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 |
|---|---|---|---|---|---|---|
| authz | unhealthy |
76 objects
|
3 degraded 2 undeclared | none | 53 days ago
boot · pod 722ls
|
|
| execsvc | unhealthy |
194 objects
|
1 degraded 7 undeclared |
8 / 8
applied · counted
8 applied on earlier boots (counted, not listed)
|
43 h ago
boot · pod 68kvn
|
|
| advpsvc | healthy |
45 objects
|
— | none declared | 3 days ago
boot · pod 6p8xs
|
|
| docsvc | healthy |
82 objects
|
1 undeclared |
5 / 5
applied · counted
5 applied on earlier boots (counted, not listed)
|
45 h ago
boot · pod gf26g
|
|
| enrollsvc | healthy |
32 objects
|
— | none declared | 2 days ago
boot · pod dsv64
|
|
| finsvc | healthy |
27 objects
|
— | none | 13 days ago
boot · pod zrlbf
|
|
| notifsvc | healthy |
23 objects
|
— | none declared | 7 days ago
boot · pod 8fc6r
|
|
| onboardingsvc | healthy |
80 objects
|
3 undeclared |
3 / 3
applied · counted
3 applied on earlier boots (counted, not listed)
|
2 days ago
boot · pod gwxjq
|
|
| patientsvc | healthy |
47 objects
|
— | none declared | 3 days ago
boot · pod dmmg7
|
|
| regsvc | healthy |
22 objects
|
— | none declared | 5 days ago
boot · pod mjwsv
|
|
| schedsvc | healthy |
15 objects
|
— | none declared | 45 h ago
boot · pod rtctq
|
|
| studiosvc | healthy |
98 objects
|
9 undeclared |
8 / 8
applied · counted
8 applied on earlier boots (counted, not listed)
|
2 days ago
boot · pod tbxft
|
|
| tusker | healthy |
18 objects
|
— |
1 / 1
applied · counted
1 applied on earlier boots (counted, not listed)
|
5 days ago
boot · pod qv7nv
|
|
| workplansvc | healthy |
31 objects
|
— |
2 / 2
applied · counted
2 applied on earlier boots (counted, not listed)
|
7 days ago
boot · pod tqjlm
|
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.
User_email_phoneNumber_subject_deltimestamp
DEGRADEDauthzemailphoneNumbersubjectdeltimestampStudyNotification_email_notificationType_studyId_deltimestamp
DEGRADEDexecsvcemailnotificationTypestudyIddeltimestampUserPreference_key_userid_deltimestamp
DEGRADEDauthzkeyuseriddeltimestampStaff_email_deltimestamp
DEGRADEDauthzemaildeltimestampconstraint_89eb5a0d
UNEXPECTEDauthzsiteKeyUser_email_phoneNumber_deltimestamp
UNEXPECTEDauthzemailphoneNumberdeltimestampCreated 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 |
|---|---|---|---|---|---|
| Filter_orgid | created | enrollsvc | Filter | orgid |
2 days ago |
| ChartReviewList_studyid | created | enrollsvc | ChartReviewList | studyid |
2 days ago |
| Report_orgid | created | enrollsvc | Report | orgid |
2 days ago |
| ChartReviewKeyword_orgid | created | enrollsvc | ChartReviewKeyword | orgid |
2 days ago |
| ChartReviewDecision_orgid | created | enrollsvc | ChartReviewDecision | orgid |
2 days ago |
| ChartReviewDecision_studyid | created | enrollsvc | ChartReviewDecision | studyid |
2 days ago |
| ChartReviewList_orgid | created | enrollsvc | ChartReviewList | 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 20
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 — 1
| object | label | properties |
|---|---|---|
| Document_status_archived | Document | statusarchived |
execsvc — 7
| object | label | properties |
|---|---|---|
| DocOverlay_docId_name_nodeId_treeId_deltimestamp | DocOverlay | docIdnamenodeIdtreeIddeltimestamp |
| Question_name_nodeId_treeId_deltimestamp | Question | namenodeIdtreeIddeltimestamp |
| Questionnaire_name_nodeId_treeId_deltimestamp | Questionnaire | namenodeIdtreeIddeltimestamp |
| DocumentSet_name_nodeId_treeId_deltimestamp | DocumentSet | namenodeIdtreeIddeltimestamp |
| ParticipantDocUpload_carePlanId_docUploadId_nodeId_deltimestamp | ParticipantDocUpload | carePlanIddocUploadIdnodeIddeltimestamp |
| Visit_name_nodeId_treeId_deltimestamp | Visit | namenodeIdtreeIddeltimestamp |
| Activity_name_nodeId_treeId_deltimestamp | Activity | namenodeIdtreeIddeltimestamp |
onboardingsvc — 3
| object | label | properties |
|---|---|---|
| constraint_89eb5a0d | Site | siteKey |
| MemberLabelGroupScopeIdScopeTypeIndex | MemberLabelGroup | scopeIdscopeType |
| MemberLabelScopeIdScopeTypeIndex | MemberLabel | scopeIdscopeType |
studiosvc — 9
| object | label | properties |
|---|---|---|
| FormV2_delpending | FormV2 | delpending |
| DocOverlayV2_orgid_scopeid_state_title_version_deltimestamp | DocOverlayV2 | orgidscopeidstatetitleversiondeltimestamp |
| ResponseSet_archivedtimestamp_name_orgid_scopeid_smoversion_shared_state_variablename_version | ResponseSet | archivedtimestampnameorgidscopeidsmoversionsharedstatevariablenameversion |
| Trigger_state_version_deltimestamp_scope_operation_orgid | Trigger | stateversiondeltimestampscopeoperationorgid |
| DocReview_orgid_scopeid_state_title_version_deltimestamp | DocReview | orgidscopeidstatetitleversiondeltimestamp |
| TaskConfig_orgid_scopeid_state_title_version_deltimestamp | TaskConfig | orgidscopeidstatetitleversiondeltimestamp |
| DocUpload_orgid_scopeid_state_title_version_deltimestamp | DocUpload | orgidscopeidstatetitleversiondeltimestamp |
| Statement_orgid_scopeid_state_title_variablename_version_deltimestamp | Statement | orgidscopeidstatetitlevariablenameversiondeltimestamp |
| TodoV2_state_title_version_deltimestamp | TodoV2 | statetitleversiondeltimestamp |