Cannot truncate a table referenced in a foreign key constraint (ActiveRecord::StatementInvalid)

[RajRoR]

> DatabaseCleaner.clean_with(:truncation, pre_count: true)

(reverb):1:in `<main>': PG::FeatureNotSupported: ERROR:  cannot truncate a table referenced in a foreign key constraint (ActiveRecord::StatementInvalid)
DETAIL:  Table "table1" references "table2".
HINT:  Truncate table "table1" at the same time, or use TRUNCATE ... CASCADE.

/root/project/vendor/bundle/ruby/3.1.0/gems/activerecord-7.2.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:56:in `exec': ERROR:  cannot truncate a table referenced in a foreign key constraint (PG::FeatureNotSupported)

DETAIL:  Table "table1" references "table2".
HINT:  Truncate table "table1" at the same time, or use TRUNCATE ... CASCADE.

Rails 7.2.1
ActiveRecord 7.2.1
DatabaseCleaner 2.0.2
DatabaseCleaner-ActiveRecord 2.2.0

[mikeheft]

I have also run into this recently out of the blue AFAICT. No one else on my team is running into this issue. I've deleted all of my bundled gems and re-bundled but that did nothing. I don't want to have to modify the code, since it's only me experiencing this, but I would think the cascade would be standard in the truncation?

[RajRoR]

@mikeheft - Is your gem version is different from your teams'? Try version 2.1. It should fix this problem. I hope that helps.

[Nathan-Heller]

I'm also running into this issue.

in my Rspec config, rails_helper.rb file:

# ...
require 'database_cleaner/active_record
# ...
RSpec.configure do |config|
  # ...
  DatabaseCleaner.strategy = :truncation
  config.before
    DatabaseCleaner.start
  end

  config.after
    DatabaseCleaner.clean
  end
  # ...
end

Rails 7.2.0
ActiveRecord 7.2.0
DatabaseCleaner-ActiveRecord 2.1.0
DatabaseCleaner-Core 2.0.1

[mikeheft]

For me I had to lock it to 1.8.3. It seems the latest version doesn't have the cascade functionality

[pgiblock]

Sharing in case anyone else ran into this with the activerecord gem:

Unfortunately, that version doesn't seem to work with newer activerecord. I tried adding some garbage options to cleanwith and got an error message mentioning that truncate_option is an available option. It appears to be appended to the TRUNCATE SQL command. For my use case, this worked:

DatabaseCleaner.clean_with :truncation, pre_count: true, truncate_option: 'CASCADE'

YMMV for specifying the option via #strategy=