View Issue Details

IDProjectCategoryView StatusLast Update
0004149SymmetricDSBugpublic2022-08-02 19:41
Reportersh Assigned Toelong  
Priorityurgent 
Status closedResolutionwon't fix 
Product Version3.9.14 
Summary0004149: Missing trigger
DescriptionI keep seeing this error message on the log file
2019-11-18 15:57:42,166 INFO [sybase-origin-001] [AseSymmetricDialect] [sybase-origin-001-syn
c-triggers-1] Tried: select count(*) from dbo.sysobjects where type = 'TR' AND name ='SYM_ON_
I_FOR_SRCH_TRM_CSTRG' which failed, will try again with catalog.

But when I run this
select * from sym_trigger_router where trigger_id = 'search_term_cs-trigger';
select * from sym_trigger where source_table_name = 'search_term_cs';
The data is all there.

trigger_id router_id enabled initial_load_order initial_load_select initial_load_delete_stmt ping_back_enabled create_time last_update_by last_update_time description
 ---------------------- ------------------------------ ------- ------------------ ------------------- ------------------------ ----------------- ----------------------- -------------- ----------------------- -----------
 search_term_cs-trigger sitesearch-sybase-mysql-router 1 100 NULL NULL 0 2019-11-18 16:28:54.826 NULL 2019-11-18 16:28:54.826 NULL

trigger_id source_catalog_name source_schema_name source_table_name channel_id reload_channel_id sync_on_update sync_on_insert sync_on_delete sync_on_incoming_batch name_for_update_trigger name_for_insert_trigger name_for_delete_trigger sync_on_update_condition sync_on_insert_condition sync_on_delete_condition custom_before_update_text custom_before_insert_text custom_before_delete_text custom_on_update_text custom_on_insert_text custom_on_delete_text external_select tx_id_expression channel_expression excluded_column_names included_column_names sync_key_names use_stream_lobs use_capture_lobs use_capture_old_data use_handle_key_updates stream_row create_time last_update_by last_update_time description
 ---------------------- ------------------- ------------------ ----------------- ------------------- ----------------- -------------- -------------- -------------- ---------------------- ----------------------- ----------------------- ----------------------- ------------------------ ------------------------ ------------------------ ------------------------- ------------------------- ------------------------- --------------------- --------------------- --------------------- --------------- ---------------- ------------------ --------------------- --------------------- -------------- --------------- ---------------- -------------------- ---------------------- ---------- ----------------------- -------------- ----------------------- -----------
 search_term_cs-trigger site_search dbo search_term_cs search_term-channel reload 1 1 1 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 1 1 0 2019-11-18 16:28:53.793 NULL 2019-11-18 16:28:53.793 NULL

I am pretty sure the triggers got created before, i'm not sure how they suddenly disappeared. And if so why SymmetricDS is not recreating it when I stop/start it up again as there are entries on sym_trigger_router and sym_trigger table.
Select name from sysobjects where name like 'sym_on_%' and name like '%SRCH%', returns nothing.
TagsNo tags attached.

Activities

sh

2019-11-19 09:50

reporter   ~0001632

Ok I have just discovered that the triggers are being created in the site_search database, while it appears that SymmetricDS is trying to look into another databases for these triggers.

What do I need to change in the configuration file to either tell SymmetricDS to look into the other database for the triggers or have the triggers created on the main database.

elong

2019-11-19 13:06

developer   ~0001634

Use sym_trigger.source_catalog_name to look for tables in another database.

sh

2019-11-20 09:58

reporter   ~0001636

I've already done that. source_catalog_name being site_search database. But still trying to look for trigger on another database.

trigger_id source_catalog_name source_schema_name source_table_name channel_id reload_channel_id sync_on_update sync_on_insert sync_on_delete sync_on_incoming_batch name_for_update_trigger name_for_insert_trigger name_for_delete_trigger sync_on_update_condition sync_on_insert_condition sync_on_delete_condition custom_before_update_text custom_before_insert_text custom_before_delete_text custom_on_update_text custom_on_insert_text custom_on_delete_text external_select tx_id_expression channel_expression excluded_column_names included_column_names sync_key_names use_stream_lobs use_capture_lobs use_capture_old_data use_handle_key_updates stream_row create_time last_update_by last_update_time description
 ------------------------------- ------------------- ------------------ ----------------------- ----------------------- ----------------- -------------- -------------- -------------- ---------------------- ----------------------- ----------------------- ----------------------- ------------------------ ------------------------ ------------------------ ------------------------- ------------------------- ------------------------- --------------------- --------------------- --------------------- --------------- ---------------- ------------------ --------------------- --------------------- -------------- --------------- ---------------- -------------------- ---------------------- ---------- ----------------------- -------------- ----------------------- -----------
search_term_cs-trigger site_search dbo search_term_cs search_term-channel reload 1 1 1 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 1 1 0 2019-11-18 16:28:53.793 NULL 2019-11-18 16:28:53.793 NULL

sh

2019-11-20 10:03

reporter   ~0001637

The query it attempts to try is this
select count(*) from dbo.sysobjects where type = 'TR' AND name ='SYM_ON_U_FOR_SRCH_TRM_RTRGG1'

By having the source_catalog_name being site_search, shouldn't the query be changed to. Note I originally did create the trigger with source_catalog_name being the other database. Tried re-sync triggers but again see same error message.
select count(*) from site_search.dbo.sysobjects where type = 'TR' AND name ='SYM_ON_U_FOR_SRCH_TRM_RTRGG1'

sh

2019-11-20 10:14

reporter   ~0001638

I've also checked on sym_trigger_router table, the trigger search_term_cs-trigger is linked to router_id sitesearch-sybase-mysql-router, and on sym_router table for router_id sitesearch-sybase-mysql-router the target_catalog_name is site_search.

router_id target_catalog_name target_schema_name target_table_name source_node_group_id target_node_group_id router_type router_expression sync_on_update sync_on_insert sync_on_delete use_source_catalog_schema create_time last_update_by last_update_time description
 ------------------------------ ------------------- ------------------ ----------------- -------------------- -------------------- ----------- ----------------- -------------- -------------- -------------- ------------------------- ----------------------- -------------- ----------------------- -----------
 sitesearch-sybase-mysql-router site_search NULL NULL sybase-origin mysql-repmaster default NULL 1 1 1 0 2019-04-15 15:28:54.183 NULL 2019-04-15 15:28:54.183 NULL

Issue History

Date Modified Username Field Change
2019-11-18 16:31 sh New Issue
2019-11-19 09:50 sh Note Added: 0001632
2019-11-19 13:06 elong Note Added: 0001634
2019-11-20 09:58 sh Note Added: 0001636
2019-11-20 10:03 sh Note Added: 0001637
2019-11-20 10:14 sh Note Added: 0001638
2022-08-02 19:41 elong Assigned To => elong
2022-08-02 19:41 elong Status new => closed
2022-08-02 19:41 elong Resolution open => won't fix