Repository navigation
ALIGN DATABASE not working #591
Description
ArcadeDB Version: v22.9.1 (build d082adc/1664822987697/main)
JDK Version: openjdk 11.0.16 2022-07-19
OS: Ubuntu 20.04
Expected behavior
?
Actual behavior
ERROR: Align Database not supported
Trace
<ArcadeDB_0> Error on command execution (PostCommandHandler)
java.lang.UnsupportedOperationException: Align Database not supported
at com.arcadedb.database.EmbeddedDatabase.alignToReplicas(EmbeddedDatabase.java:1457)
at com.arcadedb.query.sql.parser.AlignDatabaseStatement.executeSimple(AlignDatabaseStatement.java:50)
at com.arcadedb.query.sql.executor.SingleOpExecutionPlan.executeInternal(SingleOpExecutionPlan.java:115)
at com.arcadedb.query.sql.executor.ScriptLineStep.syncPull(ScriptLineStep.java:53)
at com.arcadedb.query.sql.executor.ScriptExecutionPlan.doExecute(ScriptExecutionPlan.java:97)
at com.arcadedb.query.sql.executor.ScriptExecutionPlan.fetchNext(ScriptExecutionPlan.java:57)
at com.arcadedb.query.sql.parser.LocalResultSet.fetchNext(LocalResultSet.java:46)
at com.arcadedb.query.sql.parser.LocalResultSet.<init>(LocalResultSet.java:40)
at com.arcadedb.database.EmbeddedDatabase.executeInternal(EmbeddedDatabase.java:1296)
at com.arcadedb.database.EmbeddedDatabase.execute(EmbeddedDatabase.java:1244)
at com.arcadedb.server.ServerDatabase.execute(ServerDatabase.java:415)
at com.arcadedb.server.http.handler.PostCommandHandler.executeScript(PostCommandHandler.java:100)
at com.arcadedb.server.http.handler.PostCommandHandler.execute(PostCommandHandler.java:71)
at com.arcadedb.server.http.handler.DatabaseAbstractHandler.execute(DatabaseAbstractHandler.java:85)
at com.arcadedb.server.http.handler.AbstractHandler.handleRequest(AbstractHandler.java:111)
at io.undertow.server.RoutingHandler.handleRequest(RoutingHandler.java:93)
at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
at io.undertow.server.protocol.http.HttpReadListener.handleEventWithNoRunningRequest(HttpReadListener.java:256)
at io.undertow.server.protocol.http.HttpReadListener.handleEvent(HttpReadListener.java:136)
at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:162)
at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:100)
at io.undertow.server.protocol.http.HttpOpenListener.handleEvent(HttpOpenListener.java:57)
at org.xnio.ChannelListeners.invokeChannelListener(ChannelListeners.java:92)
at org.xnio.ChannelListeners$10.handleEvent(ChannelListeners.java:291)
at org.xnio.ChannelListeners$10.handleEvent(ChannelListeners.java:286)
at org.xnio.ChannelListeners.invokeChannelListener(ChannelListeners.java:92)
at org.xnio.nio.QueuedNioTcpServer2.acceptTask(QueuedNioTcpServer2.java:178)
at org.xnio.nio.WorkerThread.safeRun(WorkerThread.java:612)
at org.xnio.nio.WorkerThread.run(WorkerThread.java:479)
Steps to reproduce
ALIGN DATABASE
on a single server, using either console or studio.
If this command depends on certain conditions, such as at least one follower exists, then this should be added to the documentation.
Activity
gramian commentedon Nov 3, 2022
Further testing results: If the HA module is enabled,
ALIGN DATABASEcan be used from the studio, but not from the console (Error in consoleERROR: Align Database not supported, no resulting server error though).Update SQL-Align-Database.adoc
lvca commentedon Nov 6, 2022
ALIGN DATABASE makes sense only in a distributed setup. I've added a note in ALIGN DATABASE command docs. About the issue with the console, the command should be fully supported: all the commands go through the HTTP server request. Did you connect the console remotely to the database?
gramian commentedon Nov 6, 2022
I used the console locally.
However, the clear remark in the docu should resolve this.
chore(studio-deps-dev)(deps-dev): bump enhanced-resolve from 5.21.3 t…
chore(studio-deps-dev)(deps-dev): bump enhanced-resolve from 5.21.3 t…