View Revisions: Issue #6922
| Summary | 0006922: Uninstall node action does not remove DDL (and truncate) capture function | ||
|---|---|---|---|
| Revision | 2025-06-05 13:20 by josh-a-hicks | ||
| Steps To Reproduce | Setup a node connected to SQL Server Turn on DDL parameter trigger.capture.ddl.changes=true Uninstall the node Verify the sym_on_filtered_ddl is removed. To check run a simple create table script on the database and would fail to fire the function and capture the change without sym runtime tables. |
||
| Revision | 2025-06-05 20:48 by pbelov | ||
| Steps To Reproduce | Setup a new node connected to any database, which supports DDL capture (PostgreSQL, SQL Server, ...) and has permissions to do so. Turn on DDL capture parameter trigger.capture.ddl.changes=true Ensure DDL triggers are installed. Uninstall the node from the Manage->Nodes screen. Verify the sym_on_filtered_ddl is NOT removed (fsym_on_filtered_ddl and fsym_on_filtered_ddl_drop in PostgreSQL). To check run a simple create table script on the database and would fail to fire the function and capture the change without sym runtime tables. |
||
| Revision | 2025-06-05 13:20 by josh-a-hicks | ||
| Description | Detected on SQL Server but may exist on other platforms. Turn on the DDL parameter to capture DDL changes and then uninstall the node the function : sym_on_filtered_ddl remains in place. This will cause future table creations on the database as it will fire the database level function to capture the ddl change and insert it into sym_data and reference sym_trigger_hist and they do not exist. |
||
| Revision | 2025-07-14 15:38 by pbelov | ||
| Description | Detected on SQL Server but may exist on other platforms. Turn on the DDL parameter to capture DDL changes and then uninstall the node the function : sym_on_filtered_ddl remains in place. This will cause future table creations on the database as it will fire the database level function to capture the ddl change and insert it into sym_data and reference sym_trigger_hist and they do not exist. Remove DDL trigger and postgres.trigger.capture.truncate.event when uninstalling a node |
||