[Bug] Use mysql be the backend,server can't startup,bacause SQL syntax error

Abierto

#2,718 abierto el 2/1/2025 1 comentario 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 1 día

Nadie ha tomado este issue todavía.

Evaluación

Dificultad: 4/5
Tiempo estimado: 3-5 días
Aptitud para principiantes: 32/100

Tipo de issue: Error
Claridad: Necesita aclaración
Estado de actividad: Estancado
Stack tecnológico: java, mysql
Área: backend, databases

Línea de trabajo

Reproduzca el fallo de inicio con MySQL 8.0.40 e inspeccione la consulta indicada por ServerInfoManager.java:339 durante la inicialización de la información del servidor. Rastree las llamadas del backend desde StandardHugeGraph.serverStarted y MysqlSessions, y confirme después que HugeGraphServer se inicia correctamente sin la excepción del backend indicada.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

bug

Bug Type (问题类型)

other exception / error (其他异常报错)

Before submit

我已经确认现有的 Issues 与 FAQ 中没有相同 / 重复问题 (I have confirmed and searched that there are no similar problems in the historical issue and documents)

Environment (环境信息)

Server Version: 1.5.0
Backend: MysSQL x nodes, SSD
OS:
处理器 Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz 3.19 GHz
机带 RAM 16.0 GB (15.8 GB 可用)
系统类型 64 位操作系统, 基于 x64 的处理器
版本 Windows 10 企业版
版本号 22H2
Data Size: just init
-MySQL Ver 8.0.40 for Win64 on x86_64 (MySQL Community Server - GPL)
-MySQL Driver mysql-connector-java-8.0.28

Expected & Actual behavior (期望与实际表现)

the error is

