Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

db create / migrate fails #32

Closed
QuentinBibas opened this issue May 14, 2018 · 2 comments
Closed

db create / migrate fails #32

QuentinBibas opened this issue May 14, 2018 · 2 comments

Comments

@QuentinBibas
Copy link

QuentinBibas commented May 14, 2018 •
edited
Loading

#29 Hi / Bonjour

When creating and migrating the database, i have errors about "answers" database not existing during migration process / Lors de la procédure de création et de migration initiale de la base de donnée, j'ai des erreurs à propos de la base "answers" non présente - existante

here is the full migrate command with --trace option as suggested by the failed migrate command :

# RAILS_ENV=production bin/rake db:migrate --trace
Running via Spring preloader in process 6639
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:migrate
== 20170731083917 CreateAnswers: migrating ====================================
-- create_table(:answers)
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

PG::UndefinedObject: ERROR:  type "jsonb" does not exist
LINE 1: SELECT 'jsonb'::regtype::oid
               ^
: SELECT 'jsonb'::regtype::oid
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:590:in `block in log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activesupport-5.0.6/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:583:in `log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql_adapter.rb:384:in `lookup_cast_type'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/quoting.rb:110:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/quoting.rb:67:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:17:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:113:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:18:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:34:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:11:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `block in visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `map'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:278:in `create_table'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:846:in `block in method_missing'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `block in say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:835:in `method_missing'
/home/admin/pia-back/db/migrate/20170731083917_create_answers.rb:3:in `change'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:789:in `exec_migration'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:773:in `block (2 levels) in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:772:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:771:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:951:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1232:in `block in execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `block in ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/transactions.rb:211:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1231:in `execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1203:in `block in migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1319:in `with_advisory_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1006:in `up'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:984:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/tasks/database_tasks.rb:163:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:195:in `block in invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:181:in `invoke'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:153:in `invoke_task'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block (2 levels) in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:118:in `run_with_threads'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:103:in `top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:81:in `block in run'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:179:in `standard_exception_handling'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:78:in `run'
/home/admin/pia-back/bin/rake:9:in `<top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
-e:1:in `<main>'
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type "jsonb" does not exist
LINE 1: SELECT 'jsonb'::regtype::oid
               ^
: SELECT 'jsonb'::regtype::oid
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:590:in `block in log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activesupport-5.0.6/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:583:in `log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql_adapter.rb:384:in `lookup_cast_type'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/quoting.rb:110:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/quoting.rb:67:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:17:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:113:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:18:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:34:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:11:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `block in visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `map'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:278:in `create_table'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:846:in `block in method_missing'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `block in say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:835:in `method_missing'
/home/admin/pia-back/db/migrate/20170731083917_create_answers.rb:3:in `change'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:789:in `exec_migration'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:773:in `block (2 levels) in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:772:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:771:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:951:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1232:in `block in execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `block in ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/transactions.rb:211:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1231:in `execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1203:in `block in migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1319:in `with_advisory_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1006:in `up'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:984:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/tasks/database_tasks.rb:163:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:195:in `block in invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:181:in `invoke'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:153:in `invoke_task'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block (2 levels) in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:118:in `run_with_threads'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:103:in `top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:81:in `block in run'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:179:in `standard_exception_handling'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:78:in `run'
/home/admin/pia-back/bin/rake:9:in `<top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
-e:1:in `<main>'
PG::UndefinedObject: ERROR:  type "jsonb" does not exist
LINE 1: SELECT 'jsonb'::regtype::oid
               ^
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `async_exec'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:98:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:590:in `block in log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activesupport-5.0.6/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract_adapter.rb:583:in `log'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql_adapter.rb:384:in `lookup_cast_type'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/quoting.rb:110:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/quoting.rb:67:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:17:in `quote_default_expression'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:113:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:18:in `add_column_options!'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:34:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/postgresql/schema_statements.rb:11:in `visit_ColumnDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `block in visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `map'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:45:in `visit_TableDefinition'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_creation.rb:14:in `accept'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/schema_statements.rb:278:in `create_table'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:846:in `block in method_missing'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `block in say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:815:in `say_with_time'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:835:in `method_missing'
/home/admin/pia-back/db/migrate/20170731083917_create_answers.rb:3:in `change'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:789:in `exec_migration'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:773:in `block (2 levels) in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/benchmark.rb:293:in `measure'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:772:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:398:in `with_connection'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:771:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:951:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1232:in `block in execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `block in ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `block in transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/transaction.rb:189:in `within_new_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/connection_adapters/abstract/database_statements.rb:232:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/transactions.rb:211:in `transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1300:in `ddl_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1231:in `execute_migration_in_transaction'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1203:in `block in migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1202:in `migrate_without_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `block in migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1319:in `with_advisory_lock'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1150:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:1006:in `up'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/migration.rb:984:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/tasks/database_tasks.rb:163:in `migrate'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/activerecord-5.0.6/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `block in execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:251:in `execute'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:195:in `block in invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:188:in `invoke_with_call_chain'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/task.rb:181:in `invoke'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:153:in `invoke_task'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block (2 levels) in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `each'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:109:in `block in top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:118:in `run_with_threads'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:103:in `top_level'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:81:in `block in run'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:179:in `standard_exception_handling'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/rake-12.1.0/lib/rake/application.rb:78:in `run'
/home/admin/pia-back/bin/rake:9:in `<top (required)>'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
/home/admin/.rbenv/versions/2.5.1/lib/ruby/2.5.0/rubygems/core_ext/kernel_require.rb:59:in `require'
-e:1:in `<main>'
Tasks: TOP => db:migrate

This happens whichever the ENV i'm selecting, or even without any ENV selected.
@brunto
Copy link
Collaborator

brunto commented Aug 22, 2018

Hello,
The "jsonb" type exist from PostgreSQL version 9.4.
I think you are on an earlier version.

@brunto
Copy link
Collaborator

brunto commented Dec 13, 2018

Issue closed due to inactivity

@brunto brunto closed this as completed Dec 13, 2018
hamzaelayachi pushed a commit to CQEN-QDCE/pia-back that referenced this issue Aug 5, 2021
Merge pull request LINCnil#32 from LINCnil/about_page
8536b0e 
Update the About page
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@brunto @QuentinBibas