Mysql backup issue

Discussion in 'General' started by nook, Oct 22, 2020.

  1. nook

    nook New Member

    hello guys
    i have
    (Debian Stretch) ISPConfig 3.1.13
    i noticed stop of making database backups. file system backups works perfect. any ideas whats going on ? biggest database is 6GB.
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    You can take a look at the logs to see if there is a error logged... furthermore, you can update to ISPConfig 3.2 which I would recommend anyway :) The backup system has had a major upgrade in 3.2.
     
  3. nook

    nook New Member

    2020-10-28 3:42:02 382451 [Warning] Host name 'zg-0915a-181.stretchoid.com' could not be resolved: Name or service not known
    2020-10-28 3:45:01 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
    2020-10-28 3:45:01 0 [Note] Event Scheduler: Purging the queue. 0 events
    2020-10-28 3:45:01 0 [Note] InnoDB: FTS optimize thread exiting.
    2020-10-28 3:45:01 0 [Note] InnoDB: Starting shutdown...
    2020-10-28 3:45:01 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
    2020-10-28 3:45:01 0 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25
    2020-10-28 3:45:01 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 3:45:01
    2020-10-28 3:45:03 0 [Note] InnoDB: Shutdown completed; log sequence number 5303083939764; transaction id 13993454251
    2020-10-28 3:45:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-10-28 3:45:03 0 [Note] /usr/sbin/mysqld: Shutdown complete

    2020-10-28 3:45:03 0 [Note] InnoDB: Using Linux native AIO
    2020-10-28 3:45:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-10-28 3:45:03 0 [Note] InnoDB: Uses event mutexes
    2020-10-28 3:45:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-10-28 3:45:03 0 [Note] InnoDB: Number of pools: 1
    2020-10-28 3:45:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-10-28 3:45:04 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2020-10-28 3:45:04 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-10-28 3:45:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-10-28 3:45:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-10-28 3:45:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-10-28 3:45:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-10-28 3:45:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2020-10-28 3:45:04 0 [Note] InnoDB: Waiting for purge to start
    2020-10-28 3:45:04 0 [Note] InnoDB: 10.3.25 started; log sequence number 5303083939764; transaction id 13993454252
    2020-10-28 3:45:04 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2020-10-28 3:45:04 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-10-28 3:45:04 0 [Note] Server socket created on IP: '::'.
    2020-10-28 3:45:04 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
    2020-10-28 3:45:04 0 [Note] Reading of all Master_info entries succeeded
    2020-10-28 3:45:04 0 [Note] Added new Master_info '' to hash table
    2020-10-28 3:45:04 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '10.3.25-MariaDB-0+deb10u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 10
    2020-10-28 3:45:04 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 3:45:04
    2020-10-28 3:58:08 5772 [Warning] Aborted connection 5772 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
    2020-10-28 3:58:08 5770 [Warning] Aborted connection 5770 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
    2020-10-28 4:16:18 5771 [Warning] Aborted connection 5771 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
    2020-10-28 4:26:50 9990 [Warning] Aborted connection 9990 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
    2020-10-28 4:26:50 9988 [Warning] Aborted connection 9988 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
    2020-10-28 5:00:01 17640 [Warning] Access denied for user 'roundcube'@'localhost' (using password: YES)
    2020-10-28 5:32:32 27862 [Warning] Aborted connection 27862 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets)
     

Share This Page