注册

执行sql查询抛错session request timeout

Springning 2023/07/10 1208 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:麒麟
【CPU】:ARM
【问题描述】*:执行sql抛如下错误:
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141|Exception in thread "taskGroup-0" com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为: select "ID","TASK_ID","CASESN","SF_WXXLXGD","SF_BMYGD","SF_WSJJJGD","SF_BSSGD","SF_WASBJGD","INFOSOURCEID","DISCOVER_TIME","PERCREATE_TIME","CREATE_TIME","DISPATCH_TIME","SOLVING_TIME","STIME","DEPTBACKTIME","TEL_ASK_TIME","END_TIME","STREETCODE","COMMUNITYCODE","GRID_CODE","COORDX","COORDY","SECTIONS","STARSECTIONS","ENDSECTIONS","ADDRESS","INFOTYPEID","INFOBCCODE","INFOSCCODE","INFOZCCODE","INFOATCODE","DESCRIPTION","STATUS","SOLVINGSTATUS","DEPT_CODE","EXECUTE_DEPT_CODE","INSERTDEPTCODE","KEEPERSN","INSERTUSER","PERCREATEUSER","CREATEUSER","DISPATCHUSER","SOLVINGUSER","SUPERVISEUSER","TELASKUSER","ENDUSER","EMERGENCY_LEVEL","APPROACH","SIMILARCASESN","SERVICE_TYPE","ISANONYMITY","RISKLEVEL","PUBLIC_SATISFACTION","CALLBACK_FLAG","URGE_COUNT","DU_LIMIT","TELASKTYPE","REPORTSOURCE","REPORT_DEPT","REPORTINDUSTRY","IS_SOLVE_APPEAL","ISHUIFANG","BANLIRESULT","VERIFYRESULT","CHECKRESULT","PRIORITYAREA","CALLNUMBER","CONTACTMODE","END_NUM","HUIFANGMANYI","HOT_LINE_SN","WORKGRID","XEXECUTEDEPTCODE","CSOLVINGTIME","ISSPEICAL","SPEICAL_SIGN","CQENDNUM","SOLVING_RESULT","ALLMANYI","GCMANYI","TDMANYI","REFLECT_PERSON","ZZDEPTCODE","FIRSTDEPTCODE","SECENDDEPTCODE","INFO_SOURCE","INFO_TYPE_NAME","LEVEL_ONE","LEVEL_TWO","LEVEL_THREE","STREET_NAME","COMMUNITY_NAME","WORKGRIDCODE","UPKEEPERNAME","INSERTDEPTNAME","EXECUTE_DEPT_NAME","HECHAKEEPERNAME","REPORTDEPTNAME","USEREVALUATENAME","ALLMANYINAME","GCMANYINAME","TDMANYINAME","DEPT_NAME","BACKRESULT","DELAYRESULT","NEWWORKGRIDNAME","SUBEXECUTEDEPTCODE_MH","SUBEXECUTEDEPTNAME_MH","SERVICETYPENAME","CASEENDNOTE","QUERYUSERVALUATE","QUERYFUWUVALUATE","QUERYVALUATION","NEWWORKGRIDCODE","CASEVALUATIONNAME","APPEALTYPE","FACTTYPE","APPEALTYPECODE","FACTTYPECODE","ZGEXECUTEDEPTCODE","ISTYPICAL","ISSTUBBORN","HASLEAD","HASTENTYPE","FIRSTHANDDEPTCODE","QUERYCODE","WP_SOURCE","ISTHREATENED","ISPRIORITYAREA","USEREVALUATE2","WP_TYPE","PEXECUTEDEPTCODE_MH","PEXECUTEDEPTNAME_MH","SATISFIED_EXPLAIN","FACT_EXPLAIN","REPLY_TYPE","REPLY_TIME","REPLY_POIN","BANLIRESULT_12345","DESCRIPTION_12345","RESULT_12345","INERTVIEW","ENDRESULTNEW","IMAGEFILENAME","WAVFILENAME","HASHOTLINEREMINDERS","ISCONTACT","CONTACT_TIME","FACTTYPE_SL","APPEALTYPE_SL","ALLENDTIME","ALLLIGHT","APPEAL_EXPLAIN","BACK_COUNT","CASEEND","CASE_END_BC_NAME","CASE_END_SC_NAME","CASEVALUATION_12345","IS_EXCEED_OVERALL_TIME","DISPATCHNOTE","END_NODE","FIRST_CONTACT","FIRST_CONTACT_NAME","HASLEADTYPECOUNT","HASTENTYPECOUNT","ISFAST","ISFIRSTCONTACT","ISFIRSTCONTACTNAME","ISREPLY","IS_SOLVING_NAME","ISTIMELYEND","IS_DISPOSAL_TIMELY","LASTSOLVINGTIME","RESULT_TYPE_NAME","SATISFIED","SOLVING_NODE","SYNCTIME","URGING_TIME" from "RSDB_STB"."RSDB_SDB_DTL_CSFW_SQMY_RXGDMXSJ_A_D" 具体错误信息为:java.sql.SQLException: session request timeout
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26)
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:97)
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:236)
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at com.alibaba.datax.plugin.reader.rdbmsreader.RdbmsReader$Task.startRead(RdbmsReader.java:80)
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
10-07-2023 15:23:16 CST 9ff81638 INFO - 2023-07-10 15:23:16.432|ERROR|main|DataxUtil:141| at java.lang.Thread.run(Thread.java:750)

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