View Issue Details

IDProjectCategoryView StatusLast Update
0001130SymmetricDSBugpublic2013-03-20 16:17
ReporterrottenAssigned To 
PrioritylowSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version3.3.4 
Target VersionFixed in Version 
Summary0001130: can't reload a table under a "*" trigger
DescriptionI have a wild card trigger on a schema in PostgreSQL 9.1, replicating all of the tables in that schema to another, identical PostgreSQL 9.1 database. There are no other SymmetricDS (or otherwise) triggers on tables in that schema.

Today I had a need to reload one of the tables in that schema:


$ ../bin/symadmin reload-table -p my_node.properties -n the_other_node my_table
Log output will be written to ../logs/my_node.log
Reloading table to node 'the_other_node'
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
java.lang.RuntimeException: Cannot find history for trigger all_in_my_schema, *
        at org.jumpmind.symmetric.service.impl.DataService.lookupTriggerHistory(DataService.java:419)
        at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvent(DataService.java:260)
        at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvent(DataService.java:252)
        at org.jumpmind.symmetric.service.impl.DataService.insertReloadEvent(DataService.java:241)
        at org.jumpmind.symmetric.service.impl.DataService.reloadTable(DataService.java:863)
        at org.jumpmind.symmetric.service.impl.DataService.reloadTable(DataService.java:831)
        at org.jumpmind.symmetric.SymmetricAdmin.reloadTable(SymmetricAdmin.java:456)
        at org.jumpmind.symmetric.SymmetricAdmin.executeWithOptions(SymmetricAdmin.java:286)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:131)


A glance at the history table shows that entries were made for each table's trigger, but no entry was made for the "*" trigger definition itself.

Steps To Reproducereplicate a schema with a "*" trigger and then try to reload an individual table
TagsNo tags attached.

Activities

rotten

2013-03-20 16:17

reporter   ~0000228

Oh, the work around is to use dbexport/dbimport, which works just fine to reload individual tables, which is why I marked it as a low priority bug.

Issue History

Date Modified Username Field Change
2013-03-20 16:01 rotten New Issue
2013-03-20 16:17 rotten Note Added: 0000228