obdump 导出失败

【产品名称】obdump

【产品版本】最新版

【问题描述】使用obdump导出oceanbase3.1.2集群的数据库,所在租户的net_read_timeout、net_write_timeout、wait_timeout都已经调为了最大值,但是运行obdump依然报错:

java.sql.SQLNonTransientConnectionException: Server has closed the connection.

Please check net_read_timeout/net_write_timeout/wait_timeout server variables. If result set contain huge amount of data, Server expects

client to read off the result set relatively fast. In this case, please consider increasing net_read_timeout session variable / processin

g your result set faster (check Streaming result sets documentation for more information)

1 个赞

应该是撞到了proxy的已知问题;可以通过调整下面的参数来规避

alter proxyconfig set enable_ob_protocol_v2 = False;

alter proxyconfig set enable_compression_protocol = False;

1 个赞

修改之后,再运行obdump命令,依然有报错,但是内容变了:

java.sql.SQLTransientConnectionException: Request to read too old versioned data

这个报错是当前查询所依赖的数据版本已经被回收,用户需要根据查询设置UNDO的保留时间,例如: set global undo_retention=xxx (默认单位是秒)。