NetXMS Support Forum

Hi,
i got a problem with my Database.
im using Postgres9.4 as DB and netxms 2.0RC version

i was confused why my rootfs was nearly out of space, then i realised /var/log/postgres  was nearly 4GB

i got 10-15 screens of message each second with :


2015-12-04 12:28:46 CET [3232-95] netxms@netxms STATEMENT:  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,country,city,street_address,postcode,maint_mode,object_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28)
2015-12-04 12:28:46 CET [3232-96] netxms@netxms ERROR:  current transaction is aborted, commands ignored until end of transaction block
2015-12-04 12:28:46 CET [3232-97] netxms@netxms STATEMENT:  DEALLOCATE "netxms_stmt_0x22d2d80_436"
2015-12-04 12:28:46 CET [3232-98] netxms@netxms ERROR:  null value in column "maint_event_id" violates not-null constraint
2015-12-04 12:28:46 CET [3232-99] netxms@netxms DETAIL:  Failing row contains (103, db81e234-0450-4be7-8197-cbc74f31bcc4, eth0, 0, 0, 0, 1449228291, 1, 0, 0, 1, 0, 01020304, 75, 503C2814, , 0, 0.000000, 0.000000, 0, 0, 00000000-0000-0000-0000-000000000000, 0, , , , , 0, null).
2015-12-04 12:28:46 CET [3232-100] netxms@netxms STATEMENT:  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,country,city,street_address,postcode,maint_mode,object_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28)
2015-12-04 12:28:46 CET [3232-101] netxms@netxms ERROR:  current transaction is aborted, commands ignored until end of transaction block
2015-12-04 12:28:46 CET [3232-102] netxms@netxms STATEMENT:  DEALLOCATE "netxms_stmt_0x22d2d80_438"
2015-12-04 12:28:46 CET [3232-103] netxms@netxms ERROR:  null value in column "maint_event_id" violates not-null constraint
2015-12-04 12:28:46 CET [3232-104] netxms@netxms DETAIL:  Failing row contains (104, 58c3a61f-5d20-4afc-bb86-5f65db97a149, 10.10.0.1, 5, 0, 0, 1449228471, 1, 0, 0, 1, 0, 01020304, 75, 503C2814, , 0, 0.000000, 0.000000, 0, 0, 00000000-0000-0000-0000-000000000000, 0, , , , , 0, null).
2015-12-04 12:28:46 CET [3232-105] netxms@netxms STATEMENT:  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,country,city,street_address,postcode,maint_mode,object_id) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28)
2015-12-04 12:28:46 CET [3232-106] netxms@netxms ERROR:  current transaction is aborted, commands ignored until end of transaction block
2015-12-04 12:28:46 CET [3232-107] netxms@netxms STATEMENT:  DEALLOCATE "netxms_stmt_0x22d2d80_440"




i dropped the database, and recreated it , but same issue.. a
also after reboot, all nodes and templates are gone


any idea whats causing this? and how to fix?

regards

yes i downloaded newest client, and also the .war file. but still no success

followed this guide..
https://wiki.netxms.org/wiki/Server_Installation_Guide#Upgrading_NetXMS_Server_on_UNIX

but after this i get the error:
Server uses incompatible version of communication protocol

ok thanks
im running the recent stable version  1.2.17.

how can i invert them on the graph?
or is this only possible in 2.0+ ?

ok awesome, got it working

but one thing - im missing the option "invert values", when configuring grapohs, data sources?
i want to have grapsh with bits/s  in  bit/s out ,  and invert one value.

how could i do this? why am i missing this option?

Thanks

Hi,
im totally new to netxms, played around a little bit, and im stuck now.

i want to use netxms primarly for monitoring switch traffic.

how can i achieve to automate the process of creating dci , and graphs?
we use only 3 switch models, so i thought about creating a template for each model.
But when i go to Data Collection Configuration - and create parameters with specific SNMP OID's. and i apply a switch to this template. it always tells me Unsupported.

also the oids change , depending on the configuration of the switch, sometimes interface description for ge-0/0/0 is identified by OID 1.3.6.1.2.1.2.2.1.2.514
on anohter switch, same model, it has OID .1.3.6.1.2.1.2.2.1.2.503.

Any help is really appreciated