search

dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.42k stars 546 forks source link

MySQL to GreenPlum #840

Closed saga1015 closed 6 years ago

saga1015 commented 6 years ago

mysql version:5.6.32 greenplum version:5.11.0 pgloader version:3.5.1 mysql2gp.load

_LOAD DATABASE
        FROM mysql://palo_load:ttpai@172.16.4.91/ttpai_boss_v1
        INTO postgresql://gpadmin:gpadmin@172.16.4.140:5432/ttpai_boss_v1
WITH create no tables, include no drop, create no indexes;_

when i run pgloader mysql2gp.load,i saw:

2018-09-25T11:22:47.169000+08:00 LOG Migrating from #<MYSQL-CONNECTION mysql://palo_load@172.16.4.91:3306/ttpai_boss_v1 {1008C2F033}>
2018-09-25T11:22:47.172000+08:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://gpadmin@172.16.4.140:5432/ttpai_boss_v1 {1008C309C3}>
2018-09-25T11:22:57.221000+08:00 ERROR Database error 42703: column c.conindid does not exist
QUERY: -- params: including
--         filter-list-to-where-clause for including
--         excluding
--         filter-list-to-where-clause for excluding
  select n.nspname,
         i.relname,
         i.oid,
         rn.nspname,
         r.relname,
         indisprimary,
         indisunique,
         pg_get_indexdef(indexrelid),
         c.conname,
         pg_get_constraintdef(c.oid)
    from pg_index x
         join pg_class i ON i.oid = x.indexrelid
         join pg_class r ON r.oid = x.indrelid
         join pg_namespace n ON n.oid = i.relnamespace
         join pg_namespace rn ON rn.oid = r.relnamespace
         left join pg_constraint c ON c.conindid = i.oid
                                  and c.conrelid = r.oid
                                  -- filter out self-fkeys
                                  and c.confrelid <> r.oid
   where n.nspname !~ '^pg_' and n.nspname <> 'information_schema'
         and ((rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_account$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_account_role$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_account_take$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_aftersale_agency_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_auto_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_auto_schedule_error$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_distribute_bid$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_distribute_bid_temp$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_market$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_market_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_market_template$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_action$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_callphone_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_info_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_info_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_operator_info_phone$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_price_confirm$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_remarks_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_remarks_info_0830_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_short_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_track_note$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_auction_transfer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_autohome_auction_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_biz_cooperation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_business_log_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_business_operate_record$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_business_users$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_business_visit_record$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_bussiness_white_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_call_area_code$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_call_axb$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_call_history_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_car_owner_pricing$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_add_car_specified_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_album$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_back_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_contact_man$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_customer_lic_pic$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_dynamic_prompt$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_ext_pk$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_original_photo$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_remark$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_remote_audit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_anomaly$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_base$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_base_equip$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_description$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_injure_equipment$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_injure_exterior$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_injure_interior$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_injure_mapping$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_injure_skeleton$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_license$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_version$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_report_version_content$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_short_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_status_statis_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_status_statis_sheet$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_status_track$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_video$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_check_vin_black$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_city_hot_familys$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_clid_number$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_follow$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_follow_pic$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_pic$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_remark$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_complaint_result$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_consume$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_consume_send$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_cooperation_auction_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_c_user_suggest$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_data_role$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_data_role_20180710$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_data_role_all$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_dealer_history_address$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_dealer_invite$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_dealer_restock_car$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_invite_allocation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_invite_quality_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_invite_quality_check_mistake$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_invite_quality_check_operator$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_invite_static$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deal_vip$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_deposit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_dept$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_doubt_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_exclude_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_fail_auto_allocation_skill$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_fail_check_invitation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_fee_standard$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_account_report$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_allocation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_apply$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_apply_audit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_ar$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_auction_bank_card$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_auction_lock$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_audit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_audit_item$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_channel_no_task$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_customer_bank_card$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_dealer_bank_card$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_debt_apply$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_gathering$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_llpay_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_llpay_order$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_no_need_audit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_payment_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_prestore_dealers$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_remark$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_remark_0426$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_settlement$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_settlement_task$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_status_track$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_store_bank_card$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_store_code$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_suspend$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_task_count$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_finance_withdrawal$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_fail_activate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_fail_final$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_reception$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_workflow$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_workflow_t1$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_follow_workflow_tmp$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_approved$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_back_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_dealer_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_diff_blame$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_diff_items_report$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_ext$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_report$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_report_media$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_right$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_help_check_status_track$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_hezuo_autohome_widthtable_error$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_import_activate_car_owner$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_import_activate_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_internal_diversity$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_internal_diversity_audit_track_note$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_internal_diversity_report$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_internal_diversity_submit_track_note$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_activate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_area_detail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_area_time$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_auto_assigned$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_auto_assigned_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_call_through$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_city_area$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_dump$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_extend$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_fail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_fail_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_fail_extend$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_follow_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_follow_info_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_follow_info_old$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_group$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_group_account$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_interval$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_join_buick$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_leads_score$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_line_type$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_manualdigging$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_newcar_tip$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_notcall$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_operator_info_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_operator_info_new$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_operator_info_old$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_operator_info_phone$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_pane_lock$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_personnel_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_phone_daily_statistics$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_push_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_quality_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_quality_check_his$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_questionnaire$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_remarks_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_result$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_schedule$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_schedule_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_score_query$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_skill$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_skill_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_skill_group$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_source_demotion$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_source_priority$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_time$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_time_lock$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_invitation_worker_group$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_inv_remote_reason$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_job$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_know_model$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_look_car_type$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_maintenance$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_maintenance_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_message_template$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_mobile_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_mobile__phone_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_new2old_source_convert$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_new_car_signup_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_no_bid_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_oauth_key$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_operate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_operating_center$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_operating_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_origin$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_owner_blacklist$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_owner_whitelist$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_pc_remaining_rate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_aftersale$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_business_visit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_complaint$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_increment$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_phone_history_reception$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_procedures_allot$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_province$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_province_city_area_licence$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_qywx_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_business$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_car_coupon$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_car_owner$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_city_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_deal_vip$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_depart$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_depart_contact$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_depart_detail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_depart_follow$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_depart_old$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_deposit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_deposit_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_local_licensenum$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_move_stuff_follow$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_operator_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_pics$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_pics_temp$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_charge$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_detail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_followup$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_log$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_old$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_position$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_position_log_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_procedures_stuff$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_remarks_info$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_source_vip$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_stuff_submit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_reception_stuff_type$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_recheck_auction_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_resource$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_role$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_role_resource$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_second_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_second_deal$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_short_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_business_blacklist$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_business_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_business_extend$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_bus_city_relation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_city_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_extend$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_signup_invitation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_addcar$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_auction_num$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_bak$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_source_list_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_star_target_car$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_star_target_car_reason$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_star_target_progress$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_star_target_reason$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_stuff_submit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_subsidy_apply$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_activity$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_activity_pay$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_backfail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_contact$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_contact_bak_20180516$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_contact_bak_20180516_1713$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_ext$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_fail$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_id$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_know$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_record$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_remaining_rate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_status_change$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_t1$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auction_violate_audit$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auto_allocation$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auto_allocation_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auto_allocation_skill$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auto_allocation_statis_task$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_auto_fail_day_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_bolt_saled$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_bring$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_callback400$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_callback400_dic$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_callback400_reply$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_city_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_dealer_adjust$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_deal_contact$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_dept_threshold$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_exclude_ids$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_execluded_channel_config$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_fail_activate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_fail_activate_t1$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_fail_byd_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_fail_final$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_group$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_group_manager$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_group_member$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_inquiry_rehandle$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_inquiry_rehandle_exception$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_prepayment$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_prepayment_history$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_price_percent$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_protect_car$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_check$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_check_authority$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_check_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_check_work$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_check_work_authority$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_quality_result$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_reception$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_reception_allocated$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_sale$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_subsidy$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_success_violate_record_follow_status$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_suspect_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_take_number$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_three_auction$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_use_callcenter_account$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_vehicle_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_vin_check_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_violate$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_virtual_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_weixin_dealer_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_white_list_dealer$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^boss_xunke$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^byd_auction_status$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^car_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^hezuo_autohome_width_table$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^hot_city$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^phone_location$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^sell_car_progress_auction_data$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^ttp_phone_message$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_ttp_auction_relative$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_ttp_sign_up_third$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_ttp_sign_up_third_hmc$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_ttp_sign_up_third_prize_cash$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_ttp_sign_up_third_yzh$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^t_utm_source$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^zone$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^zone_around$')
           or (rn.nspname = 'ttpai_boss_v1' and r.relname ~ '^_boss_auction_black_list$'))

order by n.nspname, r.relname
2018-09-25T11:22:57.223000+08:00 FATAL Failed to create the schema, see above.
2018-09-25T11:22:57.225000+08:00 LOG report summary reset
       table name     errors       rows      bytes      total time
-----------------  ---------  ---------  ---------  --------------
  fetch meta data          0        380                     1.984s
-----------------  ---------  ---------  ---------  --------------
-----------------  ---------  ---------  ---------  --------------

**FATAL Failed to create the schema, see above.**

how to slove it?
thank you very very much!!!!

dimitri commented 6 years ago

The query that fails is introspecting the PostgreSQL catalogs to list the Indexes defined in your schema.

It might be that the current master's version of pgloader is good to use though, as the query involved here did change recently: https://github.com/dimitri/pgloader/commit/5119d864f4107f4d4d2e4e850fe4b44dc33a0bbc#diff-c9534ae1cd6968102ad45b324b6184ae. Please build pgloader from current sources and try again.

That said, please report the result in Greenplum from this SQL query, for reference in case we need to add Greenplum as another variant with specific catalog queries.

select version();
saga1015 commented 6 years ago

@dimitri thank you very much :-)

