Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Database Errors on one Node of a Cluster

Created: 25 Jan 2011 | 2 comments
Tom Mc's picture

RECENTLY RESOLVED

Problem:
We've just started noticing these errors appearing in the database logs on the secondary node of a two node PGP Universal Server configuration;

2010/12/01 00:00:09 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(e90f599a-2b54-437c-b885-2a6f04abdd5f) i
s not present in table "internal_user".
2010/12/01 00:00:09 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(adaf80c7-5cbd-44d3-9ef3-56c7c2359035) i
s not present in table "internal_user".
2010/12/01 00:00:09 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(25ad2515-49ee-4eda-b104-ba04eb6e1bba) i
s not present in table "internal_user".
2010/12/01 00:00:10 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(adafe6be-144e-4dd2-b32d-9adcfb60e09d) i
s not present in table "internal_user".
2010/12/01 00:00:10 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(ede56c07-393c-45f3-b2de-aad6f0f88a8b) i
s not present in table "internal_user".
2010/12/01 00:00:10 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(77e5d4e4-386d-4983-8dec-4a1726d6b13b) i
s not present in table "internal_user".
2010/12/01 00:00:10 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: database error finishing transaction: ERROR:  insert or update on table "internal_use
r_key" violates foreign key constraint "internal_user_key_internal_user_uuid_fkey" DETAIL:  Key (internal_user_uuid)=(9aa17c35-0e33-4d49-9ea8-d2f6280b4efd) i
s not present in table "internal_user".
2010/12/01 00:00:10 +00:00  ERROR  pgp/cluster[2990]:    REPRECV-00000: replication message <ReplicateInternalUser> returning fault -11980 (unknown error)

We first noticed a problem yesterday when mail stopped passing through the secondary PGP node so we had to transfer everything through the primary node.  Can anyone give me any hints as to how to fix these errors in the database, or will we have to rebuild it?
All help appreciated.

Resolution:
PGP Technical Support couldn't in fact offer any advice other than to re-install the server, which I have since done.
 

Comments 2 CommentsJump to latest comment

bnilsson's picture

Hi Tom. Just curious - what versions of the uni was this, and did you do a cluster separation and rejoined them?

Tom Mc's picture

This was a summary of a recently resolved (at the time of the transition of the forum from PGP Corp to Symantec) topic.  The purpose of the summary was to make it available to users of the new forum.  I don't have any more information to offer on this.

When you consider your issue resolved, please click Mark As Solution on the most helpful response.

Search the Knowledge Base &