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?
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?
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