Sybase IQ 16 SP 08.32,problems with concurrent operations
Hi, i´m facing a problen with a project that involves multiple concurrent inserts and updates on a IQ table, i have read that in sybase IQ 16 you have the "blocking" option to deal with this, so we turned it on , but we are still facing the problem, the message says this :
transaction <number> attempted to access <table name> created by transaction <number>.
We tried with the default value (0 for indefinied) for the blocking_timeout option, as well as a very large value (100000) but still no luck,does anything else needs to be configurated for the "blocking" option to work?
Then we also tried with the RLV(row level versioning) aplied to this table, and it seemed to work well, however sometimes(and sometimes don´t) the Insert statements returns 2 duplicate values for the primary key(identity column).
For the problem of the duplicate identity column, we found the note "2208642 - SAP IQ: duplicate insert issue with RLV table" ,this note mentions an error that is very similar to mine and says that it is fixed in IQ 16 sp 10.03, but wen we go to service.sap to downloads, we can´t find this version ,the last one is :16.0 SP10 PL02 -> IQSERV160010P_2-20011184.ZIP EBF 25000 .
The inserts and updates have been tested outside stored procedures, inside stored procedures, with "commits" at the end, with commits at the beggining and we could not make it work.
Does anybody has any suggestions?