Skip to content
This repository was archived by the owner on May 10, 2019. It is now read-only.
This repository was archived by the owner on May 10, 2019. It is now read-only.

PostgreSQL Errors During Large Data Migrations In after_release #70

@dleve123

Description

@dleve123

cc: @fancyremarker

When running a large data migration on our Rails app we received a cascade of postgreSQL related errors when running migrations in the after_release context as defined in .aptible.yml:

  1. PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly,
  2. PG::ConnectionBad: PQsocket() can't get socket descriptor: ROLLBACK * 2,
  3. PG::ConnectionBad: PQsocket() can't get socket descriptor,
  4. ActiveRecord::StatementInvalid: PG::ConnectionBad: PQconsumeInput() server closed the connection unexpectedly,
  5. NoMethodError: undefined method 'result_error_field' for nil:NilClass (related to Rails' postgres adapter)

The migration run failed in the same way twice. The migration was successful when ran manually via aptible ssh rake db:migrate.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions