[MDEV-28772] Mariabackup locks database for minutes since 10.8.3 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.8.3
Fix Version/s: 10.8.6, 10.9.4, 10.10.2, 10.11.1
Component/s: mariabackup
Labels:
- regression

Description

We just upgraded mariadb from 10.7.3 to 10.8.3 and now backup locks the whole database for minutes, before the change the lock was only 3 or 4 seconds (no hardware change, beefy server).

This is the command we use for backup:

    mariabackup --backup --host="production.travelc.internal" --stream=xbstream  --target-dir /backup/dump --user someuser --password somepassword --use-memory=12288M | pigz -p 4 > /backup/dump/mariadbbackup-2022-06-08.gz

With 10.8.3 the lock block (executed at the end) is much slower now:

   11:45:25  PRODUCTION: [00] 2022-06-08 09:45:25 Acquiring BACKUP LOCKS...

    11:45:26  PRODUCTION: [00] 2022-06-08 09:45:25 Starting to backup non-InnoDB tables and files

    11:45:26  PRODUCTION: [01] 2022-06-08 09:45:25 Streaming ./travelc/powerbi_bookedhotelservice.frm to <STDOUT>

    11:45:26  PRODUCTION: [01] 2022-06-08 09:45:25         ...done

    11:45:26  PRODUCTION: [01] 2022-06-08 09:45:25 Streaming ./travelc/contract_apartment_room_facility.frm to <STDOUT>

    11:45:27  PRODUCTION: [00] 2022-06-08 09:45:27 >> log scanned up to (3530424892051)

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27         ...done

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27 Streaming ./travelc/promotioncode_use.frm to <STDOUT>

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27         ...done

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27 Streaming ./travelc/microsite_loyalty_settings.frm to <STDOUT>

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27         ...done

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27 Streaming ./travelc/atlante_pushed_cancelled_services.frm to <STDOUT>

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27         ...done

    11:45:27  PRODUCTION: [01] 2022-06-08 09:45:27 Streaming ./travelc/channel_rate_room_closed_to_arrival.frm to <STDOUT>

    11:45:30  PRODUCTION: [00] 2022-06-08 09:45:29 >> log scanned up to (3530424918499)

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29         ...done

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29 Streaming ./travelc/cruise_route_region.frm to <STDOUT>

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29         ...done

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29 Streaming ./travelc/cruiseline_included_i18n.frm to <STDOUT>

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29         ...done

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29 Streaming ./travelc/contract_closedtour_modality.frm to <STDOUT>

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29         ...done

    11:45:30  PRODUCTION: [01] 2022-06-08 09:45:29 Streaming ./travelc/contract_event.frm to <STDOUT>

    11:45:32  PRODUCTION: [00] 2022-06-08 09:45:32 >> log scanned up to (3530424949156)

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32         ...done

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32 Streaming ./travelc/channel_rate_room.frm to <STDOUT>

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32         ...done

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32 Streaming ./travelc/contract_private_tour_price.frm to <STDOUT>

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32         ...done

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32 Streaming ./travelc/vecilatam_airline_cash_payment.frm to <STDOUT>

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32         ...done

    11:45:32  PRODUCTION: [01] 2022-06-08 09:45:32 Streaming ./travelc/world2meet_hotel_provider_configuration_copy.frm to <STDOUT>

    11:45:35  PRODUCTION: [00] 2022-06-08 09:45:34 >> log scanned up to (3530424992606)

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34         ...done

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34 Streaming ./travelc/contract_hotel_rate_room_stop_sales.frm to <STDOUT>

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34         ...done

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34 Streaming ./travelc/trippaymentrefund.frm to <STDOUT>

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34         ...done

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34 Streaming ./travelc/hotel_roomingtemplates.frm to <STDOUT>

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34         ...done

    11:45:35  PRODUCTION: [01] 2022-06-08 09:45:34 Streaming ./travelc/contract_hotel_remarks_i18n.frm to <STDOUT>

    11:45:37  PRODUCTION: [00] 2022-06-08 09:45:37 >> log scanned up to (3530425039695)

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37         ...done

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37 Streaming ./travelc/gift_box_promotion_code.frm to <STDOUT>

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37         ...done

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37 Streaming ./travelc/europassistance_territorial_scope.frm to <STDOUT>

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37         ...done

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37 Streaming ./travelc/insurance_configuration_terms_i18n.frm to <STDOUT>

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37         ...done

    11:45:37  PRODUCTION: [01] 2022-06-08 09:45:37 Streaming ./travelc/carrental_office_i18n.frm to <STDOUT>

    11:45:40  PRODUCTION: [00] 2022-06-08 09:45:39 >> log scanned up to (3530425048820)

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39         ...done

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39 Streaming ./travelc/powerbi_providerconfiguration.frm to <STDOUT>

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39         ...done

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39 Streaming ./travelc/bookedeventservice.frm to <STDOUT>

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39         ...done

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39 Streaming ./travelc/contract_closedtour_supplement_i18n.frm to <STDOUT>

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39         ...done

    11:45:40  PRODUCTION: [01] 2022-06-08 09:45:39 Streaming ./travelc/promotion_code_country.frm to <STDOUT>

    11:45:42  PRODUCTION: [00] 2022-06-08 09:45:42 >> log scanned up to (3530425067126)

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42         ...done

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42 Streaming ./travelc/insurance_microsite.frm to <STDOUT>

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42         ...done

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42 Streaming ./travelc/pushbookingconfiguration.frm to <STDOUT>

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42         ...done

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42 Streaming ./travelc/qr_configuration_destination.frm to <STDOUT>

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42         ...done

    11:45:42  PRODUCTION: [01] 2022-06-08 09:45:42 Streaming ./travelc/repricing_hotel.frm to <STDOUT>

    11:45:45  PRODUCTION: [00] 2022-06-08 09:45:44 >> log scanned up to (3530425076298)

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44         ...done

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44 Streaming ./travelc/bookedtrippdf.frm to <STDOUT>

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44         ...done

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44 Streaming ./travelc/powerbi_destination.frm to <STDOUT>

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44         ...done

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44 Streaming ./travelc/tripnode.frm to <STDOUT>

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44         ...done

    11:45:45  PRODUCTION: [01] 2022-06-08 09:45:44 Streaming ./travelc/service_offer_supplier.frm to <STDOUT>

    11:45:47  PRODUCTION: [00] 2022-06-08 09:45:47 >> log scanned up to (3530425080390)

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47         ...done

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47 Streaming ./travelc/campaign.frm to <STDOUT>

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47         ...done

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47 Streaming ./travelc/transport_service_offer_continent_arrival.frm to <STDOUT>

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47         ...done

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47 Streaming ./travelc/themei18n.frm to <STDOUT>

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47         ...done

    11:45:47  PRODUCTION: [01] 2022-06-08 09:45:47 Streaming ./travelc/contract_transfer_prices.frm to <STDOUT>

    11:45:49  PRODUCTION: [00] 2022-06-08 09:45:49 >> log scanned up to (3530425099530)

    11:45:49  PRODUCTION: [01] 2022-06-08 09:45:49         ...done

    11:45:49  PRODUCTION: [01] 2022-06-08 09:45:49 Streaming ./travelc/atlante_additional_practice_references.frm to <STDOUT>

    11:45:49  PRODUCTION: [01] 2022-06-08 09:45:49         ...done

    ....

