View Issue Details

IDProjectCategoryView StatusLast Update
0003657SymmetricDSBugpublic2018-08-02 17:36
Reporterirfaan22Assigned To 
PriorityurgentSeverityblockReproducibilityhave not tried
Status newResolutionopen 
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
.......
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-08-02 17:36 irfaan22 New Issue