View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0003657 | SymmetricDS | Bug | public | 2018-08-02 21:36 | 2019-04-24 18:38 |
Reporter | irfaan22 | Assigned To | elong | ||
Priority | urgent | ||||
Status | closed | Resolution | no change required | ||
Product Version | 3.8.39 | ||||
Summary | 0003657: System block when replicating | ||||
Description | ....... [corp-000] - DataExtractorService - Done extracting 1 batches for request 6 [corp-000] - DataExtractorService - Extracting batches for request 7. Starting at batch 28. Ending at batch 28 [corp-000] - DataExtractorService - Done extracting 1 batches for request 7 [corp-000] - DataExtractorService - Extracting batches for request 8. Starting at batch 29. Ending at batch 29 [corp-000] - DataExtractorService - Done extracting 1 batches for request 8 [corp-000] - DataExtractorService - Extracting batches for request 9. Starting at batch 30. Ending at batch 30 [corp-000] - DataExtractorService - Done extracting 1 batches for request 9 [corp-000] - ConfigurationChangedDataRouter - About to refresh the cache of nodes because new configuration came through the data router [corp-000] - RouterService - Routed 2 data events in 93 ms [corp-000] - PullUriHandler - 11 data and 11 batches sent during pull request from store:002:002 [store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of node security because new configuration came through the data loader [store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of nodes because new configuration came through the data loader [store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="ITEM"> <column name="ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="NAME" type="VARCHAR" size="100"> <platform-column name="h2" type="VARCHAR" size="100"/> </column> </table> </database> [store-002] - H2DatabasePlatform - Running alter sql: CREATE TABLE "ITEM"( "ITEM_ID" INTEGER NOT NULL, "NAME" VARCHAR(100) NULL, PRIMARY KEY ("ITEM_ID") ); [store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="ITEM_SELLING_PRICE"> <column name="ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="STORE_ID" primaryKey="true" required="true" type="VARCHAR" size="5"> <platform-column name="h2" type="VARCHAR" size="5"/> </column> <column name="PRICE" required="true" type="DECIMAL" size="10,2"> <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/> </column> <column name="COST" type="DECIMAL" size="10,2"> <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/> </column> <foreign-key name="FK_PRICE_ITEM_ID" foreignTable="ITEM" foreignTableCatalog="" foreignTableSchema=""> <reference local="ITEM_ID" foreign="ITEM_ID"/> </foreign-key> </table> </database> [store-002] - H2DatabasePlatform - Running alter sql: CREATE TABLE "ITEM_SELLING_PRICE"( "ITEM_ID" INTEGER NOT NULL, "STORE_ID" VARCHAR(5) NOT NULL, "PRICE" DECIMAL(10,2) NOT NULL, "COST" DECIMAL(10,2), PRIMARY KEY ("ITEM_ID", "STORE_ID") ); ALTER TABLE "ITEM_SELLING_PRICE" ADD CONSTRAINT "FK_PRICE_ITEM_ID" FOREIGN KEY ("ITEM_ID") REFERENCES "ITEM" ("ITEM_ID"); [store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="SALE_TRANSACTION"> <column name="TRAN_ID" primaryKey="true" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="STORE_ID" required="true" type="VARCHAR" size="5"> <platform-column name="h2" type="VARCHAR" size="5"/> </column> <column name="WORKSTATION" required="true" type="VARCHAR" size="3"> <platform-column name="h2" type="VARCHAR" size="3"/> </column> <column name="DAY" required="true" type="VARCHAR" size="10"> <platform-column name="h2" type="VARCHAR" size="10"/> </column> <column name="SEQ" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> </table> </database> [store-002] - H2DatabasePlatform - Running alter sql: CREATE TABLE "SALE_TRANSACTION"( "TRAN_ID" INTEGER NOT NULL, "STORE_ID" VARCHAR(5) NOT NULL, "WORKSTATION" VARCHAR(3) NOT NULL, "DAY" VARCHAR(10) NOT NULL, "SEQ" INTEGER NOT NULL, PRIMARY KEY ("TRAN_ID") ); [store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="SALE_RETURN_LINE_ITEM"> <column name="TRAN_ID" primaryKey="true" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="ITEM_ID" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="PRICE" required="true" type="DECIMAL" size="10,2"> <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/> </column> <column name="QUANTITY" required="true" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <column name="RETURNED_QUANTITY" type="INTEGER" size="10"> <platform-column name="h2" type="INTEGER" size="10"/> </column> <foreign-key name="FK_SRLI_ITEM_ID" foreignTable="ITEM" foreignTableCatalog="" foreignTableSchema=""> <reference local="ITEM_ID" foreign="ITEM_ID"/> </foreign-key> <foreign-key name="FK_SRLI_TRAN_ID" foreignTable="SALE_TRANSACTION" foreignTableCatalog="" foreignTableSchema=""> <reference local="TRAN_ID" foreign="TRAN_ID"/> </foreign-key> </table> </database> [store-002] - H2DatabasePlatform - Running alter sql: CREATE TABLE "SALE_RETURN_LINE_ITEM"( "TRAN_ID" INTEGER NOT NULL, "ITEM_ID" INTEGER NOT NULL, "PRICE" DECIMAL(10,2) NOT NULL, "QUANTITY" INTEGER NOT NULL, "RETURNED_QUANTITY" INTEGER, PRIMARY KEY ("TRAN_ID") ); ALTER TABLE "SALE_RETURN_LINE_ITEM" ADD CONSTRAINT "FK_SRLI_ITEM_ID" FOREIGN KEY ("ITEM_ID") REFERENCES "ITEM" ("ITEM_ID"); ALTER TABLE "SALE_RETURN_LINE_ITEM" ADD CONSTRAINT "FK_SRLI_TRAN_ID" FOREIGN KEY ("TRAN_ID") REFERENCES "SALE_TRANSACTION" ("TRAN_ID"); [store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of node security because new configuration came through the data loader [store-002] - TriggerRouterService - Synchronizing triggers for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM [store-002] - H2SymmetricDialect - Creating SYM_ON_I_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM [store-002] - H2SymmetricDialect - Creating SYM_ON_U_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM [store-002] - H2SymmetricDialect - Creating SYM_ON_D_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM [store-002] - TriggerRouterService - Done synchronizing triggers for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM [store-002] - TriggerRouterService - Synchronizing triggers for STORE002.PUBLIC.SALE_TRANSACTION [store-002] - H2SymmetricDialect - Creating SYM_ON_I_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION [store-002] - H2SymmetricDialect - Creating SYM_ON_U_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION [store-002] - H2SymmetricDialect - Creating SYM_ON_D_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION [store-002] - TriggerRouterService - Done synchronizing triggers for STORE002.PUBLIC.SALE_TRANSACTION [store-002] - PullService - Pull data received from corp:000:000 on queue default. 11 rows and 11 batches were processed. (sym_node_security, sym_node, item, item_selling_price, sale_transaction, sale_return_line_item) [store-002] - ConfigurationChangedDataRouter - About to refresh the cache of node security because new configuration came through the data router [store-002] - RouterService - Routed 2 data events in 84 ms #<block here ....... | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2018-08-02 21:36 | irfaan22 | New Issue | |
2018-10-17 20:22 | hanes | Status | new => feedback |
2018-10-17 20:22 | hanes | Note Added: 0001291 | |
2019-04-24 18:38 | elong | Assigned To | => elong |
2019-04-24 18:38 | elong | Status | feedback => closed |
2019-04-24 18:38 | elong | Resolution | open => no change required |