Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

sucessful migration - mysql issues

https://support.nagios.com/forum/viewtopic.php?t=58970

Page 3 of 5

Re: sucessful migration - mysql issues

Posted: Tue Jun 23, 2020 5:32 pm
by ssax

Code: Select all

MiB Mem :   3954.1 total,    315.5 free,   1935.3 used,   1703.3 buff/cache
MiB Swap:   4076.0 total,   3900.0 free,    176.0 used.   1865.6 avail Mem
Can you try your RAM on that system to like 8GB and see how it performs?

Attach your /etc/php.ini as well so we can see what the limits are set at.

Please send any files from this directory as well:

Code: Select all

/etc/my.cnf.d

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 6:55 am
by veehexx
bumped it upto fixed 16GB which needed a reboot to switch between dynamic & fixed ram, so it's had a clean boot today. Was set to dynamic 4GB max which was a bit limited (5.8GB was requirement at the time)

no improvement - UI still blank in places, Monitoring Engine Process stuck in a stop state, and mysql cpu% still high.

file requests sent via PM as well

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 10:32 am
by ssax
Please edit your /etc/php.ini and change these:

Code: Select all

max_execution_time = 60
max_input_vars = 5000
memory_limit = 256M
To these:

Code: Select all

max_execution_time = 300
max_input_vars = 50000
memory_limit = 1024M
Then restart apache:

Code: Select all

service httpd restart
Then run this tail command as root (and leave it running):

Code: Select all

tail -Fn0 /var/log/httpd/error_log /var/log/httpd/ssl_error_log
Then replicate the blank UI issue a couple times and attach (or PM) the entire output from the tail command.

Then run this tail command (and leave it running):

Code: Select all

tail -Fn0 /usr/local/nagiosxi/var/cmdsubsys.log
Then try to apply configuration through the web interface and once it completes/errors send me the full output from the tail command above so we can see what's occurring.

Does the service show as running?

Code: Select all

systemctl status nagios
Do the configs validate?

Code: Select all

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 2:18 pm
by veehexx
php.ini changes done, httpd restarted.

httpd error logs give no output, but it looks like we're not speaking of the same fault.
this is my view of the service status page (host status is the same):
service status.PNG
minemap:
minemap.PNG
As you can see the pages are loading but are empty in terms of host/services.

Code: Select all

#     tail -Fn0 /usr/local/nagiosxi/var/cmdsubsys.log
.........................
PROCESSED 0 COMMANDS
.......PROCESSING COMMAND ID 4284...
PROCESS COMMAND: CMD=17, DATA=
APPLYING NAGIOSCORE CONFIG...
CMDLINE=cd /usr/local/nagiosxi/scripts && ./reconfigure_nagios.sh

--- reset_config_perms.sh ------------
> Setting script permissions
> Setting CCM script permissions
> Setting special script permissions
> Setting special component script permissions
> Setting configuration file/directory permissions
> Setting perfdata directory and RRD permissions
> Setting libexec directory permissions
> Setting Nagios XI config permissions
> Setting NOM checkpoint user:group permissions
> + Setting CCM configuration file user:group permissions
> + Setting Recurring Downtime file user:group permissions
> + Setting BPI configuration file user:group permissions
--------------------------------------

--- ccm_import.php -------------------
> Setting import directory: /usr/local/nagios/etc/import/
> Importing config files into the CCM
  No files to import
--------------------------------------

--- ccm_export.php -------------------
> Writing CCM configuration to Nagios files
  Finished writing out configuraton
--------------------------------------

--------------------------------------
> Verifying configuration with Nagios Core
> Output:
Nagios Core 4.4.6
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2020-04-28
License: GPL

Website: https://www.nagios.org
Reading configuration data...
   Read main config file okay...
Warning: Duplicate definition found for service 'Memory Usage' on host 'sccm02' (config file '/usr/local/nagios/etc/services/Memory Usage.cfg', starting on line 16)
   Read object config files okay...

Running pre-flight check on configuration data...

