Admins

Notes :

(April) root@pouet:~# cd /etc/apt/sources.list.d
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# vim nodejs.list
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# cat nodejs.list 
deb https://deb.nodesource.com/node_12.x buster main
deb-src https://deb.nodesource.com/node_12.x buster main
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# apt update
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# apt dist-upgrade
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# dpkg -l nodejs
ii  nodejs         12.22.1-1nodesource1 amd64        Node.js event-based server-side javascript engine
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# dpkg -l postgresql
ii  postgresql     11+200+deb10u4 all          object-relational SQL database (supported version)

-> OK (nodejs >=12 et pgsql >= 9.5)

# backup sql
(April) root@pouet:/etc/apt/sources.list.d[buster$ u=]# time /etc/rrsync.d/dump-pgsql

# maj 
(April) root@pouet:~# su - mastodon
(April) mastodon@pouet:~$ cd live/
(April) mastodon@pouet:~/live[live-v3.3.0]$ git fetch && git checkout v3.4.0; git checkout -b live-v3.4.0
(April) mastodon@pouet:~/live[live-v3.4.0]$  bundle install && yarn install
#prendre un thé, c'est long
(April) mastodon@pouet:~/live[live-v3.4.0]$ SKIP_POST_DEPLOYMENT_MIGRATIONS=true RAILS_ENV=production bundle exec rails db:migrate

Your database collation is susceptible to index corruption.
  (This warning does not indicate that index corruption has occurred and can be ignored)
  (To learn more, visit: https://docs.joinmastodon.org/admin/troubleshooting/index-corruption/)

(April) mastodon@pouet:~/live[live-v3.4.0]$ logout
(April) root@pouet:~# su - postgres -c psql
postgres=# \connect mastodon_production;

mastodon_production=# SELECT datcollate FROM pg_database WHERE datname = current_database();
 datcollate
-------------
 en_US.UTF-8
(1 row)

-> OK

mastodon_production=# CREATE EXTENSION IF NOT EXISTS amcheck;
mastodon_production=# SELECT bt_index_check(c.oid)
mastodon_production-# FROM pg_index i
mastodon_production-# JOIN pg_class c ON i.indexrelid = c.oid
mastodon_production-# WHERE c.relname IN ('index_account_domain_blocks_on_account_id_and_domain',
mastodon_production(#   'index_account_proofs_on_account_and_provider_and_username',
mastodon_production(#   'index_accounts_on_username_and_domain_lower', 'index_accounts_on_uri',
mastodon_production(#   'index_accounts_on_url', 'index_conversations_on_uri',
mastodon_production(#   'index_custom_emoji_categories_on_name',
mastodon_production(#   'index_custom_emojis_on_shortcode_and_domain',
mastodon_production(#   'index_devices_on_access_token_id', 'index_domain_allows_on_domain',
mastodon_production(#   'index_domain_blocks_on_domain', 'index_email_domain_blocks_on_domain',
mastodon_production(#   'index_invites_on_code', 'index_markers_on_user_id_and_timeline',
mastodon_production(#   'index_media_attachments_on_shortcode', 'index_preview_cards_on_url',
mastodon_production(#   'index_statuses_on_uri', 'index_tags_on_name_lower',
mastodon_production(#   'index_tombstones_on_uri', 'index_unavailable_domains_on_domain',
mastodon_production(#   'index_users_on_email', 'index_webauthn_credentials_on_external_id'
mastodon_production(# );

-> RAS

mastodon_production=# CREATE EXTENSION IF NOT EXISTS amcheck;
mastodon_production=# SELECT bt_index_parent_check(c.oid)
mastodon_production-# FROM pg_index i
mastodon_production-# JOIN pg_class c ON i.indexrelid = c.oid
mastodon_production-# WHERE c.relname IN ('index_account_domain_blocks_on_account_id_and_domain',
mastodon_production(#   'index_account_proofs_on_account_and_provider_and_username',
mastodon_production(#   'index_accounts_on_username_and_domain_lower', 'index_accounts_on_uri',
mastodon_production(#   'index_accounts_on_url', 'index_conversations_on_uri',
mastodon_production(#   'index_custom_emoji_categories_on_name',
mastodon_production(#   'index_custom_emojis_on_shortcode_and_domain',
mastodon_production(#   'index_devices_on_access_token_id', 'index_domain_allows_on_domain',
mastodon_production(#   'index_domain_blocks_on_domain', 'index_email_domain_blocks_on_domain',
mastodon_production(#   'index_invites_on_code', 'index_markers_on_user_id_and_timeline',
mastodon_production(#   'index_media_attachments_on_shortcode', 'index_preview_cards_on_url',
mastodon_production(#   'index_statuses_on_uri', 'index_tags_on_name_lower',
mastodon_production(#   'index_tombstones_on_uri', 'index_unavailable_domains_on_domain',
mastodon_production(#   'index_users_on_email', 'index_webauthn_credentials_on_external_id'
mastodon_production(# );

-> RAS

# If this succeeds, without returning an error, your database should be consistent, and you can safely disregard the warning Mastodon emits when running db:migrate.

-> tout est OK (voir page doc plus haut pour détail)
Session terminated, killing shell...^C ...killed.

(April) root@pouet:~# su - mastodon
(April) mastodon@pouet:~$ cd live/
(April) mastodon@pouet:~/live[live-v3.4.0]$ RAILS_ENV=production bundle exec rails assets:precompile
(April) mastodon@pouet:~/live[live-v3.4.0]$ logout
(April) root@pouet:~# systemctl restart mastodon-sidekiq.service mastodon-streaming.service mastodon-web.service
(April) root@pouet:~# su - mastodon
(April) mastodon@pouet:~$ cd live/
(April) mastodon@pouet:~/live[live-v3.4.0]$ RAILS_ENV=production bin/tootctl cache clear
(April) mastodon@pouet:~/live[live-v3.4.0]$ RAILS_ENV=production bundle exec rails db:migrate
(April) mastodon@pouet:~/live[live-v3.4.0]$ logout
(April) root@pouet:~# systemctl restart mastodon-sidekiq.service mastodon-streaming.service mastodon-web.service