No backup of database

Discussion in 'General' started by nook, Dec 19, 2020.

  1. nook

    nook New Member

    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.
     
    Last edited: Dec 19, 2020
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    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?
     
  3. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    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.
     
  4. nook

    nook New Member

    Code:
     fixed
    i mean code i put to better look like
     
    Last edited: Dec 19, 2020

Share This Page