NetXMS Support Forum

Hello,

for some purposes it would be beneficial to be able to change the address of a node via NXSL.

Maybe this function already exists, but I didn't find anything in the documentation.


Thanks

Andreas

Hello,

It took me a while, but I was on holiday.
With the described procedure everything worked without problems, now the hypertable is also filled.

But I still have one question: how can I copy the logs in the background? Also with nxdbmgr or directly in the database?

Many thanks Filipp, really a great help


Andy

Hello Filipp,

Here is the requested data:

• OS: Debian 9 (Kernel 4.9.0-15-amd64)
• Netxms: 3.8.405-1
• PostgreSQL: 11.12-1.pgdg90+1
• TimescaleDB: 1.7.5~debian9

Timescale seems to be installed:

SELECT default_version, installed_version FROM pg_available_extensions where name = 'timescaledb';
default_version | installed_version
-----------------+-------------------
1.7.5           | 1.7.5


\d+ tdata_sc_default;
                                           Table "public.tdata_sc_default"
     Column      |           Type           | Collation | Nullable | Default | Storage  | Stats target | Description
-----------------+--------------------------+-----------+----------+---------+----------+--------------+-------------
item_id         | integer                  |           | not null |         | plain    |              |
tdata_timestamp | timestamp with time zone |           | not null |         | plain    |              |
tdata_value     | text                     |           |          |         | extended |              |
Indexes:
    "tdata_sc_default_pkey" PRIMARY KEY, btree (item_id, tdata_timestamp)
    "tdata_sc_default_tdata_timestamp_idx" btree (tdata_timestamp DESC)


Hmm, so what could be the problem?

Thanks

Hello,

looks like I've got the next problem.
In the event log of the server I find the following entries:

Database query failed (Query: SELECT drop_chunks(to_timestamp(1628553600), 'tdata_sc_default'); Error: TS001 ERROR:  "tdata_sc_default" is not a hypertable or a continuous aggregate view
HINT:  It is only possible to drop chunks from a hypertable or continuous aggregate view)

I use, at least I thought I did, a TimescaleDB. During initialisation, it was also specified as such, and Timescale is also displayed as an extension in the database.

In timescaledb_information.hypertable, however, no tables are displayed, are these not used by Netxms?
If not, how can the old (or all) data be removed, the DB is currently over 500GB in size.

Thanks in advance

Andy

Hello and thank you for the reply.

Too bad, I was hoping to be able to use the whole thing without zoning.
Then I'll have to activate it and use it for this particular case.

Andy

Hello,
is it possible to have the query executed by another node?
Our server has no connection to the internet, but there is an agent which has the corresponding permissions.

I would like to query the web services from this agent, but I cannot find a suitable configuration.
"Poller Node" and/or "Source Node" do not seem to work here, we are not using zoning.

Checks via nxwsget are working as expected.

Thanks
Andy

Okay,

unfortunately, the server can no longer be started, even with default values.
Even when I load a dump on the test server and try it there, the server stops after a few minutes.

Is there a possibility to get support for this? We had planned to buy support for next year, maybe we can buy it earlier.

Thanks

Hello,

today the server crashed again for no apparent reason. The only explanation would be that a vMotion took place in ESX 30 minutes before.

Could this be the problem?

Thanks

Hi Victor,

I just uploaded an actual core-dump, name is "core_20210523".

Thanks

Hello everybody,

I have now tried several times to tune the server, but I can't get any further.
After some time, the service stops and restarts, so a practical use is not possible.

I now have a few core files, should I upload them?

Thanks

Hello,

is there anything new on this? I am also very interested in such a function.

Or is there another way to assign the appropriate rights?

Andi

Thanks Victor,

I will test the suggested values.

In fact, we have some adjustements in Hook::ConfigurationPoll. We set the interface expected state there depending on the name and CDP/LLDP. Is this a problem?

We also have a core network with large routing tables, but these are already deactivated. But it would be nice to be able to use them.

Core dump is not active yet, but I will switch it on. I can also try running the service with dbg to debug the crash.


Many thanks once again
Andi

Hello,

unfortunately, it took some time until I could deal with the topic again.
The memory usage looks OK to me, how do you recognise a slow database? At least I don't see anything in the associated logs.

Attached are a few graphics, on 11 March at 18:00 I started the server with tuned values. During the night the service stops several times, but is restarted by corosync. In the morning of 12 March, I restore the default values.

Are there any values that I should look at more closely? Or which I should monitor before the next tuning attempt? Unfortunately, the tuning topic is described somewhat briefly in the documentation, and the designations no longer seem to be correct.

Andi

Hello,

I have a problem with the correct tuning of the server.

We use version 3.8.193 of the netxms-server, database is postgresql 11.11 with timescaledb.
The whole thing is set up as a cluster (2 nodes), as described here in the forum (pacemaker, corosync), under ESX.
Each VM has 8 CPUs and 16 GB RAM, storage (flash) is connected via SAN, the network has 10 Gbit.

Without (or moderate) tuning, the CPU-load is approx. 1,6.
However, the threads, mostly POLLERS, are completely overloaded:


POLLERS
   Threads.............. 500 (250/500)
   Load average......... 4006.09 4004.16 4002.81
   Current load......... 801%
   Usage................ 100%
   Active requests...... 4005
   Scheduled requests... 0
   Total requests....... 2991207
   Thread starts........ 250
   Thread stops......... 0
   Average wait time.... 13489521 ms


If I adjust the configuration, e.g. ThreadPool.Poller.MaxSize = 4000 and so on, the load is significantly reduced.
However, after some time (minutes, hours, days) the CPU-load increases to 300 or more and the service is terminated, systemctl says netxms-server aborted.

Here the stats:

Objects............: 39878
Monitored nodes....: 4050
Collectible DCIs...: 26354
Active alarms......: 970
Uptime.............: 27 days,  4:16:28


Approx. 1100 of these are network devices that are queried via SNMP. To reduce the load, the topology query is deactivated for these.
700 are server (with agent), the rest of the devices, with a few exceptions, are monitored via PING.

The network devices are polled via proxy, other devices are connected directly to the server.

I have returned to a working configuration (with slow pollers and data collection), but would like to know how I can optimise the system.
Unfortunately I don't have any logs from the last crash, is there any other information that helps to solve the problem?

I would appreciate any tips on how to make the system more reliable.

Andi

Hmm,

still no progress despite further investigations.

Executing the external action, this time without additional parameters, via nxaction works on Linux and Windows.
Action executed via EPP does not work on Linux and Windows, there are missing around 220 lines in the log of the agent.

So, is this a bug or am i calling the action wrong as stated above?

Andreas