NetXMS Support Forum

I had to increase my shared memory and increase max transaction locks, but I am also back in business. 

This appears more relevant


>>> RELEASE SAVEPOINT nxdbmgr_1771000399839
>>> SELECT var_value FROM metadata WHERE var_name='IDataTableCreationCommand'
>>> CREATE TABLE idata_46970 (item_id integer not null,idata_timestamp bigint not null,idata_value varchar(255) null,raw_value varchar(255) null, PRIMARY KEY(item_id,idata_timestamp))
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
CREATE TABLE idata_46970 (item_id integer not null,idata_timestamp bigint not null,idata_value varchar(255) null,raw_value varchar(255) null, PRIMARY KEY(item_id,idata_timestamp))
Rolling back last stage due to upgrade errors...
Database upgrade failed
>>> SELECT var_value FROM metadata WHERE var_name='PendingOnlineUpgrades'



Getting a lot of text - here's a snippet

QuoteDROP TABLE tdata_8505
>>> RELEASE SAVEPOINT nxdbmgr_1771000353984
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_0'
>>> CREATE TABLE tdata_8505 (item_id integer not null,tdata_timestamp bigint not null,tdata_value text null, PRIMARY KEY(item_id,tdata_timestamp))
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_9'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_0'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'
>>> SELECT COUNT(*) FROM idata_74790

I am receiving similar errors, but I believe I caused my own problems by running the commands that Victor posted earlier.

QuoteDROP TABLE idata;
CREATE TABLE idata
(
   item_id integer not null,
   idata_timestamp integer not null,
   idata_value varchar(255) null,
   raw_value varchar(255) null
);
DROP TABLE tdata;
CREATE TABLE tdata
(
   item_id integer not null,
   tdata_timestamp integer not null,
   tdata_value varchar(max) null
);

Is my database irrevocably damaged?

I saw the database upgrade start when I used apt get upgrade. I thought that the server could then be started while that was running, but I suppose not.

I can see that the database upgrade is happening in the background, but the netxms-server service won't start.

"Your database has format version 60.7, but server is compiled for version 60.32"

Hello,

I am running into a similar issue on a Ubuntu installation where the database has taken multiple days to upgrade showing that it is converting idata and tdata tables, but never completing.

Thanks in advance!

Thanks tolimanjo. That limited it, but it seems that I can't call the variable interface.name for the display name.

Hello,

I'm trying to setup a template that collects port negotiation rates on Mikrotik devices. I get the info that I want on physical ports, but I get 0 results on virtual interfaces. I would like to filter out virtual interfaces so DCIs are not being created.

transport = CreateSNMPTransport($node);
if (transport == null)
 return false;
// get the interface name to return as instance-name
vb = SNMPGet(transport, ".1.3.6.1.2.1.31.1.1.1.1." .. $1);
if (vb == null) or (vb == 0)
 return false;
// filter out loopback
if (vb.value == "lo")
 return false;
return %(true, $1, vb.value);

I've tried using contains(vb.value, "vlan") on the bottom statement, but that just breaks the script.

Quite a few of these cameras were added to NetXMS when they were already offline. They then all polled down as they were checking for SNMP. I terminated the first alarms as I knew they didn't have SNMP functionality, but I have been unable to get them to change status based on ICMP either. They have also been offline since addition so I figure that would be why their status is not changing. 

It is indeed.

 

ID	Time	Origin time	Origin	Source	Zone	DCI	Event	Severity	Message	Event tags	Root ID
48056062	11.05.2025 06:03:47	11.05.2025 06:03:47	System	4th Fl Stair 2	Default	0	SYS_ICMP_UNREACHABLE	Major	Node is unreachable by ICMP	48056060
48056061	11.05.2025 06:03:46	11.05.2025 06:03:46	System	4th Fl Stair 2	Default	0	SYS_NODE_CRITICAL	Critical	Node status changed to CRITICAL	NodeStatus	0
48056060	11.05.2025 06:03:46	11.05.2025 06:03:46	System	4th Fl Stair 2	Default	0	SYS_NODE_DOWN	Critical	Site:Vicina Main 4th Fl Stair 2 is unresponsive - 10.1.102.171	0

So it looks like ICMP status check updates for cameras that were added when they were online.

Offline Camera:
[12.05.2025 09:24:38] **** Poll request sent to server ****
[12.05.2025 09:24:38] Poll request accepted, waiting for outstanding polling requests to complete...
[12.05.2025 09:24:38] Starting status poll of node Tara Kitchen - 3
[12.05.2025 09:24:38]    Starting status poll on interface unknown
[12.05.2025 09:24:38]      Current interface status is NORMAL
[12.05.2025 09:24:38]      Starting ICMP ping
[12.05.2025 09:24:41]      Interface is NORMAL for 3659 polls (3 polls required for status change)
[12.05.2025 09:24:41]      Interface status after poll is NORMAL
[12.05.2025 09:24:41]    Finished status poll on interface unknown
[12.05.2025 09:24:41] Checking primary IP address with ICMP ping
[12.05.2025 09:24:45]   Primary IP address is not responding to ICMP ping
[12.05.2025 09:24:45] Node is still unreachable
[12.05.2025 09:24:45] Finished status poll of node Tara Kitchen - 3
[12.05.2025 09:24:45] Node status after poll is NORMAL
[12.05.2025 09:24:45] **** Poll completed successfully ****

Online Camera:
[12.05.2025 09:30:20] **** Poll request sent to server ****
[12.05.2025 09:30:20] Poll request accepted, waiting for outstanding polling requests to complete...
[12.05.2025 09:30:20] Starting status poll of node Tara Kitchen - 4
[12.05.2025 09:30:20]    Starting status poll on interface unknown
[12.05.2025 09:30:20]      Current interface status is NORMAL
[12.05.2025 09:30:20]      Starting ICMP ping
[12.05.2025 09:30:20]      Interface is NORMAL for 3813 polls (3 polls required for status change)
[12.05.2025 09:30:20]      Interface status after poll is NORMAL
[12.05.2025 09:30:20]    Finished status poll on interface unknown
[12.05.2025 09:30:20] Node is connected
[12.05.2025 09:30:24] Finished status poll of node Tara Kitchen - 4
[12.05.2025 09:30:24] Node status after poll is NORMAL
[12.05.2025 09:30:24] **** Poll completed successfully ****


I suspect that this is due to certain cameras being down when they were first added, but I would like for them to show down even if they never polled up when first added.

Hello,

I am trying to monitor network security cameras that have no SNMP functionality. I set the objects to use ICMP to determine node status, but the objects don't generate alarms even though they are offline. I tried resetting the alarms using the link below:


https://wiki.netxms.org/wiki/Reseting_state_of_all_alarms_and_node_statuses

Cameras showing 100% ICMP packet loss show as normal and don't have any alarms even after alarm status reset. Any suggestions?

It works beautifully now. Thank you so much, Filipp!