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 1.2.14 released

NetXMS 1.2.14 released

Scheduled Pinned Locked Moved Announcements
20 Posts 9 Posters 77.3k 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.
  • A
    A
    andrey--k
    wrote on last edited by
    #11

    I have upgrade error 😞

    Debian 7
    Oracle db

    nxdbmgr upgrade
    NetXMS Database Manager Version 1.2.14 Build 7874

    Upgrading database...
    Upgrading from version 308 to 309
    Upgrading from version 309 to 310
    Upgrading from version 310 to 311
    Upgrading from version 311 to 312
    Upgrading from version 312 to 313
    SQL query failed (ORA-01407: cannot update ("NETXMS"."OBJECT_TOOLS"."CONFIRMATION_TEXT") to NULL):
    UPDATE object_tools SET confirmation_text='' WHERE to_char(confirmation_text)='#00'
    Rolling back last stage due to upgrade errors...
    Database upgrade failed

    From sqldeveloper:

    UPDATE object_tools SET confirmation_text='' WHERE to_char(confirmation_text)='#00';

    2 rows updated.
    Error starting at line : 1 in command -
    UPDATE object_tools SET confirmation_text='' WHERE to_char(confirmation_text)='#00'
    Error report -
    SQL Error: ORA-01407: cannot update ("NETXMS"."OBJECT_TOOLS"."CONFIRMATION_TEXT") to NULL
    01407. 00000 -  "cannot update (%s) to NULL"
    *Cause:   
    *Action:

    I found that all field created with not null constraint

    CREATE TABLE "NETXMS"."OBJECT_TOOLS"
   (	"TOOL_ID" NUMBER(*,0) NOT NULL ENABLE,
	"TOOL_NAME" VARCHAR2(255 BYTE) NOT NULL ENABLE,
	"TOOL_TYPE" NUMBER(*,0) NOT NULL ENABLE,
	"TOOL_DATA" CLOB NOT NULL ENABLE,
	"DESCRIPTION" VARCHAR2(255 BYTE) NOT NULL ENABLE,
	"FLAGS" NUMBER(*,0) NOT NULL ENABLE,
	"MATCHING_OID" VARCHAR2(255 BYTE) NOT NULL ENABLE,
	"CONFIRMATION_TEXT" VARCHAR2(255 BYTE) NOT NULL ENABLE,
	 PRIMARY KEY ("TOOL_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE
   )

    I have disabled constraint.

    ~$ nxdbmgr upgrade
NetXMS Database Manager Version 1.2.14 Build 7874

Upgrading database...
Upgrading from version 312 to 313
Upgrading from version 313 to 314
Upgrading from version 314 to 315
Upgrading from version 315 to 316
Upgrading from version 316 to 317
Upgrading from version 317 to 318
Database upgrade succeeded

    Can it couse any errors?

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

      Hi!

      As a workaround, run the following queries before DB upgrade:

      ALTER TABLE object_tools MODIFY tool_data null;
      ALTER TABLE object_tools MODIFY description null;
      ALTER TABLE object_tools MODIFY confirmation_text null;
      ALTER TABLE object_tools MODIFY matching_oid null;
      ALTER TABLE object_tools_table_columns MODIFY col_name null;

      Best regards,
      Victor

      1 Reply Last reply
      0
      • D
        D
        DCEV
        wrote on last edited by
        #13

        Hello! I'm new to NetXMS and to SNMP monitoring in general.
        We have some D-Link access points and I realized the D-Link driver comes in the Linux package, but not in Windows flavor (not any dlink.ndd in /lib/ndd). I tried to copy it in a slapdash way, of course it didn't work 😛
        Any reason for this?

        Thanks!!

        1 Reply Last reply
        0
        • A
          A
          andrey--k
          wrote on last edited by
          #14

          Oracle 11.
          Debian 7.
          Database errors.

          (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?) ORA-12899: value too large for column "NETXMS"."EVENT_LOG"."USER_TAG" (actual: 70, maximum: 63)
(event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?) ORA-12899: value too large for column "NETXMS"."EVENT_LOG"."USER_TAG" (actual: 67, maximum: 63)
(event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?) ORA-12899: value too large for column "NETXMS"."EVENT_LOG"."USER_TAG" (actual: 73, maximum: 63)

          I have already expand in my DB to 128. Please add fix to upstream.
          Thanks.

          1 Reply Last reply
          0
          • B
            B
            Borgso
            wrote on last edited by
            #15

            Hi, upgraded from 1.2.13 to 1.2.14 today and server crashes after start.

            Installed and upgraded via .deb packages.

            $ nxdbmgr upgrade
            NetXMS Database Manager Version 1.2.14 Build 7876

            Upgrading database...
            Your database format is up to date

            (gdb) run -c /etc/netxmsd.conf -D0
            Starting program: /usr/bin/netxmsd -c /etc/netxmsd.conf -D0
            [Thread debugging using libthread_db enabled]
            Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
            Using configuration file "/etc/netxmsd.conf"
            [02-Jun-2014 09:40:01.869] [INFO ] Platform subagent "/usr/lib/netxms/linux.nsm" successfully loaded
            [02-Jun-2014 09:40:01.921] [INFO ] Database driver "pgsql.ddr" loaded and initialized successfully
            [New Thread 0x7ffff7f71700 (LWP 5494)]
            [02-Jun-2014 09:40:02.020] [INFO ] Stalled database lock removed
            [New Thread 0x7ffff04c0700 (LWP 5495)]
            [New Thread 0x7ffff03bf700 (LWP 5496)]
            [02-Jun-2014 09:40:02.068] [INFO ] Network device driver "ERS8000" loaded successfully
            [02-Jun-2014 09:40:02.073] [INFO ] Network device driver "SYMBOL-WS" loaded successfully
            [02-Jun-2014 09:40:02.079] [INFO ] Network device driver "DLINK" loaded successfully
            [02-Jun-2014 09:40:02.084] [INFO ] Network device driver "CISCO-SB" loaded successfully
            [02-Jun-2014 09:40:02.089] [INFO ] Network device driver "BAYSTACK" loaded successfully
            [02-Jun-2014 09:40:02.095] [INFO ] Network device driver "NETSCREEN" loaded successfully
            [02-Jun-2014 09:40:02.101] [INFO ] Network device driver "UBNT" loaded successfully
            [02-Jun-2014 09:40:02.108] [INFO ] Network device driver "CATALYST-GENERIC" loaded successfully
            [02-Jun-2014 09:40:02.114] [INFO ] Network device driver "DELL-PWC" loaded successfully
            [02-Jun-2014 09:40:02.119] [INFO ] Network device driver "PROCURVE" loaded successfully
            [02-Jun-2014 09:40:02.125] [INFO ] Network device driver "CISCO-ESW" loaded successfully
            [02-Jun-2014 09:40:02.131] [INFO ] Network device driver "MIKROTIK" loaded successfully
            [02-Jun-2014 09:40:02.137] [INFO ] Network device driver "NTWS" loaded successfully
            [02-Jun-2014 09:40:02.143] [INFO ] Network device driver "AIRESPACE" loaded successfully
            [02-Jun-2014 09:40:02.151] [INFO ] Network device driver "PING3" loaded successfully
            [02-Jun-2014 09:40:02.156] [INFO ] Network device driver "CATALYST-2900XL" loaded successfully
            [02-Jun-2014 09:40:02.164] [INFO ] Network device driver "AT" loaded successfully
            [New Thread 0x7fffedc86700 (LWP 5497)]
            [New Thread 0x7fffedb85700 (LWP 5498)]
            [Thread 0x7fffedb85700 (LWP 5498) exited]
            *** Error in `/usr/bin/netxmsd': double free or corruption (fasttop): 0x0000000000abaf00 ***

            Program received signal SIGABRT, Aborted.
            0x00007ffff4a4cf79 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
            56      ../nptl/sysdeps/unix/sysv/linux/raise.c: No such file or directory.
            (gdb) bt
            #0  0x00007ffff4a4cf79 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
            #1  0x00007ffff4a50388 in __GI_abort () at abort.c:89
            #2  0x00007ffff4a8a1d4 in __libc_message (do_abort=do_abort@entry=1, fmt=fmt@entry=0x7ffff4b98a10 "*** Error in `%s': %s: 0x%s ***\n") at ../sysdeps/posix/libc_fatal.c:175
            #3  0x00007ffff4a964ae in malloc_printerr (ptr=<optimized out>, str=0x7ffff4b98bd8 "double free or corruption (fasttop)", action=1) at malloc.c:4996
            #4  _int_free (av=<optimized out>, p=<optimized out>, have_lock=0) at malloc.c:3840
            #5  0x00007ffff73a4556 in yyparse (scanner=0xab6e00, pLexer=0xab4b10, pCompiler=pCompiler@entry=0x7fffffff7350, pScript=pScript@entry=0xaa8140) at parser.tab.cpp:3547
            #6  0x00007ffff73a788e in NXSL_Compiler::compile (this=this@entry=0x7fffffff7350, pszSourceCode=pszSourceCode@entry=0xaa7fd0 L"sub main() {\r\n  return ($node->isAgent &&\r\n          $node->agentVersion ~= \"^1.2.6$\";\r\n}")
                at compiler.cpp:87
            #7  0x00007ffff73aa9af in NXSLCompile (pszSource=0xaa7fd0 L"sub main() {\r\n  return ($node->isAgent &&\r\n          $node->agentVersion ~= \"^1.2.6$\";\r\n}", pszError=pszError@entry=0x7fffffff77e0 L"\xf4a87aa0ç¿¿\001",
                nBufSize=nBufSize@entry=256) at main.cpp:45
            #8  0x00007ffff73aaa4e in NXSLCompileAndCreateVM (pszSource=<optimized out>, pszError=0x7fffffff77e0 L"\xf4a87aa0ç¿¿\001", nBufSize=256, env=0x998640) at main.cpp:59
            #9  0x00007ffff7af4fa5 in Template::CreateFromDB (this=0xaa64d0, dwId=<optimized out>) at template.cpp:201
            #10 0x00007ffff7ac2a9e in LoadObjects () at objects.cpp:1376
            #11 0x00007ffff7a9a3fe in Initialize () at main.cpp:754
            #12 0x0000000000401285 in main (argc=<optimized out>, argv=<optimized out>) at netxmsd.cpp:482
            (gdb)

            Logfile:

            [02-Jun-2014 09:34:56.689] Log file opened
            [02-Jun-2014 09:34:56.689] [DEBUG] Code page set to ASCII
            [02-Jun-2014 09:34:56.690] [INFO ] Platform subagent "/usr/lib/netxms/linux.nsm" successfully loaded
            [02-Jun-2014 09:34:56.691] [DEBUG] Debug callback set for DB library
            [02-Jun-2014 09:34:56.706] [INFO ] Database driver "pgsql.ddr" loaded and initialized successfully
            [02-Jun-2014 09:34:56.735] [DEBUG] New DB connection opened: handle=0xe5e110
            [02-Jun-2014 09:34:56.735] [DEBUG] Successfully connected to database netxms@localhost
            [02-Jun-2014 09:34:56.773] [DEBUG] New DB connection opened: handle=0xe5bbc0
            [02-Jun-2014 09:34:56.795] [DEBUG] New DB connection opened: handle=0xe86c40
            [02-Jun-2014 09:34:56.818] [DEBUG] New DB connection opened: handle=0xe7c980
            [02-Jun-2014 09:34:56.845] [DEBUG] New DB connection opened: handle=0xe7c110
            [02-Jun-2014 09:34:56.868] [DEBUG] New DB connection opened: handle=0xec3940
            [02-Jun-2014 09:34:56.868] [DEBUG] Database Connection Pool initialized
            [02-Jun-2014 09:34:56.868] [DEBUG] Database Connection Pool maintenance thread started
            [02-Jun-2014 09:34:56.877] [INFO ] Stalled database lock removed
            [02-Jun-2014 09:34:56.890] [DEBUG] Data directory set to /usr/share/netxms from server configuration variable
            [02-Jun-2014 09:34:56.894] [DEBUG] CAS config reloaded
            [02-Jun-2014 09:34:56.894] [DEBUG] Global configuration loaded
            [02-Jun-2014 09:34:56.895] [DEBUG] Validating ciphers
            [02-Jun-2014 09:34:56.895] [DEBUG]    AES-256 enabled
            [02-Jun-2014 09:34:56.895] [DEBUG]    Blowfish-256 enabled
            [02-Jun-2014 09:34:56.895] [DEBUG]    IDEA disabled (config)
            [02-Jun-2014 09:34:56.895] [DEBUG]    3DES enabled
            [02-Jun-2014 09:34:56.895] [DEBUG]    AES-128 enabled
            [02-Jun-2014 09:34:56.895] [DEBUG]    Blowfish-128 enabled
            [02-Jun-2014 09:34:56.895] [DEBUG] Crypto library initialized
            [02-Jun-2014 09:34:56.915] [DEBUG] ID table created
            [02-Jun-2014 09:34:56.916] [DEBUG] Script Filter::SNMP added to library
            [02-Jun-2014 09:34:56.916] [DEBUG] Script Filter::Agent added to library
            [02-Jun-2014 09:34:56.916] [DEBUG] Script Filter::AgentOrSNMP added to library
            [02-Jun-2014 09:34:56.916] [DEBUG] Script DCI::SampleTransform added to library
            [02-Jun-2014 09:34:56.917] [DEBUG] Script Filter::QFAgent added to library
            [02-Jun-2014 09:34:56.917] [DEBUG] Script InfraOrganizer2 added to library
            [02-Jun-2014 09:34:56.917] [DEBUG] Script InfraOrganizer added to library
            [02-Jun-2014 09:34:56.917] [DEBUG] SMTP mailer thread started
            [02-Jun-2014 09:34:56.918] [DEBUG] User account status update thread started
            [02-Jun-2014 09:34:56.921] [DEBUG] User accounts loaded
            [02-Jun-2014 09:34:56.922] [DEBUG] Loading network device drivers from /usr/lib/netxms/ndd
            [02-Jun-2014 09:34:56.922] [INFO ] Network device driver "ERS8000" loaded successfully
            [02-Jun-2014 09:34:56.922] [INFO ] Network device driver "SYMBOL-WS" loaded successfully
            [02-Jun-2014 09:34:56.922] [INFO ] Network device driver "DLINK" loaded successfully
            [02-Jun-2014 09:34:56.923] [INFO ] Network device driver "CISCO-SB" loaded successfully
            [02-Jun-2014 09:34:56.923] [INFO ] Network device driver "BAYSTACK" loaded successfully
            [02-Jun-2014 09:34:56.923] [INFO ] Network device driver "NETSCREEN" loaded successfully
            [02-Jun-2014 09:34:56.923] [INFO ] Network device driver "UBNT" loaded successfully
            [02-Jun-2014 09:34:56.923] [INFO ] Network device driver "CATALYST-GENERIC" loaded successfully
            [02-Jun-2014 09:34:56.924] [INFO ] Network device driver "DELL-PWC" loaded successfully
            [02-Jun-2014 09:34:56.924] [INFO ] Network device driver "PROCURVE" loaded successfully
            [02-Jun-2014 09:34:56.924] [INFO ] Network device driver "CISCO-ESW" loaded successfully
            [02-Jun-2014 09:34:56.924] [INFO ] Network device driver "MIKROTIK" loaded successfully
            [02-Jun-2014 09:34:56.925] [INFO ] Network device driver "NTWS" loaded successfully
            [02-Jun-2014 09:34:56.925] [INFO ] Network device driver "AIRESPACE" loaded successfully
            [02-Jun-2014 09:34:56.925] [INFO ] Network device driver "PING3" loaded successfully
            [02-Jun-2014 09:34:56.925] [INFO ] Network device driver "CATALYST-2900XL" loaded successfully
            [02-Jun-2014 09:34:56.926] [INFO ] Network device driver "AT" loaded successfully
            [02-Jun-2014 09:34:56.926] [DEBUG] 17 network device drivers loaded
            [02-Jun-2014 09:34:56.929] [DEBUG] Built-in objects created
            [02-Jun-2014 09:34:56.929] [DEBUG] Loading container categories...
            [02-Jun-2014 09:34:56.929] [DEBUG] Loading built-in object properties...
            [02-Jun-2014 09:34:56.931] [DEBUG] Apply template thread started
            [02-Jun-2014 09:34:56.936] [DEBUG] NetObj::loadCommonProperties() failed for object Policies [5] class=16
            [02-Jun-2014 09:34:56.937] [DEBUG] NetObj::loadCommonProperties() failed for object Network Maps [6] class=19
            [02-Jun-2014 09:34:56.943] [DEBUG] Loading conditions...
            [02-Jun-2014 09:34:56.946] [DEBUG] Loading subnets...
            [02-Jun-2014 09:34:56.984] [DEBUG] Loading mobile devices...
            [02-Jun-2014 09:34:56.985] [DEBUG] Loading nodes...
            [02-Jun-2014 09:34:59.499] [DEBUG] Loading access points...
            [02-Jun-2014 09:34:59.500] [DEBUG] Loading interfaces...
            [02-Jun-2014 09:34:59.912] [DEBUG] WARNING: duplicate interface IP address 0A7807F8 (interface object IP Interface [1048])
            [02-Jun-2014 09:35:00.317] [DEBUG] Loading network services...
            [02-Jun-2014 09:35:00.319] [DEBUG] Loading VPN connectors...
            [02-Jun-2014 09:35:00.327] [DEBUG] Loading clusters...
            [02-Jun-2014 09:35:00.327] [DEBUG] Loading templates...
            [02-Jun-2014 09:35:00.328] [DEBUG] Started caching of DCI values
            [02-Jun-2014 09:35:00.339] [DEBUG] Finished caching of DCI values

            1 Reply Last reply
            0
            • A
              A
              andrey--k
              wrote on last edited by
              #16

              После удаления нод в таблице DC_TABLES остаются записи, содержащие идентификаторы удаленных объектов.
              Это нормальное поведение?

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

                Нет, не нормально. Я проверю и исправлю.

                1 Reply Last reply
                0
                • M
                  M
                  millerpaint
                  wrote on last edited by
                  #18

                  Greetings,

                  I am way behind on versions, now running v1.2.6.

                  Is it possible to upgrade directly to this latest v1.2.14 from v1.2.6 ?

                  -Kevin C.

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

                    Hi!

                    Yes, it's possible to upgrade directly to 1.2.14.

                    Best regards,
                    Victor

                    1 Reply Last reply
                    0
                    • Iliyan VutovV
                      Iliyan VutovV
                      Iliyan Vutov
                      wrote on last edited by
                      #20

                      Hi,

                      I've upgraded to version 1.2.14 and since then the netxmsd daemon uses above 100% CPU resources (more than 1 core). There are no crashes, though, just high load. Attached some debug information. I hope it be useful to debug the problem.

                      Regards,
                      Iliyan

                      netxmsd.tar.bz

                      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