GBase 8s
适配迁移
问答

openGauss(gaussdb)迁移gbase8s支持吗?

发表于2025-11-25 10:34:41111次浏览14个评论

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

【GBase版本】:

【操作系统】:

【CPU】:

【问题描述】*: openGauss数据库gaussdb迁移gbase8s,这个支持吗?理论上都是postgresql架构的

 

新建数据源  将gaussdb(postgresql),gbase8s配置好

任务中心 -> 新建任务(源gaussdb,目的gbase8s) -> 迁移模式(源public,目的test) 

MTK迁移报错:

2025-11-25 10:25:56 ERROR cn.gbase.migration.exception.GlobalExceptionHandler-{1}:55 - 服务发生异常
cn.gbase.migration.common.exception.ServiceException: 同步源库对象失败,请检查数据!
at cn.gbase.migration.service.service.impl.TaskManageServiceImpl.syncOriginObject(TaskManageServiceImpl.java:562)
at cn.gbase.migration.service.service.impl.TaskManageServiceImpl$$FastClassBySpringCGLIB$$12101208.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
at cn.gbase.migration.service.service.impl.TaskManageServiceImpl$$EnhancerBySpringCGLIB$$a0db97e9.syncOriginObject(<generated>)
at cn.gbase.migration.controller.TaskManagerController.syncOriginObject(TaskManagerController.java:70)
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:483)
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 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.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:745)

 

评论

登录后才可以发表评论
飞影发表于 8个月前
gaussdb:
create database test_gauss;
\c test_gauss;
create table testonly (id int not null, name character varying(10) not null);
insert into testonly values (2, 'a');
insert into testonly values (3, 'c');
insert into testonly select id, name from testonly;

test_gauss=> \d
List of relations
Schema | Name | Type | Owner | Storage
--------+----------+-------+---------+----------------------------------
public | testonly | table | testuser | {orientation=row,compression=no}
(1 row)

gbase8s:
dbaccess - -
create database test in datadbs01 with log;
dbaccess test -
grant connect to user;
grant dba to user;
用户头像
GBase用户28017发表于 7个月前
@飞影:大牛啊。
用户头像
小鱼不吐泡泡发表于 8个月前
没这么测过吧,驱动换一下试试吧,opengauss的驱动和pg的驱动还是有区别的,应该是在driver文件夹里
飞影发表于 8个月前
@小鱼不吐泡泡:1、gaussdb驱动包与PostgreSQL保持兼容,其中类名、类结构与PostgreSQL驱动完全一致
2、MTK上选择数据源只能选postgresql吧
3、选postgresql后,gaussdb官网下载的驱动包,上传不了,报驱动包格式不正确
用户头像
小鱼不吐泡泡发表于 8个月前
@飞影:直接替掉pg的驱动,保持原驱动名
飞影发表于 8个月前
@小鱼不吐泡泡:不行。
JDBC预览:
jdbc:postgresql: : : 这个看固定的
用户头像
小鱼不吐泡泡发表于 8个月前
@飞影:那就没辙了
飞影发表于 8个月前
同样基于postgresql的翰高数据库可以,gaussdb。。。
用户头像
GBase用户28017发表于 7个月前
@飞影:现在国产太多了。基本是MySQL和PG的。真正自己的好少。
Wind发表于 8个月前
不支持。mtk暂未适配gaussdb数据源。
用户头像
GBase用户28017发表于 7个月前
@Wind:确实。。
用户头像
GBase用户28017发表于 7个月前
支持8c
沉香发表于 2个月前
围观了。
茵陈发表于 2个月前
围观了。