【 使用环境 】测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.2.1.3
【问题描述】
使用导数工具将本实例的sys租户的数据库导出再导入到业务租户,导入的过程非常慢,103M,总的花费了一个小时,并且导入完成 后结果是这样
All Load Tasks Finished:
No.# | Type | Name | Count | Status
1 | TABLE | apaas_meta_group_field_rel | 3 -> 3 | SUCCESS
2 | TABLE | apaas_form_template | 5 -> 5 | SUCCESS
3 | TABLE | apaas_meta_group | 6 -> 6 | SUCCESS
4 | TABLE | apaas_meta_field | 6 -> 6 | SUCCESS
5 | TABLE | apaas_form_query | 3 -> 3 | SUCCESS
6 | TABLE | apaas_user_login_info | 3 -> 3 | SUCCESS
7 | TABLE | apaas_data_tpl_export_record | 2 -> 2 | SUCCESS
8 | TABLE | apaas_form_def | 5 -> 5 | SUCCESS
9 | TABLE | apaas_form_rights | 8 -> 8 | SUCCESS
10 | TABLE | apaas_form_data_template_tpl | 3 -> 3 | SUCCESS
11 | TABLE | apaas_form_dialog | 3 -> 3 | SUCCESS
12 | TABLE | apaas_form_selector | 2 -> 2 | SUCCESS
13 | TABLE | apaas_form_print_template | 5 -> 5 | SUCCESS
14 | TABLE | apaas_form_def_bak | 5 -> 5 | SUCCESS
15 | TABLE | apaas_form_field | 4 -> 4 | SUCCESS
16 | TABLE | apaas_meta_group_dtl | 7 -> 7 | SUCCESS
17 | TABLE | apaas_data_template_field | 3 -> 3 | SUCCESS
18 | TABLE | apaas_form_bo | 4 -> 4 | SUCCESS
19 | TABLE | apaas_system_watermark | 7 -> 7 | SUCCESS
20 | TABLE | apaas_data_template_tpl | 3 -> 3 | SUCCESS
21 | TABLE | apaas_form_data_template | 2 -> 2 | SUCCESS
22 | TABLE | apaas_data_template_def | 6 -> 6 | SUCCESS
23 | TABLE | apaas_form_print_range | 3 -> 3 | SUCCESS
24 | TABLE | apaas_form_options_template | 3 -> 3 | SUCCESS
25 | TABLE | apaas_db_upgrade | 2 -> 2 | SUCCESS
No.# | Type | Name | Count | Status
1 | TABLE | apaas_bpm_exec | 7 -> 0 | FAILURE
2 | TABLE | apaas_bpm_exec_err | 2 -> 0 | FAILURE
3 | TABLE | apaas_bpm_inst_his | 10 -> 0 | FAILURE
4 | TABLE |t_dh_vendor_supply_service_scope| 6 -> 0 | FAILURE
5 | TABLE | act_re_deployment | 2 -> 0 | FAILURE
6 | TABLE | act_ru_event_subscr | 3 -> 0 | FAILURE
7 | TABLE | act_id_membership | 2 -> 0 | FAILURE
8 | TABLE | apaas_bpm_def_xml | 2 -> 0 | FAILURE
9 | TABLE | apaas_bpm_exec_seq | 4 -> 0 | FAILURE
10 | TABLE | act_ru_identitylink | 5 -> 0 | FAILURE
11 | TABLE | apaas_login_log | 4 -> 0 | FAILURE
12 | TABLE | apaas_bo_table | 6 -> 0 | FAILURE
13 | TABLE |t_dh_vendor_valuation_statistic | 6 -> 0 | FAILURE
14 | TABLE | apaas_form_field_his | 4 -> 0 | FAILURE
15 | TABLE | t_dh_vendor_valuation_dtl | 6 -> 0 | FAILURE
16 | TABLE | t_dh_vendor_grade | 6 -> 0 | FAILURE
17 | TABLE | apaas_auth_org_rel | 2 -> 0 | FAILURE
18 | TABLE | act_hi_actinst | 6 -> 0 | FAILURE
19 | TABLE | act_hi_identitylink | 5 -> 0 | FAILURE
20 | TABLE | apaas_wechat_msg | 3 -> 0 | FAILURE
21 | TABLE | apaas_bpm_bus_rel | 5 -> 0 | FAILURE
22 | TABLE | apaas_bo_attr | 4 -> 0 | FAILURE
23 | TABLE | apaas_bpm_auths | 3 -> 0 | FAILURE
24 | TABLE | apaas_bpm_agent_def | 4 -> 0 | FAILURE
25 | TABLE | apaas_bpm_guide | 3 -> 0 | FAILURE
26 | TABLE | apaas_auth_group_user_dtl | 3 -> 0 | FAILURE
27 | TABLE | apaas_bpm_favorites | 4 -> 0 | FAILURE
28 | TABLE | apaas_bpm_task_supervise | 3 -> 0 | FAILURE
29 | TABLE | act_ru_variable | 3 -> 0 | FAILURE
30 | TABLE | demo_url_fom_sub_2 | 2 -> 0 | FAILURE
31 | TABLE | act_re_procdef | 2 -> 0 | FAILURE
32 | TABLE | act_hi_procinst | 4 -> 0 | FAILURE
33 | TABLE | apaas_data_template_app | 5 -> 3 | FAILURE
34 | TABLE | act_hi_attachment | 2 -> 0 | FAILURE
35 | TABLE | act_evt_log | 2 -> 0 | FAILURE
36 | TABLE | apaas_bpm_task_pendding | 7 -> 0 | FAILURE
37 | TABLE | apaas_bpm_approval_his | 8 -> 0 | FAILURE
38 | TABLE | apaas_bo_inst | 4 -> 0 | FAILURE
39 | TABLE | apaas_auth_res_rel | 2 -> 0 | FAILURE
40 | TABLE | apaas_data_dataset | 5 -> 0 | FAILURE
41 | TABLE | apaas_code_field_config | 3 -> 0 | FAILURE
42 | TABLE | act_ru_task | 3 -> 0 | FAILURE
43 | TABLE | apaas_bo_column | 5 -> 0 | FAILURE
44 | TABLE | apaas_field_set | 4 -> 0 | FAILURE
45 | TABLE | apaas_code_scheme | 6 -> 0 | FAILURE
46 | TABLE | t_dh_core_index | 6 -> 0 | FAILURE
47 | TABLE | t_dh_vendor_certificate | 6 -> 0 | FAILURE
48 | TABLE | demo_url_form | 2 -> 0 | FAILURE
49 | TABLE | apaas_bpm_task_supervise_rec | 3 -> 0 | FAILURE
50 | TABLE | apaas_bpm_auths_def | 4 -> 0 | FAILURE
51 | TABLE | apaas_bpm_def_jump_range | 4 -> 0 | FAILURE
52 | TABLE | apaas_bpm_oper_notify_recer | 4 -> 0 | FAILURE
53 | TABLE | apaas_code_table_config | 5 -> 0 | FAILURE
54 | TABLE | apaas_bpm_triger_flow | 6 -> 0 | FAILURE
55 | TABLE | act_ge_property | 2 -> 0 | FAILURE
56 | TABLE | apaas_code_scheme_param | 3 -> 0 | FAILURE
57 | TABLE | apaas_code_do_type | 6 -> 0 | FAILURE
58 | TABLE | apaas_bpm_task_change | 8 -> 0 | FAILURE
59 | TABLE | apaas_bpm_agent | 8 -> 0 | FAILURE
60 | TABLE | apaas_bpm_task_assign | 5 -> 0 | FAILURE
61 | TABLE | apaas_code_variable | 5 -> 0 | FAILURE
62 | TABLE | apaas_bpm_approval | 11 -> 0 | FAILURE
63 | TABLE | act_hi_taskinst | 3 -> 0 | FAILURE
64 | TABLE | demo_url_fom_sub | 2 -> 0 | FAILURE
65 | TABLE | apaas_bpm_triger_param | 3 -> 0 | FAILURE
66 | TABLE | apaas_bo_index | 8 -> 0 | FAILURE
67 | TABLE | apaas_bpm_agent_condition | 4 -> 0 | FAILURE
68 | TABLE | apaas_bo_attr_column | 7 -> 0 | FAILURE
69 | TABLE | apaas_bpm_task_sign | 8 -> 0 | FAILURE
70 | TABLE | act_ru_execution | 3 -> 0 | FAILURE
71 | TABLE | apaas_auth_group_field_dtl | 3 -> 0 | FAILURE
72 | TABLE | act_ge_bytearray | 4 -> 0 | FAILURE
73 | TABLE | apaas_bpm_oper_notify | 7 -> 0 | FAILURE
74 | TABLE | apaas_bpm_task_supervise_user | 3 -> 0 | FAILURE
75 | TABLE | act_id_info | 2 -> 0 | FAILURE
76 | TABLE | apaas_business_op_log | 7 -> 0 | FAILURE
77 | TABLE | apaas_bpm_task_reminder | 5 -> 0 | FAILURE
78 | TABLE | apaas_bpm_def | 14 -> 0 | FAILURE
79 | TABLE | act_hi_comment | 2 -> 0 | FAILURE
80 | TABLE | apaas_bo_def_rel | 5 -> 0 | FAILURE
81 | TABLE | apaas_auth_group | 2 -> 0 | FAILURE
82 | TABLE | apaas_bpm_task_change_assign | 4 -> 0 | FAILURE
83 | TABLE | apaas_auth_field | 2 -> 0 | FAILURE
84 | TABLE | apaas_business_log | 6 -> 0 | FAILURE
85 | TABLE | apaas_bpm_task_reminder_rec | 4 -> 0 | FAILURE
86 | TABLE | apaas_field_scheme | 3 -> 0 | FAILURE
87 | TABLE | apaas_bpm_inst | 9 -> 0 | FAILURE
88 | TABLE | apaas_bpm_form_rights | 5 -> 0 | FAILURE
89 | TABLE | apaas_bo_def | 6 -> 0 | FAILURE
90 | TABLE | apaas_form_def_his | 6 -> 0 | FAILURE
91 | TABLE | apaas_code_template | 5 -> 0 | FAILURE
92 | TABLE | act_hi_varinst | 5 -> 0 | FAILURE
93 | TABLE | act_id_group | 2 -> 0 | FAILURE
94 | TABLE | act_hi_detail | 7 -> 0 | FAILURE
95 | TABLE | act_id_user | 2 -> 0 | FAILURE
96 | TABLE | apaas_form_bo_his | 4 -> 0 | FAILURE
97 | TABLE | act_ru_job | 2 -> 0 | FAILURE
98 | TABLE | act_procdef_info | 3 -> 0 | FAILURE
99 | TABLE | apaas_bpm_oper_log | 8 -> 0 | FAILURE
100 | TABLE | t_dh_vendor_info | 6 -> 0 | FAILURE
101 | TABLE | act_re_model | 2 -> 0 | FAILURE
102 | TABLE | apaas_bpm_common_statment | 5 -> 0 | FAILURE
103 | TABLE | apaas_bo_table_rel | 5 -> 0 | FAILURE
104 | TABLE | apaas_bpm_tasks | 12 -> 0 | FAILURE
105 | VIEW | v_contract_can_change_list | 2 -> 0 | FAILURE
106 | VIEW | v_receipt_dtl | 2 -> 0 | FAILURE
107 | VIEW | v_purchase | 2 -> 0 | FAILURE
108 | VIEW | v_inquiry_list | 2 -> 0 | FAILURE
109 | VIEW | v_cp_delivery_list | 2 -> 0 | FAILURE
110 | VIEW | v_currency_org_list | 2 -> 0 | FAILURE
111 | VIEW | v_pre_invoice_dtl | 2 -> 0 | FAILURE
112 | VIEW | v_bid_eval_list | 2 -> 0 | FAILURE
113 | VIEW | v_pricing_list | 2 -> 0 | FAILURE
114 | VIEW | v_quote_apply_list | 2 -> 0 | FAILURE
115 | VIEW | v_bid_eval_bid | 2 -> 0 | FAILURE
116 | VIEW | v_purchase_requisition_col | 2 -> 0 | FAILURE
117 | VIEW | v_delivery_list | 2 -> 0 | FAILURE
118 | VIEW | v_source_result | 2 -> 0 | FAILURE
119 | VIEW | v_invoice_open | 2 -> 0 | FAILURE
120 | VIEW | v_purchase_requisition_main | 2 -> 0 | FAILURE
121 | VIEW | v_ss_material_price_record_dtl | 2 -> 0 | FAILURE
122 | VIEW | v_bid_submit_list | 2 -> 0 | FAILURE
123 | VIEW | v_eval_system | 2 -> 0 | FAILURE
124 | VIEW | v_quote_and_inquiry | 2 -> 0 | FAILURE
125 | VIEW | v_purchase_order_dtl_list | 2 -> 0 | FAILURE
126 | VIEW | v_ss_purchase_order_dtl | 2 -> 0 | FAILURE
127 | VIEW | v_pre_receipt_dtl | 2 -> 0 | FAILURE
128 | VIEW | v_bid_sure_list | 2 -> 0 | FAILURE
129 | VIEW | v_correcti_no_origin_list | 2 -> 0 | FAILURE
130 | VIEW | v_purchase_requisition | 2 -> 0 | FAILURE
131 | VIEW |v_sl_vendor_preformance_dtl_list| 2 -> 0 | FAILURE
Total Count: 106 End Time: 2024-02-20 12:05:50
查看报错日志会有以下错误日志:
2024-02-20 12:05:50 [ERROR] Error: Loading SQL-format file: “/backup_2/data/apaas_business_crrc_dc/TABLE/apaas_bpm_bus_rel-schema.sql” f
ailure. Reason: The RootServer is not the master. Please see …/logs/ob-loader-dumper.error,查看这个ob-loader.error日志也是同样的报错日志