liberica-full-11.0.25\bin\java.exe "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2024.3.1\lib\idea_rt.jar=58049:C:\Program Files\JetBrains\IntelliJ IDEA 2024.3.1\bin" -Dfile.encoding=UTF-8 @C:\xxx org.apache.hugegraph.dist.HugeGraphServer conf/gremlin-server.yaml conf/rest-server.properties
2025-01-02 14:44:38 [main] [INFO] o.a.h.s.RestServer - RestServer starting...
1月 02, 2025 2:44:40 下午 org.glassfish.grizzly.http.server.NetworkListener start
信息: Started listener bound to [127.0.0.1:8080]
2025-01-02 14:44:40 [main] [INFO] o.a.h.u.ConfigUtil - Scanning option 'graphs' directory './conf/graphs'
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=false&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=true&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.c.CacheManager - Init RamCache for 'schema-id-hugegraph' with capacity 10000
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.c.CacheManager - Init RamCache for 'schema-name-hugegraph' with capacity 10000
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=false&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:41 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=true&maxReconnects=3&initialTimeout=3&useSSL=true'
main dict load finished, time elapsed 638 ms
model load finished, time elapsed 63 ms.
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=false&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=true&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.c.o.l.Uns - OHC using JNA OS native malloc/free
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.c.CacheManager - Init LevelCache for 'vertex-hugegraph' with capacity 10000:10000000
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.c.CacheManager - Init LevelCache for 'edge-hugegraph' with capacity 1000:1000000
2025-01-02 14:44:42 [main] [INFO] o.a.h.t.TaskManager - Use local as the scheduler of graph (hugegraph)
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.c.CacheManager - Init RamCache for 'users-hugegraph' with capacity 10240
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.c.CacheManager - Init RamCache for 'users_pwd-hugegraph' with capacity 10240
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.c.CacheManager - Init RamCache for 'token-hugegraph' with capacity 10240
2025-01-02 14:44:42 [main] [INFO] o.a.h.c.GraphManager - Graph 'hugegraph' was successfully configured via '.\conf\graphs\hugegraph.properties'
2025-01-02 14:44:42 [main] [INFO] o.a.h.c.GraphManager - RpcServer is not enabled, skip starting rpc service
2025-01-02 14:44:42 [main] [INFO] o.a.h.c.GraphManager - RpcServer is not enabled, skip wait graphs ready
2025-01-02 14:44:42 [main] [INFO] o.a.h.c.GraphManager - Check backend version
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?socketTimeout=0&useSSL=true'
2025-01-02 14:44:42 [main] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/?socketTimeout=0&useSSL=true'
2025-01-02 14:44:43 [main] [INFO] o.a.h.c.GraphManager - Unconfigured authenticator, please config auth.authenticator option in rest-server.properties, does not support role election currently
2025-01-02 14:44:43 [main] [INFO] o.a.h.StandardHugeGraph - Init system info for graph 'hugegraph'
2025-01-02 14:44:43 [main] [INFO] o.a.h.StandardHugeGraph - Init server info [server-1-MASTER] for graph 'hugegraph'...
2025-01-02 14:44:43 [server-info-db-worker-1] [INFO] o.a.h.b.s.m.MysqlSessions - Connect to the jdbc url: 'jdbc:mysql://127.0.0.1:3306/hugegraph?characterEncoding=utf-8&rewriteBatchedStatements=true&useServerPrepStmts=false&autoReconnect=true&maxReconnects=3&initialTimeout=3&useSSL=true'
2025-01-02 14:44:43 [main] [INFO] o.a.h.StandardHugeGraph - Close graph standardhugegraph[hugegraph]
1月 02, 2025 2:44:43 下午 org.glassfish.grizzly.http.server.NetworkListener shutdownNow
信息: Stopped listener bound to [127.0.0.1:8080]
Exception in thread "main" org.apache.hugegraph.HugeException: Failed to update/query server info: java.util.concurrent.ExecutionException: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at org.apache.hugegraph.task.ServerInfoManager.call(ServerInfoManager.java:339)
	at org.apache.hugegraph.task.ServerInfoManager.serverInfo(ServerInfoManager.java:352)
	at org.apache.hugegraph.task.ServerInfoManager.initServerInfo(ServerInfoManager.java:108)
	at org.apache.hugegraph.StandardHugeGraph.serverStarted(StandardHugeGraph.java:297)
	at org.apache.hugegraph.core.GraphManager.serverStarted(GraphManager.java:484)
	at org.apache.hugegraph.core.GraphManager.init(GraphManager.java:125)
	at org.apache.hugegraph.server.ApplicationConfig$GraphManagerFactory$1.onEvent(ApplicationConfig.java:143)
	at org.glassfish.jersey.server.internal.monitoring.CompositeApplicationEventListener.onEvent(CompositeApplicationEventListener.java:49)
	at org.glassfish.jersey.server.internal.monitoring.MonitoringContainerListener.onStartup(MonitoringContainerListener.java:56)
	at org.glassfish.jersey.server.ApplicationHandler.onStartup(ApplicationHandler.java:711)
	at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.start(GrizzlyHttpContainer.java:330)
	at org.glassfish.grizzly.http.server.HttpHandlerChain.start(HttpHandlerChain.java:376)
	at org.glassfish.grizzly.http.server.HttpServer.setupHttpHandler(HttpServer.java:268)
	at org.glassfish.grizzly.http.server.HttpServer.start(HttpServer.java:245)
	at org.apache.hugegraph.server.RestServer.start(RestServer.java:70)
	at org.apache.hugegraph.server.RestServer.start(RestServer.java:177)
	at org.apache.hugegraph.dist.HugeRestServer.start(HugeRestServer.java:31)
	at org.apache.hugegraph.dist.HugeGraphServer.<init>(HugeGraphServer.java:61)
	at org.apache.hugegraph.dist.HugeGraphServer.main(HugeGraphServer.java:127)
Caused by: java.util.concurrent.ExecutionException: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
	at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)
	at org.apache.hugegraph.task.ServerInfoManager.call(ServerInfoManager.java:336)
	... 18 more
