Сбой обновления до 2.4.0.beta2

Поддержка Самостоятельное хостинг
1

При попытке обновить версию с v2.4.0.beta1 +6 до 2.4.0.beta2 я получил белый экран с сообщением, в котором меня просят войти в систему непосредственно на сервере и выполнить команду ./launcher rebuild app из папки discourse. Однако в процессе миграции возникла ошибка, которая не позволяет нам завершить обновление. Пожалуйста, ознакомьтесь с логом ниже:

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'

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

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `ddl_transaction'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `each'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `migrate_without_lock'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `block in migrate'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1363:in `with_advisory_lock'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `migrate'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate'

/var/www/discourse/lib/migration/safe_migrate.rb:52:in `migrate'

/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'

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

/usr/local/bin/bundle:23:in `load'

/usr/local/bin/bundle:23:in `<main>'

Tasks: TOP => db:migrate

(Полный трассировочный стек можно увидеть, запустив задачу с флагом --trace)

I, [2019-07-30T02:26:02.062067 #15] INFO -- : gem install public_suffix -v 3.0.3 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install

Успешно установлен public_suffix-3.0.3

Установлено 1 gem

gem install addressable -v 2.5.2 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install

Успешно установлен addressable-2.5.2

Установлено 1 gem

gem install sawyer -v 0.8.1 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install

Успешно установлен sawyer-0.8.1

Установлено 1 gem

gem install octokit -v 4.9.0 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install

Успешно установлен octokit-4.9.0

Установлено 1 gem

== 20190724055909 MoveToManagedAuthenticator: миграция =======================

-- execute("INSERT INTO user_associated_accounts (\n provider_name,\n provider_uid,\n user_id,\n created_at,\n updated_at\n) SELECT\n 'oauth2_basic',\n replace(key, 'oauth2_basic_user_', ''),\n (value::json->>'user_id')::integer,\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM plugin_store_rows\nWHERE plugin_name = 'oauth2_basic'\nON CONFLICT (provider_name, user_id)\nDO NOTHING\n")

I, [2019-07-30T02:26:02.062767 #15] INFO -- : Завершение асинхронных процессов

I, [2019-07-30T02:26:02.062812 #15] INFO -- : Отправка сигнала INT процессу HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/10/bin/postmaster -D /etc/postgresql/10/main pid: 70

I, [2019-07-30T02:26:02.062859 #15] INFO -- : Отправка сигнала TERM процессу exec chpst -u redis -U redis /usr/bin/redis-server /etc/redis/redis.conf pid: 186

2019-07-30 02:26:02.063 UTC [70] LOG: получен запрос на быстрое завершение работы

186:signal-handler (1564453562) Получен сигнал SIGTERM, планирование завершения работы...

186:M 30 Jul 2019 02:26:02.159 # Пользователь запросил завершение работы...

186:M 30 Jul 2019 02:26:02.159 * Сохранение финального снимка RDB перед выходом.

2019-07-30 02:26:02.903 UTC [70] LOG: отмена всех активных транзакций

2019-07-30 02:26:02.906 UTC [70] LOG: рабочий процесс: запускатель логической репликации (PID 79) завершился с кодом выхода 1

2019-07-30 02:26:02.907 UTC [74] LOG: завершение работы

186:M 30 Jul 2019 02:26:02.909 * База данных сохранена на диск

186:M 30 Jul 2019 02:26:02.909 # Redis готов к выходу, до свидания...

2019-07-30 02:26:02.960 UTC [70] LOG: система баз данных завершена

ОШИБКА

--------------------

Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' завершилась с ошибкой, код возврата #<Process::Status: pid 11246 exit 1>

Место возникновения ошибки: /pups/lib/pups/exec_command.rb:112:in `spawn'

Выполнение не удалось с параметрами {"cd"=>"$home", "hook"=>"db_migrate", "cmd"=>["su discourse -c 'bundle exec rake db:migrate'"]}

c5f6c62f432b100b14621e70fc5cede77bcac6d5a9731b84a37d4733d122d70e

** НЕ УДАЛОСЬ ЗАПУСТИТЬ СИСТЕМУ ** Пожалуйста, прокрутите вверх и найдите более ранние сообщения об ошибках; их может быть несколько.

Есть ли какие-либо советы?

2

Нам нужно ещё несколько строк сверху, чтобы увидеть ошибку.

3

Additional Log details attached, thanks for the help @Falco:

