NetXMS Support Forum

Сегодня возник следующий вопрос.

-Netxmsd очень сильно грузит систему и mysql

top - 12:17:32 up  1:16,  2 users,  load average: 1.71, 1.67, 1.47
Tasks: 104 total,   2 running, 101 sleeping,   1 stopped,   0 zombie
Cpu(s): 54.6%us, 10.4%sy,  0.0%ni, 35.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   4117936k total,   197448k used,  3920488k free,    42456k buffers
Swap:  6377464k total,        0k used,  6377464k free,    71180k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
4455 root      20   0 88112 4044 2212 S     79  0.1  10:34.03 netxmsd
4270 mysql     20   0  127m  18m 5268 S   51  0.5   7:59.36 mysqld

непонятно чем вызывается такая параноидальная активность.

Логи мускула смотрел вроде нечего страшного, нетхмс пуляет ему в табличку eventlog и все..

в логах нетхмс следующее

SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521534,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521527,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521520,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521513,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521506,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521499,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521492,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521485,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521478,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[29-Oct-2009 12:27:47] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521535,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521528,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521521,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521514,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521507,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521500,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521493,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521486,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521479,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

старт нетхмс выглядит так:

/opt/netxms/bin/netxmsd -c /etc/netxmsd.conf
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[29-Oct-2009 12:32:15] Platform subagent "/opt/netxms/lib/libnsm_linux.so" successfully loaded
[29-Oct-2009 12:32:15] Database driver "/opt/netxms/lib/libnxddr_mysql.so" loaded and initialized successfully
[29-Oct-2009 12:32:15] Failed to load subnet object with id 13 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 18 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 23 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 28 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 12 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 17 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 22 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 27 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 14 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 19 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 24 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 29 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 10 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 11 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 15 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 16 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 20 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 21 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 25 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 26 from database
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e          xisting child object 25
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e          xisting child object 26
[29-Oct-2009 12:32:15] Listening for SNMP traps on UDP socket 0.0.0.0:162
[29-Oct-2009 12:32:15] NetXMS Server started

NetXMS Server V0.2.30 Ready
Enter "help" for command list or "down" for server shutdown
System Console

netxmsd: [29-Oct-2009 12:32:15] Listening for client connections on TCP socket 0.0.0.0:4701

конфиг нетхмс выглядит так

#
# Sample configuration file for NetXMS server
#

#
# DBDriver
#
# Database driver to use
#
# UNIX example:
DBDriver = /opt/netxms/lib/libnxddr_mysql.so
#
# Windows example:
# DBDriver = mysql.ddr

#
# DBServer
#
# Database server (ODBC source name for ODBC driver)
#
# Example:
DBServer = localhost

#
# DBName
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ?

#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ?

#
# DBPassword
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ?

#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ?

#
# DBPassword
#
# Database user's password
#
# Example:
DBPassword = ?

#
# LogFailedSQLQueries
#
# Controls logging of failed SQL queries.
# Possible values: "yes" (default) or "no".
#
# Example:
LogFailedSQLQueries = yes

#
# LogFile
#
# Server's log file. To write log to syslog (or Event Log on Windows),
# use {syslog} as file name.
#
# Examples:
# LogFile = {syslog}
LogFile = /var/log/netxmsd.log
CodePage = utf8



Что нибудь можете посоветовать?

Проблема решилась достаточно просто но неочевидно.

Достаточно было базу сделать в cp1251 вместо UTF8 и в конфиге поменять CodePage c utf8 на cp1251.

Не дружит Netxms с utf8 )

Ja nekotoroe vremja nazad proboval stavit' CodePage utf8, vrode vse rabotalo. No eto bila ne poslednjaja versija, 0.2.24 mozet. Poprobuju potestirovat' poslednjuju versiju s utf8.