Nieuwe installatie discourse 3.4.7 mislukt: kon 'badge_posts' view niet aanmaken

Hallo,

Installatie van Discourse v3.4.7 vanaf nul is mislukt met de volgende fout:

08:18:53.15 INFO  ==> Populating database
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled: (StandardError)
Failed to create 'badge_posts' view
/opt/bitnami/discourse/lib/badge_posts_view_manager.rb:22:in `create!'
/opt/bitnami/discourse/db/migrate/20180917024729_remove_superfluous_columns.rb:64:in `up'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:997:in `public_send'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:997:in `exec_migration'
/opt/bitnami/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/benchmark-0.4.0/lib/benchmark.rb:304:in `measure'
/opt/bitnami/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:978:in `block (2 levels) in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/benchmark-0.4.0/lib/benchmark.rb:304:in `measure'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:977:in `block in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:415:in `with_connection'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:976:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1190:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1538:in `block in execute_migration_in_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:616:in `block in within_new_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:613:in `within_new_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:361:in `transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1589:in `ddl_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1537:in `execute_migration_in_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1512:in `each'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1512:in `migrate_without_lock'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1457:in `block in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1609:in `with_advisory_lock'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1457:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1264:in `up'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1239:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
/opt/bitnami/discourse/lib/tasks/db.rake:267:in `block (2 levels) in <main>'
/opt/bitnami/discourse/lib/distributed_mutex.rb:53:in `block in synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:34:in `synchronize'
/opt/bitnami/discourse/lib/tasks/db.rake:242:in `block in <main>'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.2.1/exe/rake:27:in `<top (required)>'
/opt/bitnami/ruby/bin/bundle:25:in `<main>'
Caused by:
Failed to create 'badge_posts' view
/opt/bitnami/discourse/lib/badge_posts_view_manager.rb:22:in `create!'
/opt/bitnami/discourse/db/migrate/20180917024729_remove_superfluous_columns.rb:64:in `up'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:997:in `public_send'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:997:in `exec_migration'
/opt/bitnami/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `block in exec_migration'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/benchmark-0.4.0/lib/benchmark.rb:304:in `measure'
/opt/bitnami/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:978:in `block (2 levels) in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/benchmark-0.4.0/lib/benchmark.rb:304:in `measure'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:977:in `block in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:415:in `with_connection'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:976:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1190:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1538:in `block in execute_migration_in_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:616:in `block in within_new_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activesupport-7.2.2.1/lib/active_support/concurrency/null_lock.rb:9:in `synchronize'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/transaction.rb:613:in `within_new_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:361:in `transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1589:in `ddl_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1537:in `execute_migration_in_transaction'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1512:in `each'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1512:in `migrate_without_lock'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1457:in `block in migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1609:in `with_advisory_lock'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1457:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1264:in `up'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/migration.rb:1239:in `migrate'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/activerecord-7.2.2.1/lib/active_record/tasks/database_tasks.rb:262:in `migrate'
/opt/bitnami/discourse/lib/tasks/db.rake:267:in `block (2 levels) in <main>'
/opt/bitnami/discourse/lib/distributed_mutex.rb:53:in `block in synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:49:in `synchronize'
/opt/bitnami/discourse/lib/distributed_mutex.rb:34:in `synchronize'
/opt/bitnami/discourse/lib/tasks/db.rake:242:in `block in <main>'
/opt/bitnami/discourse/vendor/bundle/ruby/3.2.0/gems/rake-13.2.1/exe/rake:27:in `<top (required)>'
/opt/bitnami/ruby/bin/bundle:25:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
== 20180917024729 RemoveSuperfluousColumns: migrating =========================

Discourse versie: 3.4.7 – commit d2137efca79b8d2015d202a8a550e62ee30c6c06 (grafted, HEAD, tag: v3.4.7)

Docker image: bitnami/discourse:3.4.7-debian-12-r18

Chart versie: 17.0.0

Externe postgresql versie: 15.10.0 (Debian 15.10-0+deb12u1)

Database en gebruiker zijn aangemaakt door onze dba, en de database was leeg.

Kun je me helpen?

Met vriendelijke groet.

Hi there, the Bitnami install is deprecated and no longer supported. You’d want to do a standard install instead, as that is the official and supported method.

See also:

3 likes