postgres=# select version();
------------
PostgreSQL 8.3.23 (Greenplum Database 5.11.0 build commit:6f447c24554134df0c1d473e63e0124e7ee6de6b) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Sep 12 2018 20:17:30
saga1015 commented 6 years ago

@dimitri i build pgloader from master,but run ./pgloader mysql2gp.load,

[root@tableau bin]# ./pgloader --debug mysql2gp.load 
sb-impl::*default-external-format* :UTF-8
tmpdir: #P"/tmp/pgloader/"
2018-09-25T19:49:09.021000+08:00 NOTICE Starting pgloader, log system is ready.
2018-09-25T19:49:09.052000+08:00 INFO Starting monitor
2018-09-25T19:49:09.059000+08:00 INFO Parsed command:
LOAD DATABASE
        FROM mysql://palo_load:ttpai@172.16.4.91/ttpai_boss_v1
        INTO postgresql://gpadmin:*7n#/ixg@172.16.4.140:5432/boss_v1
;

2018-09-25T19:49:09.097000+08:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://gpadmin@172.16.4.140:5432/boss_v1 {100904A373}>
2018-09-25T19:49:09.097000+08:00 DEBUG SET client_encoding TO 'utf8'
2018-09-25T19:49:09.120000+08:00 DEBUG SET application_name TO 'pgloader'
2018-09-25T19:49:09.178000+08:00 LOG Migrating from #<MYSQL-CONNECTION mysql://palo_load@172.16.4.91:3306/ttpai_boss_v1 {1009048B93}>
2018-09-25T19:49:09.179000+08:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://gpadmin@172.16.4.140:5432/boss_v1 {100904A373}>
2018-09-25T19:49:09.218000+08:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://palo_load@172.16.4.91:3306/ttpai_boss_v1 {1009048B93}>
2018-09-25T19:49:09.221000+08:00 SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
  select c.table_name, t.table_comment,
         c.column_name, c.column_comment,
         c.data_type, c.column_type, c.column_default,
         c.is_nullable, c.extra
    from information_schema.columns c
         join information_schema.tables t using(table_schema, table_name)
   where c.table_schema = 'ttpai_boss_v1' and t.table_type = 'BASE TABLE'

