cdr stats check
The cdr stats check command displays the progress of a consistency check that specified a progress report task name.
- 1 See Connect Option.
| Element | Purpose | Restrictions | Syntax |
|---|---|---|---|
| task_name | The name of the progress report task to display. | Must be an existing named task. | Long Identifiers |
| time | The number of seconds between progress reports. | Must be a positive integer. |
The following table describes the options to the cdr stats check command.
| Long Form | Short Form | Meaning |
|---|---|---|
| --delete= | -d | Specifies to delete the specified named task information from the replcheck_stat and replcheck_stat_node tables. |
| --repeat= | -r | Specifies to repeat the progress report every specified interval of seconds. |
| --verbose | -v | Specifies that the consistency report shows specific values that are inconsistent instead of a summary of inconsistent rows. |
Usage
Use the cdr stats check command to display the progress of a consistency check operation while the cdr check replicate or cdr check replicateset command is running. You must have specified a task name in the cdr check replicate or cdr check replicateset command. You must be connected to the same server on which the cdr check replicate or cdr check replicateset command was run when you run the cdr stats check command.
The cdr stats check command displays a snapshot of the consistency report and an estimate of the time remaining to complete the consistency check. If you use the --repeat option, the consistency report is displayed every specified time interval.
You can view the progress of previously run consistency checks that have named tasks, if those progress report tasks have not been overwritten or deleted.
If you want to see the detailed progress report, include the --verbose option. The format of the verbose progress report is the same as the verbose consistency report generated by the cdr check replicate and cdr check replicateset commands.
If you want to delete a named task, use the --delete option.
Examples
The following example checks a replicate named repl1, creates a task named tst, and then displays a progress report every two seconds.
cdr check repl ;r repl1 ;m cdr1 ;a --name=tst
cdr stats check ;-repeat=2 tstThe progress report from the previous command might look like this:
Job tst
repl1 Started Jan 17 16:10:59
*********+----+----+----+----+----+----+----+----+ Remaining 0:00:08
---------------------------------------------------
Job tst
repl1 Started Jan 17 16:10:59
**********************--+----+----+----+----+----+ Remaining 0:00:04
---------------------------------------------------
Job tst
repl1 Started Jan 17 16:10:59
***********************************----+----+----+ Remaining 0:00:02
---------------------------------------------------
Job tst
repl1 Started Jan 17 16:10:59
*************************************************+ Remaining 0:00:01
---------------------------------------------------
Job tst
repl1 Completed
Started Jan 17 16:10:59, Elapsed Time 0:00:07The following example checks and repairs the replicate, creates a task named tst, and displays a verbose progress report every four seconds.
cdr check repl ;r repl1 ;m cdr1 ;a --name=tst --repair
cdr stats check ;-repeat=4 ;-verbose tstThe progress report from the previous command might look like this:
Job tst
repl1 Started Jan 17 16:34:42
*******--+----+----+----+----+----+----+----+----+ Remaining 0:00:12
Node Total Extra Missing Mismatch Child Processed
---------------- --------- --------- --------- --------- --------- ---------
cdr1 9000 0 0 0 0 0
cdr2 9000 0 0 99 0 99
cdr3 9000 0 0 0 0 0
---------------------------------------------------
Job tst
repl1 Started Jan 17 16:34:42
*********************************-+----+----+----+ Remaining 0:00:02
Node Total Extra Missing Mismatch Child Processed
---------------- --------- --------- --------- --------- --------- ---------
cdr1 43000 0 0 0 0 0
cdr2 43000 0 0 99 0 99
cdr3 43000 0 0 0 0 0
---------------------------------------------------
Job tst
repl1 Started Jan 17 16:34:42
*************************************************+ Remaining 0:00:01
Node Total Extra Missing Mismatch Child Processed
---------------- --------- --------- --------- --------- --------- ---------
cdr1 39000 0 0 0 0 99
cdr2 38901 0 99 99 0 99
cdr3 39000 0 0 0 0 0
---------------------------------------------------
Job tst
repl1 Completed
Started Jan 17 16:34:42, Elapsed Time 0:00:11
Node Total Extra Missing Mismatch Child Processed
---------------- --------- --------- --------- --------- --------- ---------
cdr1 64099 0 0 0 0 99
cdr2 64000 0 99 99 0 99
cdr3 64099 0 0 0 0 0
The following example checks a replicate set named set, creates a task named tst, and displays a progress report every five seconds:
cdr check replset ;s set ;m cdr1 ;a ;n tst
cdr stats check ;r 5 tstThe progress report from the previous command might look like this:
Job tst
repl3 Started Jan 17 16:41:19
*****----+----+----+----+----+----+----+----+----+ Remaining 0:00:16
repl2 Pending
repl1 Pending
Estimated time remaining for job tst 0:00:52
---------------------------------------------------
Job tst
repl3 Started Jan 17 16:41:19
***************************************+----+----+ Remaining 0:00:01
repl2 Pending
repl1 Pending
Estimated time remaining for job tst 0:00:19
---------------------------------------------------
Job tst
repl3 Completed
Started Jan 17 16:41:19, Elapsed Time 0:00:08
repl2 Started Jan 17 16:41:27
*******************+----+----+----+----+----+----+ Remaining 0:00:06
repl1 Pending
Estimated time remaining for job tst 0:00:13
---------------------------------------------------
Job tst
repl3 Completed
Started Jan 17 16:41:19, Elapsed Time 0:00:08
repl2 Completed
Started Jan 17 16:41:27, Elapsed Time 0:00:08
repl1 Started Jan 17 16:41:35
----+----+----+----+----+----+----+----+----+----+ Remaining 0:01:08
Estimated time remaining for job tst 0:01:08
---------------------------------------------------
Job tst
repl3 Completed
Started Jan 17 16:41:19, Elapsed Time 0:00:08
repl2 Completed
Started Jan 17 16:41:27, Elapsed Time 0:00:08
repl1 Started Jan 17 16:41:35
*********************************-+----+----+----+ Remaining 0:00:02
Estimated time remaining for job tst 0:00:02
---------------------------------------------------
Job tst
repl3 Completed
Started Jan 17 16:41:19, Elapsed Time 0:00:08
repl2 Completed
Started Jan 17 16:41:27, Elapsed Time 0:00:08
repl1 Completed
Started Jan 17 16:41:35, Elapsed Time 0:00:11
Run time for job tst 0:00:27