-
Notifications
You must be signed in to change notification settings - Fork 375
Closed
Description
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.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels