Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor
  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum
  1. Home
  2. Announcements
  3. NetXMS 2.0-RC2 released

NetXMS 2.0-RC2 released

Scheduled Pinned Locked Moved Announcements
28 Posts 10 Posters 48.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Dani@M3TU
    Dani@M3TU
    Dani@M3T
    wrote on last edited by
    #4

    On the download page the Generic Linux static version for x64 is missing.

    1 Reply Last reply
    0
    • Dani@M3TU
      Dani@M3TU
      Dani@M3T
      wrote on last edited by
      #5

      After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

      [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.

      Server is Linux x64 build from sources.

      I have to stop the agent. Maybe revert to RC1. Or is there a quick fix?

      best regards
      Dani

      Edit:
      Once we get this error in server log:

      [17-Oct-2015 12:32:03.639] [ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "alarm_events_pkey"
DETAIL:  Key (alarm_id, event_id)=(9342, 5208076) already exists.
      1 Reply Last reply
      0
      • V
        V
        Victor Kirhenshtein
        wrote on last edited by
        #6

        @user54119 said in NetXMS 2.0-RC2 released:

        After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

        [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

        1 Reply Last reply
        0
        • V
          V
          Victor Kirhenshtein
          wrote on last edited by
          #7

          @user54119 said in NetXMS 2.0-RC2 released:

          On the download page the Generic Linux static version for x64 is missing.

          Fixed.

          Best regards,
          Victor

          1 Reply Last reply
          0
          • M
            M
            multix
            wrote on last edited by
            #8

            @victor said in NetXMS 2.0-RC2 released:

            @user54119 said in NetXMS 2.0-RC2 released:

            After update from V2.0RC1 to V2.0RC2 we get thousands of this errors in the nxagentd-log on the NetXMS server:

            [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.

            1 Reply Last reply
            0
            • Dani@M3TU
              Dani@M3TU
              Dani@M3T
              wrote on last edited by
              #9

              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

              1 Reply Last reply
              0
              • M
                M
                multix
                wrote on last edited by
                #10

                @user54119 said in NetXMS 2.0-RC2 released:

                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

                1 Reply Last reply
                0
                • Y
                  Y
                  yordi
                  wrote on last edited by
                  #11

                  could not find NetXMS 2.0-RC2  with apt-get update  / upgrade ..

                  1 Reply Last reply
                  0
                  • M
                    M
                    multix
                    wrote on last edited by
                    #12

                    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.

                    1 Reply Last reply
                    0
                    • V
                      V
                      Victor Kirhenshtein
                      wrote on last edited by
                      #13

                      Try to turn off data collection cache for that agent (node properties, "Polling" page, select cache mode "Off"). You'll me be needed to delete nxagent.db again after switching off cache. I'll try to reproduce this issue on my system.

                      Best regards,
                      Victor

                      1 Reply Last reply
                      0
                      • Dani@M3TU
                        Dani@M3TU
                        Dani@M3T
                        wrote on last edited by
                        #14

                        Ok, I started the server, turned off the cache mode for the agent on the NetXMS server.
                        Than I deleted nxagent.db and started the agent. All the DCIs on other nodes where the NetXMS server is the source node (on these DCIs there is still cache enabled because of this thread: https://www.netxms.org/forum/general-support/best-practice-to-analyse-event-'sys_thread_hang') get no values.

                        So i rebooted the server once. After that I got again 500 false alerts.

                        I have to shutdown the server again.

                        edit:
                        I only disabled the agent on the server and started the server again (I had to disable my EPP rule which automaticaly restarts the agent when crashed)

                        thanks
                        Dani

                        1 Reply Last reply
                        0
                        • A
                          A
                          Alex Kirhenshtein
                          wrote on last edited by
                          #15

                          Hello

                          Check now, it should be avaiable

                          @mkemerci said in NetXMS 2.0-RC2 released:

                          Hi.
                          Thanks for new version.

                          I can't download management console for mac.

                          1 Reply Last reply
                          0
                          • A
                            A
                            Alex Kirhenshtein
                            wrote on last edited by
                            #16

                            Can you please share nxagent.db from affected system?

                            1 Reply Last reply
                            0
                            • Dani@M3TU
                              Dani@M3TU
                              Dani@M3T
                              wrote on last edited by
                              #17

                              see attached file from the agent on the NetXMS server itself:

                              nxagentd.db

                              1 Reply Last reply
                              0
                              • A
                                A
                                Alex Kirhenshtein
                                wrote on last edited by
                                #18

                                Thank you, we found the bug. Patch will be available shortly.

                                1 Reply Last reply
                                0
                                • V
                                  V
                                  Victor Kirhenshtein
                                  wrote on last edited by
                                  #19

                                  For those who build from sources - replace src/server/core/node.cpp with attached one and re-compile server. Problem should go away. Repacked sources and binaries will be available shortly as well.

                                  Best regards,
                                  Victor

                                  node.cpp

                                  1 Reply Last reply
                                  0
                                  • Dani@M3TU
                                    Dani@M3TU
                                    Dani@M3T
                                    wrote on last edited by
                                    #20

                                    I was out of office for a few hours.
                                    But now I recompiled the server with your patched file. I also revert the agent on the NetXMS server itself back to cache mode = default. Then I rebooted the NetXMS server. The problem is here again. So I stopped the agent and deleted nxagentd.db again and started the agent again.
                                    Now It's quite 😉
                                    Than I rebooted the server again for testing. At the moment I see the problem no more.
                                    But to be sure I have to check again tomorrow.

                                    Thanks Victor and Alex

                                    Dani

                                    1 Reply Last reply
                                    0
                                    • Dani@M3TU
                                      Dani@M3TU
                                      Dani@M3T
                                      wrote on last edited by
                                      #21

                                      I can confirm, problem is fixed with the patched 'node.cpp'.

                                      thanks!
                                      Dani

                                      1 Reply Last reply
                                      0
                                      • I
                                        I
                                        iGodunoff
                                        wrote on last edited by
                                        #22

                                        Just installed NetXMS 2.0 RC2 (previous version was 2.0-M5 that worked fine). The installation process goes and finishes normally. However I can't start the NetXMS Core service. In Windows logs (System) I receive the following error message from NetXMSCore: "Your database has format version 356, but server is compiled for version 374". What does it mean and how can I get NetXMS server working?

                                        P. S. Database server is MySQL 5.6.27 (GPL).

                                        1 Reply Last reply
                                        0
                                        • U
                                          U
                                          Andreas@rc
                                          wrote on last edited by
                                          #23

                                          @igodunoff said in NetXMS 2.0-RC2 released:

                                          Just installed NetXMS 2.0 RC2 (previous version was 2.0-M5 that worked fine). The installation process goes and finishes normally. However I can't start the NetXMS Core service. In Windows logs (System) I receive the following error message from NetXMSCore: "Your database has format version 356, but server is compiled for version 374". What does it mean and how can I get NetXMS server working?

                                          P. S. Database server is MySQL 5.6.27 (GPL).

                                          Simply upgrade your database: https://wiki.netxms.org/wiki/Server_Installation_Guide

                                          1 Reply Last reply
                                          0

                                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                          With your input, this post could be even better 💗

                                          Register Login
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes

                                          • Login
                                          • Don't have an account? Register
                                          • Login or register to search.
                                          Powered by NodeBB Contributors
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups