KAG icon indicating copy to clipboard operation
KAG copied to clipboard

Published 20 hours ago • verified publisher icon OpenSPG

[Bug] [Module Name] Bug title

Open nicolashw opened this issue 1 month ago • 0 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

Operating system information

Linux

What happened

use docker https://raw.githubusercontent.com/OpenSPG/openspg/refs/heads/master/dev/release/docker-compose-west.yml to init, and when i create a new knowledger base, it occurs.

unknown error Unsupported administration command: CREATE DATABASE taskon IF NOT EXISTS

and the backend error: 2025-01-13 18:46:09,812 [] [] [http-nio-8887-exec-3] ERROR c.a.o.s.a.h.s.HttpBizTemplate - execute http biz callback unknown error org.neo4j.driver.exceptions.ClientException: Unsupported administration command: CREATE DATABASE mytest IF NOT EXISTS at org.neo4j.driver.internal.util.Futures.blockingGet(Futures.java:111) at org.neo4j.driver.internal.InternalTransaction.run(InternalTransaction.java:58) at org.neo4j.driver.internal.AbstractQueryRunner.run(AbstractQueryRunner.java:34) at org.neo4j.driver.internal.AbstractQueryRunner.run(AbstractQueryRunner.java:49) at com.antgroup.openspg.common.util.neo4j.Neo4jGraphUtils.lambda$createDatabase$5(Neo4jGraphUtils.java:254) at org.neo4j.driver.internal.InternalSession.lambda$transaction$4(InternalSession.java:137) at org.neo4j.driver.internal.retry.ExponentialBackoffRetryLogic.retry(ExponentialBackoffRetryLogic.java:106) at org.neo4j.driver.internal.InternalSession.transaction(InternalSession.java:134) at org.neo4j.driver.internal.InternalSession.writeTransaction(InternalSession.java:113) at org.neo4j.driver.internal.InternalSession.writeTransaction(InternalSession.java:108) at com.antgroup.openspg.common.util.neo4j.Neo4jGraphUtils.createDatabase(Neo4jGraphUtils.java:252) at com.antgroup.openspg.server.biz.common.impl.ProjectManagerImpl.setGraphStore(ProjectManagerImpl.java:210) at com.antgroup.openspg.server.biz.common.impl.ProjectManagerImpl.create(ProjectManagerImpl.java:68) at com.antgroup.openspgapp.api.http.server.project.ProjectsController$3.action(ProjectsController.java:217) at com.antgroup.openspgapp.api.http.server.project.ProjectsController$3.action(ProjectsController.java:192) at com.antgroup.openspg.server.api.http.server.HttpBizTemplate.execute2(HttpBizTemplate.java:78) at com.antgroup.openspgapp.api.http.server.project.ProjectsController.create(ProjectsController.java:191) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:696) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:779) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.antgroup.openspgapp.api.http.server.filter.AclFilter.doFilter(AclFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at com.alipay.sofa.tracer.plugins.springmvc.SpringMvcSofaTracerFilter.doFilter(SpringMvcSofaTracerFilter.java:87) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:750) Suppressed: org.neo4j.driver.internal.util.ErrorUtil$InternalExceptionCause: null at org.neo4j.driver.internal.util.ErrorUtil.newNeo4jError(ErrorUtil.java:76) at org.neo4j.driver.internal.async.inbound.InboundMessageDispatcher.handleFailureMessage(InboundMessageDispatcher.java:107) at org.neo4j.driver.internal.messaging.common.CommonMessageReader.unpackFailureMessage(CommonMessageReader.java:75) at org.neo4j.driver.internal.messaging.common.CommonMessageReader.read(CommonMessageReader.java:53) at org.neo4j.driver.internal.async.inbound.InboundMessageHandler.channelRead0(InboundMessageHandler.java:81) at org.neo4j.driver.internal.async.inbound.InboundMessageHandler.channelRead0(InboundMessageHandler.java:37) at org.neo4j.driver.internal.shaded.io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:99) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) at org.neo4j.driver.internal.async.inbound.MessageDecoder.channelRead(MessageDecoder.java:42) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:333) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:454) at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:290) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at org.neo4j.driver.internal.shaded.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at org.neo4j.driver.internal.shaded.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at org.neo4j.driver.internal.shaded.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) at org.neo4j.driver.internal.shaded.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ... 1 common frames omitted

the database connection log seems ok. 2025-01-13 18:33:28,119 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - scheduler.handler.type=db 2025-01-13 18:33:28,119 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - scheduler.metadata.store.type=db 2025-01-13 18:33:28,120 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - schema.uri=http://127.0.0.1:8887 2025-01-13 18:33:28,121 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.port=8887 2025-01-13 18:33:28,122 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.driver=com.mysql.jdbc.Driver 2025-01-13 18:33:28,122 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.host=mysql 2025-01-13 18:33:28,123 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.password=openspg 2025-01-13 18:33:28,138 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.port=3306 2025-01-13 18:33:28,138 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.url=jdbc:mysql://mysql:3306/openspg?useUnicode=true&characterEncoding=utf8&autoReconnect=true 2025-01-13 18:33:28,141 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - server.repository.impl.jdbc.username=root 2025-01-13 18:33:28,142 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sofa-boot.formatted-version= (v3.17.0) 2025-01-13 18:33:28,143 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sofa-boot.version=3.17.0 2025-01-13 18:33:28,143 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - spring.application.name=openspgapp 2025-01-13 18:33:28,143 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - spring.beaninfo.ignore=true 2025-01-13 18:33:28,144 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - spring.main.allow-circular-references=true 2025-01-13 18:33:28,144 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - spring.servlet.multipart.max-file-size=100GB 2025-01-13 18:33:28,144 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - spring.servlet.multipart.max-request-size=100GB 2025-01-13 18:33:28,145 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.arch.data.model=64 2025-01-13 18:33:28,147 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.boot.class.path=/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/resources.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/rt.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jsse.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jce.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/charsets.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jfr.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/classes 2025-01-13 18:33:28,147 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.boot.library.path=/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/amd64 2025-01-13 18:33:28,148 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.cpu.endian=little 2025-01-13 18:33:28,148 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.cpu.isalist= 2025-01-13 18:33:28,148 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.io.unicode.encoding=UnicodeLittle 2025-01-13 18:33:28,149 [] [] [main] INFO c.a.o.s.a.s.EnvironmentPropertiesPrinter - sun.java.command=arks-sofaboot-0.0.1-SNAPSHOT-executable.jar java -Dfile.encoding=UTF-8 -Xms2048m -Xmx8192m -jar arks-sofaboot-0.0.1-SNAPSHOT-executable.jar --server.repository.impl.jdbc.host=mysql --server.repository.impl.jdbc.password=openspg --builder.model.execute.num=5 --cloudext.graphstore.url=neo4j://release-openspg-neo4j:7687?user=neo4j&password=neo4j@openspg&database=neo4j --cloudext.searchengine.url=neo4j://release-openspg-neo4j:7687?user=neo4j&password=neo4j@openspg&database=neo4j

How to reproduce

everything new and create a new Knowledge Base, it reports:

Are you willing to submit PR?

  • [X] Yes I am willing to submit a PR!

nicolashw avatar Jan 13 '25 10:01 nicolashw