i had this message appear and i resolved this issue by using multiple transactions .. this is not the most desirable solution, however it works.
originally i was deleting and re-inserting the same record in one transaction. this seems to confuse the primary cache. i changed this so that the deletion occurred in one transaction, then the insertion occurred in the 2nd transaction.
the reason this is not desirable is that if the 2nd transaction fails, i don't want the deletion (1st transaction) to be committed, however it already has been committed.
i suppose a better (still not totally desirable) solution in my case would be to *not* delete the record in the first place if it is to be re-inserted. this is undesirable as it makes my code somewhat more complicated.
i hope this gives you some insight to solving your problem.
paul.
|