Data Integrity and Storage

{{ocient}} provides several capabilities to check on the quality of data on a node and to quarantine segment groups that are problematic for any reason related to data integrity is the ability to rebuild tasks for details, see docid\ lp3hitukekekfy1vmalei alter segment quarantine alter segment quarantine isolates segment groups from segment generation or queries use this sql statement if segments are causing unexpected results or crashes the segments can be un quarantined by setting quarantine level to none syntax \ to quarantine a single segment group alter segment quarantine for { \<quarantine level> } where segment group id = seg id \ to quarantine multiple segment groups alter segment quarantine for { \<quarantine level> } where segment group id in ( seg id \[, ] ) \<quarantine level> = segment generation | query | all | none 114,100,362 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type using quarantine levels ( \<quarantine level> ) you can place quarantines at these segment levels 551,552 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type examples this example quarantines a single segment group from segment generation alter segment quarantine for segment generation where segment group id = 123456789; this example quarantines multiple segment groups from segment generation alter segment quarantine for segment generation where segment group id in (1,2,3,4,5); this example removes a quarantine from a single segment group alter segment quarantine for none where segment group id = 123456789; this example removes a quarantine from multiple segment groups alter segment quarantine for none where segment group id in (1,2,3,4,5); this example quarantines at the query level alter segment quarantine for query where segment group id = 123456789; this example removes a quarantine at the query level alter segment quarantine for none where segment group id = 123456789; this example quarantines at both the query and segment group levels alter segment quarantine for all where segment group id = 123456789; related links docid\ xhkkwud at3llhh77niqx