Upgrade errors during fresh install of Tactic (CentOS7)

3 posts / 0 new
Last post
gin
Upgrade errors during fresh install of Tactic (CentOS7)

I'm installing Tactic Enterprise 4.5.v01 on a fresh install of Cent OS 7 minimal and am following the CentOS 6.2 intructions in the Docs as closely as I can.

Everything seemed to be going okay up until the point where I was installing Tactic with the command "python /tmp/TACTIC-4.5.0.v01/src/install/install.py", whereupon a whole bunch of errors spewed out as below. There seem to be a whole lot of errors wrt the database, and there's even an upgrade alert, which is odd because fresh install. Just to check if I did anything wrong, I formatted the whole system and started again with the exact same results.

==================

Please enter the user Apache Web Server is run under:

(apache) ->

Copying files to the install directory... It may take several minutes.

Creating a symlink at [/opt/tactic/tactic]...

Verifying Python modules are properly installed...

Creating TACTIC temp directories:  /opt/tactic/tactic_temp
Changing directory ownership of temp and data directories
Creating database 'sthpw' ...

no output, assumed success
Importing sql to database [sthpw]...
   using path [/opt/tactic/tactic/src/pyasm/search/upgrade/postgresql/bootstrap_schema.sql]
Importing sql to database [sthpw]...
   using path [/opt/tactic/tactic/src/pyasm/search/upgrade/postgresql/config_schema.sql]
Importing sql to database [sthpw]...
   using path [/opt/tactic/tactic/src/pyasm/search/upgrade/postgresql/sthpw_schema.sql]
Upgrading the database schema in quiet mode...

/opt/tactic/tactic/src/pyasm/search/upgrade/upgrade_db.py:34: SyntaxWarning: import * only allowed at module level
  def execute(my):
/opt/tactic/tactic/src/pyasm/search/upgrade/project/sthpw_upgrade.py:60: SyntaxWarning: import * only allowed at module level
  def upgrade_v4_5_0_a01_008(my):
Error with query (ProgrammingError):  sthpw
        ALTER TABLE pipeline DROP CONSTRAINT project_code_foreign;

constraint "project_code_foreign" of relation "pipeline" does not exist

Error:  constraint "project_code_foreign" of relation "pipeline" does not exist

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/url) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/prod_setting) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/client_trigger) already exists.

Error:  duplicate key value violates unique constraint "pref_list_key_idx"
DETAIL:  Key (key)=(quick_text) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/plugin) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/trigger) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/process) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(sthpw/work_hour) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(config/pipeline) already exists.

Error with query (ProgrammingError):  sthpw
        ALTER TABLE "wdg_settings" DROP constraint "wdg_settings_login_fkey";

constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist

Error:  constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist

Error with query (ProgrammingError):  sthpw
        ALTER TABLE "wdg_settings" DROP constraint "wdg_settings_project_code_fkey";

constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist

Error:  constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist

Error with query (ProgrammingError):  sthpw
        ALTER TABLE wdg_settings drop constraint wdg_settings_login_fkey CASCADE;

constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist

Error:  constraint "wdg_settings_login_fkey" of relation "wdg_settings" does not exist

Error with query (ProgrammingError):  sthpw
        ALTER TABLE wdg_settings drop constraint wdg_settings_project_code_fkey CASCADE;

constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist

Error:  constraint "wdg_settings_project_code_fkey" of relation "wdg_settings" does not exist

Error with query (ProgrammingError):  sthpw
        ALTER TABLE pref_setting drop constraint pref_setting_login_fkey CASCADE;

constraint "pref_setting_login_fkey" of relation "pref_setting" does not exist

Error:  constraint "pref_setting_login_fkey" of relation "pref_setting" does not exist

Error with query (ProgrammingError):  sthpw
        alter table task drop constraint "pipeline_code_foreign";

constraint "pipeline_code_foreign" of relation "task" does not exist

Error:  constraint "pipeline_code_foreign" of relation "task" does not exist

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(sthpw/sobject_list) already exists.

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(sthpw/db_resource) already exists.

Error with query (ProgrammingError):  sthpw
        alter table task drop constraint "pipeline_code_foreign";

