SAP Knowledge Base Article - Preview

2779148 - Frequent error "Statement terminated to prevent potential deadlock" while DMLs are running IQ16.1 -- SAP IQ

Symptom

Customer informed that this error could be often produced when some DML jobs were executed, rather than a specific job was running. It seems that this is an expected behavior by the fix for CR 809642 which was delivered with SP02.02 but customer wants to know how to avoid this error.
Before the error, there was not any memory related message or error at all.

* lots of jobs failed with following error pattern.


*.iqmsg(iqconnid 0000303101)
...
I. 04/08 02:53:58. 0000303101 Txn 125546018 0 125546018
I. 04/08 03:27:20. 0000303101 [bmp-trace-tout][rpbid] tid:333078 bmp:0x82017b0c8 lbn:41558 next-lbn:41559 pbn:210095119 nb: compr?1 updateNext?0
I. 04/08 03:27:20. 0000303101 Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=333078
...
I. 04/08 03:27:40. 0000303101 [bmp-trace-tout][rpbid] tid:333078 bmp:0x82017b0c8 lbn:15090 next-lbn:15091 pbn:140463514 nb: compr?1 updateNext?0
I. 04/08 03:27:40. 0000303101 Warning, s_bufpartition::GetCleanPage is aborting to avert a potential deadlock after 3 failed tries, tid=333078
...
I. 04/08 03:27:41. 0000303101 Exception Thrown from slib/s_blockmap.cxx:13507, Err# 11, tid 122 origtid 1296
I. 04/08 03:27:41. 0000303101 O/S Err#: 0, ErrID: 2055 (s_bufman_exception); SQLCode: -1009204, SQLState: 'QSC01', Severity: 14
I. 04/08 03:27:41. 0000303101 [22257]: Statement terminated to prevent potential deadlock. Try again.
-- (slib/s_blockmap.cxx 13507)
I. 04/08 03:27:42. 0000303101 Cmt 125546778
I. 04/08 03:27:42. 0000303101 TINFO t=125546018 v=125546018 c=125546778 gt=0 gc=0 pcv=0 ME=0 MSE=0 TRR=0 #=0
I. 04/08 03:27:42. 0000303101 Disconnect: SA connHandle: 13892 SA connID: 62 IQ connID: 0000303101 User: dwwork


Read more...

Environment

 SAP IQ 16.1 SP02.x

Product

SAP IQ 16.1

Keywords

's_bufpartition::GetCleanPage' , 's_blockmap.cxx' , 'potential deadlock after 3 failed tries' , 'potential deadlock' , , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.