[2024-07-26 10:50:22,205] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.200 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
[2024-07-26 10:50:22,206] {{commontask.py:375}} INFO - 2024-07-26 10:50:22.202 [main] INFO PerfTrace - PerfTrace traceId=job-1, isEnable=false, priority=0
[2024-07-26 10:50:22,206] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.202 [main] INFO JobContainer - DataX jobContainer starts job.
[2024-07-26 10:50:22,206] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.204 [main] INFO JobContainer - Set jobId = 0
[2024-07-26 10:50:22,619] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.619 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:postgresql://29.23.194.73:5432/hr_etl.
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.993 [job-0] INFO OriginalConfPretreatmentUtil - table:[hr_portrait.dm_em_summary_info] all columns:[
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - emp_id,emp_account,emp_name,emp_name_pinyin,emp_sex_code,emp_sex_desc,birth_date,emp_age,age_area,constellation,twelve_animal,nationality_code,nationality_desc,ethnicity_code,ethnicity_desc,marital_status_code,marital_status_desc,marry_date,political_status_code,political_status_desc,emp_icon_inner_url,emp_icon_outer_url,competition_limit_flag,emp_status_code,emp_status_desc,hr_status_code,hr_status_desc,last_entry_date,emp_confirm_date,first_entry_date,company_year,company_year_total,company_year_area,work_year,years_to_deducted,days_to_deducted,months_to_deducted,service_start_date,work_gap_duration,native_place,residence_type_code,residence_type_desc,residence_address,residence_police,residence_province_code,residence_province_desc,residence_city_code,residence_city_desc,family_address,identity_number,identity_country_code,identity_country_desc,passport_country_code,passport_country_desc,passport_number,business_unit_id,business_unit_short_name,business_unit_full_name,atl_struct_id,atl_struct_short_name,atl_struct_full_id,atl_struct_full_name,long_atl_struct_full_id,atl_struct_address_id,atl_struct_city_code,atl_struct_city_desc,atl_struct_province_code,atl_struct_province_desc,atl_struct_country_code,atl_struct_country_desc,atl_struct_address_desc_remark,atl_struct_address_short_name,atl_struct_address_full_name,atl_struct_manager_emp_id,atl_struct_manager_emp_account,atl_struct_manager_emp_name,atl_struct_level_code,atl_struct_level_desc,atl_struct_type_code,atl_struct_type_desc,atl_struct_admin_flag,lnk_struct_id,lnk_struct_flag,law_company_id,law_company_short_name,law_company_desc_remark,law_company_full_name,last_duty_end_date,last_duty_start_date,position_id,position_short_name,position_desc_remark,position_full_name,emp_type_code,emp_type_desc,work_exper_cnt,fix_phone,probation_end_date,probation_period,total_company_flag,new_decline_flag,new_promote_flag,transfer_position_flag,transfer_company_flag,transfer_struct_flag,trans_company_cnt,trans_position_cnt,trans_struct_cnt,choice_cost_type_code,emp_class_code,emp_class_desc,leader_position_id,leader_type_code,leader_emp_id,leader_emp_name,leader_emp_account,level2_leader_emp_id,level2_leader_emp_account,level2_leader_emp_name,total_direct_follower_cnt,equal_level_emp_cnt,family_member_com_cnt,work_address_id,work_address_province_code,work_address_province_desc,work_address_city_desc,work_address_city_code,work_address_country_desc,work_address_country_code,work_address_full_name,work_address_short_name,work_address_desc_remark,office_email,first_core_duty_id,first_core_duty_name,second_core_duty_id,second_core_duty_name,third_core_duty_id,third_core_duty_name,fourth_core_duty_id,fourth_core_duty_name,fifth_core_duty_id,fifth_core_duty_name,sixth_core_duty_id,sixth_core_duty_name,seventh_core_duty_id,seventh_core_duty_name,eighth_core_duty_id,eighth_core_duty_name,ninth_core_duty_id,ninth_core_duty_name,tenth_core_duty_id,tenth_core_duty_name,cap_level_id,cap_level_name,this_cap_level_duration,job_level,job_pos_id,job_pos_name,last_action_code,last_action_desc,last_action_reason_code,last_action_reason_desc,last_perf_level_rank,last_year_ep,last_rank_group_id,last_eva_group_id,last_cycle_type,last_cycle_value,relative_member_cnt,emergency_contact_cnt,emp_mobile_number,mobile_country_code,emp_personal_email,mail_city_code,political_entry_date,mail_city_desc,same_contact_flag,mail_address,rew_cnt,pun_cnt,last_pun_content,last_pun_result_desc,last_pun_type_desc,last_pun_date,last_pun_reason,last_pun_dept,last_pun_file_no,last_pun_reference_name,last_pun_final_resolution_desc,last_rew_content,last_rew_result_desc,last_rew_type_desc,last_rew_date,last_rew_reason,last_rew_dept,last_rew_file_no,last_rew_reference_name,last_rew_final_resolution_desc,last_leave_certificate_number,last_leave_country_date,last_tracel_country_code,last_tracel_country_desc,last_leave_country_visit_type,last_leave_country_tracel_for,last_country_return_date,last_leave_signed_flag,highest_edu_graduat_type_desc,highest_edu_city_code,highest_edu_city_desc,highest_edu_region_code,highest_edu_region_desc,highest_edu_major_code,highest_edu_major_desc,highest_edu_background_code,highest_edu_background_desc,highest_college_category,highest_edu_end_date,highest_edu_start_date,highest_degree_code,highest_degree_desc,bach_degree_emp_flag,highest_school_name,last_edu_background_code,last_edu_background_desc,last_coll_category,last_edu_end_date,last_edu_start_date,last_degree_code,last_degree_desc,last_school_name,last_major_code,last_major_desc,last_work_employer,last_work_start_date,last_work_end_date,last_work_industry_id,last_work_industry_name,last_work_position,last_work_reference_phone,last_work_reference_name,last_branch_name,last_account_name,last_confirm_account_number,account_payment_account_flag,last_bank_code,last_branch_code,last_bank_name,last_account_number,bank_account_cnt,this_comy_exp_cnt,two_level_dir_followers_cnt,major_type_cnt,bachelor_major_cnt,master_major_cnt,doctor_major_cnt,finance_exp_year,law_exp_year,hr_exp_year,investment_exp_year,sale_exp_year,consult_exp_year,property_manager_year,property_exp_year,tech_company_manager_year,tech_company_exp_year,law_firm_manager_year,law_firm_exp_year,inter_invest_manager_year,inter_invest_exp_year,fina_regulate_manager_year,fina_regulate_exp_year,security_manager_year,security_exp_year,life_manager_year,life_exp_year,consultancy4_manager_year,consultancy4_exp_year,gov_bank5_manager_year,gov_bank5_exp_year,large_mfg_manager_year,manufacturer_company_exp_year,large_manufacturing_exp_year,estate_agency_manager_year,real_estate_exp_year,elec_business_manager_year,elec_business_exp_year,pub_fund_manager_year,pub_fund_exp_year,bank_manager_year,bank_exp_year,internet_company_manager_year,internet_company_exp_year,construct_comy_manager_year,construct_compy_exp_year,fina_tec_manager_year,fina_tec_exp_year,fin_lease_exp_year,fin_lease_manager_year,hotel_manager_year,hotel_exp_year,headhunting_manager_year,headhunting_exp_year,pri_fund_manager_year,pri_fund_exp_year,foreign_bank_manager_year,foreign_bank_exp_year,transport_firm_exp_year,transport_firm_manager_year,braker_manager_year,braker_exp_year,strat_consult_manager_year,strat_consult_exp_year,asset_exp_year,asset_manager_year,longest_work_year_com,work_year_industry,oversea_work_year,pioneer_exp_year,manager_exp_year,job_hopping_rate,insurance_project_cnt,tech_project_cnt,invest_project_cnt,bank_project_cnt,insurance_project_mange_cnt,tech_project_mange_cnt,invest_project_mange_cnt,bank_project_mange_cnt,pmo_cnt,project_manage_exp_cnt,his_promo_cnt,promo_rate,last_promo_date,sys_language,w_ins_dt,src_sys,src_tbl,last_transfer_company_date,last_transfer_position_date,last_leave_date,rejoin_company_flag,submitted_status_code,submitted_status_desc,on_the_job_flag,political_age,post_duty_id,post_duty_name,last_this_company_leave_date,thisy_capability_level_code,thisy_capability_level_desc,lasty_capability_level_code,lasty_capability_level_desc,beforey_capability_level_code,beforey_capability_level_desc,thisy_perf_level_rank,thisy_perf_level_name,lasty_perf_level_rank,lasty_perf_level_name,beforey_perf_level_rank,beforey_perf_level_name,blood_type_code,blood_type_desc,actual_birth_date,height,identity_province_code,identity_province_desc,identity_city_code,identity_city_desc,identity_area_code,identity_area_desc,identity_address,emp_extra_property,recent_graduate_flag,wechat,last_perf_level_name,last_rank_group_name,last_eva_group_name,primary_certificate_type_code,primary_certificate_type_desc,primary_certificate_number,link_struct_full_name,link_struct_short_name,join_this_struct_date,job_func_ids,job_func_names,job_func_percents,first_flag,first_job_func_id,first_job_func_name,second_job_func_id,second_job_func_name,third_job_func_id,third_job_func_name,fourth_job_func_id,fourth_job_func_name,fifth_job_func_id,fifth_job_func_name,sixth_job_func_id,sixth_job_func_name,seventh_job_func_id,seventh_job_func_name,eighth_job_func_id,eighth_job_func_name,ninth_job_func_id,ninth_job_func_name,tenth_job_func_id,tenth_job_func_name,last_core_config_id,last_core_config_name,last_core_config_level_id,last_core_config_level_name,last_job_func_id,last_job_func_name,main_urgent_name,main_urgent_mobile_num,past_work_exp_companys,identity_certificate_address,con_country_code,con_country_desc,con_province_code,con_province_desc,con_city_code,con_city_desc,con_address,family_country_code,family_country_desc,family_province_code,family_province_desc,family_city_code,family_city_desc,family_district_code,family_district_desc,political_end_date,trans_post_duty_cnt,primary_pos_flag,attendance_type_code,attendance_type_desc,junior_cap_duration,mid_cap_duration,senior_cap_duration,this_job_level_duration,last_leave_reason_code,last_leave_reason_desc,highest_study_type_code,highest_study_type_desc,party_pun_cnt,job_hopping_cnt,institute_exp_flag,headquarter_exp_flag,threey_capability_level_code,threey_capability_level_desc,threey_perf_level_rank,threey_perf_level_name,thisy_development_trend_code,thisy_development_trend_desc,lasty_development_trend_code,lasty_development_trend_desc,beforey_development_trend_code,beforey_development_trend_desc,threey_development_trend_code,threey_development_trend_desc,thisy_incompetent_flag_code,thisy_incompetent_flag_desc,lasty_incompetent_flag_code,lasty_incompetent_flag_desc,beforey_incompetent_flag_code,beforey_incompetent_flag_desc,threey_incompetent_flag_code,threey_incompetent_flag_desc,thisy_final_score,lasty_final_score,beforey_final_score,threey_final_score,kpi_lower_sixty_cnt,kpi_higher_hundred_cnt,kpi_sub_connect_cnt,sys_date,consecutive_renewals_cnt,continuous_rank_first1_cnts,continuous_rank_first2_cnts,continuous_rank_last1_cnts,rank_diff_last,x_years_rank_num,x_years_rank_diff_last,x_years_rank_diff_num,x_years_down_flag,x_years_up_flag,x_years_rank_diff_high,contract_agm_type_code,contract_agm_type_desc,sign_secret_competition_flag,predict_reg_date,political_trans_normal_date,bachelor_degree_cnt,master_degree_cnt,doctor_degree_cnt,bachelor_academy_name,master_academy_name,doctor_academy_name,mba_academy_name,pioneer_exp_cnt,con_begin_date,con_end_date,working_hour_system_code,working_hour_system_desc,out_work_exper_company,inner_work_exper_company,last_leave_other_reason_code,last_leave_other_reason_desc,residence_area_code,residence_area_desc,primary_certificate_eff_date,political_start_date,last_xfr_eff_date,this_job_level_duration_days,part_on_duty_cnt,part_duty_important_flag,certificate_first_name_cma,certificate_second_name_cma,certificate_third_name_cma,reh_cons_renewals_cnt,last_work_exp_cnt,last_1_employer,last_2_employer,last_3_employer,last_1_position,last_2_position,last_3_position,inner_work_exper_postion,out_work_exper_postion,struct_manager_flag,leader_emp_flag,thisy_appraiser_score,lasty_appraiser_score,beforey_appraiser_score,threey_appraiser_score,six_usubmit_sum_cnt,six_delay_sum_cnt,six_uapproval_cnt,six_delay_approval_cnt,ep_manage_flag,contract_unit_code,contract_unit_desc,sort_num,job_level_without_prefix,x_years_pm_rank_up_flag,x_years_pm_rank_down_flag,x_years_pm_rank_fluc_flag,x_years_pm_rank_stable_flag,last_mon_wday_otime_hcnt,last_mon_wday_sup_otime_dcnt,last_mon_wday_rel_otime_dcnt,last_mon_late_hcnt,last_mon_late_cnt,last_mon_early_leave_hcnt,last_mon_early_leave_dcnt,last_mon_absenteeism_hcnt,last_mon_absenteeism_dcnt,last_mon_unusual_cnt,last_mon_unusual_dnt,last_mon_punch_cnt,last_mon_punch_intv_lt1m_cnt,last_mon_due_wday_cnt,last_mon_reality_wday_cnt,last_3mon_leave_hcnt,newest_leave_type_id,newest_leave_type_name,newest_leave_start_time,newest_leave_end_time,newest_leave_submit_time,newest_leave_status_code,newest_leave_status_desc,job_level_name,row_number,birth_place,health_status,emp_grade,same_grade_duration,same_level_duration,hire_date,performance_info,aboard_experience
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - ].
[2024-07-26 10:50:23,531] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.530 [job-0] INFO OriginalConfPretreatmentUtil - Write data [
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - INSERT INTO %s (fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - ], which jdbcUrl like:[jdbc:postgresql://29.23.194.72:5432/portrait]
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - DataX Reader.Job [postgresqlreader] do prepare work .
[2024-07-26 10:50:23,533] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - DataX Writer.Job [postgresqlwriter] do prepare work .
[2024-07-26 10:50:23,540] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.540 [job-0] INFO CommonRdbmsWriter$Job - Begin to execute preSqls:[truncate table hr_portrait.dm_em_summary_info]. context info:jdbc:postgresql://29.23.194.72:5432/portrait.
[2024-07-26 10:50:23,562] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.562 [job-0] INFO JobContainer - jobContainer starts to do split ...
[2024-07-26 10:50:23,563] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.562 [job-0] INFO JobContainer - Job set Channel-Number to 1 channels.
[2024-07-26 10:50:23,565] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.565 [job-0] INFO JobContainer - DataX Reader.Job [postgresqlreader] splits to [1] tasks.
[2024-07-26 10:50:23,567] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.566 [job-0] INFO JobContainer - DataX Writer.Job [postgresqlwriter] splits to [1] tasks.
[2024-07-26 10:50:23,587] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.587 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
[2024-07-26 10:50:23,596] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.595 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
[2024-07-26 10:50:23,598] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.598 [job-0] INFO JobContainer - Running by standalone Mode.
[2024-07-26 10:50:23,627] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.627 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
[2024-07-26 10:50:23,632] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.632 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
[2024-07-26 10:50:23,633] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.633 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
[2024-07-26 10:50:23,644] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.644 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
[2024-07-26 10:50:23,652] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.651 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code from hr_dm.dm_em_summary_info
[2024-07-26 10:50:23,652] {{common_task.py:375}} INFO - ] jdbcUrl:[jdbc:postgresql://29.23.194.73:5432/hr_etl].
[2024-07-26 10:50:24,780] {{common_task.py:375}} INFO - 2024-07-26 10:50:24.779 [0-0-0-reader] INFO CommonRdbmsReader$Task - Finished read record by Sql: [select fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code from hr_dm.dm_em_summary_info
[2024-07-26 10:50:24,781] {{common_task.py:375}} INFO - ] jdbcUrl:[jdbc:postgresql://29.23.194.73:5432/hr_etl].
[2024-07-26 10:50:33,639] {{common_task.py:375}} INFO - 2024-07-26 10:50:33.638 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
[2024-07-26 10:50:43,641] {{common_task.py:375}} INFO - 2024-07-26 10:50:43.640 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 46.42KB/s, 38 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:50:53,643] {{common_task.py:375}} INFO - 2024-07-26 10:50:53.642 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:54:33,672] {{common_task.py:375}} INFO - 2024-07-26 10:54:33.672 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:54:43,673] {{common_task.py:375}} INFO - 2024-07-26 10:54:43.673 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - 2024-07-26 10:55:23.681 [job-0] INFO VMInfo -
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - [delta cpu info] =>
JavaUpdateChecker
commented
1 month ago
[2024-07-26 10:50:22,205] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.200 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
[2024-07-26 10:50:22,206] {{commontask.py:375}} INFO - 2024-07-26 10:50:22.202 [main] INFO PerfTrace - PerfTrace traceId=job-1, isEnable=false, priority=0
[2024-07-26 10:50:22,206] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.202 [main] INFO JobContainer - DataX jobContainer starts job.
[2024-07-26 10:50:22,206] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.204 [main] INFO JobContainer - Set jobId = 0
[2024-07-26 10:50:22,619] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.619 [job-0] INFO OriginalConfPretreatmentUtil - Available jdbcUrl:jdbc:postgresql://29.23.194.73:5432/hr_etl.
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - 2024-07-26 10:50:22.993 [job-0] INFO OriginalConfPretreatmentUtil - table:[hr_portrait.dm_em_summary_info] all columns:[
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - emp_id,emp_account,emp_name,emp_name_pinyin,emp_sex_code,emp_sex_desc,birth_date,emp_age,age_area,constellation,twelve_animal,nationality_code,nationality_desc,ethnicity_code,ethnicity_desc,marital_status_code,marital_status_desc,marry_date,political_status_code,political_status_desc,emp_icon_inner_url,emp_icon_outer_url,competition_limit_flag,emp_status_code,emp_status_desc,hr_status_code,hr_status_desc,last_entry_date,emp_confirm_date,first_entry_date,company_year,company_year_total,company_year_area,work_year,years_to_deducted,days_to_deducted,months_to_deducted,service_start_date,work_gap_duration,native_place,residence_type_code,residence_type_desc,residence_address,residence_police,residence_province_code,residence_province_desc,residence_city_code,residence_city_desc,family_address,identity_number,identity_country_code,identity_country_desc,passport_country_code,passport_country_desc,passport_number,business_unit_id,business_unit_short_name,business_unit_full_name,atl_struct_id,atl_struct_short_name,atl_struct_full_id,atl_struct_full_name,long_atl_struct_full_id,atl_struct_address_id,atl_struct_city_code,atl_struct_city_desc,atl_struct_province_code,atl_struct_province_desc,atl_struct_country_code,atl_struct_country_desc,atl_struct_address_desc_remark,atl_struct_address_short_name,atl_struct_address_full_name,atl_struct_manager_emp_id,atl_struct_manager_emp_account,atl_struct_manager_emp_name,atl_struct_level_code,atl_struct_level_desc,atl_struct_type_code,atl_struct_type_desc,atl_struct_admin_flag,lnk_struct_id,lnk_struct_flag,law_company_id,law_company_short_name,law_company_desc_remark,law_company_full_name,last_duty_end_date,last_duty_start_date,position_id,position_short_name,position_desc_remark,position_full_name,emp_type_code,emp_type_desc,work_exper_cnt,fix_phone,probation_end_date,probation_period,total_company_flag,new_decline_flag,new_promote_flag,transfer_position_flag,transfer_company_flag,transfer_struct_flag,trans_company_cnt,trans_position_cnt,trans_struct_cnt,choice_cost_type_code,emp_class_code,emp_class_desc,leader_position_id,leader_type_code,leader_emp_id,leader_emp_name,leader_emp_account,level2_leader_emp_id,level2_leader_emp_account,level2_leader_emp_name,total_direct_follower_cnt,equal_level_emp_cnt,family_member_com_cnt,work_address_id,work_address_province_code,work_address_province_desc,work_address_city_desc,work_address_city_code,work_address_country_desc,work_address_country_code,work_address_full_name,work_address_short_name,work_address_desc_remark,office_email,first_core_duty_id,first_core_duty_name,second_core_duty_id,second_core_duty_name,third_core_duty_id,third_core_duty_name,fourth_core_duty_id,fourth_core_duty_name,fifth_core_duty_id,fifth_core_duty_name,sixth_core_duty_id,sixth_core_duty_name,seventh_core_duty_id,seventh_core_duty_name,eighth_core_duty_id,eighth_core_duty_name,ninth_core_duty_id,ninth_core_duty_name,tenth_core_duty_id,tenth_core_duty_name,cap_level_id,cap_level_name,this_cap_level_duration,job_level,job_pos_id,job_pos_name,last_action_code,last_action_desc,last_action_reason_code,last_action_reason_desc,last_perf_level_rank,last_year_ep,last_rank_group_id,last_eva_group_id,last_cycle_type,last_cycle_value,relative_member_cnt,emergency_contact_cnt,emp_mobile_number,mobile_country_code,emp_personal_email,mail_city_code,political_entry_date,mail_city_desc,same_contact_flag,mail_address,rew_cnt,pun_cnt,last_pun_content,last_pun_result_desc,last_pun_type_desc,last_pun_date,last_pun_reason,last_pun_dept,last_pun_file_no,last_pun_reference_name,last_pun_final_resolution_desc,last_rew_content,last_rew_result_desc,last_rew_type_desc,last_rew_date,last_rew_reason,last_rew_dept,last_rew_file_no,last_rew_reference_name,last_rew_final_resolution_desc,last_leave_certificate_number,last_leave_country_date,last_tracel_country_code,last_tracel_country_desc,last_leave_country_visit_type,last_leave_country_tracel_for,last_country_return_date,last_leave_signed_flag,highest_edu_graduat_type_desc,highest_edu_city_code,highest_edu_city_desc,highest_edu_region_code,highest_edu_region_desc,highest_edu_major_code,highest_edu_major_desc,highest_edu_background_code,highest_edu_background_desc,highest_college_category,highest_edu_end_date,highest_edu_start_date,highest_degree_code,highest_degree_desc,bach_degree_emp_flag,highest_school_name,last_edu_background_code,last_edu_background_desc,last_coll_category,last_edu_end_date,last_edu_start_date,last_degree_code,last_degree_desc,last_school_name,last_major_code,last_major_desc,last_work_employer,last_work_start_date,last_work_end_date,last_work_industry_id,last_work_industry_name,last_work_position,last_work_reference_phone,last_work_reference_name,last_branch_name,last_account_name,last_confirm_account_number,account_payment_account_flag,last_bank_code,last_branch_code,last_bank_name,last_account_number,bank_account_cnt,this_comy_exp_cnt,two_level_dir_followers_cnt,major_type_cnt,bachelor_major_cnt,master_major_cnt,doctor_major_cnt,finance_exp_year,law_exp_year,hr_exp_year,investment_exp_year,sale_exp_year,consult_exp_year,property_manager_year,property_exp_year,tech_company_manager_year,tech_company_exp_year,law_firm_manager_year,law_firm_exp_year,inter_invest_manager_year,inter_invest_exp_year,fina_regulate_manager_year,fina_regulate_exp_year,security_manager_year,security_exp_year,life_manager_year,life_exp_year,consultancy4_manager_year,consultancy4_exp_year,gov_bank5_manager_year,gov_bank5_exp_year,large_mfg_manager_year,manufacturer_company_exp_year,large_manufacturing_exp_year,estate_agency_manager_year,real_estate_exp_year,elec_business_manager_year,elec_business_exp_year,pub_fund_manager_year,pub_fund_exp_year,bank_manager_year,bank_exp_year,internet_company_manager_year,internet_company_exp_year,construct_comy_manager_year,construct_compy_exp_year,fina_tec_manager_year,fina_tec_exp_year,fin_lease_exp_year,fin_lease_manager_year,hotel_manager_year,hotel_exp_year,headhunting_manager_year,headhunting_exp_year,pri_fund_manager_year,pri_fund_exp_year,foreign_bank_manager_year,foreign_bank_exp_year,transport_firm_exp_year,transport_firm_manager_year,braker_manager_year,braker_exp_year,strat_consult_manager_year,strat_consult_exp_year,asset_exp_year,asset_manager_year,longest_work_year_com,work_year_industry,oversea_work_year,pioneer_exp_year,manager_exp_year,job_hopping_rate,insurance_project_cnt,tech_project_cnt,invest_project_cnt,bank_project_cnt,insurance_project_mange_cnt,tech_project_mange_cnt,invest_project_mange_cnt,bank_project_mange_cnt,pmo_cnt,project_manage_exp_cnt,his_promo_cnt,promo_rate,last_promo_date,sys_language,w_ins_dt,src_sys,src_tbl,last_transfer_company_date,last_transfer_position_date,last_leave_date,rejoin_company_flag,submitted_status_code,submitted_status_desc,on_the_job_flag,political_age,post_duty_id,post_duty_name,last_this_company_leave_date,thisy_capability_level_code,thisy_capability_level_desc,lasty_capability_level_code,lasty_capability_level_desc,beforey_capability_level_code,beforey_capability_level_desc,thisy_perf_level_rank,thisy_perf_level_name,lasty_perf_level_rank,lasty_perf_level_name,beforey_perf_level_rank,beforey_perf_level_name,blood_type_code,blood_type_desc,actual_birth_date,height,identity_province_code,identity_province_desc,identity_city_code,identity_city_desc,identity_area_code,identity_area_desc,identity_address,emp_extra_property,recent_graduate_flag,wechat,last_perf_level_name,last_rank_group_name,last_eva_group_name,primary_certificate_type_code,primary_certificate_type_desc,primary_certificate_number,link_struct_full_name,link_struct_short_name,join_this_struct_date,job_func_ids,job_func_names,job_func_percents,first_flag,first_job_func_id,first_job_func_name,second_job_func_id,second_job_func_name,third_job_func_id,third_job_func_name,fourth_job_func_id,fourth_job_func_name,fifth_job_func_id,fifth_job_func_name,sixth_job_func_id,sixth_job_func_name,seventh_job_func_id,seventh_job_func_name,eighth_job_func_id,eighth_job_func_name,ninth_job_func_id,ninth_job_func_name,tenth_job_func_id,tenth_job_func_name,last_core_config_id,last_core_config_name,last_core_config_level_id,last_core_config_level_name,last_job_func_id,last_job_func_name,main_urgent_name,main_urgent_mobile_num,past_work_exp_companys,identity_certificate_address,con_country_code,con_country_desc,con_province_code,con_province_desc,con_city_code,con_city_desc,con_address,family_country_code,family_country_desc,family_province_code,family_province_desc,family_city_code,family_city_desc,family_district_code,family_district_desc,political_end_date,trans_post_duty_cnt,primary_pos_flag,attendance_type_code,attendance_type_desc,junior_cap_duration,mid_cap_duration,senior_cap_duration,this_job_level_duration,last_leave_reason_code,last_leave_reason_desc,highest_study_type_code,highest_study_type_desc,party_pun_cnt,job_hopping_cnt,institute_exp_flag,headquarter_exp_flag,threey_capability_level_code,threey_capability_level_desc,threey_perf_level_rank,threey_perf_level_name,thisy_development_trend_code,thisy_development_trend_desc,lasty_development_trend_code,lasty_development_trend_desc,beforey_development_trend_code,beforey_development_trend_desc,threey_development_trend_code,threey_development_trend_desc,thisy_incompetent_flag_code,thisy_incompetent_flag_desc,lasty_incompetent_flag_code,lasty_incompetent_flag_desc,beforey_incompetent_flag_code,beforey_incompetent_flag_desc,threey_incompetent_flag_code,threey_incompetent_flag_desc,thisy_final_score,lasty_final_score,beforey_final_score,threey_final_score,kpi_lower_sixty_cnt,kpi_higher_hundred_cnt,kpi_sub_connect_cnt,sys_date,consecutive_renewals_cnt,continuous_rank_first1_cnts,continuous_rank_first2_cnts,continuous_rank_last1_cnts,rank_diff_last,x_years_rank_num,x_years_rank_diff_last,x_years_rank_diff_num,x_years_down_flag,x_years_up_flag,x_years_rank_diff_high,contract_agm_type_code,contract_agm_type_desc,sign_secret_competition_flag,predict_reg_date,political_trans_normal_date,bachelor_degree_cnt,master_degree_cnt,doctor_degree_cnt,bachelor_academy_name,master_academy_name,doctor_academy_name,mba_academy_name,pioneer_exp_cnt,con_begin_date,con_end_date,working_hour_system_code,working_hour_system_desc,out_work_exper_company,inner_work_exper_company,last_leave_other_reason_code,last_leave_other_reason_desc,residence_area_code,residence_area_desc,primary_certificate_eff_date,political_start_date,last_xfr_eff_date,this_job_level_duration_days,part_on_duty_cnt,part_duty_important_flag,certificate_first_name_cma,certificate_second_name_cma,certificate_third_name_cma,reh_cons_renewals_cnt,last_work_exp_cnt,last_1_employer,last_2_employer,last_3_employer,last_1_position,last_2_position,last_3_position,inner_work_exper_postion,out_work_exper_postion,struct_manager_flag,leader_emp_flag,thisy_appraiser_score,lasty_appraiser_score,beforey_appraiser_score,threey_appraiser_score,six_usubmit_sum_cnt,six_delay_sum_cnt,six_uapproval_cnt,six_delay_approval_cnt,ep_manage_flag,contract_unit_code,contract_unit_desc,sort_num,job_level_without_prefix,x_years_pm_rank_up_flag,x_years_pm_rank_down_flag,x_years_pm_rank_fluc_flag,x_years_pm_rank_stable_flag,last_mon_wday_otime_hcnt,last_mon_wday_sup_otime_dcnt,last_mon_wday_rel_otime_dcnt,last_mon_late_hcnt,last_mon_late_cnt,last_mon_early_leave_hcnt,last_mon_early_leave_dcnt,last_mon_absenteeism_hcnt,last_mon_absenteeism_dcnt,last_mon_unusual_cnt,last_mon_unusual_dnt,last_mon_punch_cnt,last_mon_punch_intv_lt1m_cnt,last_mon_due_wday_cnt,last_mon_reality_wday_cnt,last_3mon_leave_hcnt,newest_leave_type_id,newest_leave_type_name,newest_leave_start_time,newest_leave_end_time,newest_leave_submit_time,newest_leave_status_code,newest_leave_status_desc,job_level_name,row_number,birth_place,health_status,emp_grade,same_grade_duration,same_level_duration,hire_date,performance_info,aboard_experience
[2024-07-26 10:50:22,994] {{common_task.py:375}} INFO - ].
[2024-07-26 10:50:23,531] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.530 [job-0] INFO OriginalConfPretreatmentUtil - Write data [
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - INSERT INTO %s (fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - ], which jdbcUrl like:[jdbc:postgresql://29.23.194.72:5432/portrait]
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
[2024-07-26 10:50:23,532] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - DataX Reader.Job [postgresqlreader] do prepare work .
[2024-07-26 10:50:23,533] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.532 [job-0] INFO JobContainer - DataX Writer.Job [postgresqlwriter] do prepare work .
[2024-07-26 10:50:23,540] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.540 [job-0] INFO CommonRdbmsWriter$Job - Begin to execute preSqls:[truncate table hr_portrait.dm_em_summary_info]. context info:jdbc:postgresql://29.23.194.72:5432/portrait.
[2024-07-26 10:50:23,562] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.562 [job-0] INFO JobContainer - jobContainer starts to do split ...
[2024-07-26 10:50:23,563] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.562 [job-0] INFO JobContainer - Job set Channel-Number to 1 channels.
[2024-07-26 10:50:23,565] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.565 [job-0] INFO JobContainer - DataX Reader.Job [postgresqlreader] splits to [1] tasks.
[2024-07-26 10:50:23,567] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.566 [job-0] INFO JobContainer - DataX Writer.Job [postgresqlwriter] splits to [1] tasks.
[2024-07-26 10:50:23,587] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.587 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
[2024-07-26 10:50:23,596] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.595 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
[2024-07-26 10:50:23,598] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.598 [job-0] INFO JobContainer - Running by standalone Mode.
[2024-07-26 10:50:23,627] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.627 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
[2024-07-26 10:50:23,632] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.632 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
[2024-07-26 10:50:23,633] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.633 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
[2024-07-26 10:50:23,644] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.644 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
[2024-07-26 10:50:23,652] {{common_task.py:375}} INFO - 2024-07-26 10:50:23.651 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code from hr_dm.dm_em_summary_info
[2024-07-26 10:50:23,652] {{common_task.py:375}} INFO - ] jdbcUrl:[jdbc:postgresql://29.23.194.73:5432/hr_etl].
[2024-07-26 10:50:24,780] {{common_task.py:375}} INFO - 2024-07-26 10:50:24.779 [0-0-0-reader] INFO CommonRdbmsReader$Task - Finished read record by Sql: [select fourth_job_func_name,invest_project_mange_cnt,security_exp_year,beforey_incompetent_flag_code,political_status_code,fourth_core_duty_id,job_level,last_mon_early_leave_dcnt,emp_age,thisy_appraiser_score,last_promo_date,identity_province_code,life_exp_year,emp_type_code,highest_edu_region_desc,submitted_status_desc,lasty_perf_level_name,highest_college_category,business_unit_id,lasty_perf_level_rank,second_job_func_id,highest_edu_background_desc,atl_struct_province_desc,highest_edu_city_desc,two_level_dir_followers_cnt,blood_type_code,join_this_struct_date,lasty_incompetent_flag_desc,identity_province_desc,last_work_end_date,last_mon_punch_intv_lt1m_cnt,residence_type_code,hotel_exp_year,identity_number,working_hour_system_desc,identity_area_desc,atl_struct_level_code,tech_project_cnt,work_address_country_desc,last_work_reference_phone,law_company_desc_remark,lasty_capability_level_code,wechat,asset_exp_year,beforey_incompetent_flag_desc,bank_account_cnt,height,residence_police,certificate_first_name_cma,manufacturer_company_exp_year,last_mon_due_wday_cnt,fourth_core_duty_name,trans_struct_cnt,thisy_perf_level_name,hr_exp_year,last_confirm_account_number,threey_incompetent_flag_code,link_struct_short_name,lnk_struct_id,x_years_rank_diff_high,atl_struct_address_id,last_rew_content,sys_language,x_years_pm_rank_stable_flag,first_entry_date,trans_company_cnt,thisy_incompetent_flag_desc,law_company_full_name,lasty_development_trend_desc,past_work_exp_companys,last_action_reason_code,last_leave_reason_code,second_core_duty_name,newest_leave_type_name,x_years_down_flag,family_country_desc,ninth_job_func_id,leader_type_code,last_mon_absenteeism_hcnt,last_mon_unusual_dnt,party_pun_cnt,last_rew_result_desc,last_tracel_country_code,work_address_id,fin_lease_exp_year,last_rank_group_name,last_rew_dept,newest_leave_start_time,inner_work_exper_company,emp_personal_email,last_tracel_country_desc,investment_exp_year,life_manager_year,first_flag,internet_company_manager_year,threey_development_trend_code,relative_member_cnt,last_cycle_value,braker_manager_year,sys_date,birth_date,marital_status_code,con_country_code,last_mon_wday_otime_hcnt,this_comy_exp_cnt,real_estate_exp_year,last_rew_type_desc,newest_leave_submit_time,pmo_cnt,con_city_desc,pri_fund_exp_year,atl_struct_manager_emp_id,promo_rate,last_account_number,certificate_third_name_cma,highest_study_type_desc,passport_number,work_year_industry,new_decline_flag,last_3mon_leave_hcnt,seventh_job_func_id,leader_position_id,braker_exp_year,total_direct_follower_cnt,job_level_name,last_action_reason_desc,ninth_job_func_name,equal_level_emp_cnt,last_leave_country_tracel_for,emp_icon_outer_url,probation_period,last_transfer_position_date,mobile_country_code,tech_project_mange_cnt,emp_sex_code,kpi_sub_connect_cnt,last_mon_absenteeism_dcnt,strat_consult_exp_year,attendance_type_desc,thisy_final_score,contract_unit_code,leader_emp_id,w_ins_dt,last_leave_country_visit_type,last_core_config_id,his_promo_cnt,asset_manager_year,job_func_percents,nationality_code,last_core_config_level_id,recent_graduate_flag,fifth_job_func_id,ninth_core_duty_id,last_degree_code,hr_status_desc,lasty_development_trend_code,bachelor_major_cnt,emp_name,doctor_academy_name,main_urgent_name,leader_emp_flag,longest_work_year_com,last_rew_date,bank_exp_year,tenth_job_func_name,contract_agm_type_code,probation_end_date,family_province_desc,last_work_employer,fifth_core_duty_id,thisy_perf_level_rank,sort_num,bank_project_cnt,last_job_func_id,atl_struct_admin_flag,invest_project_cnt,last_mon_wday_sup_otime_dcnt,last_edu_start_date,beforey_perf_level_name,rew_cnt,family_city_desc,con_province_code,last_core_config_name,last_perf_level_rank,atl_struct_address_desc_remark,first_core_duty_name,fina_tec_manager_year,bachelor_academy_name,pun_cnt,beforey_capability_level_code,src_sys,highest_edu_major_code,political_end_date,last_rew_file_no,first_job_func_name,fix_phone,emergency_contact_cnt,highest_edu_end_date,emp_account,last_cycle_type,identity_certificate_address,family_member_com_cnt,atl_struct_country_desc,last_edu_background_code,family_address,con_address,primary_pos_flag,last_eva_group_name,office_email,law_company_id,third_core_duty_name,job_func_names,certificate_second_name_cma,highest_edu_start_date,consecutive_renewals_cnt,lasty_appraiser_score,political_trans_normal_date,threey_perf_level_rank,residence_city_desc,atl_struct_full_name,marital_status_desc,sign_secret_competition_flag,cap_level_id,emp_class_code,days_to_deducted,residence_city_code,submitted_status_code,tech_company_exp_year,residence_province_code,project_manage_exp_cnt,residence_province_desc,last_xfr_eff_date,total_company_flag,atl_struct_full_id,transport_firm_manager_year,identity_city_desc,institute_exp_flag,atl_struct_city_code,actual_birth_date,six_usubmit_sum_cnt,working_hour_system_code,highest_degree_desc,last_leave_other_reason_code,six_uapproval_cnt,last_leave_country_date,pioneer_exp_cnt,lasty_incompetent_flag_code,six_delay_sum_cnt,consultancy4_manager_year,family_country_code,foreign_bank_manager_year,atl_struct_address_full_name,last_leave_reason_desc,work_year,mail_city_desc,political_entry_date,eighth_job_func_name,last_this_company_leave_date,hotel_manager_year,identity_area_code,last_degree_desc,post_duty_name,emp_type_desc,work_gap_duration,emp_status_desc,business_unit_full_name,x_years_rank_diff_num,x_years_pm_rank_up_flag,fina_tec_exp_year,last_job_func_name,level2_leader_emp_id,company_year_area,large_manufacturing_exp_year,last_leave_signed_flag,estate_agency_manager_year,thisy_development_trend_code,pri_fund_manager_year,part_duty_important_flag,last_mon_early_leave_hcnt,thisy_incompetent_flag_code,continuous_rank_first2_cnts,last_pun_result_desc,last_coll_category,last_mon_wday_rel_otime_dcnt,first_core_duty_id,position_short_name,cap_level_name,security_manager_year,law_company_short_name,major_type_cnt,primary_certificate_eff_date,first_job_func_id,second_job_func_name,this_cap_level_duration,headquarter_exp_flag,last_edu_background_desc,new_promote_flag,twelve_animal,atl_struct_address_short_name,passport_country_code,job_pos_name,master_academy_name,work_address_city_desc,elec_business_exp_year,mba_academy_name,last_3_employer,atl_struct_type_desc,business_unit_short_name,x_years_rank_num,sale_exp_year,last_pun_type_desc,fina_regulate_manager_year,last_eva_group_id,master_major_cnt,con_province_desc,third_job_func_name,highest_edu_background_code,bank_project_mange_cnt,on_the_job_flag,eighth_job_func_id,bachelor_degree_cnt,strat_consult_manager_year,last_2_employer,fifth_core_duty_name,thisy_capability_level_code,seventh_core_duty_id,x_years_rank_diff_last,tenth_job_func_id,job_func_ids,last_country_return_date,emp_mobile_number,this_job_level_duration,last_bank_name,master_degree_cnt,last_rew_reason,property_manager_year,family_city_code,last_pun_date,emp_class_desc,choice_cost_type_code,emp_sex_desc,attendance_type_code,level2_leader_emp_account,beforey_capability_level_desc,transfer_position_flag,second_core_duty_id,beforey_development_trend_desc,construct_compy_exp_year,identity_country_desc,last_mon_late_hcnt,last_perf_level_name,last_2_position,ethnicity_code,emp_id,position_desc_remark,finance_exp_year,last_school_name,work_address_province_code,this_job_level_duration_days,last_work_exp_cnt,work_exper_cnt,main_urgent_mobile_num,marry_date,tenth_core_duty_name,transfer_struct_flag,service_start_date,highest_degree_code,last_year_ep,seventh_job_func_name,pub_fund_exp_year,law_firm_manager_year,job_pos_id,atl_struct_id,sixth_core_duty_name,primary_certificate_number,con_city_code,residence_address,senior_cap_duration,con_country_desc,sixth_job_func_name,newest_leave_type_id,sixth_core_duty_id,work_address_short_name,last_branch_name,work_address_city_code,x_years_pm_rank_down_flag,highest_school_name,bach_degree_emp_flag,last_core_config_level_name,last_duty_end_date,highest_edu_region_code,atl_struct_manager_emp_account,last_leave_date,last_pun_file_no,trans_post_duty_cnt,leader_emp_name,elec_business_manager_year,last_work_position,fina_regulate_exp_year,newest_leave_status_desc,last_account_name,work_address_province_desc,lasty_final_score,emp_name_pinyin,pioneer_exp_year,last_pun_final_resolution_desc,transfer_company_flag,insurance_project_mange_cnt,tenth_core_duty_id,rejoin_company_flag,oversea_work_year,identity_country_code,law_exp_year,family_district_desc,last_pun_content,doctor_major_cnt,last_edu_end_date,x_years_pm_rank_fluc_flag,continuous_rank_last1_cnts,political_start_date,political_status_desc,rank_diff_last,last_rew_reference_name,emp_status_code,last_work_industry_id,reh_cons_renewals_cnt,emp_extra_property,residence_area_code,last_major_code,seventh_core_duty_name,last_rew_final_resolution_desc,insurance_project_cnt,last_work_start_date,last_entry_date,atl_struct_country_code,level2_leader_emp_name,highest_study_type_code,primary_certificate_type_code,mail_city_code,con_end_date,trans_position_cnt,residence_area_desc,residence_type_desc,primary_certificate_type_desc,atl_struct_level_desc,post_duty_id,eighth_core_duty_id,threey_appraiser_score,work_address_desc_remark,struct_manager_flag,ep_manage_flag,headhunting_exp_year,part_on_duty_cnt,eighth_core_duty_name,mid_cap_duration,third_job_func_id,company_year_total,beforey_development_trend_code,job_level_without_prefix,gov_bank5_exp_year,last_leave_certificate_number,out_work_exper_postion,identity_city_code,consultancy4_exp_year,row_number,last_action_code,consult_exp_year,last_mon_late_cnt,fin_lease_manager_year,last_1_employer,foreign_bank_exp_year,last_duty_start_date,last_major_desc,lasty_capability_level_desc,six_delay_approval_cnt,last_bank_code,bank_manager_year,age_area,last_pun_reference_name,fifth_job_func_name,inter_invest_manager_year,threey_development_trend_desc,ninth_core_duty_name,newest_leave_end_time,tech_company_manager_year,fourth_job_func_id,con_begin_date,family_province_code,atl_struct_province_code,predict_reg_date,highest_edu_graduat_type_desc,out_work_exper_company,thisy_capability_level_desc,beforey_final_score,last_mon_reality_wday_cnt,law_firm_exp_year,last_mon_punch_cnt,last_branch_code,atl_struct_type_code,mail_address,last_transfer_company_date,job_hopping_cnt,threey_perf_level_name,newest_leave_status_code,identity_address,ethnicity_desc,kpi_lower_sixty_cnt,atl_struct_short_name,doctor_degree_cnt,passport_country_desc,threey_incompetent_flag_desc,years_to_deducted,last_work_industry_name,large_mfg_manager_year,account_payment_account_flag,hr_status_code,atl_struct_manager_emp_name,emp_icon_inner_url,beforey_perf_level_rank,same_contact_flag,beforey_appraiser_score,pub_fund_manager_year,months_to_deducted,contract_unit_desc,inner_work_exper_postion,company_year,last_work_reference_name,last_mon_unusual_cnt,inter_invest_exp_year,work_address_full_name,highest_edu_major_desc,thisy_development_trend_desc,emp_confirm_date,highest_edu_city_code,x_years_up_flag,political_age,sixth_job_func_id,third_core_duty_id,constellation,construct_comy_manager_year,last_action_desc,src_tbl,link_struct_full_name,blood_type_desc,kpi_higher_hundred_cnt,property_exp_year,threey_capability_level_desc,job_hopping_rate,position_full_name,last_1_position,headhunting_manager_year,internet_company_exp_year,last_pun_dept,lnk_struct_flag,continuous_rank_first1_cnts,last_pun_reason,competition_limit_flag,last_3_position,work_address_country_code,native_place,last_leave_other_reason_desc,position_id,long_atl_struct_full_id,junior_cap_duration,contract_agm_type_desc,gov_bank5_manager_year,threey_final_score,family_district_code,manager_exp_year,last_rank_group_id,leader_emp_account,nationality_desc,atl_struct_city_desc,transport_firm_exp_year,threey_capability_level_code from hr_dm.dm_em_summary_info
[2024-07-26 10:50:24,781] {{common_task.py:375}} INFO - ] jdbcUrl:[jdbc:postgresql://29.23.194.73:5432/hr_etl].
[2024-07-26 10:50:33,639] {{common_task.py:375}} INFO - 2024-07-26 10:50:33.638 [job-0] INFO StandAloneJobContainerCommunicator - Total 0 records, 0 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 0.00%
[2024-07-26 10:50:43,641] {{common_task.py:375}} INFO - 2024-07-26 10:50:43.640 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 46.42KB/s, 38 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:50:53,643] {{common_task.py:375}} INFO - 2024-07-26 10:50:53.642 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00% [2024-07-26 10:54:33,672] {{common_task.py:375}} INFO - 2024-07-26 10:54:33.672 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:54:43,673] {{common_task.py:375}} INFO - 2024-07-26 10:54:43.673 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - 2024-07-26 10:55:23.681 [job-0] INFO VMInfo -
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - [delta cpu info] =>
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - curDeltaCpu | averageCpu | maxDeltaCpu | minDeltaCpu
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - -1.00% | -1.00% | -1.00% | -1.00%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO -
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO -
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - [delta memory info] =>
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - NAME | used_size | used_percent | max_used_size | max_percent
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - PS Eden Space | 184.41MB | 72.03% | 184.41MB | 72.03%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - Code Cache | 7.02MB | 99.35% | 7.02MB | 99.35%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - Compressed Class Space | 1.60MB | 91.26% | 1.60MB | 91.26%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - PS Survivor Space | 0.00MB | 0.00% | 0.00MB | 0.00%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - PS Old Gen | 0.00MB | 0.00% | 0.00MB | 0.00%
[2024-07-26 10:55:23,682] {{common_task.py:375}} INFO - Metaspace | 14.68MB | 97.84% | 14.68MB | 97.84%
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO -
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO - [delta gc info] =>
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO - NAME | curDeltaGCCount | totalGCCount | maxDeltaGCCount | minDeltaGCCount | curDeltaGCTime | totalGCTime | maxDeltaGCTime | minDeltaGCTime
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO - PS MarkSweep | 0 | 0 | 0 | 0 | 0.000s | 0.000s | 0.000s | 0.000s
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO - PS Scavenge | 0 | 0 | 0 | 0 | 0.000s | 0.000s | 0.000s | 0.000s
[2024-07-26 10:55:23,683] {{common_task.py:375}} INFO -
[2024-07-26 10:55:33,682] {{common_task.py:375}} INFO - 2024-07-26 10:55:33.682 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
[2024-07-26 10:55:43,683] {{common_task.py:375}} INFO - 2024-07-26 10:55:43.683 [job-0] INFO StandAloneJobContainerCommunicator - Total 381 records, 475356 bytes | Speed 0B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.001s | All Task WaitReaderTime 1.086s | Percentage 0.00%
用的K8S部署,pg库只要一开始写就是client模式