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

Details

    • 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 ;;

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: