NetXMS 1.2.12 released
-
There are two workarounds:
- use built-in "admin" account - it always has all access rights;
- Assign access rights directly in database. To do so, stop NetXMS server, then execute query like this:
UPDATE users SET system_access=system_access+134217728 WHERE id=insert_user_id_here
and start server.
Best regards,
Victor -
-
I have tried to install netxms on clean Debian 6 and Debian 7 from https://www.netxms.org/apt/dists/
I have found next errors:
Debian 7:
https://www.netxms.org/apt/dists/wheezy/main/binary-i386/netxms-base_1.2.12_i386.deb
Needs libssl 0.9 which is only in Debian6.https://www.netxms.org/apt/dists/wheezy/main/binary-i386/netxms-server-oracle_1.2.12_i386.deb
needs libio1 to start. It is not set in dependencies.Contib folder is not contained in the packages.
Debian 6.
https://www.netxms.org/apt/dists/squeeze/main/binary-i386/netxms-server_1.2.12_i386.deb
contains netxmsd and nxdbmgr with 11 versions.
daemon does not start after initialisation of sql database.At both:
packages do not contain images folder. -
Debian 7 + Oracle
Errors in event monitor2014-02-24 10:58:13 i0debnxms Critical SYS_DB_QUERY_FAILED Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME"))see attach
-
Похоже что каким-то образом создался обьект с пустым именем. Можете прислать результат команды
nxadm -c "show objects"
?
Ну и после этого можно попробовать найти этот обьект и дать ему какое-то имя руками. -
@victor said in NetXMS 1.2.12 released:
Похоже что каким-то образом создался обьект с пустым именем. Можете прислать результат команды
nxadm -c "show objects"
?
Ну и после этого можно попробовать найти этот обьект и дать ему какое-то имя руками.Это достаточно проблематично...
nxadm -c "show stat"
Total number of objects: 22425
Number of monitored nodes: 898
Number of collectable DCIs: 913 -
-
@d-ray said in NetXMS 1.2.12 released:
POLL ERROR: Software caused connection abort: socket write error **** Poll failed ****
Console doesn't work after 5..10min.
After upgrading to 1.2.12 Server & console same version.
anyone? same issue ?
Regards
It's a known issue. It is already fixed in current development version, we will publish next patch release soon.
Best regards,
Victor -
@victor said in NetXMS 1.2.12 released:
@d-ray said in NetXMS 1.2.12 released:
POLL ERROR: Software caused connection abort: socket write error **** Poll failed ****
Console doesn't work after 5..10min.
After upgrading to 1.2.12 Server & console same version.
anyone? same issue ?
Regards
It's a known issue. It is already fixed in current development version, we will publish next patch release soon.
Best regards,
Victorooh that's nice.
Where can I find the patch release when it is available?Best Regards,
Denis -
It will be published on web site and announced on forum as usual.
Best regards,
Victor -
Will this version allow me to do what is in the following post and if so, how do I set it up?
https://www.netxms.org/forum/general-support/dci-thresold-on-string/
-
@rabid said in NetXMS 1.2.12 released:
Will this version allow me to do what is in the following post and if so, how do I set it up?
https://www.netxms.org/forum/general-support/dci-thresold-on-string/
Sorry, I forgot to do this in 1.2.12. I've added service list and service table to Windows agent in upcoming 1.2.13 release.
Best regards,
Victor -
-
Debian 7 + oracle 11g
Сегодня утром обнаружил netxms в нерабочем состоянии.
Последние записи в логах:$ tail /var/log/netxms [05-Mar-2014 04:39:53.636] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.638] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.639] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.641] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.642] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.644] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.646] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.647] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.649] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME") [05-Mar-2014 04:39:53.650] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-01400: cannot insert NULL into ("NETXMS"."OBJECT_PROPERTIES"."NAME")Указанные выше ошибки почти ничего не дают.
Сделал дополнительный запрос:$ grep -v 'SQL query failed (Query = "INSERT INTO object_properties' /var/log/netxms [05-Mar-2014 03:11:49.955] Log file truncated. [05-Mar-2014 03:13:50.710] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30893,'CF E0 EA E5 F2 20 E4 F0 E0 E9 E2 E5 F0 EE E2 20 57 69 6E 64 6F 77 73 20 2D 20 41 76 74 6F 72 20 4C 74 64 2E 20 28 52 45 41 44 45 52 33 37 38 30 29 20 53 6D 61 72 74 43 61 72 64 5????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 03:13:50.818] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30914,'C1 E0 E7 EE E2 FB E9 20 EF E0 EA E5 F2 20 EF EE F1 F2 E0 E2 F9 E8 EA E0 20 F1 EB F3 E6 E1 FB 20 EA F0 E8 EF F2 EE E3 F0 E0 F4 E8 E8 20 F1 EC E0 F0 F2 2D EA E0 F0 F2 20 28 4D 69 6????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 03:13:50.822] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30915,'CE E1 ED EE E2 EB E5 ED E8 E5 20 E1 E5 E7 EE EF E0 F1 ED EE F1 F2 E8 20 E4 EB FF 20 EF F0 EE E8 E3 F0 FB E2 E0 F2 E5 EB FF 20 57 69 6E 64 6F 77 73 20 4D 65 64 69 61 20 2D 20 28 4????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 03:13:50.830] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30917,'CE E1 ED EE E2 EB E5 ED E8 E5 20 E1 E5 E7 EE EF E0 F1 ED EE F1 F2 E8 20 E4 EB FF 20 EF F0 EE E8 E3 F0 FB E2 E0 F2 E5 EB FF 20 57 69 6E 64 6F 77 73 20 4D 65 64 69 61 20 36 2E 34 2????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 03:13:50.839] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30919,'CE E1 ED EE E2 EB E5 ED E8 E5 20 E1 E5 E7 EE EF E0 F1 ED EE F1 F2 E8 20 E4 EB FF 20 EF F0 EE E8 E3 F0 FB E2 E0 F2 E5 EB FF 20 57 69 6E 64 6F 77 73 20 4D 65 64 69 61 20 31 31 20 2????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 03:13:50.863] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30920,'C8 F1 EF F0 E0 E2 EB E5 ED E8 E5 20 E4 EB FF 20 EF F0 EE E8 E3 F0 FB E2 E0 F2 E5 EB FF 20 57 69 6E 64 6F 77 73 20 4D 65 64 69 61 20 31 31 20 2D 20 28 4B 42 39 33 39 36 38 33 29 '????"): ORA-00917: missing comma [05-Mar-2014 03:13:50.894] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30925,'CE E1 ED EE E2 EB E5 ED E8 E5 20 E1 E5 E7 EE EF E0 F1 ED EE F1 F2 E8 20 E4 EB FF 20 57 69 6E 64 6F 77 73 20 49 6E 74 65 72 6E 65 74 20 45 78 70 6C 6F 72 65 72 20 37 20 28 4B 42 3????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 04:06:45.258] [ERROR] SQL query failed (Query = "UPDATE alarms SET alarm_state=0,ack_by=0,term_by=0,last_change_time=1393992405,current_severity=2,repeat_count=4,hd_state=0,hd_ref='',timeout=0,timeout_event=43,message='Invalid network mask 255.255.248.0 on interface "Realtek RTL8139 Family PCI Fast Ethernet NIC - ???????? ???????", should be 255.255.240.0',resolved_by=0, ack_timeout=0 WHERE alarm_id=25392"): ORA-24373: invalid length specified for statementSyslog
Mar 5 04:39:55 i0debnxms kernel: [66247.765920] netxmsd invoked oom-killer: gfp_mask=0x201da, order=0, oom_adj=0, oom_score_adj=0 Mar 5 04:39:55 i0debnxms kernel: [66247.765924] netxmsd cpuset=/ mems_allowed=0 Mar 5 04:39:55 i0debnxms kernel: [66247.765929] Pid: 3468, comm: netxmsd Not tainted 3.2.0-4-amd64 #1 Debian 3.2.54-2 Mar 5 04:39:55 i0debnxms kernel: [66247.765931] Call Trace: Mar 5 04:39:55 i0debnxms kernel: [66247.765939] [<ffffffff810b742a>] ? dump_header+0x78/0x1bd Mar 5 04:39:55 i0debnxms kernel: [66247.765943] [<ffffffff8134fdc7>] ? _raw_spin_unlock_irqrestore+0xe/0xf Mar 5 04:39:55 i0debnxms kernel: [66247.765947] [<ffffffff81097dce>] ? delayacct_end+0x72/0x7d Mar 5 04:39:55 i0debnxms kernel: [66247.765951] [<ffffffff81164a56>] ? security_real_capable_noaudit+0x40/0x4f Mar 5 04:39:55 i0debnxms kernel: [66247.765953] [<ffffffff8134fdc7>] ? _raw_spin_unlock_irqrestore+0xe/0xf Mar 5 04:39:55 i0debnxms kernel: [66247.765956] [<ffffffff810b77f3>] ? oom_kill_process+0x49/0x271 Mar 5 04:39:55 i0debnxms kernel: [66247.765958] [<ffffffff810b7eee>] ? out_of_memory+0x2ea/0x337 Mar 5 04:39:55 i0debnxms kernel: [66247.765962] [<ffffffff810bbb85>] ? __alloc_pages_nodemask+0x629/0x7aa Mar 5 04:39:55 i0debnxms kernel: [66247.765967] [<ffffffff810e5246>] ? alloc_pages_current+0xc7/0xe4 Mar 5 04:39:55 i0debnxms kernel: [66247.765970] [<ffffffff810b6b2f>] ? filemap_fault+0x24f/0x33e Mar 5 04:39:55 i0debnxms kernel: [66247.765974] [<ffffffff8106e102>] ? futex_wait+0x1fe/0x236 Mar 5 04:39:55 i0debnxms kernel: [66247.765978] [<ffffffff810ced10>] ? __do_fault+0xc8/0x3ac Mar 5 04:39:55 i0debnxms kernel: [66247.765981] [<ffffffff810d12c7>] ? handle_pte_fault+0x298/0x79f Mar 5 04:39:55 i0debnxms kernel: [66247.765984] [<ffffffff810ce865>] ? pte_offset_kernel+0x16/0x35 Mar 5 04:39:55 i0debnxms kernel: [66247.765988] [<ffffffff81352d2e>] ? do_page_fault+0x320/0x345 Mar 5 04:39:55 i0debnxms kernel: [66247.765992] [<ffffffff81048cd2>] ? release_task+0x31b/0x331 Mar 5 04:39:55 i0debnxms kernel: [66247.765995] [<ffffffff81036628>] ? should_resched+0x5/0x23 Mar 5 04:39:55 i0debnxms kernel: [66247.765998] [<ffffffff8106fb91>] ? sys_futex+0x120/0x153 Mar 5 04:39:55 i0debnxms kernel: [66247.766001] [<ffffffff81350335>] ? page_fault+0x25/0x30 Mar 5 04:39:55 i0debnxms kernel: [66247.766004] Mem-Info: Mar 5 04:39:55 i0debnxms kernel: [66247.766005] Node 0 DMA per-cpu: Mar 5 04:39:55 i0debnxms kernel: [66247.766007] CPU 0: hi: 0, btch: 1 usd: 0 Mar 5 04:39:55 i0debnxms kernel: [66247.766008] Node 0 DMA32 per-cpu: Mar 5 04:39:55 i0debnxms kernel: [66247.766010] CPU 0: hi: 186, btch: 31 usd: 0 Mar 5 04:39:55 i0debnxms kernel: [66247.766014] active_anon:118067 inactive_anon:118119 isolated_anon:0 Mar 5 04:39:55 i0debnxms kernel: [66247.766015] active_file:9 inactive_file:24 isolated_file:0 Mar 5 04:39:55 i0debnxms kernel: [66247.766016] unevictable:0 dirty:0 writeback:0 unstable:0 Mar 5 04:39:55 i0debnxms kernel: [66247.766016] free:12260 slab_reclaimable:792 slab_unreclaimable:2812 Mar 5 04:39:55 i0debnxms kernel: [66247.766017] mapped:1 shmem:0 pagetables:1187 bounce:0 Mar 5 04:39:55 i0debnxms kernel: [66247.766019] Node 0 DMA free:4660kB min:680kB low:848kB high:1020kB active_anon:5572kB inactive_anon:5660kB active_file:0kB inactive_file:0kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15688kB mlocked:0kB dirty:0kB writeback:0kB mapped:0kB shmem:0kB slab_reclaimable:0kB slab_unreclaimable:0kB kernel_stack:0kB pagetables:20kB unstable:0kB bounce:0kB writeback_tmp:0kB pages_scanned:51 all_unreclaimable? yes Mar 5 04:39:55 i0debnxms kernel: [66247.766028] lowmem_reserve[]: 0 994 994 994 Mar 5 04:39:55 i0debnxms kernel: [66247.766031] Node 0 DMA32 free:44380kB min:44372kB low:55464kB high:66556kB active_anon:466696kB inactive_anon:466816kB active_file:36kB inactive_file:96kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:1018016kB mlocked:0kB dirty:0kB writeback:0kB mapped:4kB shmem:0kB slab_reclaimable:3168kB slab_unreclaimable:11248kB kernel_stack:1648kB pagetables:4728kB unstable:0kB bounce:0kB writeback_tmp:0kB pages_scanned:7801 all_unreclaimable? yes Mar 5 04:39:55 i0debnxms kernel: [66247.766040] lowmem_reserve[]: 0 0 0 0 Mar 5 04:39:55 i0debnxms kernel: [66247.766042] Node 0 DMA: 1*4kB 2*8kB 2*16kB 2*32kB 3*64kB 2*128kB 2*256kB 1*512kB 1*1024kB 1*2048kB 0*4096kB = 4660kB Mar 5 04:39:55 i0debnxms kernel: [66247.766049] Node 0 DMA32: 133*4kB 79*8kB 45*16kB 20*32kB 20*64kB 17*128kB 4*256kB 3*512kB 1*1024kB 1*2048kB 8*4096kB = 44380kB Mar 5 04:39:55 i0debnxms kernel: [66247.766055] 1145 total pagecache pages Mar 5 04:39:55 i0debnxms kernel: [66247.766056] 1104 pages in swap cache Mar 5 04:39:55 i0debnxms kernel: [66247.766058] Swap cache stats: add 324461, delete 323357, find 89314/108284 Mar 5 04:39:55 i0debnxms kernel: [66247.766059] Free swap = 0kB Mar 5 04:39:55 i0debnxms kernel: [66247.766060] Total swap = 392188kB Mar 5 04:39:55 i0debnxms kernel: [66247.768594] 262128 pages RAM Mar 5 04:39:55 i0debnxms kernel: [66247.768596] 5436 pages reserved Mar 5 04:39:55 i0debnxms kernel: [66247.768597] 13 pages shared Mar 5 04:39:55 i0debnxms kernel: [66247.768598] 243869 pages non-shared Mar 5 04:39:55 i0debnxms kernel: [66247.768599] [ pid ] uid tgid total_vm rss cpu oom_adj oom_score_adj name Mar 5 04:39:55 i0debnxms kernel: [66247.768607] [ 339] 0 339 5378 1 0 -17 -1000 udevd Mar 5 04:39:55 i0debnxms kernel: [66247.768610] [ 461] 0 461 5360 1 0 -17 -1000 udevd Mar 5 04:39:55 i0debnxms kernel: [66247.768613] [ 462] 0 462 5360 1 0 -17 -1000 udevd Mar 5 04:39:55 i0debnxms kernel: [66247.768616] [ 1744] 0 1744 4743 13 0 0 0 rpcbind Mar 5 04:39:55 i0debnxms kernel: [66247.768619] [ 1775] 102 1775 5836 1 0 0 0 rpc.statd Mar 5 04:39:55 i0debnxms kernel: [66247.768622] [ 1793] 0 1793 6323 0 0 0 0 rpc.idmapd Mar 5 04:39:55 i0debnxms kernel: [66247.768625] [ 2075] 0 2075 30415 198 0 0 0 nxagentd Mar 5 04:39:55 i0debnxms kernel: [66247.768628] [ 2093] 0 2093 13293 0 0 0 0 rsyslogd Mar 5 04:39:55 i0debnxms kernel: [66247.768631] [ 2137] 0 2137 1029 0 0 0 0 acpid Mar 5 04:39:55 i0debnxms kernel: [66247.768634] [ 2162] 0 2162 4168 0 0 0 0 atd Mar 5 04:39:55 i0debnxms kernel: [66247.768636] [ 2207] 0 2207 5726 17 0 0 0 cron Mar 5 04:39:55 i0debnxms kernel: [66247.768639] [ 2237] 106 2237 7451 0 0 0 0 dbus-daemon Mar 5 04:39:55 i0debnxms kernel: [66247.768642] [ 2516] 101 2516 11702 4 0 0 0 exim4 Mar 5 04:39:55 i0debnxms kernel: [66247.768645] [ 2557] 0 2557 12482 0 0 -17 -1000 sshd Mar 5 04:39:55 i0debnxms kernel: [66247.768648] [ 2590] 0 2590 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768650] [ 2591] 0 2591 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768653] [ 2592] 0 2592 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768655] [ 2593] 0 2593 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768658] [ 2594] 0 2594 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768660] [ 2595] 0 2595 4695 1 0 0 0 getty Mar 5 04:39:55 i0debnxms kernel: [66247.768663] [27084] 0 27084 469821 233310 0 0 0 netxmsd Mar 5 04:39:55 i0debnxms kernel: [66247.768665] Out of memory: Kill process 27084 (netxmsd) score 902 or sacrifice child Mar 5 04:39:55 i0debnxms kernel: [66247.768764] Killed process 27084 (netxmsd) total-vm:1879284kB, anon-rss:933240kB, file-rss:0kBПохоже на memory leak.
Вывод от$ps ax -FНичего подозрительного не показывает.
$ free -l -b total used free shared buffers cached Mem: 1051672576 96010240 955662336 0 14950400 41709568 Low: 1051672576 96010240 955662336 High: 0 0 0 -/+ buffers/cache: 39350272 1012322304 Swap: 401600512 9871360 391729152На сервере не установлено ничего кроме netxms.
Netxms установлен из пакетов:$ ls -lah total 9.4M drwxr-xr-x 2 andrey andrey 4.0K Feb 19 10:16 . drwxr-xr-x 6 andrey andrey 4.0K Feb 19 12:41 .. -rw-r--r-- 1 andrey andrey 1.1M Feb 18 08:50 netxms-agent_1.2.12_amd64.deb -rw-r--r-- 1 andrey andrey 1.4M Feb 18 08:50 netxms-base_1.2.12_amd64.deb -rw-r--r-- 1 andrey andrey 6.9M Feb 18 08:50 netxms-server_1.2.12_amd64.deb -rw-r--r-- 1 andrey andrey 27K Feb 18 08:50 netxms-server-oracle_1.2.12_amd64.debЕсть предположение что виновником является модуль БД (oracle).
Дополнительно был установлен:
instantclient-basic-linux.x64-11.2.0.4.0После перезапуска в лог сыпятся ошибки:
[05-Mar-2014 08:31:11.443] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30920,'C8 F1 EF F0 E0 E2 EB E5 ED E8 E5 20 E4 EB FF 20 EF F0 EE E8 E3 F0 FB E2 E0 F2 E5 EB FF 20 57 69 6E 64 6F 77 73 20 4D 65 64 69 61 20 31 31 20 2D 20 28 4B 42 39 33 39 36 38 33 29 '????"): ORA-00917: missing comma [05-Mar-2014 08:31:11.469] [ERROR] SQL query failed (Query = "INSERT INTO raw_dci_values (item_id,raw_value,last_poll_time) VALUES (30925,'CE E1 ED EE E2 EB E5 ED E8 E5 20 E1 E5 E7 EE EF E0 F1 ED EE F1 F2 E8 20 E4 EB FF 20 57 69 6E 64 6F 77 73 20 49 6E 74 65 72 6E 65 74 20 45 78 70 6C 6F 72 65 72 20 37 20 28 4B 42 3????"): ORA-01756: quoted string not properly terminated [05-Mar-2014 08:31:57.546] [ERROR] Thread "Syncer Thread" does not respond to watchdog thread -
Debian7 + oracle 11g
netxms съел всю память и опять упал.$ uptime 09:19:17 up 55 min, 2 users, load average: 0.03, 0.25, 0.23syslog:
Mar 5 09:15:21 i0debnxms kernel: [ 3105.416859] Out of memory: Kill process 2116 (netxmsd) score 888 or sacrifice child Mar 5 09:15:21 i0debnxms kernel: [ 3105.416958] Killed process 2116 (netxmsd) total-vm:1928652kB, anon-rss:922256kB, file-rss:0kBУдалил 75000 DCI.
Потребление памяти после запуска уменьшилось с 960 MB до 215 MB.
Нагрузка на ЦПУ упала с 50-60% до 0,5-2%. -
-
@andrey-k said in NetXMS 1.2.12 released:
Удалил 75000 DCI.
Потребление памяти после запуска уменьшилось с 960 MB до 215 MB.
Нагрузка на ЦПУ упала с 50-60% до 0,5-2%.What type those DCIs was - SNMP or agent? What was collection interval?
Best regards,
Victor -
-
@andrey-k said in NetXMS 1.2.12 released:
В консоли на windows не работает переключение языка.
Утром обнаружил консоль на русском.
Провел тест:
Переключаю на английский - консоль просит перезапуска.
Соглашаюсь, консоль перезапускается - остался русский.
Закрываю, открываю по новой - уже английский... -
I have faced with memory-end trouble again.
This morning netxms was killed by system in couse of low memory. Syslog dump in attach.
System 3Gib RAM.
nxadm -c " sh sta"Total number of objects: 36245 Number of monitored nodes: 2533 Number of collectable DCIs: 4172DCI:
snmp-table.After of almost hour work of netxms it used:
$ ps all x | grep netx
F UID PID PPID PRI NI VSZ RSS WCHAN STAT TTY TIME COMMAND1 0 4826 1 20 0 2527320 1943124 ? Ssl ? 53:00 /usr/local/bin/netxmsd -d -D 5
$ free -l
total used free shared buffers cached
Mem: 3095372 2216484 878888 0 37024 180472
Low: 3095372 2216484 878888
High: 0 0 0
-/+ buffers/cache: 1998988 1096384
Swap: 731132 0 731132
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login