Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6088

Cluster mode: definition changes are distributed from node1 to node2 but not vice-versa

XMLWordPrintable

    • Hide

      1. Prepare a fresh Teiid server and standalone-ha.xml configuration running the teiid-standalone-ha-mode-install.cli script

      2. Add in test-vdb.xml the following virtual view (views schema):

          <model visible = "true" type = "VIRTUAL" name = "views">
        <metadata type = "DDL"><![CDATA[
          create view test1 as select 1
        ]]>
        </metadata>
    </model>

      3. Make a copy of the Teiid server.

      4. Run the first Teiid server using the following command:

      .\standalone.bat -c standalone-ha.xml -Djboss.node.name=srv1

      it will be the first node as a coordinator.

      5. Run the second Teiid server using the following command:

      .\standalone.bat -c standalone-ha.xml -Djboss.node.name=srv2 -Djboss.socket.binding.port-offset=100

      it will be the second node.

      6. On the first node run the following queries:

      -- should be 1
select * from views.test1 ;;

alter view views.test1 as select 2 ;;

-- should be 2
select * from views.test1 ;;

      7. On the second node run the following queries:

      -- should be 2
select * from views.test1 ;;

alter view views.test1 as select 3 ;;

-- should be 3
select * from views.test1 ;;

      8. Check on the first node:

      -- should be 3
-- wrong result, it shows 2!
select * from views.test1 ;;
      Show
      1. Prepare a fresh Teiid server and standalone-ha.xml configuration running the teiid-standalone-ha-mode-install.cli script 2. Add in test-vdb.xml the following virtual view (views schema): <model visible = " true " type = "VIRTUAL" name = "views" > <metadata type = "DDL" ><![CDATA[ create view test1 as select 1 ]]> </metadata> </model> 3. Make a copy of the Teiid server. 4. Run the first Teiid server using the following command: .\standalone.bat -c standalone-ha.xml -Djboss.node.name=srv1 it will be the first node as a coordinator. 5. Run the second Teiid server using the following command: .\standalone.bat -c standalone-ha.xml -Djboss.node.name=srv2 -Djboss.socket.binding.port-offset=100 it will be the second node. 6. On the first node run the following queries: -- should be 1 select * from views.test1 ;; alter view views.test1 as select 2 ;; -- should be 2 select * from views.test1 ;; 7. On the second node run the following queries: -- should be 2 select * from views.test1 ;; alter view views.test1 as select 3 ;; -- should be 3 select * from views.test1 ;; 8. Check on the first node: -- should be 3 -- wrong result , it shows 2! select * from views.test1 ;;
    • Undefined

      I configured two Teiid server nodes in standalone-ha clustering mode. Node1 works as a coordinator. Deployed on both nodes the same and very simple views.test1 virtual view. If I change the definition of the view on node1 the change will be distributed to node2 but not vice-versa. If I change the definition of the view on node2 the change won't be distributed to node1.

        1. TEIID-6088_Cluster_mode.patch
          2 kB

              rhn-engineering-shawkins Steven Hawkins
              dalex005 Dmitrii Pogorelov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: