Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ArcadeDB-Studio With Gremlin-Server No Longer Accessible Upon Its Docker-Container Restart #1106

Closed
ZachMurray opened this issue May 31, 2023 · 5 comments
Closed

ArcadeDB-Studio With Gremlin-Server No Longer Accessible Upon Its Docker-Container Restart #1106

ZachMurray opened this issue May 31, 2023 · 5 comments
Assignees
@lvca
Labels
question Further information is requested waiting for user
Milestone
23.6.1

Comments

@ZachMurray
Copy link

ArcadeDB Version:

ArcadeDB Server v23.3.1-SNAPSHOT (build 0393db01efcce6d393482991ff18b330970081ef/1678969633791/main)

OS and JDK Version:

Running on Linux 5.10.102.1-microsoft-standard-WSL2 - OpenJDK 64-Bit Server VM Temurin-11.0.18+10

Expected behavior

ArcadeDB-Studio would be accessible upon startup-restart.
I expected to see the webpage load like I saw before when I was first using ArcadeDB.

Actual behavior

Unable to access ArcadeDB-Studio upon its Docker-container restart.

This page isn’t working
localhost didn’t send any data.
ERR_EMPTY_RESPONSE

Steps to reproduce

  1. Create a ArcadeDB-Docker-instance with Gremlin-Server-Plugin turned-on
  2. Verify ArcadeDB-Studio opens up properly
  3. Stop the ArcadeDB
  4. Restart, Stop-Restart, Stop-Start ArcadeDB-container with Docker-UI
  5. See that ArcadeDB-Studio is no longer loading and other APIs aren't working as expected either

log output

2023-05-31 07:34:46  █████╗ ██████╗  ██████╗ █████╗ ██████╗ ███████╗██████╗ ██████╗
2023-05-31 07:34:46 ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔══██╗
2023-05-31 07:34:46 ███████║██████╔╝██║     ███████║██║  ██║█████╗  ██║  ██║██████╔╝
2023-05-31 07:34:46 ██╔══██║██╔══██╗██║     ██╔══██║██║  ██║██╔══╝  ██║  ██║██╔══██╗
2023-05-31 07:34:46 ██║  ██║██║  ██║╚██████╗██║  ██║██████╔╝███████╗██████╔╝██████╔╝
2023-05-31 07:34:46 ╚═╝  ╚═╝╚═╝  ╚═╝ ╚═════╝╚═╝  ╚═╝╚═════╝ ╚══════╝╚═════╝ ╚═════╝
2023-05-31 07:34:46 PLAY WITH DATA                                    arcadedb.com
2023-05-31 07:34:46 removing old pid file /home/arcadedb/bin/arcadedb.pid
2023-05-31 07:34:46 
2023-05-31 07:34:46 2023-05-31 12:34:46.796 INFO  [ArcadeDBServer] <ArcadeDB_0> ArcadeDB Server v23.3.1-SNAPSHOT (build 0393db01efcce6d393482991ff18b330970081ef/1678969633791/main) is starting up...
2023-05-31 07:34:46 2023-05-31 12:34:46.807 INFO  [ArcadeDBServer] <ArcadeDB_0> Running on Linux 5.10.102.1-microsoft-standard-WSL2 - OpenJDK 64-Bit Server VM Temurin-11.0.18+10
2023-05-31 07:34:46 2023-05-31 12:34:46.807 INFO  [ArcadeDBServer] <ArcadeDB_0> Starting ArcadeDB Server in development mode with plugins [Redis, MongoDB, Postgres, GremlinServer] ...
2023-05-31 07:34:47 2023-05-31 12:34:46.819 INFO  [ArcadeDBServer] <ArcadeDB_0> - JMX Metrics Started...
2023-05-31 07:34:48 2023-05-31 12:34:47.632 INFO  [SourceDiscovery] <ArcadeDB_0> Analyzing url: https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz...
2023-05-31 07:34:48 2023-05-31 12:34:48.312 INFO  [SourceDiscovery] <ArcadeDB_0> Recognized format OrientDB (parsingLimitBytes=9.54MB parsingLimitEntries=0)
2023-05-31 07:34:49 Importing OrientDB database from stream to './databases/Imported'
2023-05-31 07:34:49 Creation of the schema: types, properties and indexes
2023-05-31 07:34:49 - Created index UNIQUE on Beer[id]
2023-05-31 07:34:49 - Created index UNIQUE on Brewery[id]
2023-05-31 07:34:49 - Created index UNIQUE on Style[id]
2023-05-31 07:34:49 - Created index UNIQUE on Category[id]
2023-05-31 07:34:49 Creation of records started: creating vertices and documents records (edges on the next phase)
2023-05-31 07:34:49 2023-05-31 12:34:48.312 INFO  [Importer] <ArcadeDB_0> Checking schema...Exception in thread "main" com.arcadedb.exception.CommandExecutionException: Error on importing database
2023-05-31 07:34:49 - Status update: parsed 9,997 (9,997/sec) - 0 documents (0/sec) - 5,417 vertices (5,417/sec) - 0 edges (0/sec) - 0 skipped edges - 0 linked edges (0/sec - 0%)
2023-05-31 07:34:49     at com.arcadedb.query.sql.parser.ImportDatabaseStatement.executeSimple(ImportDatabaseStatement.java:69)
2023-05-31 07:34:49     at com.arcadedb.query.sql.executor.SingleOpExecutionPlan.executeInternal(SingleOpExecutionPlan.java:91)
2023-05-31 07:34:49     at com.arcadedb.query.sql.parser.SimpleExecStatement.execute(SimpleExecStatement.java:52)
2023-05-31 07:34:49     at com.arcadedb.query.sql.parser.Statement.execute(Statement.java:77)
2023-05-31 07:34:49     at com.arcadedb.query.sql.parser.Statement.execute(Statement.java:61)
2023-05-31 07:34:49     at com.arcadedb.query.sql.SQLQueryEngine.command(SQLQueryEngine.java:104)
2023-05-31 07:34:49     at com.arcadedb.database.EmbeddedDatabase.command(EmbeddedDatabase.java:1257)
2023-05-31 07:34:49     at com.arcadedb.server.ServerDatabase.command(ServerDatabase.java:416)
2023-05-31 07:34:49     at com.arcadedb.server.ArcadeDBServer.loadDefaultDatabases(ArcadeDBServer.java:495)
2023-05-31 07:34:49     at com.arcadedb.server.ArcadeDBServer.start(ArcadeDBServer.java:139)
2023-05-31 07:34:49     at com.arcadedb.server.ArcadeDBServer.main(ArcadeDBServer.java:92)
2023-05-31 07:34:49 Caused by: com.arcadedb.integration.importer.ImportException: Error on parsing source 'https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz (compressed=true size=1085781)'
2023-05-31 07:34:49     at com.arcadedb.integration.importer.Importer.load(Importer.java:63)
2023-05-31 07:34:49     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2023-05-31 07:34:49     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2023-05-31 07:34:49     at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2023-05-31 07:34:49     at java.base/java.lang.reflect.Method.invoke(Method.java:566)
2023-05-31 07:34:49     at com.arcadedb.query.sql.parser.ImportDatabaseStatement.executeSimple(ImportDatabaseStatement.java:61)
2023-05-31 07:34:49     ... 10 more
2023-05-31 07:34:49 Caused by: com.arcadedb.exception.DuplicatedKeyException: Duplicated key [1] found on index 'Category[id]' already assigned to record #73:0
2023-05-31 07:34:49     at com.arcadedb.database.TransactionIndexContext.checkUniqueIndexKeys(TransactionIndexContext.java:344)
2023-05-31 07:34:49     at com.arcadedb.database.TransactionIndexContext.checkUniqueIndexKeys(TransactionIndexContext.java:379)
2023-05-31 07:34:49     at com.arcadedb.database.TransactionIndexContext.commit(TransactionIndexContext.java:161)
2023-05-31 07:34:49     at com.arcadedb.database.TransactionContext.commit1stPhase(TransactionContext.java:487)
2023-05-31 07:34:49     at com.arcadedb.database.TransactionContext.commit(TransactionContext.java:114)
2023-05-31 07:34:49     at com.arcadedb.database.EmbeddedDatabase.lambda$commit$2(EmbeddedDatabase.java:356)
2023-05-31 07:34:49     at com.arcadedb.database.EmbeddedDatabase.executeInReadLock(EmbeddedDatabase.java:1326)
2023-05-31 07:34:49     at com.arcadedb.database.EmbeddedDatabase.commit(EmbeddedDatabase.java:351)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.OrientDBImporter.parseRecords(OrientDBImporter.java:341)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.OrientDBImporter.parseInputFile(OrientDBImporter.java:287)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.OrientDBImporter.run(OrientDBImporter.java:176)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.format.OrientDBImporterFormat.load(OrientDBImporterFormat.java:48)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.Importer.loadFromSource(Importer.java:93)
2023-05-31 07:34:49     at com.arcadedb.integration.importer.Importer.load(Importer.java:54)
2023-05-31 07:34:49     ... 15 more

shell command

docker run -d --name arcadeDb -p 2424:2424 -p 2480:2480 -p 8182:8182 
       --env JAVA_OPTS="-Darcadedb.server.rootPassword=playwithdata 
          -Darcadedb.server.defaultDatabases=Imported[root]{import:https://github.com/ArcadeData/arcadedb-datasets/raw/main/orientdb/OpenBeer.gz} 
          -Darcadedb.server.plugins=GremlinServer:com.arcadedb.server.gremlin.GremlinServerPlugin " 
          arcadedata/arcadedb:latest
@lvca
Copy link
Contributor

lvca commented May 31, 2023

This happens only from the 2nd time you start the docker container, right?

@lvca lvca self-assigned this May 31, 2023
@lvca lvca added this to the 23.5.1 milestone May 31, 2023
@ZachMurray
Copy link
Author

This happens only from the 2nd time you start the docker container, right?

Yes, for the Duplicate-Key-Exception.

@lvca
Copy link
Contributor

lvca commented Jun 1, 2023

Ok. I guess the issue with the recurrent importing causes the server startup to fail. What happens if you remove the importing? Does the server become available?

@lvca lvca modified the milestones: 23.5.1, 23.6.1 Jun 9, 2023
@lvca
Copy link
Contributor

lvca commented Jun 13, 2023

@ZachMurray any chance you can try my last comment?

@lvca
Copy link
Contributor

lvca commented Jun 20, 2023

Closing this issue after a while. In case, please comment here to reopen it.

@lvca lvca closed this as completed Jun 20, 2023
@lvca lvca added waiting for user question Further information is requested labels Jun 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lvca lvca

Labels
question Further information is requested waiting for user
Projects
None yet
Milestone
23.6.1
Development

No branches or pull requests
2 participants
@lvca @ZachMurray