【 使用环境 】生产环境
【 OB or 其他组件 】obproxy、导数工具 obloader-obdumper
【 使用版本 】
【问题描述】
2024-04-10 20:43:32 [ERROR] Dump failed. Reason: Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.. SQL: SELECT `FSerialId`,`FSettleDate`,`FOpenDate`,`FAccountNo`,`FTradeNo`,`FParentAccountNo`,`FExchangeNo`,`FCommodityType`,`FCommodityNo`,`FContractNo`,`FCallOrPutFlag`,`FContractSerialNo`,`FStrikePrice`,`FMatchSide`,`FHedgeFlag`,`FPositionPrice`,`FPositionQty`,`FPositionId`,`FCombineType`,`FPositionCmbId`,`FAccountMargin`,`FExchangeMargin`,`FPositionZProfit`,`FPositionDProfit`,`FOptionMarketValue`,`FAccountMaintenanceMargin`,`FAccountMarginMode`,`FAccountSettleMarginParam`,`FAccountMaintenanceMarginParam`,`FAccountMarginRef`,`FExchangeMarginRef`,`FPositionCmbIdRef`,`FOperatorNo`,`FOperateTime` FROM `THisPosition` partition(`d20231215`) WHERE (`FSettleDate`,`FAccountNo`,`FPositionId`,`FCommodityType`,`FMatchSide`,`FExchangeNo`)<=(?,?,?,?,?,?). Range: 2023-12-15,100109999,2023121500720936,F,B,ZCE.
2024-04-10 20:43:32 [ERROR] Dump vxdatabase.THisPosition failed. Reason: java.lang.IllegalStateException: java.sql.SQLTransientConnectionException: Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
每次导出数据均出现如上错误，致使一个表导出失败，
使用obclient设置
set global ob_query_timeout=36000000000;
obclient查看、navicat ：
SHOW VARIABLES LIKE ‘ob_query_timeout’；
均已生效，但是使用 obdumper 导出还是报 [ERROR] Error: Timeout, query has reached the maximum query timeout: 300000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
重启数据库还是报这个错
