Pointeur d'objet corrompu pendant le processus de sauvegarde

RikoDEV · Mai 16, 2020, 10:14

Version de Discourse : 2.5.0.beta4 (e81a4048e3)

Lors de la tentative de sauvegarde, j’obtiens l’erreur indiquée ci-dessous.

[2020-05-16 10:09:19] pg_dump: traitement des données pour la table "public.reviewable_claimed_topics"
[2020-05-16 10:09:19] pg_dump: vidage du contenu de la table "public.reviewable_claimed_topics"
[2020-05-16 10:09:19] pg_dump: traitement des données pour la table "public.reviewable_histories"
[2020-05-16 10:09:19] pg_dump: vidage du contenu de la table "public.reviewable_histories"
[2020-05-16 10:09:19] pg_dump: traitement des données pour la table "public.reviewable_scores"
[2020-05-16 10:09:19] pg_dump: vidage du contenu de la table "public.reviewable_scores"
[2020-05-16 10:09:19] pg_dump: traitement des données pour la table "public.reviewables"
[2020-05-16 10:09:19] pg_dump: vidage du contenu de la table "public.reviewables"
[2020-05-16 10:09:19] pg_dump: traitement des données pour la table "public.scheduler_stats"
[2020-05-16 10:09:19] pg_dump: vidage du contenu de la table "public.scheduler_stats"
[2020-05-16 10:09:19] pg_dump: Échec du vidage du contenu de la table "scheduler_stats" : échec de PQgetResult().
[2020-05-16 10:09:19] pg_dump: Message d'erreur provenant du serveur : PANIC : pointeur d'élément corrompu : 10992
[2020-05-16 10:09:19] pg_dump: La commande était : COPY public.scheduler_stats (id, name, hostname, pid, duration_ms, live_slots_start, live_slots_finish, started_at, success, error) TO stdout;
[2020-05-16 10:09:19] Reprendre sidekiq...
[2020-05-16 10:09:19] EXCEPTION : échec de pg_dump
[2020-05-16 10:09:19] /var/www/discourse/lib/backup_restore/backuper.rb:183:in `dump_public_schema'
/var/www/discourse/lib/backup_restore/backuper.rb:40:in `run'
/var/www/discourse/lib/backup_restore.rb:184:in `block in start!'
/var/www/discourse/lib/backup_restore.rb:181:in `fork'
/var/www/discourse/lib/backup_restore.rb:181:in `start!'
/var/www/discourse/lib/backup_restore.rb:15:in `backup!'
/var/www/discourse/app/controllers/admin/backups_controller.rb:40:in `create'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/abstract_controller/base.rb:195:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/rendering.rb:30:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/abstract_controller/callbacks.rb:42:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3/lib/active_support/callbacks.rb:135:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/abstract_controller/callbacks.rb:41:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/rescue.rb:22:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/instrumentation.rb:33:in `block in process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3/lib/active_support/notifications.rb:180:in `block in instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3/lib/active_support/notifications/instrumenter.rb:24:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3/lib/active_support/notifications.rb:180:in `instrument'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/instrumentation.rb:32:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal/params_wrapper.rb:245:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activerecord-6.0.3/lib/active_record/railties/controller_runtime.rb:27:in `process_action'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/abstract_controller/base.rb:136:in `process'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionview-6.0.3/lib/action_view/rendering.rb:39:in `process'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.1/lib/mini_profiler/profiling_methods.rb:104:in `block in profile_method'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal.rb:190:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_controller/metal.rb:254:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/routing/route_set.rb:33:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/routing/mapper.rb:18:in `block in <class:Constraints>'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/routing/mapper.rb:48:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/journey/router.rb:49:in `block in serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/journey/router.rb:32:in `each'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/journey/router.rb:32:in `serve'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/routing/route_set.rb:834:in `call'
/var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:68:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/tempfile_reaper.rb:15:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/conditional_get.rb:38:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/head.rb:12:in `call'
/var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
/var/www/discourse/lib/middleware/anonymous_cache.rb:318:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/session/abstract/id.rb:259:in `context'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/session/abstract/id.rb:253:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/cookies.rb:648:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/activesupport-6.0.3/lib/active_support/callbacks.rb:101:in `run_callbacks'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/callbacks.rb:26:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/actionable_exceptions.rb:17:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/logster-2.8.0/lib/logster/middleware/reporter.rb:43:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3/lib/rails/rack/logger.rb:37:in `call_app'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3/lib/rails/rack/logger.rb:28:in `call'
/var/www/discourse/config/initializers/100-quiet_logger.rb:18:in `call'
/var/www/discourse/config/initializers/100-silence_logger.rb:31:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/remote_ip.rb:81:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/request_id.rb:27:in `call'
/var/www/discourse/lib/middleware/enforce_hostname.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/method_override.rb:22:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/executor.rb:14:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/sendfile.rb:111:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/actionpack-6.0.3/lib/action_dispatch/middleware/host_authorization.rb:76:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.1/lib/mini_profiler/profiler.rb:312:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/message_bus-3.2.0/lib/message_bus/rack/middleware.rb:57:in `call'
/var/www/discourse/lib/middleware/request_tracker.rb:172:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3/lib/rails/engine.rb:527:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3/lib/rails/railtie.rb:190:in `public_send'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/railties-6.0.3/lib/rails/railtie.rb:190:in `method_missing'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/urlmap.rb:68:in `block in call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/urlmap.rb:53:in `each'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/rack-2.0.8/lib/rack/urlmap.rb:53:in `call'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.5/lib/unicorn/http_server.rb:605:in `process_client'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.5/lib/unicorn/http_server.rb:701:in `worker_loop'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.5/lib/unicorn/http_server.rb:548:in `spawn_missing_workers'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.5/lib/unicorn/http_server.rb:144:in `start'
/var/www/discourse/vendor/bundle/ruby/2.6.0/gems/unicorn-5.5.5/bin/unicorn:128:in `<top (required)>'
/var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `load'
/var/www/discourse/vendor/bundle/ruby/2.6.0/bin/unicorn:23:in `<main>'
[2020-05-16 10:09:19] Suppression des anciennes sauvegardes...
[2020-05-16 10:09:19] Nettoyage...
[2020-05-16 10:09:19] Suppression des restes de « .tar »...
[2020-05-16 10:09:19] Marquage de la sauvegarde comme terminée...
[2020-05-16 10:09:19] Actualisation des statistiques du disque...
[2020-05-16 10:09:19] Notification de la fin de la sauvegarde à « RikoDEV »...
[2020-05-16 10:09:29] Une erreur s'est produite lors de la notification à l'utilisateur.
[2020-05-16 10:09:29] Terminé !

