Vertex does not support user supplied identifiers

[humutkazan]

Discussed in #1007

^{Originally posted by humutkazan April 6, 2023}
I am trying to migrate to arcadedb and want to use it with gremlin server. Got arcade db up and running on docker with this command

docker run --rm -p 2480:2480 -p 2424:2424 -p 8182:8182 -e "arcadedb.server.defaultDatabases=Imported[root]{import:https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz}" --env JAVA_OPTS="-Darcadedb.server.rootPassword=playwithdata -Darcadedb.server.plugins=Redis:com.arcadedb.redis.RedisProtocolPlugin,MongoDB:com.arcadedb.mongo.MongoDBProtocolPlugin,Postgres:com.arcadedb.postgres.PostgresProtocolPlugin,GremlinServer:com.arcadedb.server.gremlin.GremlinServerPlugin" arcadedata/arcadedb:latest

When I try to run my code I got this error

org.apache.tinkerpop.gremlin.driver.exception.ResponseException: Vertex does not support user supplied identifiers

it shows the location of error and it is the code below (can provide more info if needed be)

        var traversal = g.addV(someLabel).property(T.id, id);

        traversal = addTraversalProperties(traversal, properties);

        traversal.as("label")
                .V(toVertexIds).as("equipment")
                .addE(EDGE_LABEL)
                .from("label")
                .to("equipment")
                .tail()
                .select("label")
                .id()
                .tryNext().orElseThrow(() -> new IllegalStateException(String.format("result: %s", queryResult)));

I tried to add graph.set-vertex-id=true into the gremlin-server.properties file inside docker but nothing changed.

Does anyone have any idea what I can do the solve this issue? Thanks

[humutkazan]

Same thing when I run it via server.bat file. And I don't know if this is relevant but it throws me this error every time

(arcadedb-23.3.1)

2023-04-07 12:10:10.001 INFO  [GremlinServer] Channel started at port 8182.Exception in thread "main" com.arcadedb.exception.DatabaseOperationException: Error on creating new database instance
        at com.arcadedb.database.EmbeddedDatabase.openInternal(EmbeddedDatabase.java:1679)
        at com.arcadedb.database.EmbeddedDatabase.open(EmbeddedDatabase.java:182)
        at com.arcadedb.database.DatabaseFactory.open(DatabaseFactory.java:76)
        at com.arcadedb.server.ArcadeDBServer.getDatabase(ArcadeDBServer.java:399)
        at com.arcadedb.server.ArcadeDBServer.getDatabase(ArcadeDBServer.java:283)
        at com.arcadedb.server.ArcadeDBServer.loadDatabases(ArcadeDBServer.java:421)
        at com.arcadedb.server.ArcadeDBServer.start(ArcadeDBServer.java:144)
        at com.arcadedb.server.ArcadeDBServer.main(ArcadeDBServer.java:92)
Caused by: com.arcadedb.utility.LockException: Database 'graph' is locked by another process (path=C:\Users\username\Desktop\arcadedb-23.3.1\.\databases\graph)
        at com.arcadedb.database.EmbeddedDatabase.lockDatabase(EmbeddedDatabase.java:1517)
        at com.arcadedb.database.EmbeddedDatabase.checkForRecovery(EmbeddedDatabase.java:1615)
        at com.arcadedb.database.EmbeddedDatabase.openInternal(EmbeddedDatabase.java:1657)
        ... 7 more
Caused by: java.nio.channels.OverlappingFileLockException
        at java.base/sun.nio.ch.FileLockTable.checkList(FileLockTable.java:229)
        at java.base/sun.nio.ch.FileLockTable.add(FileLockTable.java:123)
        at java.base/sun.nio.ch.FileChannelImpl.tryLock(FileChannelImpl.java:1154)
        at java.base/java.nio.channels.FileChannel.tryLock(FileChannel.java:1165)
        at com.arcadedb.database.EmbeddedDatabase.lockDatabase(EmbeddedDatabase.java:1498)
        ... 9 more

[lvca]

Welcome @humutkazan!

ArcadeDB provides its own ID as a Record ID. You can provide your ID as a normal attribute, like "id". You can define a unique index on it for fast retrieval.

About the last issue, an ArcadeDB server was running in the background, that's why the file was locked.