Should I just use -nosavepoint and be done with it ?

Posted by Etienne Begin on 23-Mar-2016 15:32

Hi!

OE 10.2B08 HP UX B.11.31 U ia64

We have occurrences of error 1422, they are frequent enough to bother some people.  Can I just use -nosavepoint.. is this an acceptable solution ?

I can reproduce the 1422 error at will.  I have a backup of the source that causes the issue as well as the DB.  Problem is that I simply don't have time skim the code down to a point where I can turn it into usable evidence by PSC Support.  I have proven that -nosavepoint prevents the 1422 from occuring.

I will try to get 11.5.1 on the server (we are being hosted this will take time) and see if I can reproduce with that version. 

Should I just use -nosavepoint ?

Etienne

All Replies

Posted by Etienne Begin on 07-Apr-2016 11:49

Upgrading to 10.2B0836 hotfix solved the problem.

KB:

knowledgebase.progress.com/.../Index-corruption-undoing-sub-transactions-when-multiple-databases-are-involved

If 1422 occurs again and not hotfix, we'll have to consider -nosavepoint again.

Etienne.

This thread is closed