arcadedb-xx.x.x.zip & arcadedb-xx.x.x.tar.gz doesn't contain all 3rd libraries

[corradomio]

ArcadeDB Version: 22.2.1

11

OS: Windows

Expected behavior

To create a database distribution file to be used in the installation in another computer

Actual behavior

The distribution file is created (.zip & .tar.gz) BUT it doesn't contain all 3rd library files. After the installation & the database creation, the cypher engine is not available:

MATCH (n) RETURN COUNT(n)

doesn't work: it says that the Cypher engine is not installed. This is false: arcadedb-gremlin is available but the dependent libraries are missing.

I think the problem is in "package" module' "pom.xml" file: it is not correct to use

       <exclusions>
            <exclusion>
                <groupId>*</groupId>
                <artifactId>*</artifactId>
            </exclusion>
        </exclusions>

Note: I removed the exclusions and in this way it works.

[lvca]

@robfrank do you have any idea about this?

[arcade-player]

The jars of modules (postgres, redis, gremil..) are fat jars including all the dependencies.

The cypher query engine is embedded inside the arcadedb-gremlin jar:

unzip -l arcadedb-gremlin-22.2.1.jar | grep CypherQueryEngineFactory
     2041  02-23-2022 16:02   com/arcadedb/gremlin/query/CypherQueryEngineFactory.class

Tha trick we are using in package:

       <exclusions>
            <exclusion>
                <groupId>*</groupId>
                <artifactId>*</artifactId>
            </exclusion>
        </exclusions>

is to include the jar, arcadedb-gremlin.jar, while excluding third-party libraries THAT are included in the fat jar.

This is the log starting server.sh

./server.sh \
           -Darcadedb.server.rootPassword=playwithdata \
           -D"arcadedb.server.defaultDatabases=Imported[root]{import:https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz}"

 █████╗ ██████╗  ██████╗ █████╗ ██████╗ ███████╗██████╗ ██████╗
██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔══██╗
███████║██████╔╝██║     ███████║██║  ██║█████╗  ██║  ██║██████╔╝
██╔══██║██╔══██╗██║     ██╔══██║██║  ██║██╔══╝  ██║  ██║██╔══██╗
██║  ██║██║  ██║╚██████╗██║  ██║██████╔╝███████╗██████╔╝██████╔╝
╚═╝  ╚═╝╚═╝  ╚═╝ ╚═════╝╚═╝  ╚═╝╚═════╝ ╚══════╝╚═════╝ ╚═════╝
PLAY WITH DATA                                    arcadedb.com
removing old pid file /Users/rfranchini/Downloads/arcadedb-22.2.1/bin/arcadedb.pid

