{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3578","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3578/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3578/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3578/events","html_url":"https://github.com/orientechnologies/orientdb/issues/3578","id":57506284,"number":3578,"title":"Clustering","user":{"login":"vitorenesduarte","id":4520516,"avatar_url":"https://avatars.githubusercontent.com/u/4520516?v=3","gravatar_id":"","url":"https://api.github.com/users/vitorenesduarte","html_url":"https://github.com/vitorenesduarte","followers_url":"https://api.github.com/users/vitorenesduarte/followers","following_url":"https://api.github.com/users/vitorenesduarte/following{/other_user}","gists_url":"https://api.github.com/users/vitorenesduarte/gists{/gist_id}","starred_url":"https://api.github.com/users/vitorenesduarte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitorenesduarte/subscriptions","organizations_url":"https://api.github.com/users/vitorenesduarte/orgs","repos_url":"https://api.github.com/users/vitorenesduarte/repos","events_url":"https://api.github.com/users/vitorenesduarte/events{/privacy}","received_events_url":"https://api.github.com/users/vitorenesduarte/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb/labels/distributed","name":"distributed","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-02-12T19:20:03Z","updated_at":"2015-02-13T07:18:40Z","closed_at":null,"body":"Hi,\r\n__v2.0.2__\r\n- create some database and:\r\n```sql\r\ncreate class User\r\nalter cluster User name User0\r\nalter class user addcluster User1\r\n```\r\n- change __hazelcast.xml__ to:\r\n```xml\r\n<hazelcast\r\n        xsi:schemaLocation=\"http://www.hazelcast.com/schema/config hazelcast-config-3.0.xsd\"\r\n        xmlns=\"http://www.hazelcast.com/schema/config\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\r\n        <group>\r\n                <name>orientdb</name>\r\n                <password>orientdb</password>\r\n        </group>\r\n        <network>\r\n                <port auto-increment=\"true\">2434</port>\r\n                <join>\r\n                        <multicast enabled=\"false\">\r\n                                <multicast-group>235.1.1.1</multicast-group>\r\n                                <multicast-port>2434</multicast-port>\r\n                        </multicast>\r\n                        <tcp-ip enabled=\"true\">\r\n                                <member>10.0.71.5:2434</member>\r\n                                <member>10.0.71.5:2435</member>\r\n                        </tcp-ip>\r\n                </join>\r\n        </network>\r\n        <executor-service>\r\n                <pool-size>16</pool-size>\r\n        </executor-service>\r\n</hazelcast>\r\n```\r\n- change __default-distributed-db-config.json__ to:\r\n```json\r\n{\r\n    \"autoDeploy\": true,\r\n    \"hotAlignment\": false,\r\n    \"executionMode\": \"undefined\",\r\n    \"readQuorum\": 1,\r\n    \"writeQuorum\": 2,\r\n    \"failureAvailableNodesLessQuorum\": false,\r\n    \"readYourWrites\": true,\r\n    \"clusters\": {\r\n        \"internal\": {\r\n        },\r\n        \"index\": {\r\n        },\r\n        \"User0\":{\r\n                \"servers\" : [ \"node0\" ]\r\n        },\r\n        \"User1\":{\r\n                \"servers\" : [ \"node1\" ]\r\n        },\r\n\r\n        \"*\": {\r\n            \"servers\" : [ \"<NEW_NODE>\" ]\r\n        }\r\n    }\r\n}\r\n```\r\n- create a copy of __orientdb-community-2.0.2__ folder\r\n- run both __dserver.sh__; call the first __node0__, the second __node1__\r\n- [here](https://www.dropbox.com/s/l3iuvm1bcepglil/sharding.tar.gz?dl=0) are the dbs I have after the steps above.\r\n- now from studio:\r\n```sql\r\n# from localhost:2480, which is the port of node0\r\ninsert into cluster:User0 set name = 'User0_80'\r\nselect from User # returns the expected\r\n```\r\n```sql\r\n# from localhost:2481\r\nselect from User # shows nothing\r\n# I was hoping to see info from all clusters\r\n```\r\n-----\r\n```sql\r\n# from localhost:2480\r\ninsert into cluster:User1 set name = 'User1_80' # returns the recorded inserted\r\n# from what I read, I thought only master node could insert in his cluster\r\nselect from User # returns 'User0_80' and 'User1_80'\r\n```\r\n```sql\r\n# from localhost:2481\r\nselect from User # returns only 'User1_80'\r\n```\r\n----\r\n```sql\r\n# from localhost:2481\r\ninsert into cluster:User1 set name = 'User1_81'\r\n```\r\n```sql\r\n# from localhost:2480\r\nselect from User # returns 'User0_80' and 'User1_80' and 'User1_81'\r\n```\r\n----\r\nAnd when trying this:\r\n```sql\r\n# from localhost:2481\r\ninsert into cluster:User0 set name = 'User0_81'\r\n```\r\nI got:\r\n```bash\r\ncom.orientechnologies.orient.core.exception.OStorageException: Cannot route COMMAND operation to the distributed node\r\n--> com.orientechnologies.orient.server.distributed.ODistributedException: Quorum 2 not reached for request ....\r\n```\r\n\r\nWhat is going on? Nothing is coherent. Maybe there's something wrong with my configuration.\r\nSorry for the long post."},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/74214534","html_url":"https://github.com/orientechnologies/orientdb/issues/3578#issuecomment-74214534","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/3578","id":74214534,"user":{"login":"vitorenesduarte","id":4520516,"avatar_url":"https://avatars.githubusercontent.com/u/4520516?v=3","gravatar_id":"","url":"https://api.github.com/users/vitorenesduarte","html_url":"https://github.com/vitorenesduarte","followers_url":"https://api.github.com/users/vitorenesduarte/followers","following_url":"https://api.github.com/users/vitorenesduarte/following{/other_user}","gists_url":"https://api.github.com/users/vitorenesduarte/gists{/gist_id}","starred_url":"https://api.github.com/users/vitorenesduarte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitorenesduarte/subscriptions","organizations_url":"https://api.github.com/users/vitorenesduarte/orgs","repos_url":"https://api.github.com/users/vitorenesduarte/repos","events_url":"https://api.github.com/users/vitorenesduarte/events{/privacy}","received_events_url":"https://api.github.com/users/vitorenesduarte/received_events","type":"User","site_admin":false},"created_at":"2015-02-13T07:18:40Z","updated_at":"2015-02-13T07:18:40Z","body":"Yes, can you provide the link?"}}