order by table_name, ordinal_position;
2018-09-25T19:49:11.318000+08:00 SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
SELECT s.table_name, s.constraint_name, s.ft, s.cols, s.fcols,
       rc.update_rule, rc.delete_rule

FROM
 (
  SELECT tc.table_schema, tc.table_name,
         tc.constraint_name, k.referenced_table_name ft,

             group_concat(         k.column_name
                          order by k.ordinal_position) as cols,

             group_concat(         k.referenced_column_name
                          order by k.position_in_unique_constraint) as fcols

        FROM information_schema.table_constraints tc

        LEFT JOIN information_schema.key_column_usage k
               ON k.table_schema = tc.table_schema
              AND k.table_name = tc.table_name
              AND k.constraint_name = tc.constraint_name

      WHERE     tc.table_schema = 'ttpai_boss_v1'
            AND k.referenced_table_schema = 'ttpai_boss_v1'
            AND tc.constraint_type = 'FOREIGN KEY'

   GROUP BY tc.table_schema, tc.table_name, tc.constraint_name, ft
 ) s
             JOIN information_schema.referential_constraints rc
               ON rc.constraint_schema = s.table_schema
              AND rc.constraint_name = s.constraint_name
              AND rc.table_name = s.table_name;
2018-09-25T19:49:11.440000+08:00 SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
  SELECT table_name, index_name, index_type,
         sum(non_unique),
         cast(GROUP_CONCAT(column_name order by seq_in_index) as char)
    FROM information_schema.statistics
   WHERE table_schema = 'ttpai_boss_v1'

GROUP BY table_name, index_name, index_type;
2018-09-25T19:49:16.759000+08:00 NOTICE Prepare PostgreSQL database.
2018-09-25T19:49:16.777000+08:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://gpadmin@172.16.4.140:5432/boss_v1 {100801E643}>
2018-09-25T19:49:16.777000+08:00 DEBUG SET client_encoding TO 'utf8'
2018-09-25T19:49:16.803000+08:00 DEBUG SET application_name TO 'pgloader'
2018-09-25T19:49:16.845000+08:00 DEBUG BEGIN
KABOOM!
INFO: Control stack guard page unprotected
Control stack guard page temporarily disabled: proceed with caution
2018-09-25T19:49:17.117000+08:00 INFO Stopping monitor

What I am doing here?

Control stack exhausted (no more space for function call frames).
This is probably due to heavily nested or infinitely recursive function
calls, or a tail call that SBCL cannot or has not optimized away.

PROCEED WITH CAUTION.
dimitri commented 6 years ago

Hi @saga1015 ; that's a different error altogether, nothing to do with catalog support. I'm not sure but it looks related to other issues, such as https://github.com/dimitri/pgloader/issues/810 I think. Closing this one then.