Author Topic: Upgrade 31.0 to 31.1 failed  (Read 384 times)

Nem0

  • Newbie
  • *
  • Posts: 4
    • View Profile
Upgrade 31.0 to 31.1 failed
« on: December 07, 2019, 09:51:46 am »
Today a try upgrade from ubuntu repo. Unfortunately get coredump

Code: [Select]
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?
« Last Edit: December 07, 2019, 10:04:09 am by Nem0 »

Tatjana Dubrovica

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 268
    • View Profile
Re: Upgrade 31.0 to 31.1 failed
« Reply #1 on: December 09, 2019, 01:41:04 pm »
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?

Nem0

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Upgrade 31.0 to 31.1 failed
« Reply #2 on: December 11, 2019, 08:33:55 am »
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
 
« Last Edit: December 11, 2019, 08:50:09 am by Nem0 »