View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002950 | SymmetricDS | Bug | public | 2016-12-27 05:50 | 2019-08-26 12:45 |
Reporter | monoranjang | Assigned To | elong | ||
Priority | urgent | ||||
Status | closed | Resolution | open | ||
Product Version | 3.8.9 | ||||
Summary | 0002950: Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777] | ||||
Description | I have a table with two CLOB datatype. Here is the configuration: ------------Channel Configuration---------- Channel Id*: MA_CREDENTIALS Processing Order*: 1 Batch Algorithm*: Default Max. Batch Size*: 1000 Max. Batch to Send*: 60 Max. Data to Route*: 100000 Max. KB/s*: 0 Data Loader Type*: Default Queue Name*: default Enabled: Checked Reload Channel: Unchecked(Tried with checked also, same error) File Sync Channel: Unchecked Use Old Data to Route: Checked(Tried with checked also, same error) Use Row Data to Route: Checked(Tried with checked also, same error) Use Primary Key (PK) Data to Route: Checked(Tried with checked also, same error) Tables Contain Big Lobs: Checked(Tried with checked also, same error) ------------------Trigger Configuration------------- Trigger Id*: ms.ma_credentials Source Catalog: Source Schema: MS Source Table*: MA_CREDENTIALS Channel*: MA_CREDENTIALS Sync on Insert: Checked Sync on Update: Checked Sync on Delete: Checked Reload Channel Id*: reload Sync on Insert Condition*: 1=1 Sync on Update Condition*: 1=1 Sync on Delete Condition*: 1=1 Custom Insert Trigger Text: Custom Update Trigger Text: Custom Delete Trigger Text: Sync on Incoming: Unchecked Stream Lobs: Checked Capture Lobs: Checked Capture Old Data: Checked External Select: Checked Excluded Column Names: Included Column Names: Sync Key Names: Channel Expression: ---------------------Table Routing ----------------------- Trigger*: ms.ma_credentials Router*: Server pushes for client MS Initial Load Select: Initial Load Delete Initial Load Order*: 50 Initial Load Batch Count: 0 Enabled: Checked Ping Back Enabled: Unchecked Help | ||||
Steps To Reproduce | Create Channel, Trigger & Router for a table with clob datatype. Do initial load of the table with create table option | ||||
Additional Information | 2016-12-25 18:32:47,875 ERROR [server] [NodeCommunicationService] [server-extract-default-10] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777] 2016-12-25 18:32:49,711 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:51,224 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:52,738 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:54,228 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:54,865 INFO [server] [FileSyncExtractorService] [server-file_extract-default-6] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:32:55,404 INFO [server] [DataExtractorService] [server-extract-default-11] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:32:55,907 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:56,986 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:57,572 INFO [server] [FileSyncExtractorService] [server-file_extract-default-6] Done extracting 1 batches for request 55 2016-12-25 18:32:58,101 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:32:59,440 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is marked as ready but it has been deleted. Rescheduling it for extraction 2016-12-25 18:33:00,302 ERROR [server] [NodeCommunicationService] [server-extract-default-11] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777] 2016-12-25 18:33:01,831 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:03,028 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:04,708 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:05,945 INFO [server] [FileSyncExtractorService] [server-file_extract-default-7] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:33:06,291 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:06,485 INFO [server] [DataExtractorService] [server-extract-default-12] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:33:07,491 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:08,435 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:08,652 INFO [server] [FileSyncExtractorService] [server-file_extract-default-7] Done extracting 1 batches for request 55 2016-12-25 18:33:09,652 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is marked as ready but it has been deleted. Rescheduling it for extraction 2016-12-25 18:33:10,040 ERROR [server] [NodeCommunicationService] [server-extract-default-12] Failed to execute EXTRACT for node 1 and channel default StackTraceKey [SqlException:1239135777] 2016-12-25 18:33:12,624 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:15,124 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:17,631 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:18,173 INFO [server] [FileSyncExtractorService] [server-file_extract-default-8] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:33:18,714 INFO [server] [DataExtractorService] [server-extract-default-13] Extracting batches for request 55. Starting at batch 1288. Ending at batch 1288 2016-12-25 18:33:19,330 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction 2016-12-25 18:33:20,879 INFO [server] [FileSyncExtractorService] [server-file_extract-default-8] Done extracting 1 batches for request 55 2016-12-25 18:33:20,884 INFO [server] [DataExtractorService] [server-data-extractor-1] Batch 1-1288 is not ready for delivery. It is currently scheduled for extraction | ||||
Tags | extract | ||||
|
Note: SymmetricDS Server Node(inside office premise under firewall) is connected with a schema SYMDBTEST. It fetches data from a schema called MS(office premise). Client node is in AWS connected to schema SYMDBTEST at AWS-RDS. Trying to push data to schema MS in AWS-RDS. |
|
The SqlException:1239135777 is an arbitrary abbreviation that points at the actual error, so it doesn't tell us what the extract error was. Can you get the first occurrence of the error in the log, along with the full stace trace, and post it here? |
|
Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action. |
Date Modified | Username | Field | Change |
---|---|---|---|
2016-12-27 05:50 | monoranjang | New Issue | |
2016-12-27 06:13 | monoranjang | Note Added: 0000944 | |
2017-01-11 17:17 | chenson | Project | SymmetricDS Pro => SymmetricDS |
2019-04-24 14:24 | elong | Assigned To | => elong |
2019-04-24 14:24 | elong | Status | new => feedback |
2019-04-24 14:24 | elong | Note Added: 0001427 | |
2019-04-24 14:25 | elong | Tag Attached: extract | |
2019-08-26 12:45 | admin | Note Added: 0001586 | |
2019-08-26 12:45 | admin | Status | feedback => closed |