You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
To run a batch script with lot of inserts or updates without consuming all available connections.
Actual behavior
When running a batch script through the console, it seems like each insert or update is consuming one "connection", so the limit is reached and no new connections can be made (although the script is still executing fine). The server logs Reached maximum number of concurrent connections (max=1000, current=213837), reject incoming connection from /127.0.0.1:52756 [OServerNetworkListener].
Steps to reproduce
I can reproduce it with a fresh install of 3.2.0. Unzip zip and start server.
Create a script with thousand lines like this: create vertex V set num = 1; ...
In console:
orientdb> connect remote:localhost/demodb admin admin;
Connecting to database [remote:localhost/demodb] with user 'admin'...OK
orientdb {db=demodb}> load script script.sql;
Try to connect to server (i.e. opening Studio) while the script is executing, the connection is rejected and logs:
Reached maximum number of concurrent connections (max=1000, current=3779), reject incoming connection from /127.0.0.1:57932 [OServerNetworkListener] ("current" is an increasing number).
The text was updated successfully, but these errors were encountered:
Hi, I tested this again with version 3.2.27 and the problem is still present. I attach a minimal script to reproduce the case. While the script is running (load it though the console, i.e. in interactive shell with console.sh), log in to the database in Studio and log out and try to log in again.
OrientDB Version: 3.2.0
Java Version: openjdk version "11.0.11"
OS: Ubuntu 21.04
Expected behavior
To run a batch script with lot of inserts or updates without consuming all available connections.
Actual behavior
When running a batch script through the console, it seems like each insert or update is consuming one "connection", so the limit is reached and no new connections can be made (although the script is still executing fine). The server logs
Reached maximum number of concurrent connections (max=1000, current=213837), reject incoming connection from /127.0.0.1:52756 [OServerNetworkListener]
.Steps to reproduce
I can reproduce it with a fresh install of 3.2.0. Unzip zip and start server.
Create a script with thousand lines like this:
create vertex V set num = 1; ...
In console:
Try to connect to server (i.e. opening Studio) while the script is executing, the connection is rejected and logs:
Reached maximum number of concurrent connections (max=1000, current=3779), reject incoming connection from /127.0.0.1:57932 [OServerNetworkListener]
("current" is an increasing number).The text was updated successfully, but these errors were encountered: