Hi there-
I've been able to get the DBs to talk to one another, but having issues
with one line in the SQL. I'm double checking it works in a non-distributed
DB, and will confirm later. But maybe you have an idea?
ERROR:
2014-11-28 00:01:05:114 WARNING [node2] class UserLikesPost, set mastership
of cluster 'userlikespost_node2' (id=140) to 'node2'
[OHazelcastPlugin][node2]<-[node1] error on executing distributed request
370 on local node: command_sql(update ORole PUT rules = "database.class.*",
15 WHERE name = "member")
com.orientechnologies.orient.core.exception.OCommandExecutionException:
field rules is not defined as a map
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLUpdate.handlePutEntries(OCommandExecutorSQLUpdate.java:473)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLUpdate.result(OCommandExecutorSQLUpdate.java:256)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.addResult(OCommandExecutorSQLSelect.java:590)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.handleResult(OCommandExecutorSQLSelect.java:526)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearchRecord(OCommandExecutorSQLSelect.java:480)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.fetchFromTarget(OCommandExecutorSQLSelect.java:1240)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.fetchValuesFromIndexCursor(OCommandExecutorSQLSelect.java:1608)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.searchForIndexes(OCommandExecutorSQLSelect.java:1489)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.searchInClasses(OCommandExecutorSQLSelect.java:713)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLResultsetAbstract.assignTarget(OCommandExecutorSQLResultsetAbstract.java:184)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.assignTarget(OCommandExecutorSQLSelect.java:414)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.executeSearch(OCommandExecutorSQLSelect.java:396)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLSelect.execute(OCommandExecutorSQLSelect.java:367)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:64)
at
com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:86)
at
com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:75)
at
com.orientechnologies.orient.server.distributed.ODistributedStorage.command(ODistributedStorage.java:208)
at
com.orientechnologies.orient.core.sql.query.OSQLQuery.run(OSQLQuery.java:70)
at
com.orientechnologies.orient.core.query.OQueryAbstract.execute(OQueryAbstract.java:33)
at
com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.query(ODatabaseDocumentTx.java:563)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLUpdate.execute(OCommandExecutorSQLUpdate.java:204)
at
com.orientechnologies.orient.core.sql.OCommandExecutorSQLDelegate.execute(OCommandExecutorSQLDelegate.java:64)
at
com.orientechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:86)
at
com.orientechnologies.orient.core.storage.OStorageEmbedded.command(OStorageEmbedded.java:75)
at
com.orientechnologies.orient.server.distributed.ODistributedStorage.command(ODistributedStorage.java:208)
at
com.orientechnologies.orient.core.command.OCommandRequestTextAbstract.execute(OCommandRequestTextAbstract.java:63)
at
com.orientechnologies.orient.server.distributed.task.OSQLCommandTask.execute(OSQLCommandTask.java:69)
at
com.orientechnologies.orient.server.hazelcast.OHazelcastPlugin.executeOnLocalNode(OHazelcastPlugin.java:711)
at
com.orientechnologies.orient.server.hazelcast.ODistributedWorker.onMessage(ODistributedWorker.java:294)
at
com.orientechnologies.orient.server.hazelcast.ODistributedWorker.run(ODistributedWorker.java:117)
-- ROLES --
-----------
-- Member role: allow nothing by default
INSERT INTO ORole SET name = "member", mode = 0
-- To CRUD any record in any class, the user must also pass the
record-level security
UPDATE ORole PUT rules = "database.class.*", 15 WHERE name = "member"
UPDATE ORole PUT rules = "database.class.Exercise", 2 WHERE name = "member"
UPDATE ORole PUT rules = "database.class.ExerciseHasVariationExercise", 2
WHERE name = "member"
UPDATE ORole PUT rules = "database.class.Gym", 2 WHERE name = "member"
UPDATE ORole PUT rules = "database.class.Hashtag", 2 WHERE name = "member"
UPDATE ORole PUT rules = "database.class.PromoCode", 6 WHERE name = "member"
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