2022-05-12 09:24:18.060 INFO  [ArcadeDBServer] <ArcadeDB_0> ArcadeDB Server v22.2.1 (build d204f6e5e97e4aa972b4e78ce20ffa3a8367497f/1645632123773/main) is starting up...
2022-05-12 09:24:18.067 INFO  [ArcadeDBServer] <ArcadeDB_0> Starting ArcadeDB Server with plugins [] ...
2022-05-12 09:24:18.078 INFO  [ArcadeDBServer] <ArcadeDB_0> - JMX Metrics Started...
2022-05-12 09:24:18.114 INFO  [ArcadeDBServer] <ArcadeDB_0> Creating default database 'Imported'...
2022-05-12 09:24:18.291 INFO  [SourceDiscovery] <ArcadeDB_0> Analyzing url: https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz...
2022-05-12 09:24:19.066 INFO  [SourceDiscovery] <ArcadeDB_0> Recognized format OrientDB (parsingLimitBytes=9.54MB parsingLimitEntries=0)
2022-05-12 09:24:19.067 INFO  [Importer] <ArcadeDB_0> Checking schema...Importing OrientDB database from stream to '../databases/Imported'
Creation of the schema: types, properties and indexes
- Created type 'V' with the following properties {}
- Created type 'Beer' with the following properties {id=INTEGER}
- Created type 'Brewery' with the following properties {id=INTEGER}
- Created type 'Category' with the following properties {id=INTEGER}
- Created type 'E' with the following properties {}
- Created type 'HasBrewery' with the following properties {}
- Created type 'HasCategory' with the following properties {}
- Created type 'HasStyle' with the following properties {}
- Created type 'Style' with the following properties {id=INTEGER}
- Created index UNIQUE on Beer[id]
- Created index UNIQUE on Brewery[id]
- Created index UNIQUE on Style[id]
- Created index UNIQUE on Category[id]
Creation of records started: creating vertices and documents records (edges on the next phase)
- Creation of records completed: created 7,467 vertices and 0 documents, skipped 14,908 edges (7,467 records/sec elapsed=1 secs)
Creation of edges started: creating edges between vertices
- Creation of edges completed: created 14,908 edges {HasStyle=4433, HasBrewery=5901, HasCategory=4574} (14,908 edges/sec elapsed=1 secs)
Dropping empty 'V' base vertex type (in OrientDB all the vertices have their own class
Dropping empty 'E' base edge type (in OrientDB all the edges have their own class
***************************************************************************************************
Import of OrientDB database completed in 1 secs with 0 errors and 0 warnings.

SUMMARY

- Records..................................: 7,484
-- Beer                                    : 5,901
-- Brewery                                 : 1,414
-- Category                                : 11
-- E                                       : 0
-- HasBrewery                              : 5,901
-- HasCategory                             : 4,574
-- HasStyle                                : 4,433
-- OFunction                               : 0  (excluded)
-- OIdentity                               : 0  (excluded)
-- ORestricted                             : 0  (excluded)
-- ORole                                   : 3  (excluded)
-- OSchedule                               : 0  (excluded)
-- OSecurityPolicy                         : 4  (excluded)
-- OSequence                               : 0  (excluded)
-- OTriggered                              : 0  (excluded)
-- OUser                                   : 3  (excluded)
-- Style                                   : 141
-- V                                       : 0
-- _studio                                 : 7  (excluded)
- Total attributes.........................: 513,424
***************************************************************************************************

NOTES:
- users stored in OUser class will not be imported because ArcadeDB has users only at server level. If you want to import such users into ArcadeDB server configuration, please run the importer with the option -s <securityFileDirectory>
- you can find your new ArcadeDB database in '../databases/Imported'
- Status update: parsed 0 (0/sec) - 0 documents (0/sec) - 7,467 vertices (3,733/sec) - 14,908 edges (7,454/sec) - 0 skipped edges - 0 linked edges (0/sec - 0%)

2022-05-12 09:24:21.263 INFO  [HttpServer] <ArcadeDB_0> - Starting HTTP Server (host=0.0.0.0 port=2480-2489)...
2022-05-12 09:24:21.298 INFO  [undertow] starting server: Undertow - 2.2.16.Final
2022-05-12 09:24:21.305 INFO  [xnio] XNIO version 3.8.6.Final
2022-05-12 09:24:21.314 INFO  [nio] XNIO NIO Implementation Version 3.8.6.Final
2022-05-12 09:24:21.338 INFO  [threads] JBoss Threads version 3.1.0.Final
2022-05-12 09:24:21.378 INFO  [HttpServer] <ArcadeDB_0> - HTTP Server started (host=0.0.0.0 port=2480)
2022-05-12 09:24:21.379 INFO  [ArcadeDBServer] <ArcadeDB_0> Available query languages: [mongo, gremlin, cypher, graphql, sql]
2022-05-12 09:24:21.379 INFO  [ArcadeDBServer] <ArcadeDB_0> ArcadeDB Server started (CPUs=12 MAXRAM=8.00GB)
2022-05-12 09:24:21.380 INFO  [ArcadeDBServer] <ArcadeDB_0> Studio web tool available at http://localhost:2480 

then, going to http://localhost:2480 and executing a cypher query:

[lvca]

@corradomio Did you resolve?

[lvca]

Closing the issue because of no feedback from the author. If you're still working on this issue, please comment to have this reopened. Thanks.