ArcadeDB Version:

ArcadeDB Server v23.10.1-SNAPSHOT (build 186c0adb0743a94a733a512d31a17901d174f3bb/1695791343005/main)
From Docker Image

OS and JDK Version:

Running on Linux 5.10.102.1-microsoft-standard-WSL2 - OpenJDK 64-Bit Server VM 11.0.20.1 (Temurin-11.0.20.1+1)

Expected behavior

Query remaining vertexes possible after dropped another vertext

Actual behavior

Getting an Error: org.apache.tinkerpop.gremlin.driver.exception.ResponseException: Record #13:0 not found
My first analysis is, that it's happening if you drop a vertex that is having more than one incoming edge.

Steps to reproduce

Run the following gremlin query (Copy & Paste). I use gdotv for fast testing.

g.addV("RG").
  property("name", "r1").
  addV("RG").
  property("name", "r2").as("member2").
  V().
  has("name", "r1").
  addE(":TEST").to("member2").
  addV("RG").
  property("name", "r3").as("member3").
  V().
  has("name", "r1").
  addE(":TEST").to("member3").
  addV("RG").
  property("name", "r4").as("member4").
  V().
  has("name", "r2").
  addE(":TEST").to("member4").
  addV("RG").
  property("name", "r5").as("member5").
  V().
  has("name", "r3").
  addE(":TEST").to("member5").
  V().
  has("name", "r4").
  addE(":TEST").to("member5").
  addV("P").
  property("name", "p1").as("member6").
  V().
  has("name", "r5").
  addE(":TEST").from("member6")

You will have the following graph:

Execute the following gremlin query to remove r4 from r5 and all incoming vertexes with the label P:

g.V().
  has("RG", "name", "r4").
  out().
  has("RG", "name", "r5").
  as('deleteEntry').
  select('deleteEntry').
  sideEffect(in().hasLabel("P").drop()).
  sideEffect(select('deleteEntry').drop()).
  constant('deleted');

The drop itself will execute without an error. But afterwards you are not able anymore to query the database:
Getting an Error: org.apache.tinkerpop.gremlin.driver.exception.ResponseException: Record #13:0 not found

Second Issue (which is linked)

The above delete query is not working if you remove the select part of the query. Maybe this is related to gremlin not sure, but I wanted to add that here.

  select('deleteEntry').