PG::DuplicateTable: ERROR: relation "auditor_authentication_records_2021_3" already exists

[Aravind S Pillai]

Hello Team,

I was trying to setup the Canvas LMS production (stable) on Ubuntu 20.04, (Postgres 12)and on the RAILS_ENV=production bundle exec rake db:initial_setup I ended up in the following error:

==  CreateAuditorsPartitions: migrating =======================================

rake aborted!

StandardError: An error has occurred, this and all later migrations canceled:

PG::DuplicateTable: ERROR:  relation "auditor_authentication_records_2021_3" already exists

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `exec'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:92:in `block (2 levels) in execute'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:91:in `block in execute'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:722:in `block (2 levels) in log'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:721:in `block in log'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/notifications/instrumenter.rb:24:in `instrument'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/sharded_instrumenter.rb:22:in `instrument'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:712:in `log'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/active_record/abstract_adapter.rb:39:in `log'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/postgresql/database_statements.rb:90:in `execute'

/var/canvas/gems/canvas_partman/lib/canvas_partman/partition_manager.rb:166:in `execute'

/var/canvas/gems/canvas_partman/lib/canvas_partman/partition_manager.rb:89:in `block in create_partition'

/var/canvas/gems/canvas_partman/lib/canvas_partman/partition_manager.rb:122:in `block in with_statement_timeout'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:278:in `transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/transactions.rb:212:in `transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/active_record/base.rb:51:in `transaction'

/var/canvas/gems/canvas_partman/lib/canvas_partman/partition_manager.rb:120:in `with_statement_timeout'

/var/canvas/gems/canvas_partman/lib/canvas_partman/partition_manager.rb:88:in `create_partition'

/var/canvas/db/migrate/20200414193317_create_auditors_partitions.rb:34:in `block (2 levels) in up'

/var/canvas/db/migrate/20200414193317_create_auditors_partitions.rb:31:in `times'

/var/canvas/db/migrate/20200414193317_create_auditors_partitions.rb:31:in `block in up'

/var/canvas/db/migrate/20200414193317_create_auditors_partitions.rb:27:in `each'

/var/canvas/db/migrate/20200414193317_create_auditors_partitions.rb:27:in `up'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:831:in `exec_migration'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:812:in `block (2 levels) in migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:811:in `block in migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:471:in `with_connection'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/connection_pool_proxy.rb:15:in `with_connection'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:810:in `migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-inst-jobs-3.1.2/lib/switchman_inst_jobs/active_record/migration.rb:16:in `migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:624:in `migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1002:in `migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1310:in `block in execute_migration_in_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1361:in `block in ddl_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `block in transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3.5/lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/transactions.rb:212:in `transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/active_record/base.rb:51:in `transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1361:in `ddl_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1309:in `execute_migration_in_transaction'

/var/canvas/config/initializers/active_record.rb:1467:in `execute_migration_in_transaction'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1281:in `block in migrate_without_lock'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1280:in `each'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1280:in `migrate_without_lock'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1229:in `block in migrate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1382:in `with_advisory_lock'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3.5/lib/active_record/migration.rb:1229:in `migrate'

/var/canvas/lib/tasks/canvas.rake:175:in `block (3 levels) in <top (required)>'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:87:in `block (6 levels) in shardify_task'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:87:in `each'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:87:in `block (5 levels) in shardify_task'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/database_server.rb:109:in `unguard'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:86:in `block (4 levels) in shardify_task'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/app/models/switchman/shard.rb:152:in `with_each_shard'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:71:in `block (3 levels) in shardify_task'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/database_server.rb:109:in `unguard'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:68:in `block (2 levels) in shardify_task'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/switchman/guard_rail.rb:24:in `activate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-inst-jobs-3.1.2/lib/switchman_inst_jobs/guard_rail.rb:8:in `activate'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/switchman-2.0.7/lib/tasks/switchman.rake:67:in `block in shardify_task'

/var/canvas/lib/tasks/db_load_data.rake:225:in `block (2 levels) in <top (required)>'

/var/canvas/vendor/bundle/ruby/2.6.0/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'

Kindly suggest a solution....thanks in advance !

--

Thanks & Regards,

Aravind S

[Simon Williams]

Hi Aravind,

I think what’s happening is that for some reason the code is trying to create the same partition table name twice. I’m not sure exactly how you got into this state, but I think changing line 34 of db/migrate/20200414193317_create_auditors_partitions.rb to:

    partman.create_partition(current_partition_time) unless partman.partition_exists?(current_partition_time)

should help.

Hope that helps,

Simon

--

---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/canvas-lms-users/71c809aa-92ff-4019-b974-bf59c8a34b22n%40googlegroups.com.

[Aravind S Pillai]

OK Simon, dropped the DB once again, still into this same error. 

Was investigating what is exactly happening here, but no luck

Will do a reset, repeat the same steps and will see. Thanks for the support.

--

Thanks & Kind Regards,

Aravind S

To view this discussion on the web visit https://groups.google.com/d/msgid/canvas-lms-users/46AE9BEF-51D4-4FF8-8347-D0B74F31D633%40instructure.com.

[Andrey Gangan]

have got same error with fresh setup.

Is any idea?

среда, 7 апреля 2021 г. в 11:55:10 UTC+3, aravindso...@gmail.com:

[Dengpan Huang]

have got same error with fresh setup.

Is any idea?

[Andrey Gangan]

I reinstalled later without issue

try to reinstall from scratch or drop db and setup it again

понедельник, 19 апреля 2021 г. в 04:34:29 UTC+3, huangd...@gmail.com:

[Dengpan Huang]

I am trying to update canvas , I installed canvas 2 years ago. o(╯□╰)o

[Andrey Gangan]

If you try to update with 2 years step - you are wrong.

max step is 6 months.

select some tegs and switch to them then bundle, yarn, compile, and db migration

then next tag witj about 5-6  months step.

BigBlueButton hosting, linux support

среда, 21 апреля 2021 г. в 15:52:36 UTC+3, huangd...@gmail.com:

[Dengpan Huang]

Thank you very much ! I will reupdate it tomorrow.
Have a good day !