constraint "pipeline_code_foreign" of relation "task" does not exist

Error:  constraint "pipeline_code_foreign" of relation "task" does not exist

Error:  duplicate key value violates unique constraint "search_object_search_type_idx"
DETAIL:  Key (search_type)=(prod/session_contents) already exists.

Error:  duplicate key value violates unique constraint "search_object_code_idx"
DETAIL:  Key (code)=(prod/session_contents) already exists.

 

IMPORTANT NOTICE:

        You are upgrading from an earlier version to 4.0.  TACTIC version 4.0 has made some important changes, particularly in the way that some tables are related to each other.  Previously, TACTIC would relate such items as snapshots, tasks and notes by the column "search_id".  In 4.0, this has been changed to "search_code".  The "search_id" will still exists, but wil not be used to relate tables.

        In order to upgrade, TACTIC needs to fill in the "search_code" column of various tables.  This is a heavy process if you have a lot of data.  It is a non-destructive script and will only add data.  It will not change any current existing data.  You may wish to run this separately if you have large projects with lots of data.

        You can run this script now or you can run it manually by:

        python <TACTIC_INSTALL_DIR>/src/bin/fixes/fix_search_code.py

 

Run now? (y/n):y
Running ...

cmd:  /usr/bin/python "/opt/tactic/tactic/src/bin/fixes/fix_search_code.py"

Error:  duplicate key value violates unique constraint "search_object_code_idx"
DETAIL:  Key (code)=(sthpw/department) already exists.

Error:  duplicate key value violates unique constraint "search_object_code_idx"
DETAIL:  Key (code)=(sthpw/custom_script) already exists.

Error:  duplicate key value violates unique constraint "search_object_code_idx"
DETAIL:  Key (code)=(sthpw/interaction) already exists.

Error:  duplicate key value violates unique constraint "search_object_code_idx"
DETAIL:  Key (code)=(sthpw/department) already exists.

Please refer to the file [/opt/tactic/tactic_temp/upgrade_output.txt] for any upgrade messages.

Default project template files have been updated.

*** Installation of TACTIC completed at [/opt/tactic] ***

Next, please install the Apache Web Server and then copy the Apache config extension [/opt/tactic/tactic_data/config/tactic.conf] to the Apache web server config area. e.g. /etc/httpd/conf.d/

Depending on the OS, you may need to add the following line to the main config file [httpd.conf] shipped with Apache as well:

Include conf.d/*.conf

==================

Of course Tactic isn't starting up properly. If it's any help, here's the output:

==================

su apache -s /bin/bash -c "python /opt/tactic/tactic/src/bin/startup_dev.py"

Data Directory [/opt/tactic/tactic_data]
Asset Directory [/opt/tactic/assets]
Temp Directory [/opt/tactic/tactic_temp]
Config path [/opt/tactic/tactic_data/config/tactic-conf.xml]
Registering project ... admin
Registering project ... default

Starting Workflow Engine
Starting Scheduler ....

Starting TACTIC v4.5.0.v01 ...

CherryPy Checker:
'/opt/tactic/tactic_data/dist' (root + dir) is not an existing filesystem path.
section: [/tactic/dist]
root: None
dir: '/opt/tactic/tactic_data/dist'

CherryPy Checker:
'/opt/tactic/tactic_data/dist' (root + dir) is not an existing filesystem path.
section: [/dist]
root: None
dir: '/opt/tactic/tactic_data/dist'

==================

It just stalls there forever at that point. Tried to create the "/opt/tactic/tactic_data/dist" folder, and the CherryPy error dissappers, but it still stalls there.

I'd really appreciate any advice on what to do now. I'd prefer to fix what I have now, but I'll format and start again if I have to. Also, know that I'm a Linux neophyte, so please provide enough detail for me to Google my way through any complex explanations.

Diego
Diego's picture

Hi gin,

those errors are ok and your tactic server seems to start ok, why do you say it stalls? The server is just waiting for connections. Did you try to connect with a browser?

Diego

gin

Thanks Diego, you're right. I was looking for the "ENGINE Bus STARTED" notice that the tutorial showed. I also was trying to connect over the network, which is not working atm. Localhost does work, though.