注册

metadata.reflect 执行报错 (dmPython.DatabaseError) [CODE:-608]请求执行超时

沈伟 2024/02/01 676 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:
【CPU】:
【问题描述】*:
dm_engine = create_engine('dm+dmPython://xxx:xxx@xx.xx.xx.xx:5236')
dst_metadata = MetaData()
dst_metadata.reflect(bind=dm_engine)
执行 报错sqlalchemy.exc.DatabaseError: (dmPython.DatabaseError) [CODE:-608]请求执行超时

我看报错信息是执行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 = 'ACCOUNT_BIND_INFO'
AND ac.constraint_type IN ('R','P','U')
AND ac.owner = 'HSRISK_DATA_CHECK'
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 这个sql报错了 我直接在客户端上执行这个sql 需要333秒 这个是py中封装的sql有问题吗

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