Stuck Multi-Server Updating

Discussion in 'Server Operation' started by mrbcast, Dec 20, 2019.

  1. mrbcast

    mrbcast New Member

    Hey Til,
    I have a Ubuntu 16 install with two additional installs in proxmox lxc containers. Server 1 is ispconfig web, mail, db, dns, ftp, firewall. The two other servers are DNS only. For the last couple of months now they are updating DNS Zone files but not server settings. I have gone through the mysql error logs and the one thing that keeps showing up is the following:

    2019-12-19T21:52:26.229672Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2019-12-19T21:52:26.229785Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
    2019-12-19T21:52:26.232419Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.28-0ubuntu0.16.04.2) starting as process 3053 ...
    2019-12-19T21:52:26.248031Z 0 [Note] InnoDB: PUNCH HOLE support available
    2019-12-19T21:52:26.248073Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2019-12-19T21:52:26.248088Z 0 [Note] InnoDB: Uses event mutexes
    2019-12-19T21:52:26.248099Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2019-12-19T21:52:26.248110Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
    2019-12-19T21:52:26.248121Z 0 [Note] InnoDB: Using Linux native AIO
    2019-12-19T21:52:26.248588Z 0 [Note] InnoDB: Number of pools: 1
    2019-12-19T21:52:26.248775Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2019-12-19T21:52:26.251816Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2019-12-19T21:52:26.270153Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2019-12-19T21:52:26.273747Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2019-12-19T21:52:26.286844Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2019-12-19T21:52:26.299931Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2019-12-19T21:52:26.300020Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2019-12-19T21:52:26.321830Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2019-12-19T21:52:26.323176Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2019-12-19T21:52:26.323200Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2019-12-19T21:52:26.323831Z 0 [Note] InnoDB: Waiting for purge to start
    2019-12-19T21:52:26.374062Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 2732052
    2019-12-19T21:52:26.374330Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2019-12-19T21:52:26.374588Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2019-12-19T21:52:26.377159Z 0 [Note] InnoDB: Buffer pool(s) load completed at 191219 21:52:26
    2019-12-19T21:52:26.384178Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    2019-12-19T21:52:26.384200Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
    2019-12-19T21:52:26.385192Z 0 [Warning] CA certificate ca.pem is self signed.
    2019-12-19T21:52:26.385251Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
    2019-12-19T21:52:26.385381Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2019-12-19T21:52:26.385446Z 0 [Note] IPv6 is available.
    2019-12-19T21:52:26.385462Z 0 [Note] - '::' resolves to '::';
    2019-12-19T21:52:26.385490Z 0 [Note] Server socket created on IP: '::'.
    2019-12-19T21:52:26.399910Z 0 [Note] Event Scheduler: Loaded 0 events
    2019-12-19T21:52:26.400220Z 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.7.28-0ubuntu0.16.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
    2019-12-19T21:52:26.990398Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
    2019-12-19T21:52:31.762008Z 4 [Note] Got an error reading communication packets
    2019-12-19T21:53:01.510249Z 8 [Note] Got an error reading communication packets
    2019-12-19T21:54:01.759813Z 12 [Note] Got an error reading communication packets

    I have exhausted my limited amount of knowledge and cannot seem to get the red numbers on the master to go down on server updates for things like ip addresses and settings and such. Please advise as to what I might look for or try. All three servers are at the latest 3.1.15p2 version and all other functions seem to be working fine. Thanks for all your help and Happy Holidays to you and your family.

    Jeff McDaniel
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Did you start a new thread for the same problem as ?
    Quote from that other thread:
    How was this move done? Did the problems start immediately after the move?
    Start with this:
    Then follow the troubleshooting instructions in
    My quess is database connection does not work. Check the IP-numbers in /etc/hosts are correct in all three hosts. Check the database users can connect from the DNS slaves to the master.
  3. MephiaSR

    MephiaSR New Member

    Does this PID show up more than once?
    ps -audbpS | grep PID

Share This Page