View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001454 | SymmetricDS | Bug | public | 2013-10-27 14:04 | 2019-04-22 14:32 |
| Reporter | syre | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 3.5.10 | ||||
| Summary | 0001454: symadm uninstall-tables can not clear all sym tables in oracle | ||||
| Description | symadm uninstall-tables can not clear all sym tables in oracle. maybe caused by missing qoutes "" on table names in drop table sql. | ||||
| Tags | No tags attached. | ||||
|
|
Do you have a stack trace? What tables are left behind? |
|
|
table remains: SQL> select TABLE_NAME from all_tables where table_name like 'SYM_%'; TABLE_NAME ------------------------------ SYM_CHANNEL SYM_CONFLICT SYM_DATA SYM_DATA_EVENT SYM_DATA_GAP SYM_EXTRACT_REQUEST SYM_FILE_INCOMING SYM_FILE_SNAPSHOT SYM_FILE_TRIGGER SYM_FILE_TRIGGER_ROUTER SYM_GROUPLET TABLE_NAME ------------------------------ SYM_GROUPLET_LINK SYM_INCOMING_BATCH SYM_INCOMING_ERROR SYM_LOAD_FILTER SYM_LOCK SYM_NODE SYM_NODE_CHANNEL_CTL SYM_NODE_COMMUNICATION SYM_NODE_GROUP SYM_NODE_GROUP_CHANNEL_WND SYM_NODE_GROUP_LINK TABLE_NAME ------------------------------ SYM_NODE_HOST SYM_NODE_HOST_CHANNEL_STATS SYM_NODE_HOST_JOB_STATS SYM_NODE_HOST_STATS SYM_NODE_IDENTITY SYM_NODE_SECURITY SYM_OUTGOING_BATCH SYM_PARAMETER SYM_REGISTRATION_REDIRECT SYM_REGISTRATION_REQUEST SYM_ROUTER TABLE_NAME ------------------------------ SYM_SEQUENCE SYM_TABLE_RELOAD_REQUEST SYM_TRANSFORM_COLUMN SYM_TRANSFORM_TABLE SYM_TRIGGER SYM_TRIGGER_HIST SYM_TRIGGER_ROUTER SYM_TRIGGER_ROUTER_GROUPLET 41 rows selected. |
|
|
Can you provide the log output from running the uninstall command. I can't reproduce this. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-10-27 14:04 | syre | New Issue | |
| 2013-10-27 14:06 | chenson | Note Added: 0000380 | |
| 2013-11-06 02:24 | syre | Note Added: 0000389 | |
| 2014-02-07 01:22 | chenson | Note Added: 0000465 | |
| 2019-04-22 14:32 | elong | Status | new => closed |
| 2019-04-22 14:32 | elong | Resolution | open => unable to reproduce |