注册

使用sqlalchemy 执行SQL报错session request timeout

DM_406784 2024/04/29 648 7

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8 docker
【操作系统】:centos7
【CPU】: x86
【问题描述】*: 执行sql查询报错,下面是执行的具体sql语句

SELECT
ac.constraint_name,
ac.constraint_type,
loc.column_name AS local_column,
rem.table_name AS remote_table,
rem.column_name AS remote_column,
rem.owner AS remote_owner,
loc.position as loc_pos,
rem.position as rem_pos
FROM all_constraints ac,
all_cons_columns loc,
all_cons_columns rem
WHERE ac.table_name = 'UPLOAD_FILE'
AND ac.constraint_type IN ('R','P','U')
AND ac.owner = 'test'
AND ac.owner = loc.owner
AND ac.constraint_name = loc.constraint_name
AND ac.r_owner = rem.owner(+)
AND ac.r_constraint_name = rem.constraint_name(+)
AND (rem.position IS NULL or loc.position=rem.position)
ORDER BY ac.constraint_name, loc.position

image.png

直接执行sql没问题
image.png
max_session 已经调整到10000

回答 0
暂无回答
扫一扫
联系客服