Restore the entire Elasticsearch index from the database via Commander service.
Changes in the object structure might lead to differences between the index of Elasticsearch and the database. As of yuuvis® Momentum version 2020 Winter, it is possible to reindex Elasticsearch according to the database by means of the dbs-reindex command provided by the /wiki/spaces/YMY/pages/320050357.
The reindexing can be limited by a start date and an end date, and by specifying a tenant. Per default, the command is executed in a simulation mode that does not manipulate any data. In order to actually apply the reindexing to the data, the simulation mode has to be turned off with the dbs-configure command. After the non-simulation reindexing has been executed, the simulation mode is turned on again automatically.
These parameters can be given to the dbs-configure command:
| Parameter | Description | Example |
|---|---|---|
-s | --simulation | Turns the simulation mode After starting the Commander service and after a non-simulation reindexing process, the simulation mode is set to | dbs-configure --simulation |
These parameters can be given to the dbs reindex command:
| Parameter | Description | Example |
|---|---|---|
-e | --end-date <arg> | Sets an end date. The argument is in format yyyy-MM-dd. | dbs-reindex --end-date=2020-01-21 |
-s | --start-date <arg> | Sets a start date. The argument is in format yyyy-MM-dd. | dbs-reindex -s 2019-01-21 |
-t | --tenant <arg> | Specifies the target tenant. If not specified, the command is executed for all tenants. | dbs-reindex -t default(with the example tenant default) |
The following example code shows the commands together with the corresponding command line outputs for a non-simulation reindexing. The simulation mode is turned off in line 7. In line 18, the reindexing is executed for the default tenant starting from 2017-01-01 and ending on 2017-12-31.
Lt. Commander>help dbs-configure
NAME
dbs-configure - configure timeouts
SYNOPSYS
dbs-configure [-s] [-c] [-f]
OPTIONS
-s or --simulation
turn simulation mode on/off
[Optional, default = false]
-c or --cockroach
Sturn cockroach-db on/off. If cockroach-db is turned 'on', command 'rename' will do updates on database without 'SELECT FOR UPDATE'
[Optional, default = false]
-f or --fulltext
turn fulltext index on/off.
[Optional, default = false]
Lt. Commander>dbs-configure --simulation
simulation mode is [true]
Lt. Commander>help dbs-reindex
NAME
dbs-reindex - reindex all dmsObject from database
SYNOPSYS
dbs-reindex [[-t] string] [[-s] string] [[-e] string]
OPTIONS
-t or --tenant string
specify tenant
[Optional, default = ]
-s or --start-date string
Set start date. e.g.: -s 2019-01-21
[Optional, default = ]
-e or --end-date string
Set end date. e.g.: --end-date=2020-01-21
[Optional, default = ]
Lt. Commander>dbs-reindex -t default -s 2017-01-01 --end-date=2017-12-31
tenant[default] start-date[2017-01-01] endDate[2017-12-31]
getting stats
....