Subject Re: [IBO] E_Record_Not_Located_For_Update error
Author rsaeger.edv@t-online.de
--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> The SQL monitor may reveal some helpful hints.

Jason,

this is the monitor output:

/*---
COMMIT
TR_HANDLE = 15539408

SECONDS = 0,031
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15539808
STMT_HANDLE = 15539480

SELECT RDB$DB_KEY
, TARAZ
, TAGAZ
, BEZPAUSE
, ZULSS
, ZULNS
, GUTSCHNS
, ZULUEB1
, ZULUEB2
, STDAT1
, STDSA1
, ZULSO
, ZULF1
, ZULF2
, JAHRRS
, MONAZ
, ZUL19
FROM TARIF
WHERE TARIF.RDB$DB_KEY=? /* BIND_0 */
FOR UPDATE

PLAN (TARIF INDEX ())

FIELDS = [ Version 1 SQLd 17 SQLn 17
TARIF.DB_KEY = DB_KEY $8000000001000000
TARIF.TARAZ = 6
TARIF.TAGAZ = 7
TARIF.BEZPAUSE = 0,25
TARIF.ZULSS = 5
TARIF.ZULNS = 20
TARIF.GUTSCHNS = 0,2667
TARIF.ZULUEB1 = 25
TARIF.ZULUEB2 = 50
TARIF.STDAT1 = 2
TARIF.STDSA1 = 4
TARIF.ZULSO = 50
TARIF.ZULF1 = 100
TARIF.ZULF2 = 200
TARIF.JAHRRS = 0
TARIF.MONAZ = 0
TARIF.ZUL19 = 0 ]
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15539808
STMT_HANDLE = 15539276

UPDATE TARIF
SET TARAZ = ? /* TARAZ */
, TAGAZ = ? /* TAGAZ */
, BEZPAUSE = ? /* BEZPAUSE */
, ZULSS = ? /* ZULSS */
, ZULNS = ? /* ZULNS */
, GUTSCHNS = ? /* GUTSCHNS */
, ZULUEB1 = ? /* ZULUEB1 */
, ZULUEB2 = ? /* ZULUEB2 */
, STDAT1 = ? /* STDAT1 */
, STDSA1 = ? /* STDSA1 */
, ZULSO = ? /* ZULSO */
, ZULF1 = ? /* ZULF1 */
, ZULF2 = ? /* ZULF2 */
, JAHRRS = ? /* JAHRRS */
, MONAZ = ? /* MONAZ */
, ZUL19 = ? /* ZUL19 */
WHERE CURRENT OF C1340626429044393 <<<<<<<<<<<<<<<<<

PLAN (TARIF INDEX ())

FIELDS = [ Version 1 SQLd 0 SQLn 0 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15539808
STMT_HANDLE = 15539276
PARAMS = [ Version 1 SQLd 16 SQLn 16
TARIF.TARAZ = 8
TARIF.TAGAZ = 7
TARIF.BEZPAUSE = 0,25
TARIF.ZULSS = 5
TARIF.ZULNS = 20
TARIF.GUTSCHNS = 0,2667
TARIF.ZULUEB1 = 25
TARIF.ZULUEB2 = 50
TARIF.STDAT1 = 2
TARIF.STDSA1 = 4
TARIF.ZULSO = 50
TARIF.ZULF1 = 100
TARIF.ZULF2 = 200
TARIF.JAHRRS = 0
TARIF.MONAZ = 0
TARIF.ZUL19 = 0 ]

ERRCODE = 335544336
----*/
/*---
INTERPRETE BUFFER =

SECONDS = 0,025

ERRCODE = 8
----*/
/*---
INTERPRETE BUFFER = deadlock

ERRCODE = 39
----*/
/*---
INTERPRETE BUFFER = update conflicts with concurrent update

ERRCODE = -1
----*/

Look at the line I marked with <<<<<<<<<<<<<<<<<.
What does it mean?
And what should I do to avoid it?

Thanks
Richard