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. Support
  3. Upgrade 31.0 to 31.1 failed

Upgrade 31.0 to 31.1 failed

Scheduled Pinned Locked Moved Support
3 Posts 2 Posters 21.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.
  • N
    N
    Nem0
    wrote on last edited by
    #1

    Today a try upgrade from ubuntu repo. Unfortunately get coredump

    nxdbmgr -t -X
    
    ---------
    NetXMS Database Manager Version 3.1.242 Build 3.1-242-g2c0fcdb3de (UNICODE)
    
    Upgrading database...
    Upgrading from version 31.0 to 31.1
    >>> CREATE TABLE rack_passive_elements (  id integer not null,  rack_id integer not null,  name varchar(255) not null,  type integer not null,  position integer not null,  orientation integer not null,  port_count integer not null,PRIMARY KEY(id))
    SQL query failed (Table 'rack_passive_elements' already exists):
    CREATE TABLE rack_passive_elements (  id integer not null,  rack_id integer not null,  name varchar(255) not null,  type integer not null,  position integer not null,  orientation integer not null,  port_count integer not null,PRIMARY KEY(id))
    >>> CREATE TABLE physical_links (  id integer not null,  description varchar(255) not null,  left_object_id integer not null,  left_patch_pannel_id integer not null,  left_port_number integer not null,  left_front char(1) not null,  right_object_id integer not null,  right_patch_pannel_id integer not null,  right_port_number integer not null,  right_front char(1) not null,PRIMARY KEY(id))
    SQL query failed (Table 'physical_links' already exists):
    CREATE TABLE physical_links (  id integer not null,  description varchar(255) not null,  left_object_id integer not null,  left_patch_pannel_id integer not null,  left_port_number integer not null,  left_front char(1) not null,  right_object_id integer not null,  right_patch_pannel_id integer not null,  right_port_number integer not null,  right_front char(1) not null,PRIMARY KEY(id))
    Segmentation fault (core dumped)
    

    After manually dropping tables and restarting script - nothing changed

    Ubuntu 16.04 + MariaDB 10.1

    Any suggestions?


    _usr_bin_nxdbmgr.0.crash

    1 Reply Last reply
    0
    • Z
      Z
      Tatjana Dubrovica
      wrote on last edited by
      #2

      Looks like debug symbols are not installed on your system so core dump does not contain information.
      Can you please install netxms-server-dbg and attach core dump again.

      Also can you please provide result of "SELECT id,passive_elements FROM racks" query in NetXMS database?

      1 Reply Last reply
      0
      • N
        N
        Nem0
        wrote on last edited by
        #3

        @zev said in Upgrade 31.0 to 31.1 failed:

        Looks like debug symbols are not installed on your system so core dump does not contain information.
        Can you please install netxms-server-dbg and attach core dump again.

        Also can you please provide result of "SELECT id,passive_elements FROM racks" query in NetXMS database?

        Ok. Today will be done

        UPD:
        After installing latest upgrades today ( to 3.1.261-2 ) - database upgrade work as expected.
        Thanks

        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