Thanks for the quick reply -
The MySQL looks clean .. I checked all the tables with my utility and they are good.
---
Code: Select all
150706 5:49:45 InnoDB: Initializing buffer pool, size = 128.0M
150706 5:49:45 InnoDB: Completed initialization of buffer pool
150706 5:49:45 InnoDB: highest supported file format is Barracuda.
150706 5:49:45 InnoDB: Waiting for the background threads to start
150706 5:49:46 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597945
150706 5:49:46 [Note] Plugin 'FEEDBACK' is disabled.
150706 5:49:46 [Note] Server socket created on IP: '0.0.0.0'.
150706 5:49:46 [Note] Event Scheduler: Loaded 0 events
150706 5:49:46 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.41-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
We're trying to load in thousands of hosts directly to the database, and then use the "Apply Configuration" for it to write the files and restart the services. This works great for a few hundred hosts/services - but i'm finding that when I try to load more than 1000 at a time, the strange error occurs. (i would understand a timeout or error related to thresholds or resources .. but when it references a non-existent file is when I got worried : )
When I click on "Write Config Files" - it just goes to a white screen. (probably too many files to write?) So i'm using the scripts/reconfigure_nagios.sh tool, and that works after a couple tries.
Do you know the best way to write the individual hosts and services files from the CCM codebase? I'm thinking that writing the files before trying to restart will be easier on the system. We'll end up with about 40k hosts and services when all is done - the server load looks good so far - the mod_gearman is working well!
Thanks again! : )
- Ian