NetXMS Support Forum

Hi Filipp,

Quote from: Filipp Sudanov on September 05, 2025, 04:43:15 PMCould be that during the execution of the first script it deleted all the duplicates.

I think, the duplicates was created while the update of NetXMS to V5.2.5. But, in cause of my revert to a VM snapshot with NetXMS V5.2.4, there are no duplicates in tables. I run the scripts above against the V5.2.4 Version of the tables (after i restored the snapshot of the VM)...

Greetings
Marco

Hi Alex,

thanks for the new script... Started it an the result is:


psql:showduplicate1.sql:39: HINWEIS:  Total duplicate rows found: 0


So, at earlier post you said i had duplicates, but the script says there are none... Whats the truth? :-)

Greetings
Marco

Hi Alex,

thanks for the hint. I try the script via psql with (showduplicate.sql is your script):

psql -h localhost -U netxms -p 5432 -a -f showduplicate.sql

But the only output is the script himself, there are noch other outputs:

xxx@xxx:~$ psql -h localhost -U netxms -p 5432 -a -f showduplicate.sql
Passwort für Benutzer netxms:
DO $$
DECLARE
    node_record RECORD;
    tbl_name TEXT;
    dup_count INTEGER;
    total_duplicates INTEGER := 0;
BEGIN
    FOR node_record IN SELECT id FROM nodes
    LOOP
        tbl_name := 'idata_' || node_record.id;
        IF EXISTS (
            SELECT 1
            FROM information_schema.tables
            WHERE table_schema = 'public'
            AND table_name = tbl_name
        ) THEN
            EXECUTE format('
                SELECT COUNT(*) FROM public.%I
                WHERE ctid NOT IN (
                    SELECT MIN(ctid)
                    FROM public.%I
                    GROUP BY item_id, idata_timestamp
                )', tbl_name, tbl_name) INTO dup_count;
            IF dup_count > 0 THEN
                RAISE NOTICE 'Table % has % duplicate rows', tbl_name, dup_count;
                total_duplicates := total_duplicates + dup_count;
            END IF;
        END IF;
    END LOOP;
    RAISE NOTICE 'Total duplicate rows found: %', total_duplicates;
END $$;

The script is running about 1h bevor i canceld it.

Am I on the right way to run the script?

Greetings
Marco

Hi Filipp,

thanks for then explanation. So, i give the update a second try... :-)

Greetings
Marco 

Hello @all,

after Upgrade to V5.2.5 i get the hint to run nxdbmgr background-upgrade from installer:


Upgrading database...
Upgrading from version 52.20 to 52.21
Upgrading from version 52.21 to 52.22
Database upgrade succeeded

WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.
NetXMS MIB Compiler  Version 5.2.5 (5.2-431-g1b87ea4f16)
Copyright (c) 2005-2025 Raden Solutions




If i run then nxdbmgr background-upgrade i get the following errors:

DROP INDEX idx_tdata_7035
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »idata_7046« nicht erlaubt):
ALTER TABLE idata_7046 ADD PRIMARY KEY (item_id,idata_timestamp)
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7046« nicht erlaubt):
ALTER TABLE tdata_7046 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7052_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7052_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7052« nicht erlaubt):
ALTER TABLE tdata_7052 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »idata_7089« nicht erlaubt):
ALTER TABLE idata_7089 ADD PRIMARY KEY (item_id,idata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_tdata_7089« existiert nicht):
DROP INDEX idx_tdata_7089
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »idata_7096« nicht erlaubt):
ALTER TABLE idata_7096 ADD PRIMARY KEY (item_id,idata_timestamp)
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7096« nicht erlaubt):
ALTER TABLE tdata_7096 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7127_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7127_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7127« nicht erlaubt):
ALTER TABLE tdata_7127 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7128_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7128_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7128« nicht erlaubt):
ALTER TABLE tdata_7128 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7130_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7130_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7130« nicht erlaubt):
ALTER TABLE tdata_7130 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7132_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7132_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7132« nicht erlaubt):
ALTER TABLE tdata_7132 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7152_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7152_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7152« nicht erlaubt):
ALTER TABLE tdata_7152 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7159_id_timestamp« existiert nicht):
DROP INDEX idx_idata_7159_id_timestamp
SQL query failed (42P16 FEHLER:  mehrere Primärschlüssel für Tabelle »tdata_7159« nicht erlaubt):
ALTER TABLE tdata_7159 ADD PRIMARY KEY (item_id,tdata_timestamp)
SQL query failed (42704 FEHLER:  Index »idx_idata_7163_id_timestamp« existiert nicht):

The server seems to be running, but i have restored my VM to the last snapshot... To many errors in output.. :-)

Have anyone else this messages when running  nxdbmgr background-upgrade? We use Debian 11 / Postgres for NetXMS.

Greetings
Marco

 
Hello @all,
 
