Story #14824

postgresql 10.x compatibility

Added by Eric Biagiotti 5 months ago. Updated 5 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Story points:
-

Related issues

Related to Arvados - Story #14873: [API] Update to Rails 5Resolved03/20/2019

History

#1 Updated by Tom Morris 5 months ago

  • Target version set to To Be Groomed

#2 Updated by Lucas Di Pentima 5 months ago

The error was: ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "increment_by"

#3 Updated by Eric Biagiotti 5 months ago

#4 Updated by Eric Biagiotti 5 months ago

This is an issue with rails after updating to postgres 10. Summarized nicely here https://help.heroku.com/WKJ027JH/rails-error-after-upgrading-to-postgres-10.

Three possible solutions:

  1. Update rails to 5.0.x
  2. Update and use the following monkey patch for our version of rails https://github.com/rails/rails/issues/28780#issuecomment-354868174
  3. Continue using postgres 9.6

Also available in: Atom PDF