lxdb

Manage the LakeXpress DB, the database where LakeXpress stores its configurations and run history. How to create it: Set up the LakeXpress DB. Examples: LakeXpress DB recipes.

All lxdb commands also accept the common options.

Destructive commands are dry runs by default

drop, truncate and release-locks only show what they would do. Nothing changes until you add --confirm.

lxdb init

Create the LakeXpress tables in the LakeXpress DB, and check the connection. Existing tables and data are kept, so it is safe to run again. The first config create or sync also creates the tables if needed.

usage: LakeXpress lxdb init --auth_file AUTH_FILE --lxdb_auth_id ID
                            [common options]

No options besides the common ones.

lxdb drop

Drop all LakeXpress tables from the LakeXpress DB, with their data.

usage: LakeXpress lxdb drop --auth_file AUTH_FILE --lxdb_auth_id ID
                            [--confirm] [common options]

Option	Description
--confirm	Drop the tables. Without it, lists the tables that would be dropped

lxdb truncate

Delete all data from the LakeXpress tables (configurations, runs, watermarks) and keep the tables.

usage: LakeXpress lxdb truncate --auth_file AUTH_FILE
                                --lxdb_auth_id ID [--confirm]
                                [--sync_id SYNC_ID] [common options]

Option	Description
--confirm	Delete the data. Without it, lists the tables that would be emptied
--sync_id ID	Not implemented yet: with this option, nothing is deleted. To remove one sync configuration and its data, use config delete

lxdb locks

List the tables currently locked in the LakeXpress DB.

Locks are only used by incremental syncs: they prevent two runs from changing the same watermark at the same time. Full syncs do not use locks.

usage: LakeXpress lxdb locks --auth_file AUTH_FILE --lxdb_auth_id ID
                             [--sync_id SYNC_ID] [common options]

Option	Description
--sync_id ID	Only show the locks of this sync configuration

lxdb release-locks

Release locks left behind by a sync that crashed or was killed. They block the next runs of the same tables. Use lxdb locks first to see them.

usage: LakeXpress lxdb release-locks --auth_file AUTH_FILE
                                     --lxdb_auth_id ID
                                     [--max_age_hours HOURS]
                                     [--table_id ID] [--confirm]
                                     [common options]

Option	Description
--max_age_hours N	Release the locks older than N hours (default: 24)
--table_id ID	Release the lock of this table only (IDs are shown by lxdb locks)
--confirm	Release the locks. Without it, shows the locks that would be released