Caused by: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:482)
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:456)
	at org.apache.hugegraph.backend.store.mysql.MysqlStore.query(MysqlStore.java:277)
	at org.apache.hugegraph.backend.tx.AbstractTransaction.query(AbstractTransaction.java:161)
	at org.apache.hugegraph.backend.tx.GraphTransaction.query(GraphTransaction.java:538)
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesFromBackend(GraphTransaction.java:862)
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesByIds(GraphTransaction.java:810)
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryServerInfos(GraphTransaction.java:765)
	at org.apache.hugegraph.task.ServerInfoManager.lambda$serverInfo$3(ServerInfoManager.java:353)
	at org.apache.hugegraph.task.TaskManager$ContextCallable.call(TaskManager.java:497)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[pos=0 lim=9 cap=9])' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1201)
	at org.apache.hugegraph.backend.store.mysql.MysqlSessions$Session.select(MysqlSessions.java:503)
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:472)
	... 13 more
2025-01-02 14:44:43 [main] [ERROR] o.a.h.d.HugeGraphServer - HugeRestServer start error: 
org.apache.hugegraph.HugeException: Failed to update/query server info: java.util.concurrent.ExecutionException: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at org.apache.hugegraph.task.ServerInfoManager.call(ServerInfoManager.java:339) ~[classes/:?]
	at org.apache.hugegraph.task.ServerInfoManager.serverInfo(ServerInfoManager.java:352) ~[classes/:?]
	at org.apache.hugegraph.task.ServerInfoManager.initServerInfo(ServerInfoManager.java:108) ~[classes/:?]
	at org.apache.hugegraph.StandardHugeGraph.serverStarted(StandardHugeGraph.java:297) ~[classes/:?]
	at org.apache.hugegraph.core.GraphManager.serverStarted(GraphManager.java:484) ~[classes/:?]
	at org.apache.hugegraph.core.GraphManager.init(GraphManager.java:125) ~[classes/:?]
	at org.apache.hugegraph.server.ApplicationConfig$GraphManagerFactory$1.onEvent(ApplicationConfig.java:143) ~[classes/:?]
	at org.glassfish.jersey.server.internal.monitoring.CompositeApplicationEventListener.onEvent(CompositeApplicationEventListener.java:49) ~[jersey-server-3.0.3.jar:?]
	at org.glassfish.jersey.server.internal.monitoring.MonitoringContainerListener.onStartup(MonitoringContainerListener.java:56) ~[jersey-server-3.0.3.jar:?]
	at org.glassfish.jersey.server.ApplicationHandler.onStartup(ApplicationHandler.java:711) ~[jersey-server-3.0.3.jar:?]
	at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.start(GrizzlyHttpContainer.java:330) ~[jersey-container-grizzly2-http-3.0.3.jar:?]
	at org.glassfish.grizzly.http.server.HttpHandlerChain.start(HttpHandlerChain.java:376) ~[grizzly-http-server-3.0.1.jar:3.0.1]
	at org.glassfish.grizzly.http.server.HttpServer.setupHttpHandler(HttpServer.java:268) ~[grizzly-http-server-3.0.1.jar:3.0.1]
	at org.glassfish.grizzly.http.server.HttpServer.start(HttpServer.java:245) ~[grizzly-http-server-3.0.1.jar:3.0.1]
	at org.apache.hugegraph.server.RestServer.start(RestServer.java:70) ~[classes/:?]
	at org.apache.hugegraph.server.RestServer.start(RestServer.java:177) ~[classes/:?]
	at org.apache.hugegraph.dist.HugeRestServer.start(HugeRestServer.java:31) ~[classes/:?]
	at org.apache.hugegraph.dist.HugeGraphServer.<init>(HugeGraphServer.java:61) ~[classes/:?]
	at org.apache.hugegraph.dist.HugeGraphServer.main(HugeGraphServer.java:127) ~[classes/:?]
