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
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 ;)
Hey there, Andy.
Thanks for the heads up. I will definitely take note of that. :)
Warm regards,
Danial
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Warm regards,
Danial
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.