News:

We really need your input in this questionnaire

Main Menu

Upgrade 31.0 to 31.1 failed

Started by Nem0, December 07, 2019, 09:51:46 AM

Previous topic - Next topic

Nem0

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?

Tatjana Dubrovica

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

#2
Quote from: Tatjana Dubrovica 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?

Ok. Today will be done

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