> 
> Bundle complete! 118 Gemfile dependencies, 194 gems now installed.
> 
> Gems in the group development were not installed.
> 
> Bundled gems are installed into `./vendor/bundle`
> 
> Post-install message from i18n:
> 
> HEADS UP! i18n 1.1 changed fallbacks to exclude default locale.
> 
> But that may break your application.
> 
> Please check your Rails app for 'config.i18n.fallbacks = true'.
> 
> If you're using I18n (>= 1.1.0) and Rails (< 5.2.2), this should be
> 
> 'config.i18n.fallbacks = [I18n.default_locale]'.
> 
> If not, fallbacks will be broken in your app by I18n 1.1.x.
> 
> For more info see:
> 
> https://github.com/svenfuchs/i18n/releases/tag/v1.1.0
> 
> Post-install message from rubocop:
> 
> Performance cops have been removed from RuboCop 0.68. Use the `rubocop-performance` gem instead.
> 
> Put this in your `Gemfile`.
> 
> ```rb
> 
> gem 'rubocop-performance'
> 
> ```
> 
> And then execute:
> 
> ```sh
> 
> $ bundle install
> 
> ```
> 
> Put this into your `.rubocop.yml`.
> 
> ```yaml
> 
> require: rubocop-performance
> 
> ```
> 
> More information: https://github.com/rubocop-hq/rubocop-performance
> 
> I, [2019-07-30T02:30:24.659675 #13] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate'
> 
> 2019-07-30 02:30:54.028 UTC [11272] discourse@discourse ERROR: invalid input syntax for integer: "[5205]"
> 
> 2019-07-30 02:30:54.028 UTC [11272] discourse@discourse STATEMENT: INSERT INTO user_associated_accounts (
> 
> provider_name,
> 
> provider_uid,
> 
> user_id,
> 
> created_at,
> 
> updated_at
> 
> ) SELECT
> 
> 'oauth2_basic',
> 
> replace(key, 'oauth2_basic_user_', ''),
> 
> (value::json->>'user_id')::integer,
> 
> CURRENT_TIMESTAMP,
> 
> CURRENT_TIMESTAMP
> 
> FROM plugin_store_rows
> 
> WHERE plugin_name = 'oauth2_basic'
> 
> ON CONFLICT (provider_name, user_id)
> 
> DO NOTHING
> 
> rake aborted!
> 
> StandardError: An error has occurred, this and all later migrations canceled:
> 
> PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "[5205]"
> 
> : INSERT INTO user_associated_accounts (
> 
> provider_name,
> 
> provider_uid,
> 
> user_id,
> 
> created_at,
> 
> updated_at
> 
> ) SELECT
> 
> 'oauth2_basic',
> 
> replace(key, 'oauth2_basic_user_', ''),
> 
> (value::json->>'user_id')::integer,
> 
> CURRENT_TIMESTAMP,
> 
> CURRENT_TIMESTAMP
> 
> FROM plugin_store_rows
> 
> WHERE plugin_name = 'oauth2_basic'
> 
> ON CONFLICT (provider_name, user_id)
> 
> DO NOTHING
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:84:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:871:in `block in method_missing'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `block in say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:860:in `method_missing'
> 
> /var/www/discourse/plugins/discourse-oauth2-basic/db/migrate/20190724055909_move_to_managed_authenticator.rb:5:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:817:in `exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:9:in `block in exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:797:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:796:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:29:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:977:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `block in ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/transactions.rb:212:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `each'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1363:in `with_advisory_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:52:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
> 
> /usr/local/bin/bundle:23:in `load'
> 
> /usr/local/bin/bundle:23:in `<main>'
> 
> Caused by:
> 
> ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "[5205]"
> 
> : INSERT INTO user_associated_accounts (
> 
> provider_name,
> 
> provider_uid,
> 
> user_id,
> 
> created_at,
> 
> updated_at
> 
> ) SELECT
> 
> 'oauth2_basic',
> 
> replace(key, 'oauth2_basic_user_', ''),
> 
> (value::json->>'user_id')::integer,
> 
> CURRENT_TIMESTAMP,
> 
> CURRENT_TIMESTAMP
> 
> FROM plugin_store_rows
> 
> WHERE plugin_name = 'oauth2_basic'
> 
> ON CONFLICT (provider_name, user_id)
> 
> DO NOTHING
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:84:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:871:in `block in method_missing'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `block in say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:860:in `method_missing'
> 
> /var/www/discourse/plugins/discourse-oauth2-basic/db/migrate/20190724055909_move_to_managed_authenticator.rb:5:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:817:in `exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:9:in `block in exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:797:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:796:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:29:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:977:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `block in ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/transactions.rb:212:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `each'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1363:in `with_advisory_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:52:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
> 
> /usr/local/bin/bundle:23:in `load'
> 
> /usr/local/bin/bundle:23:in `<main>'
> 
> Caused by:
> 
> PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "[5205]"
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-1.0.2/lib/patches/db/pg.rb:110:in `async_exec'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:84:in `async_exec'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:75:in `block (2 levels) in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:74:in `block in execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in `instrument'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:73:in `execute'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:871:in `block in method_missing'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `block in say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `say_with_time'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:860:in `method_missing'
> 
> /var/www/discourse/plugins/discourse-oauth2-basic/db/migrate/20190724055909_move_to_managed_authenticator.rb:5:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:817:in `exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:9:in `block in exec_migration'
> 
> /var/www/discourse/lib/freedom_patches/schema_migration_details.rb:8:in `exec_migration'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:798:in `block (2 levels) in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:797:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:796:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:29:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:977:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `block in ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/transactions.rb:212:in `transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `ddl_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in `block in migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `each'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `migrate_without_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `block in migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1363:in `with_advisory_lock'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate'
> 
> /var/www/discourse/lib/migration/safe_migrate.rb:52:in `migrate'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <top (required)>'
> 
> /var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>'
> 
> /usr/local/bin/bundle:23:in `load'
> 
> /usr/local/bin/bundle:23:in `<main>'
> 
> Tasks: TOP => db:migrate
> 
> (See full trace by running task with --trace)
> 
> I, [2019-07-30T02:30:54.047592 #13] INFO -- : gem install public_suffix -v 3.0.3 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install
> 
> Successfully installed public_suffix-3.0.3
> 
> 1 gem installed
> 
> gem install addressable -v 2.5.2 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install
> 
> Successfully installed addressable-2.5.2
> 
> 1 gem installed
> 
> gem install sawyer -v 0.8.1 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install
> 
> Successfully installed sawyer-0.8.1
> 
> 1 gem installed
> 
> gem install octokit -v 4.9.0 -i /var/www/discourse/plugins/discourse-github/gems/2.6.2 --no-document --ignore-dependencies --no-user-install
> 
> Successfully installed octokit-4.9.0
> 
> 1 gem installed
> 
> == 20190724055909 MoveToManagedAuthenticator: migrating =======================
> 
> -- execute("INSERT INTO user_associated_accounts (\n provider_name,\n provider_uid,\n user_id,\n created_at,\n updated_at\n) SELECT\n 'oauth2_basic',\n replace(key, 'oauth2_basic_user_', ''),\n (value::json->>'user_id')::integer,\n CURRENT_TIMESTAMP,\n CURRENT_TIMESTAMP\nFROM plugin_store_rows\nWHERE plugin_name = 'oauth2_basic'\nON CONFLICT (provider_name, user_id)\nDO NOTHING\n")
> 
> 184:signal-handler (1564453854) Received SIGTERM scheduling shutdown...
> 
> I, [2019-07-30T02:30:54.048180 #13] INFO -- : Terminating async processes
> 
> I, [2019-07-30T02:30:54.048226 #13] INFO -- : Sending INT to HOME=/var/lib/postgresql USER=postgres exec chpst -u postgres:postgres:ssl-cert -U postgres:postgres:ssl-cert /usr/lib/postgresql/10/bin/postmaster -D /etc/postgresql/10/main pid: 68
> 
> I, [2019-07-30T02:30:54.048275 #13] INFO -- : Sending TERM to exec chpst -u redis -U redis /usr/bin/redis-server /etc/redis/redis.conf pid: 184
> 
> 2019-07-30 02:30:54.048 UTC [68] LOG: received fast shutdown request
> 
> 2019-07-30 02:30:54.077 UTC [68] LOG: aborting any active transactions
> 
> 2019-07-30 02:30:54.082 UTC [68] LOG: worker process: logical replication launcher (PID 77) exited with exit code 1
> 
> 2019-07-30 02:30:54.082 UTC [72] LOG: shutting down
> 
> 184:M 30 Jul 2019 02:30:54.135 # User requested shutdown...
> 
> 184:M 30 Jul 2019 02:30:54.136 * Saving the final RDB snapshot before exiting.
> 
> 2019-07-30 02:30:54.145 UTC [68] LOG: database system is shut down
> 
> 184:M 30 Jul 2019 02:30:54.647 * DB saved on disk
> 
> 184:M 30 Jul 2019 02:30:54.647 # Redis is now ready to exit, bye bye...
> 
> FAILED
> 
> --------------------
> 
> Pups::ExecError: cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' failed with return #<Process::Status: pid 11235 exit 1>
> 
> Location of failure: /pups/lib/pups/exec_command.rb:112:in `spawn'
> 
> exec failed with the params {"cd"=>"$home", "hook"=>"db_migrate", "cmd"=>["su discourse -c 'bundle exec rake db:migrate'"]}
> 
> e269f7d0ccb5cb508ee7a10a8dfe7b386e9bb1c35d6bb192eadc8cdef3c689c8
> 
> ** FAILED TO BOOTSTRAP ** please scroll up and look for earlier error messages, there may be more than one
4

Пишу, чтобы уточнить совет. Заранее спасибо!

5

Похоже, это было сломано этим PR от @angus

Ожидается, что ключ user_id в JSON строки плагина будет целым числом, а не массивом целых чисел.

6

@angus, у нас есть примерное время исправления?

7

@Jim.Morrison Я посмотрю на это завтра с самого утра.

cc @david

8

@Jim.Morrison Пожалуйста, попробуйте обновить снова. Я только что выложил исправление, которое добавляет защиту от этой ситуации:

Однако я не уверен, как это вообще произошло. У вас есть какие-либо пользовательские плагины или скрипты консоли, которые вы использовали для редактирования ассоциаций аккаунтов?

11

Обновление Staging прошло успешно. Однако при попытке обновить Production всё полностью сломалось:

31%20PM
31%20PM2674×510 70.2 KB

Переход на корневой домен на мобильном устройстве работает нормально, пока я не пройду аутентификацию.

@angus @david, не связано ли это с последним обновлением плагина oauth2?

12

Непосредственная проблема решена путем удаления конфликта плагинов через App.yml. Спасибо еще раз за помощь, @angus!