Project

General

Profile

Actions

Bug #7987

closed

[Deployment] api-server-upgrade script fails on first run

Added by Brett Smith almost 9 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assigned To:
-
Category:
Deployment
Target version:
-
Story points:
-

Description

From https://github.com/guillermo-carrasco/arvados-ansible/issues/23

Got the following error while running this workbench task:

psql:/var/www/arvados-api/current/db/structure.sql:15: ERROR:  syntax error at or near "EXTENSION" 
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
rake aborted!
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR:  syntax error at or near "," 
LINE 1: NOTIFY logs, '1'
                   ^
: NOTIFY logs, '1'

vagrant ssh workbench and running the offending command again seems to solve the issue for now:

/bin/bash /usr/local/bin/arvados-api-server-upgrade.sh"
Actions

Also available in: Atom PDF