NetXMS 1.1.5 error creating nodes and restoring old IP

[testos]

Hi!

Creating a new node with any ip, netxms always gives ip 255.255.255.255 and a strange Primary Host Name.
Also, after upgrading to 1.1.5, old IP were restored in nodes with IP changed at some point.

Best regards.

---

[victor]

Hi!

Do you enter only IP address, only name, or both when creating node? Also, what is server operating system?

Best regards,
Victor

[testos]

I enter both fields: node name and node IP  address.
My operating system is a Linux Centos 5.

Best regards

[victor]

I just tried to reproduce this issue on test server, but without success - everything work as expected. Could you please set debug level to 9 (you can do this while server is running by entering "debug 9" command on server console, either via management console or nxadm tool), try to create a new node, and send me the log?

Best regards,
Victor

[victor]

Additional question - do you use old or new console for creating nodes? I encounter same issue with old console (nxcon.exe) connected to server 1.1.5. Java console connected to same server works fine.

Best regards,
Victor

[testos]

I use Legacy console for 1.1.5 branch. I created a test environment and I am struggling with it. On the other hand, I get many errors when I try to reindex my database:

[root@GesRed2 netxms-1.1.5]# nxdbmgr reindex
NetXMS Database Manager Version 1.1.5

Reindexing table raw_dci_values by (item_id)...
SQL query failed (Duplicate key name 'idx_raw_dci_values_item_id'):
CREATE INDEX idx_raw_dci_values_item_id ON raw_dci_values(item_id)
Reindexing table event_log by (event_timestamp)...
SQL query failed (Duplicate key name 'idx_event_log_event_timestamp'):
CREATE INDEX idx_event_log_event_timestamp ON event_log(event_timestamp)
Reindexing table thresholds by (item_id)...
SQL query failed (Duplicate key name 'idx_thresholds_item_id'):
CREATE INDEX idx_thresholds_item_id ON thresholds(item_id)
Reindexing table thresholds by (sequence_number)...
SQL query failed (Duplicate key name 'idx_thresholds_sequence'):
CREATE INDEX idx_thresholds_sequence ON thresholds(sequence_number)
Reindexing table alarm_notes by (alarm_id)...
SQL query failed (Duplicate key name 'idx_alarm_notes_alarm_id'):
CREATE INDEX idx_alarm_notes_alarm_id ON alarm_notes(alarm_id)
Reindexing table syslog by (msg_timestamp)...
SQL query failed (Duplicate key name 'idx_syslog_msg_timestamp'):
CREATE INDEX idx_syslog_msg_timestamp ON syslog(msg_timestamp)
Reindexing table snmp_trap_log by (trap_timestamp)...
SQL query failed (Duplicate key name 'idx_snmp_trap_log_trap_timestamp'):
CREATE INDEX idx_snmp_trap_log_trap_timestamp ON snmp_trap_log(trap_timestamp)
Reindexing table address_lists by (list_type)...
SQL query failed (Duplicate key name 'idx_address_lists_list_type'):
CREATE INDEX idx_address_lists_list_type ON address_lists(list_type)
Reindexing table idata_16
SQL query failed (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 'FROM idata_16' at line 1):
DROP INDEX idata_16 FROM idata_16
SQL query failed (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 'FROM idata_16' at line 1):
DROP INDEX idata_16 FROM idata_16
SQL query failed (Duplicate key name 'idx_idata_16_id_timestamp'):
CREATE INDEX idx_idata_16_id_timestamp ON idata_16(item_id,idata_timestamp)
Reindexing table idata_33
SQL query failed (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 'FROM idata_33' at line 1):
DROP INDEX idata_33 FROM idata_33
SQL query failed (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 'FROM idata_33' at line 1):
DROP INDEX idata_33 FROM idata_33
SQL query failed (Duplicate key name 'idx_idata_33_id_timestamp'):
CREATE INDEX idx_idata_33_id_timestamp ON idata_33(item_id,idata_timestamp)
...
...

Best regards.

[victor]

There is a bug in legacy console with node creation. I'll publish patched version later today.
You should not use reindex operation in nxdbmgr. It was created long time ago for one specific case and is currently broken. It need to be either fixed or removed. But why you need to reindex database?

Best regards,
Victor

[testos]

Hi Victor!

I'll publish patched version later today.

Thanks for you support.

. But why you need to reindex database?

I was trying to prove something to solve this strange behavior

Best regards.

[victor]

Patched legacy console available here: https://www.netxms.org/download/patches/009/netxms-console-1.1.5.1.exe

Best regards,
Victor

[testos]

Thank you Victor.
It seems all work fine now.

Best regards.