Сегодня возник следующий вопрос.
-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.