Gremlin.Net.Driver.Exceptions.ConnectionClosedException

Question

Created object for gremlinServer , connectionPoolSettings

    var gremlinClient = new GremlinClient(gremlinServer,connectionPoolSettings:connectionPoolSettings);

    using (gremlinClient)
    {
      var v1 = graph.AddV("person").Property("name", "marko").Next();**
      var v2 = graph.AddV("person").Property("name", "stephen").Next();
      graph.V(v1).AddE("knows").To(v2).Property("weight", 0.75).Iterate();
    }

At var V1 getting below exception:

Gremlin.Net.Driver.Exceptions.ConnectionClosedException: 'Connection closed by server. CloseStatus: InternalServerError, CloseDescription: Internal-Server-Error. Any in-progress requests on the connection will be in an unknown state, and may need to be retried.

I am not able to understand why the server is closing connection

Kelvin Lawrence · Answer 1 · 2022-09-12T13:36:33.640

0

After you call Next() the first time that v1 object is now a result. Is graph the actual GraphTraversalSource, or something you spawned from it? If the latter, after the call to Next it has been completed and you will have to create it again.

In general, it would be better to have the first two calls that populate v1 and v2 return their IDs. Even better, do it all as one query. I will show examples of both below.

 var v1 = graph.AddV("person").Property("name", "marko").Id().Next();
 var v2 = graph.AddV("person").Property("name", "stephen")).Id().Next();
 graph.V(v1).AddE("knows").To(V(v2)).Property("weight", 0.75).Iterate();
}

or, cleaner,

 graph.AddV("person").Property("name", "marko").As("a").
       AddV("person").Property("name", "stephen")).
       AddE("knows").From("a").Property("weight", 0.75).
       Iterate();
}

I also assume that graph is a GraphTraversalSource object (commonly called g, and not an actual Graph object of something spawned from g.

edited Sep 12 '22 at 13:36

answered Sep 12 '22 at 13:21

Kelvin Lawrence

14,674
2
16
38

Hi @kelvin-lawrence, Thanks for your support on my issue. I tried both the approaches you mentioned above , however I still landing into same below exception: Gremlin.Net.Driver.Exceptions.ConnectionClosedException: 'Connection closed by server. CloseStatus: InternalServerError, CloseDescription: Internal-Server-Error. Any in-progress requests on the connection will be in an unknown state, and may need to be retried.' – place holder Sep 12 '22 at 17:42
That sounds very odd. Which version of the Gremlin .Net client are you using? – Kelvin Lawrence Sep 13 '22 at 01:29
Hi @Kelvin Lawrence, Thanks for your support. I am using Gremlin.Net 3.61. version .Net framework version is 4.7.0 – place holder Sep 13 '22 at 06:28

score 0 · Answer 2 · answered Sep 13 '22 at 06:41

Since you tagged this question with Cosmos DB, I assume that you're using that backend. It unfortunately doesn't support any Gremlin.Net version newer than 3.4.13, but you mentioned in a comment that you are using Gremlin.Net 3.6.1 which cannot work with Cosmos DB right now.

Apart from the versions, Cosmos DB also does not support Gremlin Bytecode which is used internally when you create your traversals in C# and then iterate them. With Cosmos DB, you have to send them as string instead, just like you would send an SQL query string for example.

So, instead of this (I'm taking the code from kelvin-lawrence's response as it uses a single traversal):

graph.AddV("person").Property("name", "marko").As("a").
       AddV("person").Property("name", "stephen")).
       AddE("knows").From("a").Property("weight", 0.75).
       Iterate();

you have to do this:

var query =  "g.addV('person').property('name', 'marko').as('a').
       addV('person').property('name', 'stephen')).
       addE('knows').from('a').property('weight', 0.75).
       iterate()";
await gremlinClient.SubmitAsync<object>(query);

In general, please check the official Cosmos DB docs or this example repository for Cosmos DB and Gremlin.Net.

Thanks for the extra info Florian. I was not aware that there is no support at all for Gremlin Bytecode in Cosmos DB. — Kelvin Lawrence, Sep 13 '22 at 14:12

score 0 · Answer 3 · answered Feb 27 '23 at 17:41

I got this error after updating the Gremlin Nuget package. After adding to this Quick Start Issue, I found the compatibility chart states that version 3.4.13 is supported. 3.4.13 was released on Jan 13, 2022. After I put the Nuget back to 3.4.13, the connection exception went away.

It makes me wonder why Microsoft hasn't updated to be able to support the newer versions. It's been 13 months at the time I write this.

Gremlin.Net.Driver.Exceptions.ConnectionClosedException

3 Answers3

Linked