wodby / mariadb

MariaDB docker container image
https://wodby.com/stacks/mariadb
GNU General Public License v2.0
49 stars 31 forks source link

when import sql file Lost connection to server during query #35

Open zhouitpro opened 3 years ago

zhouitpro commented 3 years ago

ERROR 2013 (HY000) at line 2239 in file: '/Users/zhouitpro/Downloads/database.sql': Lost connection to server during query ERROR 2006 (HY000) at line 2240 in file: '/Users/zhouitpro/Downloads/database.sql': Server has gone away No connection. Trying to reconnect... ERROR 2013 (HY000) at line 2240 in file: '/Users/zhouitpro/Downloads/database.sql': Lost connection to server at 'handshake: reading initial communication packet', system error: 35 ERROR at line 2240 in file: '/Users/zhouitpro/Downloads/database.sql': Can't connect to the server

No connection. Trying to reconnect...

my docker-compose.yml

version: "3"
services:
  mariadb:
    image: wodby/mariadb:10.5
    container_name: mariadb
    ports:
      - 3306:3306
    volumes:
      - ./mariadb-data:/var/lib/mysql:cached
    restart: always
    environment:
      TZ: 'Asia/Shanghai'
      MYSQL_ROOT_PASSWORD: "root"
      MYSQL_ROOT_HOST: "%"
      MYSQL_INNODB_BUFFER_POOL_SIZE: 1G
      MYSQL_MAX_ALLOWED_PACKET: 2G
      MYSQL_INNODB_FILE_FORMAT: barracuda
      MYSQL_TMP_TABLE_SIZE: 512M
      MYSQL_CONNECT_TIMEOUT: 3000
      MYSQL_INNODB_LOCK_WAIT_TIMEOUT: 3000
      MYSQL_TRANSACTION_ISOLATION: READ-COMMITTED
networks:
  default:
    external:
      name: proxy