I'm in a right pickle! Following a Base upgrade.
Following a base upgrade - database has been corrupted, then to make things worse, the database backups have been missed
Anyone any ideas where to go,
Where to start?
Is their a tool to check your db?
IntegrityError: insert or update on table "wkf_workitem" violates foreign key constraint "wkf_workitem_inst_id_fkey" DETAIL: Key (inst_id)=(11789) is not present in table "wkf_instance".
suppose "inst_id" is primary key in XYZ table.
what has happend is, the records from your XYZ table( whose foriegn key is "inst_id") has been deleted which is leading to inconsistency of data,
For the easyness you can go with new DB, but as u want to stick with current ,so 2 possible things what u can do is:
1) create records with the id showing in error (in this case 11789) in table XYZ
2) delete the records where inst_id is the id showing in error(in this case 11789) using "delete from wkf_instance where inst_id = 11789"
This issue will keep on coming until u remove all the inconsistent data
Hope this help!!
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/10/16, 6:24 AM|
|Seen: 190 times|
|Last updated: 8/10/16, 12:42 PM|