If initialize authorization fails for any reason, some remnants of the operation remain around. Once DDL_TRANSACTIONS have been enabled, then this issue goes away.
Code changes have been made as follows:
- If the initialize operation fails and DDL_TRANSACTIONS is not enabled, go ahead and cleanup all remnants of the operation.
- Added new option to cleanup after a failed authorization attempt: INITIALIZE AUTHORIZATION, CLEANUP. The CLEANUP option can be used to clean up after a failed initialize attempt when the DROP option fails.
- Added logging into the initialize, drop, and cleanup authorization requests.