Checking objects...
        Checked 1876 services.
        Checked 116 hosts.
        Checked 25 host groups.
        Checked 7 service groups.
        Checked 7 contacts.
        Checked 3 contact groups.
        Checked 153 commands.
        Checked 13 time periods.
        Checked 0 host escalations.
        Checked 0 service escalations.
Checking for circular paths...
        Checked 116 hosts
        Checked 0 service dependencies
        Checked 0 host dependencies
        Checked 13 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 0
Total Errors:   0

Things look okay - No serious problems were detected during the pre-flight check
> Return Code: 0
--------------------------------------
....................................................OUTPUT=--------------------------------------
RETURNCODE=0

PROCESSED 1 COMMANDS
PROCESSING COMMAND ID 4285...
PROCESS COMMAND: CMD=1160, DATA=
PROCESSING COMMAND ID 4286...
PROCESS COMMAND: CMD=1150, DATA=remove
CMDLINE=php /usr/local/nagiosxi/html/includes/components/nagiosbpi/api_tool.php --cmd=syncall
theres 2 points in this output that seem to take an abnormally long time to run.
immediately after '--- ccm_export.php -------------------
> Writing CCM configuration to Nagios files' line - this has 20 seconds delay
After the 'Things look okay - No serious problems were detected during the pre-flight check
> Return Code: 0
--------------------------------------'. - this has 90 secs delay.

'systemctl status nagios' shows service is running.

config validates ok, with only a dup warning.
#/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg

Code: Select all

Nagios Core 4.4.6
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2020-04-28
License: GPL

Website: https://www.nagios.org
Reading configuration data...
   Read main config file okay...
Warning: Duplicate definition found for service 'Memory Usage' on host 'sccm02' (config file '/usr/local/nagios/etc/services/Memory Usage.cfg', starting on line 16)
   Read object config files okay...

Running pre-flight check on configuration data...

Checking objects...
        Checked 1876 services.
        Checked 116 hosts.
        Checked 25 host groups.
        Checked 7 service groups.
        Checked 7 contacts.
        Checked 3 contact groups.
        Checked 153 commands.
        Checked 13 time periods.
        Checked 0 host escalations.
        Checked 0 service escalations.
Checking for circular paths...
        Checked 116 hosts
        Checked 0 service dependencies
        Checked 0 host dependencies
        Checked 13 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 0
Total Errors:   0

Things look okay - No serious problems were detected during the pre-flight check

just to avoid further confusion
system status:
system status.PNG

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 2:19 pm
by veehexx
3 attachment limit met in last post. last screenshot here...
Montioring Engine status:
monitoring engine.PNG
edit: yes i have clicked 'start' action on this page :D the little modal popup says sucessful but the process doesnt actually start (according to webUI).

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 2:25 pm
by bpennin
I see the same issue with my upgrade as well. Tried to do the manual install of ndo but received error about:checking for mysql/mysql.h... no
configure: error: Can't locate mysql headers. Following this thread closely...

Re: sucessful migration - mysql issues

Posted: Wed Jun 24, 2020 4:48 pm
by ssax
Does the nagios core interface show properly?

Code: Select all

http://YOURXISERVER/nagios/
There is a bug in XI 5.7+ with the new NDO on some systems not updating DB (it shows properly in Core), there is not currently a resolution for it, development is currently working the issue.

As a workaround, please do this to downgrade NDO3 to NDO2DB (they are entirely different) and it should resolve your issues:

Take an XI backup first just in case:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Code: Select all

systemctl stop nagios
cd /tmp
rm -rf /tmp/nagiosxi
wget https://assets.nagios.com/downloads/nagiosxi/5/xi-5.6.14.tar.gz
tar zxf xi-5.6.14.tar.gz
cd /tmp/nagiosxi
./init.sh
cd /tmp/nagiosxi/subcomponents/ndoutils
./install
systemctl enable ndo2db
systemctl start ndo2db
Then edit your /usr/local/nagios/etc/nagios.cfg and make sure this line is uncommented:

Code: Select all

broker_module=/usr/local/nagios/bin/ndomod.o config_file=/usr/local/nagios/etc/ndomod.cfg
Make sure this line is commented:

Code: Select all

#broker_module=/usr/local/nagios/bin/ndo.so /usr/local/nagios/etc/ndo.cfg
Then start the nagios service:

Code: Select all

systemctl start nagios

Re: sucessful migration - mysql issues

Posted: Thu Jun 25, 2020 4:10 am
by veehexx
ssax wrote:Does the nagios core interface show properly?

Code: Select all

http://YOURXISERVER/nagios/
tried this and i'm getting the "Whoops! Error: Could not read host and service status information!" page on practially all the pages. the 'Home' page shows 'Unable to get process status'.

i assume the rest of your post isnt applicable. I read it as 'do this if the core interface does work ok'.

not sure if it helps but i've stopped both nagios and mysqld services. restarted mysqld. CPU is idle.
manually run '/usr/local/nagios/bin/nagios /usr/local/nagios/etc/nagios.cfg' and sql cpu time immediately raises to 100% of a core. CTRL+C on the non-daemon process will keep mysql cpu time high for a bit and then it'll drop back to idle. it's like theres some sql query from nagiosXI that its having issues with. nagios keeps resending whatever it is when running. If you stop nagios service/command then sql will eventually time out and recover. DB are not my stong point so I'm going to look at some mysql tools to see if i can see what might be occuring... if i find anything i'll update this thread

non-daemon process output

Code: Select all

#     /usr/local/nagios/bin/nagios /usr/local/nagios/etc/nagios.cfg

Nagios Core 4.4.6
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 2020-04-28
License: GPL

Website: https://www.nagios.org
Nagios 4.4.6 starting... (PID=284356)
Local time is Thu Jun 25 10:18:50 BST 2020
wproc: Successfully registered manager as @wproc with query handler
wproc: Registry request: name=Core Worker 284357;pid=284357
wproc: Registry request: name=Core Worker 284358;pid=284358
wproc: Registry request: name=Core Worker 284360;pid=284360
wproc: Registry request: name=Core Worker 284359;pid=284359
wproc: Registry request: name=Core Worker 284362;pid=284362
wproc: Registry request: name=Core Worker 284363;pid=284363
wproc: Registry request: name=Core Worker 284361;pid=284361
wproc: Registry request: name=Core Worker 284365;pid=284365
wproc: Registry request: name=Core Worker 284364;pid=284364
Event broker module '/usr/local/nagios/bin/ndo.so' initialized successfully.

Re: sucessful migration - mysql issues

Posted: Thu Jun 25, 2020 4:51 am
by veehexx
that was quicker than i thought to find out. look at process ID 971.

mysql -uroot -pPASSWORD

mysqld running, nagios stopped, cpu low

Code: Select all

