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