Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

DB errors with AO_78C957_AUDITEVENTS

Simon Gao
Simon Gao April 23, 2013

Hi,

I found following errors logged by PostgreSQL server:

2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732217) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732217) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732218) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732218) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:50 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: DETAIL:  Key (AUDIT_EVENT_ID)=(732220) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: DETAIL:  Key (AUDIT_EVENT_ID)=(732220) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:23:52 PDT:192.168.1.15(42249):jiradbuser@jiradb:[5148]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732888) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(732888) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:28:08 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(733545) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: ERROR:  insert or update on table "AO_78C957_AUDITHINT" violates foreign key constraint "fk_ao_78c957_audithint_audit_event_id"
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: DETAIL:  Key (AUDIT_EVENT_ID)=(733545) is not present in table "AO_78C957_AUDITEVENTS".
2013-04-23 11:32:48 PDT:192.168.1.15(44000):jiradbuser@jiradb:[8463]: STATEMENT:  UPDATE public."AO_78C957_AUDITHINT" SET "VALID_VALUES" = $1,"HINT_TEXT" = $2,"AUDIT_EVENT_ID" = $3,"EXCEPTION_STACK" = $4,"PROVIDED_VALUE" = $5,"CAUSED_REJECTION" = $6,"CREATED" = $7 WHERE "ID" = $8

Please advise on how to fix such issue.

Thanks,

Simon

Answer
Watch
Like Be the first to like this
400 views

2 answers

0 votes
Andy Brook [Plugin People]
Andy Brook [Plugin People]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 23, 2013

Hi Simon,

The above seems to be a Hint failing to be written as the related AuditEvent was not found. Its unclear what caused that. Can you please create a JIRA issue and attach a logfile for the time this occurred, as well as your current schema for the AUDIT_* tables, so I can review an determine if any changes are required?

@Danial, please consdier posting links to the related issue tracker for the product, address deatils are not very helpful unelss someone is going to come visiting ;)

View More Comments
AhmadDanial
AhmadDanial
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 23, 2013

Hey there, Andy.

Thanks for the heads up. I will definitely take note of that. :)

Warm regards,

Danial

Like
Reply
0 votes
AhmadDanial
AhmadDanial
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 23, 2013

Hey there, Simon.

As far as the error is concerned, I recommend you to contact the plugin vendor directly to address the problem that you are facing with the plugin usage:

  1. Plugin: The Plugin People for Enterprise Mail Handler

Warm regards,

Danial

Reply

Suggest an answer

Log in or Sign up to answer
Product apps
Apps & Integrations
TAGS
AUG Leaders

Atlassian Community Events

    See all events