codinghorror · Mai 16, 2020, 11:18

D’après le message d’erreur, il semble que la base de données soit corrompue ?

RikoDEV · Mai 17, 2020, 7:46

Existe-t-il un moyen de réparer cette base de données sans perdre de données ? J’ai la dernière sauvegarde il y a 2 mois et je ne veux pas perdre les sujets créés.

Falco · Mai 17, 2020, 4:25

Vous avez eu de la chance que cette table ne contienne que des statistiques Sidekiq et rien d’important. Vous pouvez essayer de supprimer les lignes de cette table, puis déclencher une nouvelle sauvegarde. Espérons que seule cette table a été affectée

RikoDEV · Mai 17, 2020, 4:45

Le problème est que PostgreSQL plante lorsque j’essaie de nettoyer cette table.

discourse=# DELETE FROM scheduler_stats;
PANIC:  pointeur d'élément corrompu : 10992
le serveur a fermé la connexion de manière inattendue
        Cela signifie probablement que le serveur s'est terminé de manière anormale
        avant ou pendant le traitement de la requête.
La connexion au serveur a été perdue. Tentative de réinitialisation : Réussie.

Falco · Mai 17, 2020, 4:53

Oh non. Un TRUNCATE sur cette table échoue-t-il aussi ?

RikoDEV · Mai 17, 2020, 4:55

TRUNCATE fonctionne, merci. . Je vais maintenant vérifier si la sauvegarde a réussi.

EDIT :

Oh non !

[2020-05-17 16:56:39] pg_dump : Échec de l'extraction du contenu de la table "post_search_data" : PQgetResult() a échoué.
[2020-05-17 16:56:39] pg_dump : Message d'erreur provenant du serveur : ERROR : page invalide dans le bloc 89 de la relation base/16384/22213
[2020-05-17 16:56:39] pg_dump : La commande était : COPY public.post_search_data (post_id, search_data, raw_data, locale, version) TO stdout ;
[2020-05-17 16:56:39] Reprendre sidekiq...
[2020-05-17 16:56:39] EXCEPTION : pg_dump a échoué
[2020-05-17 16:56:39] /var/www/discourse/lib/backup_restore/backuper.rb:183:in `dump_public_schema'

EDIT 2

Résolu en utilisant https://stackoverflow.com/questions/5220344/postgresql-invalid-page-header-in-block.

Sujet		Réponses	Vues
Repairing damaged post_search_data (unable to create database dumps and execute search reindex) Self-hosting	13	2623	Mai 2, 2019
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4767	Février 5, 2020
Backup failed due to PG/SQL errors Self-hosting	9	2410	Décembre 17, 2020
Unable to backup with error on email_logs table Self-hosting	0	548	Janvier 22, 2023
Can't restore saved backup Self-hosting	3	1262	Mars 7, 2017

Pointeur d'objet corrompu pendant le processus de sauvegarde

Sujets connexes