> ## Documentation Index > Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt > Use this file to discover all available pages before exploring further. # admin_verify_db
admin\_verify\_db(options={"{"}{"}"})\[source]

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 (dict of str to str) –

Optional parameters. Allowed keys are:

  • rebuild\_on\_error – \[DEPRECATED] Use the Rebuild DB feature of GAdmin instead. Allowed values are:

    • true

    • false

    The default value is ‘false’.

  • verify\_nulls – When true, verifies that null values are set to zero. Allowed values are:

    • true

    • false

    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 input parameter options to true or place the database offline. Allowed values are:

    • true

    • false

    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. Allowed values are:

    • true

    • false

    The default value is ‘true’.

  • verify\_rank0 – If true, compare rank0 table metadata against workers’ metadata. Allowed values are:

    • true

    • false

    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 input parameter options to true. Allowed values are:

    • true

    • false

    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. Allowed values are:

    • true

    • false

    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 dict ( {"{"}{"}"} ).

Returns

A dict with the following entries–

verified\_ok (bool) –

True if no errors were found, false otherwise. The default value is False.

error\_list (list of str) –

List of errors found while validating the database internal state. The default value is an empty list ( \[] ).

orphaned\_tables\_total\_size (long) –

If verify\_persist is true, verify\_orphaned\_tables\_only is true or delete\_orphaned\_tables is true, this is the sum in bytes of all orphaned tables found. Otherwise, -1.

info (dict of str to str) –

Additional information.