markddrake / YADAMU---Yet-Another-DAta-Migration-Utility

A utility for Migrating Data between Oracle, Postgres, MySQL MariaDB, Snowflake. Stage Data from supported database to Amazon S3 and Azure Blob Storage in JSON and CSV Formats
MIT License
17 stars 9 forks source link

Import: DDL Errors not handled correctly causing unhandled errors #225

Closed markddrake closed 10 months ago

markddrake commented 11 months ago

If a DDL operation fails during an Import this can cause a series of unhandled errors resulting from the fact that the Writer DBI is destroyed before the writers have terminated and released their connections.

markddrake commented 11 months ago

The DBI doDestroy() function must wait for all activeWriter promises to settle before attempting to shut down the database connection and close the connection pool. The activeWriter promise must reject if the writer terminates as a result of an error.