dataworks同步任务执行到一半才报权限不够断开连接?
https://di-cn-hangzhou.data.aliyun.com/web/di/instanceLog?id=1311043105&resourceGroup=S_res_group_552365146833154_1671690796715&requestId=1001611482119_2_T3_4053764913&projectId=57923
数据库查询被终止 辛苦提个工单给pg的同学帮忙看下 ,提供pg相关信息 和下面这个报错信息
com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-06], Description:[执行数据库 Sql 失败, 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为:select ecid,uid,selleruserid,eiastoken,email,feedbackscore,feedbackratingstar,positivefeedbackpercent,registrationdate,site,status,buyeruserid,useridlastchanged,vatstatus,name,street1,street2,cityname,stateorprovince,country,countryname,phone,postalcode,fromwho,transactioncount,amount,created,updated,"desc" from public.ebay_customers 具体错误信息为:FATAL: terminating connection due to conflict with recovery
Detail: User query might have needed to see row versions that must be removed.
Hint: In a moment you should be able to reconnect to the database and repeat your command. - org.postgresql.util.PSQLException: FATAL: terminating connection due to conflict with recovery
Detail: User query might have needed to see row versions that must be removed.
Hint: In a moment you should be able to reconnect to the database and repeat your command. ,此回答整理自钉群“DataWorks交流群(答疑@机器人)”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
DataWorks基于MaxCompute/Hologres/EMR/CDP等大数据引擎,为数据仓库/数据湖/湖仓一体等解决方案提供统一的全链路大数据开发治理平台。