Skip to main content

hydra janitor

hydra janitor

This command cleans up stale database rows.

Synopsis

This command cleans up stale database rows. This will select records to delete with a limit and delete records in batch to ensure that no table locking issues arise in big production databases.

Warning

This command is irreversible. Proceed with caution!

This is a destructive command and will purge data directly from the database. Please use this command with caution.

###############

Janitor can be used in several ways.

  1. By passing the database connection string (DSN) as an argument Pass the database url (dsn) as an argument to janitor. E.g. janitor {database-url}

  2. By passing the DSN as an environment variable

     export DSN=...
    janitor -e
  3. By passing a configuration file containing the DSN janitor -c /path/to/conf.yml

  4. Extra optional parameters can also be added such as

     hydra janitor --keep-if-younger 23h --access-lifespan 1h --refresh-lifespan 40h --consent-request-lifespan 10m {database-url}
  5. Running only a certain cleanup

     hydra janitor --tokens {database-url}

    or

     hydra janitor --requests {database-url}

    or

     hydra janitor --grants {database-url}

    or any combination of them

     hydra janitor --tokens --requests --grants {database-url}
hydra janitor [<database-url>] [flags]

Examples

hydra janitor --keep-if-younger 23h --access-lifespan 1h --refresh-lifespan 40h --consent-request-lifespan 10m <database-url>

Options

      --access-lifespan duration            Set the access token lifespan e.g. 1s, 1m, 1h.
--batch-size int Define how many records are deleted with each iteration. (default 100)
-c, --config strings Path to one or more .json, .yaml, .yml, .toml config files. Values are loaded in the order provided, meaning that the last config file overwrites values from the previous config file.
--consent-request-lifespan duration Set the login/consent request lifespan e.g. 1s, 1m, 1h
--grants This will only run the cleanup on trust relationships and will skip requests and token cleanup.
-h, --help help for janitor
--keep-if-younger duration Keep database records that are younger than a specified duration e.g. 1s, 1m, 1h.
--limit int Limit the number of records retrieved from database for deletion. (default 10000)
-e, --read-from-env If set, reads the database connection string from the environment variable DSN or config file key dsn.
--refresh-lifespan duration Set the refresh token lifespan e.g. 1s, 1m, 1h.
--requests This will only run the cleanup on requests and will skip token and trust relationships cleanup.
--tokens This will only run the cleanup on tokens and will skip requests and trust relationships cleanup.

SEE ALSO

  • hydra - Run and manage Ory Hydra