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

[ActiveRecord 5.2 Test Failure] test/cases/adapters/postgresql/network_test.rb #108

Closed
alimi opened this issue Apr 17, 2020 · 1 comment
Closed

[ActiveRecord 5.2 Test Failure] test/cases/adapters/postgresql/network_test.rb #108

alimi opened this issue Apr 17, 2020 · 1 comment

Comments

@alimi
Copy link
Contributor

alimi commented Apr 17, 2020 

Error:
PostgresqlNetworkTest#test_cidr_column:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_cidr_column:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:23

Error:
PostgresqlNetworkTest#test_macaddr_column:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_macaddr_column:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:43

Error:
PostgresqlNetworkTest#test_inet_column:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_inet_column:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:33

Error:
PostgresqlNetworkTest#test_invalid_network_address:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_invalid_network_address:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:74

Error:
PostgresqlNetworkTest#test_network_types:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_network_types:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:53

Error:
PostgresqlNetworkTest#test_schema_dump_with_shorthand:
ActiveRecord::StatementInvalid: PG::UndefinedObject: ERROR:  type 'cidr' does not exist
: SELECT 'cidr'::regtype::oid
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:63:in `block (2 levels) in query'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:62:in `block in query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:61:in `query'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:98:in `query_value'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:83:in `lookup_cast_type'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/quoting.rb:92:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/quoting.rb:73:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:19:in `quote_default_expression'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:106:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_creation.rb:60:in `add_column_options!'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:36:in `visit_ColumnDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `block in visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `map'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:47:in `visit_TableDefinition'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_creation.rb:16:in `accept'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:311:in `create_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:12:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:606:in `block (2 levels) in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `catch'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:605:in `block in default_terminator'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:199:in `block in halting'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `block in invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:513:in `invoke_before'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:131:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:41:in `before_setup'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:861:in `before_setup'

Error:
PostgresqlNetworkTest#test_schema_dump_with_shorthand:
ActiveRecord::StatementInvalid: PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: DROP TABLE IF EXISTS "postgresql_network_addresses"
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `exec'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
    /Users/alimi/repos/rails/activesupport/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
    /Users/alimi/repos/rails/activesupport/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
    /Users/alimi/.rvm/rubies/ruby-2.5.3/lib/ruby/2.5.0/monitor.rb:226:in `mon_synchronize'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
    /Users/alimi/repos/rails/activesupport/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
    /Users/alimi/repos/rails/activerecord/lib/active_record/connection_adapters/postgresql/schema_statements.rb:58:in `drop_table'
    /Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:20:in `block in <class:PostgresqlNetworkTest>'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `instance_exec'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:426:in `block in make_lambda'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:271:in `block in simple'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `block in invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `each'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:517:in `invoke_after'
    /Users/alimi/repos/rails/activesupport/lib/active_support/callbacks.rb:133:in `run_callbacks'
    /Users/alimi/repos/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:46:in `after_teardown'
    /Users/alimi/repos/rails/activerecord/lib/active_record/fixtures.rb:865:in `after_teardown'

bin/rails test Users/alimi/repos/rails/activerecord/test/cases/adapters/postgresql/network_test.rb:90

See the Contributing Guide for instructions on running tests.

If the test isn't valid against CockroachDB

  1. Add a ruby file to test/excludes that matches the name of the test class if one doesn't already exist. For example to exclude a test from ActiveRecord::AdapterTest, create test/excludes/ActiveRecord/AdapterTest.rb.
  2. Add an exclude statement to the file with the name of the test to exclude and a description. For example to exclude test_indexes from ActiveRecord::AdapterTest:

    activerecord-cockroachdb-adapter/test/excludes/ActiveRecord/AdapterTest.rb

    Line 1 in c3cb637

    exclude :test_indexes, "Rails transactional tests are being used while making schema changes. See https://www.cockroachlabs.com/docs/stable/online-schema-changes.html#limited-support-for-schema-changes-within-transactions."
  3. Finally, if the test can run against CockroachDB with a few changes, add it to test/cases. Everything from the ActiveRecord test suite will be available, so a lot of the excluded test can be copied over. Namespace the test under the CockroachDB module to avoid name collisions. See test/cases/adapter_test.rb for an example.

See #48.
@sandstrom
Copy link

May be blocked on cockroachdb/cockroach#18846

@BuonOmo BuonOmo closed this as completed Sep 3, 2024
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
3 participants
@sandstrom @alimi @BuonOmo