i have encoutered this problem twice. I have this table "produce"
which have after insert trigger. What the trigger does is to update
the record on table "items". The problem is that after saving the
records and I use savepoint like
this "produce.ib_transaction.savepoint" to commit the work. After
closing and re opening the table "produce" all the recently entered
record where gone, but if I take a look at the table "items" I see
that their is a change that take place, meaning the trigger on the
table "produce" after insert where trigger but the record where not
save.

What happen here? I didn't use cache update here, what else should I
check for?

Although this happen very rare. But is it very annoying, because this
is a inventory application where it must be very accurate.