Orient Studio and Console, not behaving properly with Distributed Mode over 3 Node Cluster

[ashwani-dumca]

OrientDB Version: orientdb-community-3.2.32.tar.gz

Java Version: openjdk 11.0.23 2024-04-16

OS: Ubuntu 22.04.3 LTS

Expected behavior

Orient Studio and Console should be able to provide answer for checking the information about Distributed Commands you have provided on

curl -u root:root "http://node_ip:2480/distributed/node"
curl -u root:root "http://node_ip:2480/distributed/database/GratefulDeadConcerts"
curl -u root:root "http://node_ip:2480/distributed/queue/*"

Actual behavior

2024-08-21 13:44:41:903 WARNI ->node_ip: Command not found: GET.distributed/node [ONetworkProtocolHttpDb]
2024-08-21 13:45:41:704 WARNI ->node_ip: Command not found: GET.distributed/database/GratefulDeadConcerts [ONetworkProtocolHttpDb]
2024-08-21 13:46:36:890 WARNI ->node_ip: Command not found: GET.distributed/queue/* [ONetworkProtocolHttpDb]

Steps to reproduce

https://stackoverflow.com/questions/78913660/orient-studio-and-orient-console-are-not-working-properly-with-distributed-mode

[tglman]

Hi,

The commands are available only with the agent.jar added in the plugin folder of the distribution, you can find the plugin in the releases links: https://github.com/orientechnologies/orientdb/releases

[ashwani-dumca]

Thank You @tglman for considering the query, Possible for you to please provide me some link or steps to use the agent.jar ?

Secondly, why Orient Studio is not working properly ? Earlier it was working properly till the time I was just using the server.sh ?

What are all the other possible ways to verify my distributed cluster is working fine using the OrientDB console, is there any help or TODO page providing any information on that ?

[ashwani-dumca]

During the Insertion of the Vertex, it says Null Pointer Exception in the console but Vertex get created

`orientdb {db=firewall_db}> CREATE CLASS FirewallRule EXTENDS V;

Error: com.orientechnologies.orient.core.exception.OStorageException: Error on executing command: create CLASS FirewallRule EXTENDS V DB name="firewall_db"

Error: java.lang.NullPointerException

orientdb {db=firewall_db}> ALTER CLASS FirewallRule ADDCLUSTER firewall_rule_cluster;

Class updated successfully.

orientdb {db=firewall_db}>`

[ashwani-dumca]

Few of the commands are not working on the OrientDB Console:

orientdb {db=firewall_db}> LIST CLUSTERS VERBOSE;


CLUSTERS (collections)
+----+-----+-----+
|#   |NAME |COUNT|
+----+-----+-----+
|0   |     |     |
|1   |     |     |
|2   |     |     |
|3   |     |     |
|4   |     |     |
|5   |     |     |
|6   |     |     |
|7   |     |     |
|8   |     |     |
|9   |     |     |
|10  |     |     |
|11  |     |     |
|12  |     |     |
|13  |     |     |
|14  |     |     |
|15  |     |     |
|16  |     |     |
|17  |     |     |
|18  |     |     |
|19  |     |     |
|20  |     |     |
|21  |     |     |
|22  |     |     |
|23  |     |     |
|24  |     |     |
|25  |     |     |
|26  |     |     |
|27  |     |     |
|28  |     |     |
|29  |     |     |
|30  |     |     |
|31  |     |     |
|32  |     |     |
|33  |     |     |
|34  |     |     |
|35  |     |     |
|36  |     |     |
|37  |     |     |
|38  |     |     |
|39  |     |     |
|40  |     |     |
|41  |     |     |
|42  |     |     |
|43  |     |     |
|44  |     |     |
|45  |     |     |
|46  |     |     |
|47  |     |     |
+----+-----+-----+
|    |TOTAL|    0|
+----+-----+-----+

orientdb {db=firewall_db}>

orientdb {db=firewall_db}> INFO CLASS Region;

CLASS 'Region'

Records..............: 2
Super classes........: [V]
Default cluster......: region (id=24)
Supported clusters...: region_cluster(18), region(24), region_1(25), region_2(26), region_3(27)
Cluster selection....: round-robin
Oversize.............: 0.0

PROPERTIES
+----+---------------+-------+-----------------+---------+--------+--------+----+----+-------+-------+
|#   |NAME           |TYPE   |LINKED-TYPE/CLASS|MANDATORY|READONLY|NOT-NULL|MIN |MAX |COLLATE|DEFAULT|
+----+---------------+-------+-----------------+---------+--------+--------+----+----+-------+-------+
|0   |environment    |STRING |                 |false    |false   |false   |    |    |default|       |
|1   |region_name    |STRING |                 |false    |false   |false   |    |    |default|       |
|2   |default_netsize|INTEGER|                 |false    |false   |false   |    |    |default|       |
+----+---------------+-------+-----------------+---------+--------+--------+----+----+-------+-------+
orientdb {db=firewall_db}> SELECT COUNT(*) FROM cluster:region_cluster;

+----+--------+
|#   |COUNT(*)|
+----+--------+
|0   |2       |
+----+--------+