Project

General

Profile

Actions
Copy link

Bug #7987

closed

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

Added by Brett Smith over 10 years ago. Updated about 6 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 over 10 years ago

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

Updated by Ward Vandewege over 10 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 over 10 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 over 10 years ago

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

Updated by Peter Amstutz about 6 years ago

  • Status changed from New to Closed
Actions
Copy link

Also available in: Atom PDF