Yasunaga Kobari
kobar****@irvin*****
2007年 9月 27日 (木) 10:57:12 JST
お世話になります。 小針です。 オンラインリカバリーを実施したとき 2007-09-27 10:12:23.949 NOTICE: Going to cancel the backend (14885) 2007-09-27 10:12:23.952 ERROR: org.postgresforest.tool.recovery.RecoveryException: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request というメッセージが表示され、Phase1のリカバリーが失敗しました。 再度同じコマンド(Phase-1)を実行したところ、 org.postgresql.util.PSQLException: ERROR: trigger "administrator_logger" for relation "administrator" already exists org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block というメッセージが表示されPhase-1を実行することができませんでした。 この環境でリカバリーを続行するにはどのようにすればよろしいでしょうか？ また、原因について何かわかりますでしょうか？ 実際の実行したコマンドは以下のとおりです。 リカバリーコマンドの実行は、障害が発生したマシン上で実行しています。 よろしくお願いいたします。 $ /usr/local/forest402/bin/ForestRecovery.sh -phase1 -pass forest.987z -user forest -gsc_url jdbc:postgresql://db12:5432/gsc 1 ：１ukjjj 2007-09-27 10:11:23.754 NOTICE: RECOVERING: 2007-09-27 10:11:23.754 NOTICE: FROM [1]jdbc:postgresql://db12:5432/aaaa_admin 2007-09-27 10:11:23.755 NOTICE: TO [0]jdbc:postgresql://db11:5432/aaaa_admin 2007-09-27 10:11:23.762 NOTICE: SERVER STATUS: 2007-09-27 10:11:23.763 NOTICE: Src: Server 1, Status 1 2007-09-27 10:11:23.763 NOTICE: Dst: Server 0, Status -1 2007-09-27 10:11:23.764 NOTICE: RECOVERY_MODE = 1 2007-09-27 10:11:23.764 NOTICE: RECOVERY / INITIALIZATION 2007-09-27 10:11:23.779 NOTICE: TABLE(S) TO COPY: 2007-09-27 10:11:23.779 NOTICE: administrator 2007-09-27 10:11:23.779 NOTICE: chk_table 2007-09-27 10:11:23.78 NOTICE: client 2007-09-27 10:11:23.78 NOTICE: client_database 2007-09-27 10:11:23.78 NOTICE: client_user 2007-09-27 10:11:23.78 NOTICE: database 2007-09-27 10:11:23.78 NOTICE: env 2007-09-27 10:11:23.78 NOTICE: login 2007-09-27 10:11:23.781 NOTICE: seq 2007-09-27 10:11:23.781 NOTICE: RECOVERY / PHASE 1: start. 2007-09-27 10:11:23.781 NOTICE: GSC CHECK: 2007-09-27 10:11:23.782 NOTICE: forest_servdb, aaaa_admin: OK 2007-09-27 10:11:23.784 NOTICE: forest_tablepartdtl, administrator: OK 2007-09-27 10:11:23.784 NOTICE: forest_tablepartdtl, chk_table: OK 2007-09-27 10:11:23.785 NOTICE: forest_tablepartdtl, client: OK 2007-09-27 10:11:23.785 NOTICE: forest_tablepartdtl, client_database: OK 2007-09-27 10:11:23.786 NOTICE: forest_tablepartdtl, client_user: OK 2007-09-27 10:11:23.786 NOTICE: forest_tablepartdtl, database: OK 2007-09-27 10:11:23.787 NOTICE: forest_tablepartdtl, env: OK 2007-09-27 10:11:23.788 NOTICE: forest_tablepartdtl, login: OK 2007-09-27 10:11:23.788 NOTICE: forest_tablepartdtl, seq: OK 2007-09-27 10:11:23.859 NOTICE: Log table already exists. 2007-09-27 10:11:23.86 NOTICE: Log table already exists. 2007-09-27 10:11:23.861 NOTICE: Log table already exists. 2007-09-27 10:11:23.862 NOTICE: Log table already exists. 2007-09-27 10:11:23.863 NOTICE: Log table already exists. 2007-09-27 10:11:23.863 NOTICE: Log table already exists. 2007-09-27 10:11:23.864 NOTICE: Log table already exists. 2007-09-27 10:11:23.865 NOTICE: Log table already exists. 2007-09-27 10:11:23.894 NOTICE: COPYING ALL TABLES: start. 2007-09-27 10:11:23.894 NOTICE: CREATE SNAPSHOT: start. 2007-09-27 10:12:23.949 NOTICE: Going to cancel the backend (14885) 2007-09-27 10:12:23.952 ERROR: org.postgresforest.tool.recovery.RecoveryException: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
