View Issue Details

IDProjectCategoryView StatusLast Update
0001707SymmetricDSBugpublic2014-06-16 20:27
ReporterdreamonAssigned Tochenson 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version3.5.20 
Target Version3.6.0Fixed in Version3.6.0 
Summary0001707: Trigger for all tables * is not creating triggers for some of the tables
DescriptionTrigger:
insert into sym_trigger
(trigger_id,source_schema_name,source_table_name,channel_id,last_update_time,create_time)
values('all','MYSCHEMA','*','channel1',current_timestamp,current_timestamp);
creates triggers only for tables, which names are before sym_ tables, but not creating triggers for tables which goes after sym_ i.e. starting with "T".
log exception:
2014-05-01 21:00:36,678 INFO [corp-000] [TriggerRouterService] [corp-000-job-1] Synchronizing triggers
2014-05-01 21:00:38,518 ERROR [corp-000] [TriggerRouterService] [corp-000-job-1] Failed to retrieve tables for trigger with id of all
java.lang.NullPointerException
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.containsExactMatchForSourceTableName(TriggerRouterService.java:1234)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.getTablesForTrigger(TriggerRouterService.java:1203)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTrigger(TriggerRouterService.java:1269)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1263)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1037)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:988)
    at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:984)
    at org.jumpmind.symmetric.route.ConfigurationChangedDataRouter.contextCommitted(ConfigurationChangedDataRouter.java:378)
    at org.jumpmind.symmetric.service.impl.RouterService.completeBatchesAndCommit(RouterService.java:469)
    at org.jumpmind.symmetric.service.impl.RouterService.routeDataForChannel(RouterService.java:414)
    at org.jumpmind.symmetric.service.impl.RouterService.routeDataForEachChannel(RouterService.java:299)
    at org.jumpmind.symmetric.service.impl.RouterService.routeData(RouterService.java:164)
    at org.jumpmind.symmetric.job.RouterJob.doJob(RouterJob.java:40)
    at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:180)
    at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:724)
Steps To ReproduceCreate tables with names A and T.
Insert trigger-router for all tables using *.
Run app, it will create triggers only for table A.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: master 6b0d1260

2014-05-01 21:36:28

chenson

Details Diff
0001707: Trigger for all tables * is not creating triggers for some of the tables
0001707
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2014-05-01 20:39 dreamon New Issue
2014-05-01 21:36 chenson Fixed in Version => 3.6.0
2014-05-01 21:36 chenson Target Version => 3.6.0
2014-05-01 21:36 chenson Status new => resolved
2014-05-01 21:36 chenson Resolution open => fixed
2014-05-01 21:36 chenson Assigned To => chenson
2014-05-01 22:00 Changeset attached => SymmetricDS trunk r8229
2014-06-16 20:27 chenson Status resolved => closed
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master 6b0d1260