ERPNext Bench Backup is not working

ERPNext
1

My DB size 20GB, I have run bench backup which is not working. But it was okay previously, suddenly it stop working. I got this error in mariadb Log

image
image1053×161 23.7 KB

Is their any possible solution to fix this ?

2

I think there is a -verbose parameter which yields more information.

3

I have tried this , but still got the same error

image
image1006×100 14.6 KB

mariadb log

image
image1042×139 20.2 KB

4

Hi @Shaid_Azmin:

Maybe related to mysql config …
Check / set larger value to this variable

net_write_timeout

Hope this helps.

5

this is my mariadb compose file

I have added Innodb Buffer Size and MAX ALLOWED PACKET

SET GLOBAL innodb_buffer_pool_size=(40 * 1024 * 1024 * 1024);

SET GLOBAL max_allowed_packet=1073741824;

version: "3.7"

services:
  mariadb-master:
    image: 'bitnami/mariadb:10.3'
    deploy:
      restart_policy:
        condition: on-failure
    networks:
      - frappe-network
    volumes:
      - 'mariadb_master_data:/bitnami/mariadb'
    environment:
      - MARIADB_CHARACTER_SET=utf8mb4
      - MARIADB_COLLATE=utf8mb4_unicode_ci
      - MARIADB_EXTRA_FLAGS=--skip-character-set-client-handshake
      - MARIADB_REPLICATION_MODE=master
      - MARIADB_REPLICATION_USER=repl_user
      - MARIADB_REPLICATION_PASSWORD=example
      - MARIADB_ROOT_PASSWORD=example

  mariadb-slave:
    image: 'bitnami/mariadb:10.3'
    deploy:
      restart_policy:
        condition: on-failure
    networks:
      - frappe-network
    volumes:
      - 'mariadb_slave_data:/bitnami/mariadb'
    environment:
      - MARIADB_CHARACTER_SET=utf8mb4
      - MARIADB_COLLATE=utf8mb4_unicode_ci
      - MARIADB_EXTRA_FLAGS=--skip-character-set-client-handshake
      - MARIADB_REPLICATION_MODE=slave
      - MARIADB_REPLICATION_USER=repl_user
      - MARIADB_REPLICATION_PASSWORD=example
      - MARIADB_MASTER_HOST=mariadb-master
      - MARIADB_MASTER_PORT_NUMBER=3306
      - MARIADB_MASTER_ROOT_PASSWORD=example

volumes:
  mariadb_master_data:
  mariadb_slave_data:

networks:
  frappe-network:
    name: frappe-network
    attachable: true