Caused by: java.util.concurrent.ExecutionException: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:?]
	at java.util.concurrent.FutureTask.get(FutureTask.java:191) ~[?:?]
	at org.apache.hugegraph.task.ServerInfoManager.call(ServerInfoManager.java:336) ~[classes/:?]
	... 18 more
Caused by: org.apache.hugegraph.backend.BackendException: Failed to query [`Query * from VERTEX where id in [0x877365727665722d31]`]
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:482) ~[classes/:?]
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:456) ~[classes/:?]
	at org.apache.hugegraph.backend.store.mysql.MysqlStore.query(MysqlStore.java:277) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.AbstractTransaction.query(AbstractTransaction.java:161) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.query(GraphTransaction.java:538) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesFromBackend(GraphTransaction.java:862) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesByIds(GraphTransaction.java:810) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryServerInfos(GraphTransaction.java:765) ~[classes/:?]
	at org.apache.hugegraph.task.ServerInfoManager.lambda$serverInfo$3(ServerInfoManager.java:353) ~[classes/:?]
	at org.apache.hugegraph.task.TaskManager$ContextCallable.call(TaskManager.java:497) ~[classes/:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[pos=0 lim=9 cap=9])' at line 1
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1201) ~[mysql-connector-java-8.0.28.jar:8.0.28]
	at org.apache.hugegraph.backend.store.mysql.MysqlSessions$Session.select(MysqlSessions.java:503) ~[classes/:?]
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:472) ~[classes/:?]
	at org.apache.hugegraph.backend.store.mysql.MysqlTable.query(MysqlTable.java:456) ~[classes/:?]
	at org.apache.hugegraph.backend.store.mysql.MysqlStore.query(MysqlStore.java:277) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.AbstractTransaction.query(AbstractTransaction.java:161) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.query(GraphTransaction.java:538) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesFromBackend(GraphTransaction.java:862) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryVerticesByIds(GraphTransaction.java:810) ~[classes/:?]
	at org.apache.hugegraph.backend.tx.GraphTransaction.queryServerInfos(GraphTransaction.java:765) ~[classes/:?]
	at org.apache.hugegraph.task.ServerInfoManager.lambda$serverInfo$3(ServerInfoManager.java:353) ~[classes/:?]
	at org.apache.hugegraph.task.TaskManager$ContextCallable.call(TaskManager.java:497) ~[classes/:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
	at java.lang.Thread.run(Thread.java:829) ~[?:?]
2025-01-02 14:44:43 [main] [INFO] o.a.h.HugeFactory - HugeFactory shutdown
2025-01-02 14:44:43 [hugegraph-shutdown] [INFO] o.a.h.HugeFactory - HugeGraph is shutting down

init not cause problem,but server can't run

Vertex/Edge example (问题点 / 边数据举例)

No response

Schema [VertexLabel, EdgeLabel, IndexLabel] (元数据结构)

No response

Lenguaje dominante: Java
Estrellas: 3.2k
Forks: 640
Merge medio: 1 d 7 h
PR fusionados (30 d): 88

Preparar el entorno

Sin Dockerfile ni archivo de Docker Compose
Tiene una plantilla de pull request
Leer la guía de contribución

Primeros pasos

Lee el issue completo y luego la guía de contribución del proyecto.
Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
Haz un fork del repositorio y trabaja en una rama.
Abre un pull request que haga referencia al número del issue.

Más de apache/hugegraph

[Bug] PD task REST: balanceLeaders throws a bare HTTP 500 during the balance-shard window, and task responses cannot be told apart from a no-op or a follower answer
Posiblemente ocupada @pallavithegod la tomó hace 3 días. Abierto
- ¿Algo no está bien?
Dificultad 2/5 1-3 horas Aptitud para principiantes 70/100

apache/hugegraph#3231 · 2 comentarios · Abierto el 23/9/2026

Los mantenedores suelen responder en 1 día
[Task] Establish systematic performance baselines and optimization tracking
Posiblemente ocupada @contrueCT la tomó hace 3 días. Abierto
- ¿Algo no está bien?
help wanted improvement rust

Dificultad 5/5 Más de una semana Aptitud para principiantes 12/100

apache/hugegraph#3346 · 2 comentarios · 1 reacción · Abierto el 14/10/2026

Los mantenedores suelen responder en 1 día
[Bug] Cypher endpoint rejects the standard date() function as unknown
Posiblemente ocupada @Mihir-Rabari la tomó hace 2 días. Abierto
- ¿Algo no está bien?
bug

Dificultad 4/5 3-5 días Aptitud para principiantes 52/100

apache/hugegraph#3318 · Abierto el 12/10/2026

Los mantenedores suelen responder en 1 día
[Bug] CI accepts obsolete PR targets after retargeting or force-push
Quizá libre de nuevo Un pull request para esta issue se cerró sin fusionarse. Abierto
- ¿Algo no está bien?
Dificultad 3/5 1-2 días Aptitud para principiantes 25/100

apache/hugegraph#3296 · Abierto el 9/10/2026

Los mantenedores suelen responder en 1 día
[Feature] Server image: map server.urls_to_pd and server.deploy_in_k8s from the environment, and stop editing conf files in place
Abierto
- ¿Algo no está bien?
Dificultad 4/5 3-5 días Aptitud para principiantes 48/100

apache/hugegraph#3286 · Abierto el 7/10/2026

Los mantenedores suelen responder en 1 día

Todos los issues de apache/hugegraph

Issues similares

[Bug] dubbo.protocol.triple.max-message-size is only read from OS environment variables
Posiblemente ocupada @CCCLL la tomó hoy. Abierto
- ¿Algo no está bien?
Dificultad 2/5 1-3 horas Aptitud para principiantes 72/100

apache/dubbo#16517 · Abierto el 19/10/2026

Los mantenedores suelen responder en 1 día
Upgrade to Bouncy Castle 1.86 to avoid vulnerabilities
Abierto
- ¿Algo no está bien?
Dificultad 2/5 1-3 horas Aptitud para principiantes 64/100

hierynomus/sshj#1070 · Abierto el 19/10/2026
Unexpected-log test failures drop the attachments an error is logged with
Abierto
- ¿Algo no está bien?
Dificultad 2/5 1-3 horas Aptitud para principiantes 84/100

intellij-elixir/intellij-elixir#4492 · Abierto el 19/10/2026

Los mantenedores suelen responder en 1 día
NullPointerException in AsciiDocLinkIndex on broken symlinks triggers an endless index rebuild loop (high CPU, IDE unresponsive)
Abierto
- ¿Algo no está bien?
bug

Dificultad 2/5 1-3 horas Aptitud para principiantes 77/100

asciidoctor/asciidoctor-intellij-plugin#2130 · Abierto el 19/10/2026
[Server] OpenAPI 3.1 YAML specs generate Object fields: resolveToJSON drops every schema type
Abierto
- ¿Algo no está bien?
Dificultad 2/5 1-3 horas Aptitud para principiantes 76/100

quarkiverse/quarkus-openapi-generator#1796 · 1 comentario · Abierto el 19/10/2026

Más issues de Java

[Bug] Use mysql be the backend,server can't startup,bacause SQL syntax error

¿Algo no está bien?

Evaluación

Línea de trabajo

Descripción

Bug Type (问题类型)

Before submit

Environment (环境信息)

Expected & Actual behavior (期望与实际表现)

Vertex/Edge example (问题点 / 边数据举例)

Schema [VertexLabel, EdgeLabel, IndexLabel] (元数据结构)

Preparar el entorno

Primeros pasos

Más de apache/hugegraph

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

Issues similares

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

¿Algo no está bien?

Recibe los nuevos issues en tu correo