mysql> show processlist;
+-----+-----------------+-----------+----------+---------+------+------------------------+------------------+
| Id  | User            | Host      | db       | Command | Time | State                  | Info             |
+-----+-----------------+-----------+----------+---------+------+------------------------+------------------+
|   4 | event_scheduler | localhost | NULL     | Daemon  | 1260 | Waiting on empty queue | NULL             |
|   8 | nagiosxi        | localhost | nagiosxi | Sleep   |   44 |                        | NULL             |
|   9 | ndoutils        | localhost | nagios   | Sleep   |   44 |                        | NULL             |
|  10 | nagiosql        | localhost | nagiosql | Sleep   |   44 |                        | NULL             |
|  11 | nagiosxi        | localhost | nagiosxi | Sleep   |   43 |                        | NULL             |
|  12 | ndoutils        | localhost | nagios   | Sleep   |   43 |                        | NULL             |
|  13 | nagiosql        | localhost | nagiosql | Sleep   |   43 |                        | NULL             |
|  14 | nagiosxi        | localhost | nagiosxi | Sleep   |   14 |                        | NULL             |
|  15 | ndoutils        | localhost | nagios   | Sleep   |   14 |                        | NULL             |
|  16 | nagiosql        | localhost | nagiosql | Sleep   |   14 |                        | NULL             |
|  17 | nagiosxi        | localhost | nagiosxi | Sleep   |   15 |                        | NULL             |
|  18 | nagiosxi        | localhost | nagiosxi | Sleep   |   13 |                        | NULL             |
|  19 | ndoutils        | localhost | nagios   | Sleep   |   15 |                        | NULL             |
|  20 | ndoutils        | localhost | nagios   | Sleep   |   13 |                        | NULL             |
|  21 | nagiosql        | localhost | nagiosql | Sleep   |   15 |                        | NULL             |
|  22 | nagiosql        | localhost | nagiosql | Sleep   |   13 |                        | NULL             |
|  23 | nagiosxi        | localhost | nagiosxi | Sleep   |   11 |                        | NULL             |
|  24 | ndoutils        | localhost | nagios   | Sleep   |   11 |                        | NULL             |
|  25 | nagiosql        | localhost | nagiosql | Sleep   |   11 |                        | NULL             |
|  26 | nagiosxi        | localhost | nagiosxi | Sleep   |   10 |                        | NULL             |
|  27 | nagiosxi        | localhost | nagiosxi | Sleep   |   10 |                        | NULL             |
|  28 | ndoutils        | localhost | nagios   | Sleep   |   10 |                        | NULL             |
|  29 | ndoutils        | localhost | nagios   | Sleep   |   10 |                        | NULL             |
|  30 | nagiosql        | localhost | nagiosql | Sleep   |   10 |                        | NULL             |
|  31 | nagiosql        | localhost | nagiosql | Sleep   |   10 |                        | NULL             |
|  32 | nagiosxi        | localhost | nagiosxi | Sleep   |   70 |                        | NULL             |
|  33 | ndoutils        | localhost | nagios   | Sleep   |   70 |                        | NULL             |
|  34 | nagiosql        | localhost | nagiosql | Sleep   |   70 |                        | NULL             |
|  70 | nagiosxi        | localhost | nagiosxi | Sleep   |   70 |                        | NULL             |
|  71 | ndoutils        | localhost | nagios   | Sleep   |   70 |                        | NULL             |
|  72 | nagiosql        | localhost | nagiosql | Sleep   |   70 |                        | NULL             |
|  73 | nagiosxi        | localhost | nagiosxi | Sleep   |   40 |                        | NULL             |
|  74 | ndoutils        | localhost | nagios   | Sleep   |   40 |                        | NULL             |
|  75 | nagiosql        | localhost | nagiosql | Sleep   |   40 |                        | NULL             |
| 889 | nagiosxi        | localhost | nagiosxi | Sleep   |    9 |                        | NULL             |
| 890 | nagiosxi        | localhost | nagiosxi | Sleep   |   13 |                        | NULL             |
| 891 | nagiosxi        | localhost | nagiosxi | Sleep   |   18 |                        | NULL             |
| 896 | ndoutils        | localhost | nagios   | Sleep   |   39 |                        | NULL             |
| 899 | ndoutils        | localhost | nagios   | Sleep   |   18 |                        | NULL             |
| 900 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                        | NULL             |
| 901 | ndoutils        | localhost | nagios   | Sleep   |   39 |                        | NULL             |
| 903 | ndoutils        | localhost | nagios   | Sleep   |   39 |                        | NULL             |
| 904 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 905 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 908 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 909 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 910 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                        | NULL             |
| 911 | ndoutils        | localhost | nagios   | Sleep   |   39 |                        | NULL             |
| 912 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 913 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                        | NULL             |
| 914 | ndoutils        | localhost | nagios   | Sleep   |   39 |                        | NULL             |
| 915 | nagiosql        | localhost | nagiosql | Sleep   |   39 |                        | NULL             |
| 924 | root            | localhost | NULL     | Query   |    0 | starting               | show processlist |
+-----+-----------------+-----------+----------+---------+------+------------------------+------------------+
53 rows in set (0.00 sec)
mysqld running, nagios non-daemon running. mysql CPU time high

