Query works on Studio, fails using REST API ( ... is not idempotent) (original) (raw)

Hello it's me again

ArcadeDB Version:

ArcadeDB Server v24.5.1-SNAPSHOT (build 71472c4c05ae9278d0d5d71a919b31883e1ea767/1713899543605/main) is starting up... creating nodes and reading nodes

OS and JDK Version:

Running on Linux 5.15.0-100-generic - OpenJDK 64-Bit Server VM 11.0.22 for creating nodes and reading nodes

Expected behavior

Query should execute and not fail.

Actual behavior

Error :

{"error":"Cannot execute command","detail":"Query \u0027create vertex type CHUNK\u0027 is not idempotent","exception":"java.lang.IllegalArgumentException"}

mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: java.lang.IllegalArgumentException: Query 'create vertex type CHUNK' is not idempotent mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.query.sql.SQLQueryEngine.query(SQLQueryEngine.java:92) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.database.LocalDatabase.query(LocalDatabase.java:1371) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.server.ServerDatabase.query(ServerDatabase.java:489) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.server.http.handler.GetQueryHandler.execute(GetQueryHandler.java:61) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.server.http.handler.DatabaseAbstractHandler.execute(DatabaseAbstractHandler.java:100) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at com.arcadedb.server.http.handler.AbstractServerHttpHandler.handleRequest(AbstractServerHttpHandler.java:127) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.RoutingHandler.handleRequest(RoutingHandler.java:93) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.protocol.http.HttpReadListener.handleEventWithNoRunningRequest(HttpReadListener.java:265) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.protocol.http.HttpReadListener.handleEvent(HttpReadListener.java:136) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:162) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:100) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:57) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.ChannelListeners.invokeChannelListener(ChannelListeners.java:92) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.ChannelListeners$10.handleEvent(ChannelListeners.java:291) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.ChannelListeners$10.handleEvent(ChannelListeners.java:286) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.ChannelListeners.invokeChannelListener(ChannelListeners.java:92) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.nio.QueuedNioTcpServer2.acceptTask(QueuedNioTcpServer2.java:178) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.nio.WorkerThread.safeRun(WorkerThread.java:612) mai 10 09:31:51 cfia-IDEXTEND server.sh[1388]: at org.xnio.nio.WorkerThread.run(WorkerThread.java:479)

Steps to reproduce

curl -X GET http://localhost:2480/api/v1/query/test/sql/create%20vertex%20type%20CHUNK --user root:rootroot

Do it using Studio and it works

firefox_zbU8AUz3s5.mp4

Yes I also tried the if not exist, it doesn't help, that was my original query.