Здравствуйте!
Не могу понять откуда это взялось
и как с этим бороться?
Результат проверки таблиц:
А потом через какое -то время результат проверки таблиц меняется
SQL Query Error
[QUOTE]File: /home/bitrix/www/bitrix/modules/main/include/dbquery_error.php
Query: CHECK TABLE `b_calendar_event_sect`
[[2006] MySQL server has gone away]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/mysql/database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => /home/bitrix/www/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/admin/repair_db.php
[line] => 253
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/bitrix/www/bitrix/admin/repair_db.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/bitrix/www/bitrix/modules/main/admin/repair_db.php
)
)
)
[/QUOTE]
Не могу понять откуда это взялось
и как с этим бороться?
Результат проверки таблиц:
b_calendar_event | 50690 | 22 609 920 | [Warning] InnoDB: Index FTS_DOC_ID_INDEX is marked as corrupted [Warning] InnoDB: Index ix_cal_event_date is marked as corrupted [Warning] InnoDB: Index ix_cal_event_date_utc is marked as corrupted [Warning] InnoDB: Index ix_cal_event_created_by is marked as corrupted [Warning] InnoDB: Index ix_cal_event_parent_id is marked as corrupted [Warning] InnoDB: Index ix_cal_event_owner_id_date is marked as corrupted [Warning] InnoDB: Index ix_cal_event_owner_id_accessibility is marked as corrupted [Warning] InnoDB: Index IXF_B_CALENDAR_EVENT_SEARCHABLE_CONTENT is marked as corrupted [error] Corrupt | [Repair Error] Table 'sitemanager.b_calendar_event' doesn't exist [Repair status] Operation failed [Check Error] Table 'sitemanager.b_calendar_event' doesn't exist [Check status] Operation failed | |
b_calendar_event_sect | 50784 | 2 637 824 | MySQL Query Error: CHECK TABLE `b_calendar_event_sect`[[2006] MySQL server has gone away]
|
А потом через какое -то время результат проверки таблиц меняется
Название таблицы | Количество записей | Размер таблицы (байт) | Результат проверки | Результат восстановления | |
b_admin_notify | 0 | 16 384 | [status] OK | ||
b_admin_notify_lang | 0 | 16 384 | [status] OK | ||
b_agent | 531 | 131 072 | [status] OK | ||
b_app_password | 19 | 16 384 | [status] OK | ||
b_bitrix24_apps | 6 | 16 384 | [status] OK | ||
b_bitrix24_apps_lang | 18 | 16 384 | [status] OK | ||
b_bitrix24_apps_rights | 0 | 16 384 | [status] OK | ||
b_bitrix24_mail_counter | 36 | 16 384 | [status] OK | ||
b_bitrix24_option | 1 | 16 384 | [status] OK | ||
b_bizcard_card | 0 | 16 384 | [status] OK | ||
b_blog | 9 | 16 384 | [status] OK | ||
b_blog_category | 8 | 16 384 | [status] OK | ||
b_blog_comment | 119 | 65 536 | [status] OK | ||
b_blog_group | 2 | 16 384 | [status] OK | ||
b_blog_image | 0 | 16 384 | [status] OK | ||
b_blog_post | 124 | 131 072 | [status] OK | ||
b_blog_post_category | 7 | 16 384 | [status] OK | ||
b_blog_post_param | 116 | 16 384 | [status] OK | ||
b_blog_site_path | 10 | 16 384 | [status] OK | ||
b_blog_socnet | 9 | 16 384 | [status] OK | ||
b_blog_socnet_rights | 288 | 16 384 | [status] OK | ||
b_blog_trackback | 0 | 16 384 | [status] OK | ||
b_blog_user | 8 | 16 384 | [status] OK | ||
b_blog_user2blog | 0 | 16 384 | [status] OK | ||
b_blog_user2user_group | 0 | 16 384 | [status] OK | ||
b_blog_user_group | 2 | 16 384 | [status] OK | ||
b_blog_user_group_perms | 532 | 49 152 | [status] OK | ||
b_bp_history | 53 | 409 600 | [status] OK | ||
b_bp_rest_activity | 0 | 16 384 | [status] OK | ||
b_bp_rest_provider | 0 | 16 384 | [status] OK | ||
b_bp_scheduler_event | 0 | 16 384 | [status] OK | ||
b_bp_task | 0 | 16 384 | [status] OK | ||
b_bp_task_user | 0 | 16 384 | [status] OK | ||
b_bp_tracking | 4728 | 1 425 408 | [status] OK | ||
b_bp_workflow_instance | 142 | 1 081 344 | [status] OK | ||
b_bp_workflow_permissions | 0 | 16 384 | [status] OK | ||
b_bp_workflow_state | 7588 | 1 589 248 | [status] OK | ||
b_bp_workflow_state_identify | 5 | 16 384 | [status] OK | ||
b_bp_workflow_template | 28 | 81 920 | [status] OK | ||
b_cache_tag | 1782 | 212 992 | [status] OK | ||
b_calendar_access | 38 | 16 384 | [status] OK | ||
b_calendar_attendees | 0 | 16 384 | [status] OK | ||
b_calendar_event | 50693 | 22 609 920 | [status] OK | ||
b_calendar_event_sect | 50787 | 2 637 824 | [status] OK | ||
b_calendar_push | 0 | 16 384 | [status] OK | ||
b_calendar_resource | 0 | 16 384 | [status] OK | ||
b_calendar_section | 30 | 16 384 | [status] OK | ||
b_calendar_type | 6 | 16 384 | [status] OK | ||
b_captcha | 0 | 16 384 | [status] OK | ||
b_catalog_contractor | 0 | 16 384 | [status] OK | ||
b_catalog_currency | 5 | 16 384 | [status] OK | ||
b_catalog_currency_lang | 56 | 16 384 | [status] OK | ||
b_catalog_currency_rate | 0 | 16 384 | [status] OK | ||
b_catalog_disc_save_group | 0 | 16 384 | [status] OK | ||
b_catalog_disc_save_range | 0 | 16 384 | [status] OK | ||
b_catalog_disc_save_user | 0 | 16 384 | [status] OK | ||
b_catalog_discount | 0 | 16 384 | [status] OK | ||
b_catalog_discount2cat | 0 | 16 384 | [status] OK | ||
b_catalog_discount2group | 0 | 16 384 | [status] OK | ||
b_catalog_discount2iblock | 0 | 16 384 | [status] OK | ||
b_catalog_discount2product | 0 | 16 384 | [status] OK | ||
b_catalog_discount2section | 0 | 16 384 | [status] OK | ||
b_catalog_discount_cond | 0 | 16 384 | [status] OK | ||
b_catalog_discount_coupon | 0 | 16 384 | [status] OK | ||
b_catalog_discount_module | 0 | 16 384 | [status] OK | ||
b_catalog_docs_barcode | 0 | 16 384 | [status] OK | ||
b_catalog_docs_element | 0 | 16 384 | [status] OK | ||
b_catalog_export | 0 | 16 384 | [status] OK | ||
b_catalog_extra | 0 | 16 384 | [status] OK | ||
b_catalog_group | 1 | 16 384 | [status] OK | ||
b_catalog_group2group | 4 | 16 384 | [status] OK | ||
b_catalog_group_lang | 8 | 16 384 | [status] OK | ||
b_catalog_iblock | 1 | 16 384 | [status] OK | ||
b_catalog_load | 0 | 16 384 | [status] OK | ||
b_catalog_measure | 5 | 16 384 | [status] OK | ||
b_catalog_measure_ratio | 0 | 16 384 | [status] OK | ||
b_catalog_price | 1365 | 114 688 | [status] OK | ||
b_catalog_product | 1365 | 196 608 | [status] OK | ||
b_catalog_product2group | 0 | 16 384 | [status] OK | ||
b_catalog_product_sets | 0 | 16 384 | [status] OK | ||
b_catalog_rounding | 0 | 16 384 | [status] OK | ||
b_catalog_store | 0 | 16 384 | [status] OK | ||
b_catalog_store_barcode | 0 | 16 384 | [status] OK | ||
b_catalog_store_docs | 0 | 16 384 | [status] OK | ||
b_catalog_store_product | 0 | 16 384 | [status] OK | ||
b_catalog_subscribe | 0 | 16 384 | [status] OK | ||
b_catalog_subscribe_access | 0 | 16 384 | [status] OK | ||
b_catalog_vat | 2 | 16 384 | [status] OK | ||
b_catalog_viewed_product | 0 | 16 384 | [status] OK | ||
b_checklist | 0 | 16 384 | [status] OK | ||
b_clouds_file_bucket | 0 | 16 384 | [status] OK | ||
b_clouds_file_resize | 0 | 16 384 | [status] OK | ||
b_clouds_file_upload | 0 | 16 384 | [status] OK | ||
b_component_params | 0 | 16 384 | [status] OK | ||
b_composite_log | 0 | 16 384 | [status] OK | ||
b_composite_page | 0 | 16 384 | [status] OK | ||
b_consent_agreement | 5 | 16 384 | [status] OK | ||
b_consent_field | 4 | 16 384 | [status] OK | ||
b_consent_user_consent | 214 | 65 536 | [status] OK | ||
b_counter_data | 0 | 16 384 | [status] OK | ||
b_crm_act | 76707 | 548 110 336 | [status] OK | ||
b_crm_act_bind | 109899 | 4 734 976 | [status] OK | ||
b_crm_act_channel_stat | 75673 | 4 734 976 | [status] OK | ||
b_crm_act_comm | 116075 | 27 836 416 | [status] OK | ||
b_crm_act_elem | 55202 | 2 637 824 | [status] OK | ||
b_crm_act_mail_meta | 44372 | 5 783 552 | [status] OK | ||
b_crm_act_stat | 93251 | 10 010 624 | [status] OK | ||
b_crm_addr | 17994 | 1 589 248 | [status] OK | ||
b_crm_ads_form_link | 0 | 16 384 | [status] OK | ||
b_crm_automation_template | 17 | 16 384 | [status] OK | ||
b_crm_automation_trigger | 0 | 16 384 | [status] OK | ||
b_crm_automation_trigger_app | 0 | 16 384 | [status] OK | ||
b_crm_bank_detail | 9 | 16 384 | [status] OK | ||
b_crm_biz_type | 51 | 16 384 | [status] OK | ||
b_crm_button | 4 | 16 384 | [status] OK | ||
b_crm_button_avatar | 2 | 16 384 | [status] OK | ||
b_crm_button_guest | 69 | 16 384 | [status] OK | ||
b_crm_button_guest_entity | 82 | 16 384 | [status] OK | ||
b_crm_call_list | 24 | 16 384 | [status] OK | ||
b_crm_call_list_created | 0 | 16 384 | [status] OK | ||
b_crm_call_list_item | 1074 | 65 536 | [status] OK | ||
b_crm_catalog | 1 | 16 384 | [status] OK | ||
b_crm_company | 3037 | 2 637 824 | [status] OK | ||
b_crm_company_act_mark_stat | 15394 | 1 589 248 | [status] OK | ||
b_crm_company_act_stat | 31126 | 2 637 824 | [status] OK | ||
b_crm_company_act_stm_stat | 10830 | 1 589 248 | [status] OK | ||
b_crm_company_act_sts_stat | 9 | 16 384 | [status] OK | ||
b_crm_company_act_sum_stat | 0 | 16 384 | [status] OK | ||
b_crm_company_growth_stat | 3293 | 131 072 | [status] OK | ||
b_crm_contact | 3235 | 1 589 248 | [status] OK | ||
b_crm_contact_act_mark_stat | 7923 | 1 589 248 | [status] OK | ||
b_crm_contact_act_stat | 19388 | 1 589 248 | [status] OK | ||
b_crm_contact_act_stm_stat | 5927 | 458 752 | [status] OK | ||
b_crm_contact_act_sts_stat | 16 | 16 384 | [status] OK | ||
b_crm_contact_act_sum_stat | 0 | 16 384 | [status] OK | ||
b_crm_contact_company | 2837 | 131 072 | [status] OK | ||
b_crm_contact_growth_stat | 3261 | 131 072 | [status] OK | ||
b_crm_conv_map | 5 | 49 152 | [status] OK | ||
b_crm_deal | 1 | 16 384 | [status] OK | ||
b_crm_deal_act_stat | 1 | 16 384 | [status] OK | ||
b_crm_deal_category | 0 | 16 384 | [status] OK | ||
b_crm_deal_channel_stat | 0 | 16 384 | [status] OK | ||
b_crm_deal_contact | 0 | 16 384 | [status] OK | ||
b_crm_deal_inv_stat | 1 | 16 384 | [status] OK | ||
b_crm_deal_recur | 0 | 16 384 | [status] OK | ||
b_crm_deal_stage_history | 0 | 16 384 | [status] OK | ||
b_crm_deal_sum_stat | 1 | 16 384 | [status] OK | ||
b_crm_dp_bd_mcd | 9 | 16 384 | [status] OK | ||
b_crm_dp_comm_mcd | 19018 | 1 589 248 | [status] OK | ||
b_crm_dp_entity_hash | 25227 | 2 637 824 | [status] OK | ||
b_crm_dp_entity_stat | 14705 | 2 637 824 | [status] OK | ||
b_crm_dp_index | 622 | 229 376 | [status] OK | ||
b_crm_dp_index_mismatch | 54 | 16 384 | [status] OK | ||
b_crm_dp_org_mcd | 3396 | 212 992 | [status] OK | ||
b_crm_dp_prsn_mcd | 1584 | 131 072 | [status] OK | ||
b_crm_dp_rq_mcd | 6 | 16 384 | [status] OK | ||
b_crm_entity_cfg | 4 | 16 384 | [status] OK | ||
b_crm_entity_channel | 83714 | 3 686 400 | [status] OK | ||
b_crm_entity_lock | 0 | 16 384 | [status] OK | ||
b_crm_entity_perms | 64047 | 3 686 400 | [status] OK | ||
b_crm_event | 208423 | 277 544 960 | [status] OK | ||
b_crm_event_relations | 340298 | 21 544 960 | [status] OK | ||
b_crm_exclusion | 5 | 16 384 | [status] OK | ||
b_crm_ext_channel_connector | 0 | 16 384 | [status] OK | ||
b_crm_external_sale | 0 | 16 384 | [status] OK | ||
b_crm_field_multi | 21984 | 2 637 824 | [status] OK | ||
b_crm_inv_status_history | 0 | 16 384 | [status] OK | ||
b_crm_invoice | 0 | 16 384 | [status] OK | ||
b_crm_invoice_basket | 0 | 16 384 | [status] OK | ||
b_crm_invoice_basket_props | 0 | 16 384 | [status] OK | ||
b_crm_invoice_change | 37 | 16 384 | [status] OK | ||
b_crm_invoice_coupons | 0 | 16 384 | [status] OK | ||
b_crm_invoice_delivery | 0 | 16 384 | [status] OK | ||
b_crm_invoice_discount | 0 | 16 384 | [status] OK | ||
b_crm_invoice_discount_data | 0 | 16 384 | [status] OK | ||
b_crm_invoice_dlv_basket | 0 | 16 384 | [status] OK | ||
b_crm_invoice_entity_marker | 0 | 16 384 | [status] OK | ||
b_crm_invoice_modules | 0 | 16 384 | [status] OK | ||
b_crm_invoice_payment | 1 | 16 384 | [status] OK | ||
b_crm_invoice_props_value | 0 | 16 384 | [status] OK | ||
b_crm_invoice_recur | 0 | 16 384 | [status] OK | ||
b_crm_invoice_round | 0 | 16 384 | [status] OK | ||
b_crm_invoice_rules | 0 | 16 384 | [status] OK | ||
b_crm_invoice_rules_descr | 0 | 16 384 | [status] OK | ||
b_crm_invoice_sum_stat | 1 | 16 384 | [status] OK | ||
b_crm_invoice_tax | 0 | 16 384 | [status] OK | ||
b_crm_kanban_sort | 161 | 16 384 | [status] OK | ||
b_crm_kanban_supervisor | 0 | 16 384 | [status] OK | ||
b_crm_lead | 8045 | 7 880 704 | MySQL Query Error: CHECK TABLE `b_crm_lead`[[2006] MySQL server has gone away]
|
SQL Query Error
[QUOTE]File: /home/bitrix/www/bitrix/modules/main/include/dbquery_error.php
Query: CHECK TABLE `b_calendar_event_sect`
[[2006] MySQL server has gone away]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/classes/mysql/database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => /home/bitrix/www/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/bitrix/www/bitrix/modules/main/admin/repair_db.php
[line] => 253
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/bitrix/www/bitrix/admin/repair_db.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/bitrix/www/bitrix/modules/main/admin/repair_db.php
)
)
)
[/QUOTE]