View Issue Details

IDProjectCategoryView StatusLast Update
0003657SymmetricDSBugpublic2018-10-17 16:22
Reporterirfaan22Assigned To 
Priorityurgent 
Status feedbackResolutionopen 
Product Version3.8.39 
Target VersionFixed in Version 
Summary0003657: 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
.......

Activities

hanes

2018-10-17 16:22

developer   ~0001291

Can you be more specific about what your error is? I'm not seeing the issue when looking at your description you have provided.

Issue History

Date Modified Username Field Change
2018-08-02 17:36 irfaan22 New Issue
2018-10-17 16:22 hanes Status new => feedback
2018-10-17 16:22 hanes Note Added: 0001291