Skip to content

Add "script ending" message in certain stages to ensure that process completes vs is killed #1806

@simonpane

Description

@simonpane

There are several circumstances where Ora2Pg may run for a while and without using the --debug option, it may be difficult to know for certain from STDOUT/STDERR as to whether Ora2Pg completed or was killed or died.

For example, when exporting using the -t COPY option, the last few lines of output may look like:

[2024-08-02 18:47:34] [========================>] 695788/694218 total rows (100.2%) - (1224 sec., avg: 568 recs/sec), TABLE_A in progress.           
[2024-08-02 19:32:48] [========================>] 45175/44792 rows (100.9%) Table TABLE_A (3935 sec., 11 recs/sec)                        
[2024-08-02 19:32:48] [========================>] 726949/694218 rows (104.7%) on total estimated data (3938 sec., avg: 184 tuples/sec)     

Or when running ./import_all.sh ... -s it may end with something like:

...
ALTER TABLE
CREATE TABLE
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
ALTER TABLE

Or when loading data using ./import_all.sh ... -a the final rows may look similar to:

...
SET
SET
SET
TRUNCATE TABLE
COPY 0
SET
SET
SET
TRUNCATE TABLE
COPY 0
COMMIT

Therefore, in these situations it would be beneficial to have a message showing that Ora2Pg has actually completed (vs having died or been killed for some reason).

Simple change to add -- PR will be provided.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions