Database Issues

[anw]

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

[mkemerci]

I installed netxms to a new pc and had same errors.

I solved this by doing these steps  :

After compiling netxms 2.0rc2;
Create db,
download netxms 2.0 rc1 version (for only initdb sql file)
use nxdbmgr initdb with 2.0rc1 sql file
do a nxdbmgr upgrade
and start netxms 2.0 rc2.

[alk]

This issue is already fixed in trunk.