View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004149 | SymmetricDS | Bug | public | 2019-11-18 16:31 | 2022-08-02 19:41 |
Reporter | sh | Assigned To | elong | ||
Priority | urgent | ||||
Status | closed | Resolution | won't fix | ||
Product Version | 3.9.14 | ||||
Summary | 0004149: Missing trigger | ||||
Description | I 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. | ||||
Tags | No tags attached. | ||||
|
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. |
|
Use sym_trigger.source_catalog_name to look for tables in another database. |
|
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 |
|
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' |
|
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 |
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 |