Project

General

Profile

Actions
Copy link

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
Copy link
 #1

Updated by Brett Smith almost 9 years ago

  • Target version set to Arvados Future Sprints
Actions
Copy link
 #2

Updated by Ward Vandewege almost 9 years ago

Rake, specifically db:structure, pulls in pl/pgsql.

The fix for this error would be to install the postgresql-contrib package before the rake db call is made.

Actions
Copy link
 #3

Updated by Tom Clegg almost 9 years ago

If this is just "what we have" and we don't actually need it, we can extend the existing "remove useless troublesome stuff from structure.sql" code in source:services/api/Rakefile to remove this line of source:services/api/db/structure.sql:

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
Actions
Copy link
 #4

Updated by Brett Smith almost 9 years ago

  • Target version deleted (Arvados Future Sprints)
Actions
Copy link
 #5

Updated by Peter Amstutz almost 5 years ago

  • Status changed from New to Closed
Actions
Copy link

Also available in: Atom PDF