View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007038 | SymmetricDS | Bug | public | 2025-08-28 16:38 | 2025-08-28 16:38 |
| Reporter | mdrouard | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.16.6 | ||||
| Summary | 0007038: DataService.findOrCreateTriggerHistory does not handle wildcards when getting table names from cache. | ||||
| Description | This causes an error stating that the database does not exist when routing and purging if a trigger history cannot be found when there is a wildcard in the catalog name for a given table. 2025-08-28 12:04:17,229 ERROR [owner] [DataGapRouteReader] [owner-router-reader-1] Failed to read data for routing org.jumpmind.db.sql.SqlException: com.microsoft.sqlserver.jdbc.SQLServerException: Database 'DATABASE_*' does not exist. Make sure that the name is entered correctly. Handle the wildcard when getting the source catalog name from the trigger, so that the correct table can be pulled from the cache. | ||||
| Steps To Reproduce | 1. Setup a wildcard card in a catalog for a table to replicate 2. Verify that data can replicate correctly for the table 3. Note the trigger_hist_id in sym_trigger_hist for the table 4. Force rebuild of triggers on the table 5. Stop Symmetric service 6. Insert a new record in the table 7. Verify that this record has been inserted in sym_data with the new trigger_hist_id 8. Delete the old trigger history with the original trigger_hist_id from sym_trigger_hist 9. Modify the new record to have the old trigger_hist_id 10. Restart Symmetric Service 11. Observe that the error occurs. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-08-28 16:38 | mdrouard | New Issue |