Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save malachaifrazier/e6e7dd601db78989060c1e45e779430d to your computer and use it in GitHub Desktop.
Save malachaifrazier/e6e7dd601db78989060c1e45e779430d to your computer and use it in GitHub Desktop.
Bloody hell
```
** Invoke db:environment:set (first_time)
** Invoke db:load_config (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:load_config
** Execute db:environment:set
** Invoke db:schema:load (first_time)
** Invoke db:load_config
** Invoke db:check_protected_environments (first_time)
** Invoke db:load_config
** Execute db:check_protected_environments
** Execute db:schema:load
rails aborted!
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR: syntax error at or near "("
LINE 1: ...earchable_index_col" tsvector GENERATED ALWAYS AS (to_tsvect...
^
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `exec'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `block (2 levels) in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:47:in `block in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:46:in `execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:325:in `create_table'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:931:in `block in method_missing'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:899:in `block in say_with_time'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/3.1.0/benchmark.rb:296:in `measure'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:899:in `say_with_time'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:920:in `method_missing'
/Users/malachai/Desktop/Projects/railsdevs.com/db/schema.rb:78:in `block in <top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:55:in `instance_eval'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:55:in `define'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:50:in `define'
/Users/malachai/Desktop/Projects/railsdevs.com/db/schema.rb:13:in `<top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:374:in `load'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:374:in `load_schema'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:477:in `block in load_schema_current'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:552:in `block (2 levels) in each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:549:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:549:in `block in each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:548:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:548:in `each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:476:in `load_schema_current'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/railties/databases.rake:469:in `block (3 levels) in <top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:18:in `perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/command.rb:51:in `invoke'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands.rb:18:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
Caused by:
PG::SyntaxError: ERROR: syntax error at or near "("
LINE 1: ...earchable_index_col" tsvector GENERATED ALWAYS AS (to_tsvect...
^
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `exec'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:48:in `block (2 levels) in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/dependencies/interlock.rb:41:in `permit_concurrent_loads'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:47:in `block in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract_adapter.rb:765:in `block in log'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activesupport-7.0.2.4/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract_adapter.rb:756:in `log'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:46:in `execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:325:in `create_table'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:931:in `block in method_missing'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:899:in `block in say_with_time'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/3.1.0/benchmark.rb:296:in `measure'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:899:in `say_with_time'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/migration.rb:920:in `method_missing'
/Users/malachai/Desktop/Projects/railsdevs.com/db/schema.rb:78:in `block in <top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:55:in `instance_eval'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:55:in `define'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/schema.rb:50:in `define'
/Users/malachai/Desktop/Projects/railsdevs.com/db/schema.rb:13:in `<top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:374:in `load'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:374:in `load_schema'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:477:in `block in load_schema_current'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:552:in `block (2 levels) in each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:549:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:549:in `block in each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:548:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:548:in `each_current_configuration'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/tasks/database_tasks.rb:476:in `load_schema_current'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/activerecord-7.0.2.4/lib/active_record/railties/databases.rake:469:in `block (3 levels) in <top (required)>'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `block in execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:281:in `execute'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:219:in `block in invoke_with_call_chain'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `synchronize'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:199:in `invoke_with_call_chain'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/task.rb:188:in `invoke'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:160:in `invoke_task'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block (2 levels) in top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `each'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:116:in `block in top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:125:in `run_with_threads'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:110:in `top_level'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:24:in `block (2 levels) in perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/application.rb:186:in `standard_exception_handling'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:24:in `block in perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/rake-13.0.6/lib/rake/rake_module.rb:59:in `with_application'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands/rake/rake_command.rb:18:in `perform'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/command.rb:51:in `invoke'
/Users/malachai/.rbenv/versions/3.1.2/lib/ruby/gems/3.1.0/gems/railties-7.0.2.4/lib/rails/commands.rb:18:in `<top (required)>'
bin/rails:4:in `require'
bin/rails:4:in `<main>'
Tasks: TOP => db:schema:load
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment