Page 1 of 1
NagiosXI Hostgroup members limit
Posted: Wed Aug 22, 2018 6:15 am
by Gonela
Hi Team,
Not able to add hosts into hostgroup more than 950 hosts and getting following error while mapping hosts to hostgroup.
"
Error while inserting data into the database:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `id`=62' at line 1
"
Please help me on this.
OS : Centos 7
NagiosXI Version : 5.5.2
Re: NagiosXI Hostgroup members limit
Posted: Wed Aug 22, 2018 1:20 pm
by scottwilkerson
Where do you get this error? When you click the Save button?
I was able to add 4000 hosts to a hostgroup without issue.
do any of these hosts have special chars in their hostname maybe?
Re: NagiosXI Hostgroup members limit
Posted: Wed Aug 22, 2018 8:37 pm
by Gonela
I'm getting this error while mapping hosts to hostgroup and while click on save button.
and There is no special characters in my hostnames .
Is there any parameter to increase import character length?
Re: NagiosXI Hostgroup members limit
Posted: Thu Aug 23, 2018 9:47 am
by scottwilkerson
Gonela wrote:
Is there any parameter to increase import character length?
Are you performing these in the CCM in the hostgroups section? Or through an import?
Can you also send the output of the following
Code: Select all
tail -20 /var/log/mariadb/mariadb.log
Re: NagiosXI Hostgroup members limit
Posted: Mon Sep 03, 2018 7:50 am
by Gonela
I'm performing these in the CCM in the hostgroups section . not import option.
tail -20 /var/log/mariadb/mariadb.log
Code: Select all
=======================================
180824 13:51:44 InnoDB: Shutdown completed; log sequence number 499953516120
180824 13:51:45 [Note] /usr/libexec/mysqld: Shutdown complete
180824 13:51:45 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
180824 15:05:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180824 15:05:45 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 1456 ...
180824 15:05:45 InnoDB: The InnoDB memory heap is disabled
180824 15:05:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180824 15:05:45 InnoDB: Compressed tables use zlib 1.2.7
180824 15:05:45 InnoDB: Using Linux native AIO
180824 15:05:45 InnoDB: Initializing buffer pool, size = 128.0M
180824 15:05:45 InnoDB: Completed initialization of buffer pool
180824 15:05:45 InnoDB: highest supported file format is Barracuda.
180824 15:05:45 InnoDB: Waiting for the background threads to start
180824 15:05:47 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 499953516120
180824 15:05:47 [Note] Plugin 'FEEDBACK' is disabled.
180824 15:05:47 [Note] Server socket created on IP: '0.0.0.0'.
180824 15:05:47 [Note] Event Scheduler: Loaded 0 events
180824 15:05:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
=========================================================================
Re: NagiosXI Hostgroup members limit
Posted: Tue Sep 04, 2018 10:20 am
by scottwilkerson
Curious, after getting the error on the screen, if you re-open the hostgroup do you see all the hosts you added?
Re: NagiosXI Hostgroup members limit
Posted: Wed Sep 05, 2018 8:02 pm
by Gonela
No, Hosts are not added.
and it's automatically going to CCM main menu.
Re: NagiosXI Hostgroup members limit
Posted: Thu Sep 06, 2018 12:59 pm
by scottwilkerson
I think we are going to have to take a look at the system to figure out where the problem could be.
Can you open a ticket and reference this thread and we can try to schedule a remote
https://support.nagios.com/tickets/