View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001707 | SymmetricDS | Bug | public | 2014-05-02 00:39 | 2014-06-17 00:27 |
Reporter | dreamon | Assigned To | chenson | ||
Priority | high | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.20 | ||||
Target Version | 3.6.0 | Fixed in Version | 3.6.0 | ||
Summary | 0001707: Trigger for all tables * is not creating triggers for some of the tables | ||||
Description | Trigger: 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 Reproduce | Create tables with names A and T. Insert trigger-router for all tables using *. Run app, it will create triggers only for table A. | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2014-05-02 00:39 | dreamon | New Issue | |
2014-05-02 01:36 | chenson | Fixed in Version | => 3.6.0 |
2014-05-02 01:36 | chenson | Target Version | => 3.6.0 |
2014-05-02 01:36 | chenson | Status | new => resolved |
2014-05-02 01:36 | chenson | Resolution | open => fixed |
2014-05-02 01:36 | chenson | Assigned To | => chenson |
2014-05-02 02:00 | Changeset attached | => SymmetricDS trunk r8229 | |
2014-06-17 00:27 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 6b0d1260 |