[postgresforest-users 82] Going to cancel the backend Message

Back to archive index

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 :1ukjjj
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




postgresforest-users メーリングリストの案内
Back to archive index