Пропадают настройки при выключении сервера.

Started by karmael, February 08, 2010, 02:06:43 PM

Previous topic - Next topic

karmael

Спасибо огромное. Настройки стали сохраняться, в логах ошибки присутствуют, но как  понял работе не мешают  ;D

Victor Kirhenshtein


karmael

Вы не поверите , но старые, но мало. т.е. они не блокирую прохождение других sql запросов (не знаю, скорей всего после сборки с новым pgsql.cpp)
нынешний лог в полном составе (т.е. больше не растет и ошибок больше нет) ошибки генерит только при старте сервера и выглядит вот так :


[12-Feb-2010 09:34:18] Log file opened
[12-Feb-2010 09:34:18] Platform subagent "/usr/local/netxms/lib/libnsm_linux.so" successfully loaded
[12-Feb-2010 09:34:18] Database driver "/usr/local/netxms/lib/libnxddr_pgsql.so" loaded and initialized successfully
[12-Feb-2010 09:35:00] Listening for SNMP traps on UDP socket 0.0.0.0:162
[12-Feb-2010 09:35:00] NetXMS Server started
[12-Feb-2010 09:35:00] Listening for client connections on TCP socket 0.0.0.0:4701
[12-Feb-2010 09:38:03] SQL query failed (Query = "UPDATE object_properties SET name='Подключение по л<D0>',status=0,is_deleted=0,inherit_access_rights=1,last_modified=1265956683,status_calc_alg=0,status_prop_alg=0,status_fixed_val=1,status_shift=0,status_translation='01020304',status_single_threshold=75,status_thresholds='503C2814',comments='',is_system=0,location_type=0,latitude='0.000000',longitude='0.000000' WHERE object_id=1374"): ERROR:  unterminated quoted string at or near "'Подключение по л"
LINE 1: UPDATE object_properties SET name='Подключение по л
                                          ^
[12-Feb-2010 09:38:03] SQL query failed (Query = "SELECT id FROM interfaces WHERE id=1374"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "INSERT INTO interfaces (id,ip_addr,ip_netmask,node_id,if_type,if_index,mac_addr,synthetic_mask,required_polls) VALUES (1374,'192.168.5.12','255.255.255.0',1103,6,65539,'00304866C4E3',0,0)"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "DELETE FROM acl WHERE object_id=1374"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "SELECT object_id FROM object_properties WHERE object_id=1638"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "SELECT id FROM interfaces WHERE id=1638"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "INSERT INTO interfaces (id,ip_addr,ip_netmask,node_id,if_type,if_index,mac_addr,synthetic_mask,required_polls) VALUES (1638,'192.168.2.4','255.255.255.0',373,6,65539,'003005989DE8',0,0)"): ERROR:  current transaction is aborted, commands ignored until end of transaction block
[12-Feb-2010 09:38:03] SQL query failed (Query = "DELETE FROM acl WHERE object_id=1638"): ERROR:  current transaction is aborted, commands ignored until end of transaction block