OrientDB connections not getting closed on close API

[arpitdd123]

I am facing issue with orientdb and getting below exception.
Reached maximum number of concurrent connections (max=1000, current=1000), reject incoming connection from /127.0.0.1:54782 [OServerNetworkListener]
For more analysis I wrote below code for connection create and close.

public class ConnectionsOpenAndClose {

    public static void main(String[] args) {

        String databaseUrl = <url>;
        String username = <username>;
        String password = <password>;
        OPartitionedDatabasePool pool = openConnections(databaseUrl, username, password);
        ODatabaseDocument oDatabaseDocument = pool.acquire();
        closeConnections(pool, oDatabaseDocument);

    }

    private static void closeConnections(OPartitionedDatabasePool pool, ODatabaseDocument oDatabaseDocument) {
        if (Objects.nonNull(pool)) {
            if (Objects.nonNull(oDatabaseDocument)) {
                oDatabaseDocument.activateOnCurrentThread();
                oDatabaseDocument.close();
            }
            pool.close();
        }
    }

    private static OPartitionedDatabasePool openConnections(String databaseUrl, String username, String password) {
        OPartitionedDatabasePool pool = new OPartitionedDatabasePool(databaseUrl, username, password);
        ODatabaseDocument odbDocument = pool.acquire();
        odbDocument.close();
        return pool;

    }

}

After executing code, I found that on pool.close() or oDatabaseDocument.close(); no binary listeners are getting closed. This, I verified from orientdb studio dashboard. These connections are getting released only after above code terminates from JVM.

Is there any solution for this, how to close these connections? Because after some time orientdb starts rejecting incoming connections, and then eventually orientdb hangs and need to be restarted.

This case is occurring on REDHAT machine where above code is executed and latest Orientdb is on any OS.

Orientdb Version 3.2.23

[tglman]

Hi,

could you use instead ODatabasePool or even not use the pool and use the OrientDB context like:

    OrientDB orientDB = new OrientDB("embedded:/path/to/databases/", OrientDBConfig.default());
    try (ODatabaseSession session = orientDB.open("database", "user", "password")) {
    
    }
    orientDB.close();

the OPartitionedDatabasePool has been deprecated and require open and close of the session to be done exactly on the same thread.

Regards