i have a DCI which collect Date/Time via Powershell every hour. For Example here the last Values from the history of this DCI:
 
"Timestamp","Value","Raw value"
"08.08.2025 06:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 05:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 04:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 03:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 02:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 01:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"08.08.2025 00:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 23:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 22:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 21:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 20:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 19:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 18:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 17:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 16:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00"
"07.08.2025 15:25:56","03.08.2025 18:00:00","03.08.2025 18:00:00" 


I created a Threshold to get an alarm if the value NOT change in the last 24h:

Function: "Diff with previous value" 
Sample: 24
Operation: "> : greater than"
Value: 0
Activation Event: <Type Warning>
Dectivation Event: <Type Normal>
 
But the threshold throws no alarm, even if change the sample count to 1 or 2.
 
Is this the false threshold function to compare a string? But in the NetXMS Documentation for Thresholds this function should work with strings...

---
Diff with previous value
Delta between the last and previous values will be used. If DCI data type is string and the last and previous values match, system will use 0, and if they don't - 1.
---- 
 
Where are my fault?  I am thankful for any hint...
 
Greetings
Marco
 
 
 

Hi Filipp,

you are my hero!!! 

Thanks for the infos. I truncate the table and postgres frees up the storage space...

Many thanks!

Greetings
Marco

Hello @all,

played here around with windows event logging in NetXMS V5.2.4 (Debian, Postgres).

Therefore the database size blowed up. I have changed serveral retention values an the housekeeper is running a few minutes an do it's best, but the database don't shrinks.

What can i do to shrink the DB? Deleting and restoring?

Greetings
Marco

Hello Filipp,

this Version works for me... The error message is gone.


Greetings
Marco

Hello @all,

since update to NetXMS V5.2.2 (Debian/Postgresql) i see the following error message at every template i click on (in template view):



(Message: Cannot open data collection configuration for <TemplateName>: Invalid thread access)

The view doesn't actualize, i doesn't see the DCI's from the template i choose...

Otherwise, NetXMS seems working normal...

Having anyone else this behaviour?

Greetings
Marco 

Hello @all,

today i updated from V5.1.3 > V5.1.4 (Linux Debian 12, PostgreSQL V15 DB).

After update, the NetXMS Server is running for a few minutes then crashed an restartet. I've rebooted the server, but the behavior doesn't change.

I've restored the server from backup to V5.1.3 and NetXMS ist running fine again.

Have anyone else this issue?

Greetings
Marco

Quote from: Filipp Sudanov on August 13, 2024, 02:17:52 PM

Quote from: Spheron on August 13, 2024, 02:08:09 PMhaving here a similar problem with a Netgear GS728TPv3.

Any chances we can get remote access to your device for a few days? SNMP-only access is enough, it can be some test device not connected to real network

Hi Filipp,

sorry for the - very - late reply. Meanwhile Netgear released a new firmware with a vlan/snmp bugfix. After upgrade to newest switch firmware the VLAN infos in NetXMS are correct...

Greetings
Marco  

Hello @all,

having here a similar problem with a Netgear GS728TPv3.

Ports Tab ist empty, Interface List shows VLANs at wrong interface or VLAN fields are empty in interface List...

The correct values are:
VLAN1 is on port 1-18
VLAN2 is on port 19-24

NetXMS is using the GENRIC Driver.

Using here NetXMS V5.0.6 (Linux Debian / PostgreSQL)

Must i use a vendor driver for this switch type too?

Greetings
Marco 

 

Hi Tatjana,

thanks for your post.

I've tried these and it works so far...  Now, i'd like to migrate my previous config to get Windows Eventlog to the wineventsync.nsm subagent.

Therefore i created the following config:

SubAgent=wineventsync.nsm

[WinEventSync]
EventLog=Application
EventLog=Security
EventLog=System

[WinEventSync/Security]
IncludeEvent=4624
IncludeEvent=4634
IncludeEvent=4647
ExcludeEvent=0-65535

[WinEventSync/System]
SeverityFilter = Error,Critical

[WinEventSync/Application]
SeverityFilter = Error,Critical

All of it works, except the SeverityFilter of the System Eventlog. I tested this with 

eventcreate /T ERROR /ID 1000 /L SYSTEM /D "TestError"
but i dont see any entrys in the NetXMS WindowsEvents...


If i do so with the Application Log 


eventcreate /T ERROR /ID 1000 /L APPLICATION /D "TestError"
the Windows Event Entry in the NetXMS WindowsEvents is created...


Is there a wrong entry in my config (please see above...)


Greetings
Marco

Hello @all,

i want to create an event from every user session (showed in NetXMS register "User Sessions") so that i get every user logon/logoff in the NetXMS event log from every node.

Is there a chance to create those infos in the NetXMS event log?

I would appreciate any help/tips.

Greetings
Marco