Checking the status of the cloning process v16
The process_status_from_log function provides the status of a cloning function from its log file:
process_status_from_log ( <log_file> TEXT )
The function returns the following fields from the log file:
| Field name | Description |
|---|---|
status | Displays either STARTING, RUNNING, FINISH, or FAILED. |
execution_time | When the command was executed. Displayed in timestamp format. |
pid | Session process ID in which clone schema is getting called. |
level | Displays either INFO, ERROR, or SUCCESSFUL. |
stage | Displays either STARTUP, INITIAL, DDL-COLLECTION, PRE-DATA, DATA-COPY, POST-DATA, or FINAL. |
message | Information respective to each command or failure. |
Parameters
log_file
Name of the log file recording the cloning of a schema as specified when the cloning function was invoked.
Example
The following shows the use of the process_status_from_log function:
edb=# SELECT edb_util.process_status_from_log('clone_edb_edbcopy');
Output
process_status_from_log --------------------------------------------------------------------------------------------------- (FINISH,"26-JUN-17 11:57:03.214458 -04:00",3691,INFO,"STAGE: FINAL","successfully cloned schema") (1 row)
- On this page
- Parameters
- Example