hello guys any help to find sollution for not making auto backups in ispconfig? how to debug ? i have: ISPConfig 3.1.13 Linux Code: Distributor ID: Debian Description: Debian GNU/Linux 10 (buster) Release: 10 Codename: buster crontab Code: * * * * * /usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done * * * * * /usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done 0 5 * * * /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh &> /dev/null database Code: version 10.3.27-MariaDB-0+deb10u1 version_comment Debian 10 version_compile_machine x86_64 version_compile_os debian-linux-gnu version_malloc_library system version_source_revision dba846ce2a4c57363c4f0256b0e6d2dd1a55ac40 version_ssl_library YaSSL 2.4.4 wsrep_patch_version wsrep_25.24 some mysql error log form hours when make backups Code: 2020-12-19 0:22:01 292016 [Warning] Aborted connection 292016 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:22:01 292013 [Warning] Aborted connection 292013 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:22:01 292012 [Warning] Aborted connection 292012 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:22:01 290408 [Warning] Aborted connection 290408 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:22:01 290406 [Warning] Aborted connection 290406 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:25:12 290407 [Warning] Aborted connection 290407 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:36:50 295122 [Warning] IP address 'XXXXXXXXXXXXX' has been resolved to the host name 'XXXXXXXXXXro.ovo.sc', which resembles IPv4-address itself. 2020-12-19 0:38:14 295449 [Warning] IP address 'XXXXXXXXXXXXX' has been resolved to the host name 'XXXXXXXXXX.bc.googleusercontent.com', which resembles IPv4-address itself. 2020-12-19 0:38:14 295449 [Warning] Access denied for user 'root'@'XXXXXXXXXXXX' (using password: NO) 2020-12-19 0:56:53 299172 [Warning] IP address 'XXXXXXXXX' has been resolved to the host name 'XXXXXXXXXX.ro.ovo.sc', which resembles IPv4-address itself. 2020-12-19 0:57:02 299210 [Warning] IP address 'XXXXXXXXX' has been resolved to the host name 'XXXXXXXXXX.ro.ovo.sc', which resembles IPv4-address itself. 2020-12-19 0:58:58 299147 [Warning] Aborted connection 299147 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 0:58:58 299149 [Warning] Aborted connection 299149 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 1:29:56 306230 [Warning] IP address 'XXXXXXXXXX' could not be resolved: Name or service not known 2020-12-19 1:52:12 309045 [Warning] Aborted connection 309045 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 1:56:49 310539 [Warning] Aborted connection 310539 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 1:56:49 310537 [Warning] Aborted connection 310537 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 2:00:49 311238 [Warning] Access denied for user 'username_here'@'localhost' (using password: YES) 2020-12-19 2:20:59 315905 [Warning] IP address 'XXXXXXXXXX' could not be resolved: Name or service not known 2020-12-19 2:51:18 320551 [Warning] IP address 'XXXXXXXXXX' could not be resolved: Name or service not known 2020-12-19 3:01:01 5549 [Warning] Aborted connection 5549 to db: 'NAME_OF_DATABASE' user: 'NAME_OF_DATABASE' host: 'localhost' (Got an error reading communication packets) 2020-12-19 3:01:01 6193 [Warning] Aborted connection 6193 to db: 'NAME_OF_DATABASE' user: 'NAME_OF_DATABASE' host: 'localhost' (Got an error reading communication packets) 2020-12-19 3:12:46 323371 [Warning] Aborted connection 323371 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 3:12:46 323369 [Warning] Aborted connection 323369 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 3:13:39 323370 [Warning] Aborted connection 323370 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 3:45:02 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2020-12-19 3:45:02 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-12-19 3:45:02 0 [Note] InnoDB: FTS optimize thread exiting. 2020-12-19 3:45:02 0 [Note] InnoDB: Starting shutdown... 2020-12-19 3:45:02 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-12-19 3:45:02 0 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25 2020-12-19 3:45:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 201219 3:45:02 2020-12-19 3:45:04 0 [Note] InnoDB: Shutdown completed; log sequence number 5495766588084; transaction id 14119356513 2020-12-19 3:45:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-12-19 3:45:04 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-12-19 3:45:04 0 [Note] InnoDB: Using Linux native AIO 2020-12-19 3:45:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-12-19 3:45:04 0 [Note] InnoDB: Uses event mutexes 2020-12-19 3:45:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-12-19 3:45:04 0 [Note] InnoDB: Number of pools: 1 2020-12-19 3:45:04 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-12-19 3:45:04 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-12-19 3:45:04 0 [Note] InnoDB: Completed initialization of buffer pool 2020-12-19 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-12-19 3:45:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-12-19 3:45:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-12-19 3:45:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-12-19 3:45:05 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-12-19 3:45:05 0 [Note] InnoDB: Waiting for purge to start 2020-12-19 3:45:05 0 [Note] InnoDB: 10.3.27 started; log sequence number 5495766588084; transaction id 14119356512 2020-12-19 3:45:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-12-19 3:45:05 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-12-19 3:45:05 0 [Note] Server socket created on IP: '::'. 2020-12-19 3:45:05 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-12-19 3:45:05 0 [Note] Reading of all Master_info entries succeeded 2020-12-19 3:45:05 0 [Note] Added new Master_info '' to hash table 2020-12-19 3:45:05 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.3.27-MariaDB-0+deb10u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian 10 2020-12-19 3:45:05 0 [Note] InnoDB: Buffer pool(s) load completed at 201219 3:45:05 2020-12-19 4:09:13 8799 [Warning] Aborted connection 8799 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) 2020-12-19 4:09:13 8798 [Warning] Aborted connection 8798 to db: 'dbispconfig' user: 'ispconfig' host: 'localhost' (Got an error reading communication packets) biggest database is 6.1 GB its just old school forum i noticed that form july i dont have auto backups. file backups works fine.
Please put logs and code between code tags so it is more readable (in the editor: insert -> Code). I would advice you to upgrade to the latest ISPConfig version (currently 3.2.1). is MariaDB set up according to the Perfect Server guide? Maybe you are running out of memory?
Agreed it's hard to read that, especially on a phone, but if that line indicates mysql is being shut down during your backup, it of course will case it to be incomplete or fail.