With 10.7.3 the whole lock block was just 3 seconds. Log sample is:

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 Acquiring BACKUP LOCKS...

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040507593)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040507891)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040508531)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040508742)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040509143)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040509425)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040509738)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040510037)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040510330)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040510645)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040510929)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040511226)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040511868)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040512225)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040512527)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040512810)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040513123)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040513406)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040513703)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040514143)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040514747)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040515031)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040515354)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040515653)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040516058)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040516140)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040517523)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040517852)

    00:24:11  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040518356)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040518828)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040518877)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040519296)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040519576)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040519868)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040520163)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040520464)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040520760)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040521271)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040521507)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040521695)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040522017)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040522313)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040522608)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040522860)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040523216)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040523568)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040524062)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040524486)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040524791)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040525105)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040525527)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:11 >> log scanned up to (3495040525838)

    00:24:12  PRODUCTION: 2022-06-02 22:24:12 0 [Note] InnoDB: Read redo log up to LSN=3495040526336

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040525838)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040526125)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040526425)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040526766)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040527076)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040527376)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040527668)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040527983)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 Starting to backup non-InnoDB tables and files

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/powerbi_bookedhotelservice.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_apartment_room_facility.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/promotioncode_use.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/microsite_loyalty_settings.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/atlante_pushed_cancelled_services.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/channel_rate_room_closed_to_arrival.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/cruise_route_region.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/cruiseline_included_i18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_closedtour_modality.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_event.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/channel_rate_room.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_private_tour_price.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/vecilatam_airline_cash_payment.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/world2meet_hotel_provider_configuration_copy.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_hotel_rate_room_stop_sales.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/trippaymentrefund.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/hotel_roomingtemplates.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_hotel_remarks_i18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/gift_box_promotion_code.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/europassistance_territorial_scope.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/insurance_configuration_terms_i18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/carrental_office_i18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/powerbi_providerconfiguration.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/bookedeventservice.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_closedtour_supplement_i18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/promotion_code_country.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/insurance_microsite.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/pushbookingconfiguration.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/qr_configuration_destination.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/repricing_hotel.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/bookedtrippdf.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/powerbi_destination.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/tripnode.frm to <STDOUT>

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/service_offer_supplier.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/campaign.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/transport_service_offer_continent_arrival.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/themei18n.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/contract_transfer_prices.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12 Streaming ./travelc/atlante_additional_practice_references.frm to <STDOUT>

    00:24:12  PRODUCTION: [00] 2022-06-02 22:24:12 >> log scanned up to (3495040528266)

    00:24:12  PRODUCTION: [01] 2022-06-02 22:24:12         ...done

We tried purging all binary logs at the beginning with no luck. Where can we look at?

Attachments

Issue Links

is duplicated by

MDEV-28955 MariaBackup is locking my database (and causing downtime) for 30 minutes

Closed

MDEV-29631 Mariabackup blocks connections until it ends

Closed

relates to

MDEV-28758 Mariabackup copies binary logs to backup directory

Closed

Activity

Transition	Time In Source Status	Execution Times

Marko Mäkelä made transition - 2022-08-02 12:28

Open

Needs Feedback

55d 1h 42m

Sergei Golubchik made transition - 2022-09-19 10:05

Needs Feedback

Open

47d 21h 36m

Marko Mäkelä made transition - 2022-10-03 06:40

Open

In Progress

13d 20h 35m

Marko Mäkelä made transition - 2022-10-17 14:37

In Progress

Closed

14d 7h 56m

People

Assignee:: Marko Mäkelä

Reporter:: Vicente Rossello Jaume

Votes:: 3 Vote for this issue

Watchers:: 10 Start watching this issue

Dates

Created:: 2022-06-08 10:46

Updated:: 2023-06-30 20:30

Resolved:: 2022-10-17 14:37

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration