NetXMS Support Forum

Hi. Thanks for 2.0 version.

I installed server now. But I can't download management console for mac.

Can you update link please.

Thanks.

thank you

Hi.

Netxms server is working for 6 days and memory usage is growing. Netxms ram usage was about 1.5 g in first day, but now, it is about 24g. And Management console connection performance is very slower then first day.

Where must I look for this? I am using Netxms 2.0RC2, postgresql 9.3 and centos7 for server.

Thanks.

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.

I am trying to use sendxmpp for 2 months and having same problem. When this happens, my server's event processing queue is increasing. I searched for alternative to send xmpp messages, and saw sendxmpp for linux. I tested it and it is fast enough (I tried with netxms at 25 messages per second and sucsess.).

I set agent debug level to 9.
I am using this agent for 4-5 sql query. My log looks as below :
DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.793] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.794] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.795] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.795] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.796] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.797] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.798] [DEBUG] GetTableValue(): result is 0 (SUCCESS)
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.798] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] Requesting table "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: sleeping for 0 seconds
[18-Oct-2015 20:47:58.799] [DEBUG] DataCollector: polling DCI 38972 "DB.Query(INST2CHECK,"SELECT db_name(database_id) as database_name, mirroring_state_desc, mirroring_state FROM sys.database_mirroring WHERE mirroring_guid is not null ORDER BY database_name ASC")"



This is the part that I could place here. It is not stopping writing this error.
Perhaps it can help.

Quote from: Dani@M3T on October 18, 2015, 07:05:20 PM
Hi Victor

The download link is ok now, thanks for that.

After deleting the nxagent.db file and restart of server and agent, it's quite for a few seconds or minutes. After that the same goes on, 1000 of the same error messages in the agent log and 1000 up and down emails in a few minutes.
I have to stop the agent and server again. When I only stop the agent, the agent is autom. restarted after a while.

kind regards
Dani

I have the same symptoms.
My error log is :
[ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp

Quote from: Victor Kirhenshtein on October 17, 2015, 06:55:58 PM

Quote from: Dani@M3T on October 17, 2015, 01:21:52 PM
After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

Code Select Expand

[17-Oct-2015 12:18:14.018] [ERROR] SQL query failed (Query = "INSERT INTO dc_queue (server_id,dci_id,dci_type,dci_origin,snmp_target_guid,timestamp,value) VALUES (?,?,?,?,?,?,?)"): UNIQUE constraint failed: dc_queue.server_id, dc_queue.dci_id, dc_queue.timestamp

So we also get thousands of false alarms (and emails) per minute.

Try to stop the agent, delete nxagent.db file (likely in /var/lib/netxms or <install prefix>/var/lib/netxms), and start agent again.

Best regards,
Victor

I did as you say. And alarms gone for a short time. Then, there they are. I restarted my server and nxagent again, if it occurs again, I will inform.

Thanks.


After I restarted both server and agent, everything is ok.

Hi.
Thanks for new version.

I can't download management console for mac.

Hi,
as I told above, I added 600 new servers to my netxms server. When I saw I could not use netxms, I deleted them

I will ad them and apply templates to them. And then, I will do as you said.

If I could find a solution, I will inform.
thanks.

Hi. I am using 2.0-rc1 in cents 7 with postgresql

my stats is :
Total number of objects :34087
Number of monitored nodes : 2448
Number of Collectable DCIs : 28725

my queue is :
Data Collector                            :0
DCI cache loader                        :0
Database Writer                          :0
Database writer (IDATA)              :0
Database writer (raw DCI values) : 0
Event processor                           :86236
Node poller                                  : 0
Syslog processing                         : 0
Syslog writer                                :0


Event processing is too slow, so everything is being wrong.

before 4-5 days ago, I added 600 servers as node. I am not polling any DCI .
I am looking for only if they are up or down (status)

I set debug and there is no error in debug.

Does anybody has idea about my slow event processing problem ?

Hi.

I had a look to forum and find this link :
https://www.netxms.org/forum/configuration/notification-about-event-only-during-defined-period-of-time/

Does this topic answer of your question?

you should say yes to this question.
Or you can use
nxdbmgr check -f
command line.

there is not any special folder to run nxdbmgr.  if the netxms installation folder is in path, then you can run this command from any folder. Otherwise, you must specify the nxdbmgr folder in command.

If I did not misunderstand, you are trying to run nxdbmgr in sqlcmd (saw in topic). Can you try to run nxdbmgr in command prompt (neither sqlcmd nor powershell.)