[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

Ascending order - Click to sort in descending order

View 71 older comments

Vicente Rossello Jaume added a comment - 2022-10-18 12:44

Where can I find the executable? sorry, i'm rather a newbie with deb files and that stuff

Vicente Rossello Jaume added a comment - 2022-10-18 12:44 Where can I find the executable? sorry, i'm rather a newbie with deb files and that stuff

Nuno added a comment - 2022-10-18 12:49

Files here: https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/

would it be the "kvm-deb-focal-amd64" one maybe?
https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/kvm-deb-focal-amd64/debs/binary/

https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/kvm-deb-focal-amd64/debs/binary/mariadb-backup_10.8.6+maria~ubu2004_amd64.deb

Then extract the files of the ".deb" file with 7-zip, and go up to the folder "\mariadb-backup_10.8.6+maria_ubu2004_amd64.deb\data.tar\.\usr\bin\"
And there you find the "mariadb-backup" file.

Nuno added a comment - 2022-10-18 12:49 Files here: https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/ would it be the "kvm-deb-focal-amd64" one maybe? https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/kvm-deb-focal-amd64/debs/binary/ https://hasky.askmonty.org/archive/bb-10.8-release/build-50973/kvm-deb-focal-amd64/debs/binary/mariadb-backup_10.8.6+maria~ubu2004_amd64.deb Then extract the files of the ".deb" file with 7-zip, and go up to the folder "\mariadb-backup_10.8.6+maria_ubu2004_amd64.deb\data.tar\.\usr\bin\" And there you find the "mariadb-backup" file.

Vicente Rossello Jaume added a comment - 2022-10-18 13:36

Thanks, I was trying to decompress the wrong deb file

Vicente Rossello Jaume added a comment - 2022-10-18 13:36 Thanks, I was trying to decompress the wrong deb file

Marko Mäkelä added a comment - 2022-10-18 13:51

nunop, thank you for helping out. Yes, it is exactly that build number 50973. Alternatively, you can find the final version at http://hasky.askmonty.org/archive/10.8/build-51011/ or using a later build number.

Marko Mäkelä added a comment - 2022-10-18 13:51 nunop , thank you for helping out. Yes, it is exactly that build number 50973. Alternatively, you can find the final version at http://hasky.askmonty.org/archive/10.8/build-51011/ or using a later build number.

Vicente Rossello Jaume added a comment - 2022-10-18 15:12

2 second lock with that version of mariadb-backup, innodb_log_file_buffering=OFF on the server and default log-copy-interval. It worked fine for us

Vicente Rossello Jaume added a comment - 2022-10-18 15:12 2 second lock with that version of mariadb-backup, innodb_log_file_buffering=OFF on the server and default log-copy-interval. It worked fine for us

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