Code: Select all

mysql> show processlist;
+------+-----------------+-----------+----------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
| Id   | User            | Host      | db       | Command | Time | State                        | Info                                                                                                 |
+------+-----------------+-----------+----------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
|    4 | event_scheduler | localhost | NULL     | Daemon  | 1449 | Waiting on empty queue       | NULL                                                                                                 |
|    8 | nagiosxi        | localhost | nagiosxi | Sleep   |   20 |                              | NULL                                                                                                 |
|    9 | ndoutils        | localhost | nagios   | Sleep   |   20 |                              | NULL                                                                                                 |
|   10 | nagiosql        | localhost | nagiosql | Sleep   |   20 |                              | NULL                                                                                                 |
|   11 | nagiosxi        | localhost | nagiosxi | Sleep   |   19 |                              | NULL                                                                                                 |
|   12 | ndoutils        | localhost | nagios   | Sleep   |   19 |                              | NULL                                                                                                 |
|   13 | nagiosql        | localhost | nagiosql | Sleep   |   19 |                              | NULL                                                                                                 |
|   14 | nagiosxi        | localhost | nagiosxi | Sleep   |   78 |                              | NULL                                                                                                 |
|   15 | ndoutils        | localhost | nagios   | Sleep   |   78 |                              | NULL                                                                                                 |
|   16 | nagiosql        | localhost | nagiosql | Sleep   |   78 |                              | NULL                                                                                                 |
|   17 | nagiosxi        | localhost | nagiosxi | Sleep   |   79 |                              | NULL                                                                                                 |
|   18 | nagiosxi        | localhost | nagiosxi | Sleep   |   53 |                              | NULL                                                                                                 |
|   19 | ndoutils        | localhost | nagios   | Sleep   |   79 |                              | NULL                                                                                                 |
|   20 | ndoutils        | localhost | nagios   | Sleep   |   53 |                              | NULL                                                                                                 |
|   21 | nagiosql        | localhost | nagiosql | Sleep   |   79 |                              | NULL                                                                                                 |
|   22 | nagiosql        | localhost | nagiosql | Sleep   |   53 |                              | NULL                                                                                                 |
|   23 | nagiosxi        | localhost | nagiosxi | Sleep   |   51 |                              | NULL                                                                                                 |
|   24 | ndoutils        | localhost | nagios   | Sleep   |   51 |                              | NULL                                                                                                 |
|   25 | nagiosql        | localhost | nagiosql | Sleep   |   51 |                              | NULL                                                                                                 |
|   26 | nagiosxi        | localhost | nagiosxi | Sleep   |   24 |                              | NULL                                                                                                 |
|   27 | nagiosxi        | localhost | nagiosxi | Sleep   |   48 |                              | NULL                                                                                                 |
|   28 | ndoutils        | localhost | nagios   | Sleep   |   24 |                              | NULL                                                                                                 |
|   29 | ndoutils        | localhost | nagios   | Sleep   |   49 |                              | NULL                                                                                                 |
|   30 | nagiosql        | localhost | nagiosql | Sleep   |   24 |                              | NULL                                                                                                 |
|   31 | nagiosql        | localhost | nagiosql | Sleep   |   49 |                              | NULL                                                                                                 |
|   32 | nagiosxi        | localhost | nagiosxi | Sleep   |   23 |                              | NULL                                                                                                 |
|   33 | ndoutils        | localhost | nagios   | Sleep   |   23 |                              | NULL                                                                                                 |
|   34 | nagiosql        | localhost | nagiosql | Sleep   |   23 |                              | NULL                                                                                                 |
|   70 | nagiosxi        | localhost | nagiosxi | Sleep   |   21 |                              | NULL                                                                                                 |
|   71 | ndoutils        | localhost | nagios   | Sleep   |   21 |                              | NULL                                                                                                 |
|   72 | nagiosql        | localhost | nagiosql | Sleep   |   21 |                              | NULL                                                                                                 |
|   73 | nagiosxi        | localhost | nagiosxi | Sleep   |   18 |                              | NULL                                                                                                 |
|   74 | ndoutils        | localhost | nagios   | Sleep   |   18 |                              | NULL                                                                                                 |
|   75 | nagiosql        | localhost | nagiosql | Sleep   |   18 |                              | NULL                                                                                                 |
|  924 | root            | localhost | NULL     | Query   |    0 | starting                     | show processlist                                                                                     |
|  971 | ndoutils        | localhost | nagios   | Execute |   39 | Waiting for table level lock | INSERT INTO nagios_commenthistory (instance_id, comment_type, entry_type, object_id, comment_time, i |
|  972 | ndoutils        | localhost | nagios   | Sleep   |  124 |                              | NULL                                                                                                 |
|  973 | ndoutils        | localhost | nagios   | Execute |   39 | Waiting for table level lock | INSERT INTO nagios_commenthistory (instance_id, comment_type, entry_type, object_id, comment_time, i |
| 1016 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                              | NULL                                                                                                 |
| 1018 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                              | NULL                                                                                                 |
| 1020 | ndoutils        | localhost | nagios   | Sleep   |   48 |                              | NULL                                                                                                 |
| 1021 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1023 | nagiosxi        | localhost | nagiosxi | Sleep   |    8 |                              | NULL                                                                                                 |
| 1024 | ndoutils        | localhost | nagios   | Sleep   |   48 |                              | NULL                                                                                                 |
| 1025 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1027 | nagiosxi        | localhost | nagiosxi | Sleep   |   48 |                              | NULL                                                                                                 |
| 1028 | ndoutils        | localhost | nagios   | Sleep   |   48 |                              | NULL                                                                                                 |
| 1031 | ndoutils        | localhost | nagios   | Query   |   48 | updating                     | DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1530005701)                       |
| 1032 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1036 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1037 | nagiosxi        | localhost | nagiosxi | Sleep   |    3 |                              | NULL                                                                                                 |
| 1038 | ndoutils        | localhost | nagios   | Sleep   |    8 |                              | NULL                                                                                                 |
| 1039 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1041 | nagiosxi        | localhost | nagiosxi | Sleep   |    8 |                              | NULL                                                                                                 |
| 1042 | ndoutils        | localhost | nagios   | Sleep   |   48 |                              | NULL                                                                                                 |
| 1043 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
| 1047 | nagiosxi        | localhost | nagiosxi | Sleep   |    0 |                              | NULL                                                                                                 |
| 1048 | ndoutils        | localhost | nagios   | Sleep   |   48 |                              | NULL                                                                                                 |
| 1049 | nagiosql        | localhost | nagiosql | Sleep   |   48 |                              | NULL                                                                                                 |
+------+-----------------+-----------+----------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------+
59 rows in set (0.00 sec)
mysqld running, nagios non-daemon ctrl+C'd, wait a bit (30-60secs) for cpu time to become low. ID 971 is no longer present.

to my untrained eye, it looks like theres a table lock issue thats holding everything up. re-querying 'show processlist;' when nagios process is running will always show this ' Waiting for table level lock' line.

I'm happy to remove all comments if thats the way forward as we only really use it because it's a required field. Being a small team we can almost guarantee i'll be fixing any server issue and netadmin will handle the network failures so we know immediately who's likely to know.
To satisfy my own curiosity, if it is indeed something broken, it'd be nice to know if theres a specific commenthistory entry causing the issue - some weird character we've used for example.

Re: sucessful migration - mysql issues

Posted: Thu Jun 25, 2020 9:25 am
by bpennin
My Core Nagios screen displayed correctly so I copied all configs and files associated with NDOutil over from a 5.6.13 Nagios box over and commented the lines out and add the lines in as instructed in the nagios.cfg file and I am now up and running ok.
All times are UTC-05:00
Page 3 of 5

Powered by phpBB® Forum Software © phpBB Limited