Skip to main content

  • ​
    adminVerifyDb

    public AdminVerifyDbResponse adminVerifyDb(AdminVerifyDbRequest request) throws GPUdbException
    Verify database is in a consistent state. When inconsistencies or errors are found, the verified_ok flag in the response is set to false and the list of errors found is provided in the error_list.
    Parameters:
    request - Request object containing the parameters for the operation.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.

  • ​
    adminVerifyDb

    public AdminVerifyDbResponse adminVerifyDb(Map<String,String> options) throws GPUdbException
    Verify database is in a consistent state. When inconsistencies or errors are found, the verified_ok flag in the response is set to false and the list of errors found is provided in the error_list.
    Parameters:
    options - Optional parameters.
    • REBUILD_ON_ERROR: [DEPRECATED] Use the Rebuild DB feature of GAdmin instead. Supported values:The default value is FALSE.
    • VERIFY_NULLS: When TRUE, verifies that null values are set to zero. Supported values:The default value is FALSE.
    • VERIFY_PERSIST: When TRUE, persistent objects will be compared against their state in memory and workers will be checked for orphaned table data in persist. To check for orphaned worker data, either set CONCURRENT_SAFE in options to TRUE or place the database offline. Supported values:The default value is FALSE.
    • CONCURRENT_SAFE: When TRUE, allows this endpoint to be run safely with other concurrent database operations. Other operations may be slower while this is running. Supported values:The default value is TRUE.
    • VERIFY_RANK0: If TRUE, compare rank0 table metadata against workers’ metadata. Supported values:The default value is FALSE.
    • DELETE_ORPHANED_TABLES: If TRUE, orphaned table directories found on workers for which there is no corresponding metadata will be deleted. It is recommended to run this while the database is offline OR set CONCURRENT_SAFE in options to TRUE. Supported values:The default value is FALSE.
    • VERIFY_ORPHANED_TABLES_ONLY: If TRUE, only the presence of orphaned table directories will be checked, all persistence and table consistency checks will be skipped. Supported values:The default value is FALSE.
    • REPAIR_REPLICATED_TABLES: When TRUE, replicated tables whose record counts differ across the worker ranks and toms are repaired: the copy with the most records is kept, and every other copy is replaced with it. That copy may include records from a load that did not complete, or records that a delete did not remove. A table whose copies all have the same number of records is not detected, even if their contents differ. The verifiedOk flag and errorList still report the inconsistencies found before the repair; run the verification again to confirm the repair. Only the tables selected by TABLE_INCLUDES or TABLE_EXCLUDES are repaired. Requires CONCURRENT_SAFE to be TRUE, and cannot be used with VERIFY_ORPHANED_TABLES_ONLY. The repaired tables are listed in the REPAIRED_REPLICATED_TABLES entry of the response info map. Supported values:The default value is FALSE.
    • TABLE_INCLUDES: Comma-separated list of table names to include when verifying table consistency on wokers. Cannot be used simultaneously with TABLE_EXCLUDES.
    • TABLE_EXCLUDES: Comma-separated list of table names to exclude when verifying table consistency on wokers. Cannot be used simultaneously with TABLE_INCLUDES.
    The default value is an empty Map.
    Returns:
    Response object containing the results of the operation.
    Throws:
    GPUdbException - if an error occurs during the operation.