Hi.
We are having some serious problems after migrating our Naxiosxi server running on CentOS6 to Ubuntu 18.04. The restore onto the new server went well. No error-messages. We also ran the restore_repair.sh for change to a new OS.
The Nagiosxi-version is 5.6.14. The plan is to upgrade to a newer version once everything is up and running.
Everything starts up, but the new server is using a lot of Cpu and the communication to the servers times out most of the time. It's not possible to make any changes, add or delete services for example. Everything hangs.
We have also tried to run the repair-scripr : /usr/local/nagiosxi/scripts/repair_databases.sh
This completes sucessfully, but it doesen't change anything. Still the same problems.
Please advice !
Her is an output from the /var/log/mysql/error.log :
2022-12-12T08:09:41.433615Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more
details).
2022-12-12T08:09:41.433710Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with stric
t mode in a future release.
2022-12-12T08:09:41.434609Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.40-0ubuntu0.18.04.1) starting as process 31641 ...
2022-12-12T08:09:41.437403Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-12-12T08:09:41.437417Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-12-12T08:09:41.437420Z 0 [Note] InnoDB: Uses event mutexes
2022-12-12T08:09:41.437423Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-12-12T08:09:41.437426Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-12-12T08:09:41.437431Z 0 [Note] InnoDB: Using Linux native AIO
2022-12-12T08:09:41.437592Z 0 [Note] InnoDB: Number of pools: 1
2022-12-12T08:09:41.437667Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-12-12T08:09:41.438628Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-12-12T08:09:41.444191Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-12-12T08:09:41.445468Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-12-12T08:09:41.456888Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-12-12T08:09:41.475671Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-12-12T08:09:41.475752Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-12-12T08:09:41.517512Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-12-12T08:09:41.518006Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-12-12T08:09:41.518012Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-12-12T08:09:41.518389Z 0 [Note] InnoDB: Waiting for purge to start
2022-12-12T08:09:41.568580Z 0 [Note] InnoDB: 5.7.40 started; log sequence number 435784958
2022-12-12T08:09:41.568813Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-12-12T08:09:41.568932Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-12-12T08:09:41.570531Z 0 [Note] InnoDB: Buffer pool(s) load completed at 221212 9:09:41
2022-12-12T08:09:41.572490Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-12-12T08:09:41.572500Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-12-12T08:09:41.572503Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-12-12T08:09:41.572505Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-12-12T08:09:41.572962Z 0 [Warning] CA certificate ca.pem is self signed.
2022-12-12T08:09:41.572990Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-12-12T08:09:41.573045Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2022-12-12T08:09:41.573062Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2022-12-12T08:09:41.573091Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2022-12-12T08:09:41.577284Z 0 [Note] Event Scheduler: Loaded 0 events
2022-12-12T08:09:41.577432Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.40-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2022-12-12T08:18:40.038399Z 3 [Note] Aborted connection 3 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)
2022-12-12T08:18:59.011622Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6506ms. The settings might not be optimal. (flushed=87 and evicted=0, during the time.)
2022-12-12T08:37:16.948858Z 452 [Note] Aborted connection 452 to db: 'nagios' user: 'ndoutils' host: 'localhost' (Got an error reading communication packets)