NagiosXI Hostgroup members limit

[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

[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?

[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?

[scottwilkerson]

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

[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

=========================================================================

[scottwilkerson]

Curious, after getting the error on the screen, if you re-open the hostgroup do you see all the hosts you added?

[Gonela]

No, Hosts are not added.

and it's automatically going to CCM main menu.

[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/