oceanbase 客户端 window 使用导出功能 报错maximum open cursors exceeded

应用开发者专区
#1

odc 工具，使用导出（ MYSQL模式） 报下面错误，mysql本身可以配置max_open_cursors 但是oceanbase没有找到
2024-04-09 11:37:23 [ERROR] Split rows for non-partitioned table(with primary key): “t_mdm_codebg” failed. Reason: maximum open cursors exceeded
1659
2024-04-09 11:37:23 [WARN] Failed to run data transfer task.
1660
java.lang.RuntimeException: java.sql.SQLException: maximum open cursors exceeded

594fbecc8102471adffa455600e803f5
594fbecc8102471adffa455600e803f51306×792 39 KB

#3

请在租户下执行 alter system set open_cursors=？将open_cursors调大，参考https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000642103