View Issue Details

IDProjectCategoryView StatusLast Update
0003109SymmetricDSBugpublic2019-03-14 08:39
ReportermarcAssigned To 
Prioritylow 
Status confirmedResolutionopen 
Product Version3.8.24 
Target Version3.10.1Fixed in Version 
Summary0003109: File replication routing job fails with error message when channel is not a file sync channel - needs better error message
DescriptionHello,

I have configured file sync to setup master master replication of a folder using symmetricds but I'm getting stuck.

I can confirm the records in the sym_file_snapshot table on the master have been created by the tracker job, with correct data in trigger_id and router_id fields, but then routing fails with the following log output

FileSyncDataRouter - Could not find a trigger router with a trigger_id of null and a router_id of null. The file snapshot will not be routed

Not so sure if this is a bug or if I missed something in the config but couldn't find what is wrong.

Steps To ReproduceCreate a /dockercom folder on source and target

Insert symmetric conf :

insert into sym_file_trigger
(trigger_id,channel_id,base_dir,recurse,last_update_time,create_time)
values('dockercom','dockercom', '/dockercom', 0, current_timestamp,current_timestamp);

insert into sym_file_trigger
(trigger_id,channel_id,base_dir,recurse,last_update_time,create_time)
values('dockercom_slave','dockercom', '/dockercom', 0, current_timestamp,current_timestamp);

insert into sym_router
(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)
values('master_2_store_dockercom', 'master', 'store', 'default',current_timestamp, current_timestamp);

insert into sym_router
(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)
values('store_2_master_dockercom', 'store', 'master', 'default',current_timestamp, current_timestamp);

insert into sym_file_trigger_router
(trigger_id,router_id,last_update_time,create_time)
values('dockercom','master_2_store_dockercom', current_timestamp, current_timestamp);

insert into sym_file_trigger_router
(trigger_id,router_id,last_update_time,create_time)
values('dockercom_slave','store_2_master_dockercom', current_timestamp, current_timestamp);


Add some text files to the master /dockercom folder

Look at the master log
Additional InformationContent of the snapshot table

trigger_id, router_id, relative_dir, file_name, channel_id, reload_channel_id, last_event_type, crc32_checksum, file_size, file_modified_time, last_update_time, last_update_by, create_time
'dockercom', 'master_2_store_dockercom', '.', '.env', 'dockercom', 'filesync_reload', 'C', '3454198307', '47', '1494749769000', '2017-05-14 08:20:00', NULL, '2017-05-14 08:20:00'
'dockercom', 'master_2_store_dockercom', '.', 'docker-compose.run.yml', 'dockercom', 'filesync_reload', 'C', '1664581753', '2404', '1494749769000', '2017-05-14 08:20:00', NULL, '2017-05-14 08:20:00'
'dockercom', 'master_2_store_dockercom', '.', 'run_client_docker.sh', 'dockercom', 'filesync_reload', 'C', '1667299467', '2021', '1494749769000', '2017-05-14 08:20:00', NULL, '2017-05-14 08:20:00'
'dockercom', 'master_2_store_dockercom', '.', 'upgrade_latest', 'dockercom', 'filesync_reload', 'C', '0', '0', '1494746198000', '2017-05-14 08:20:00', NULL, '2017-05-14 08:20:00'
TagsNo tags attached.

Relationships

has duplicate 0003607 closed file trigger error 
has duplicate 0003740 closed Error in log file could be improved in cases where file triggers are assigned to non-file-sync channels. 

Activities

lindom

2018-06-20 04:36

reporter   ~0001209

marc:
  have you sollution this problem?I face the same problem of you. I don't know whether it's a bug or a config error.
  if you have the sollution,please send a email to me ,thank you !
  my email is lindom@foxmail.com.

hanes

2018-10-03 09:35

developer   ~0001249

I was able to recreate the issue. It's one of configuration (although SymmetricDS could probably do a better job of explaining the error in the logs). You have your channel for the file sync set to be "dockercom", but I'm guessing you dont have the file_sync_flag set to "1" on that channel (which indicates to SymmetricDS that it's a channel for file sync.) I can get the same error you describe above.

Issue History

Date Modified Username Field Change
2017-05-15 00:59 marc New Issue
2018-06-20 04:36 lindom Note Added: 0001209
2018-10-03 09:35 hanes Status new => feedback
2018-10-03 09:35 hanes Note Added: 0001249
2018-10-17 09:18 hanes Status feedback => confirmed
2018-10-17 09:18 hanes Target Version => 3.10.0
2018-10-17 09:18 hanes Summary File replication routing job fails with error message => File replication routing job fails with error message when channel is not a file sync channel - needs better error message
2018-10-17 09:18 hanes Target Version 3.10.0 =>
2018-10-17 11:51 hanes Relationship added has duplicate 0003607
2018-10-17 14:40 hanes Target Version => 3.10.0
2018-10-25 15:22 hanes Relationship added has duplicate 0003740
2018-12-05 14:58 hanes Priority normal => low
2019-03-14 08:39 admin Target Version 3.10.0 => 3.10.1