Symptom
Too many checkpoints have been executed at intervals of about 3 or 4 seconds on secondary node.
Normal transaction processings are blocked due to handling excessive checkpoints. An ev_begintxn session has been lasted for about 3 hours at that time.
This situation caused abnormal status on secondary node for a long while.
[srvlog]
I. 06/30 12:20:10. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
I. 06/30 12:20:10. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
I. 06/30 12:20:16. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
I. 06/30 12:20:16. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
...
...
I. 06/30 12:20:58. Starting checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
I. 06/30 12:20:58. Finished checkpoint of "IQ_S1" (IQ_S1.db) at Mon Jun 30 20XX 12:20
[iqmsg]
I. 06/30 12:15:47. 0000000139 Connect: SA connHandle: 1000000127 SA connID: 22 IQ connID: 0000000139 User: dbo
I. 06/30 12:15:47. 0000000139 ev_begintxn started
...
I. 06/30 12:16:29. 0000000139 Chk
I. 06/30 12:16:29. 0000000139 ChkDone [NumTxnCP: 6]
I. 06/30 12:16:29. 0000000139 PostChk
...
I. 06/30 12:16:34. 0000000139 Chk
I. 06/30 12:16:34. 0000000139 ChkDone [NumTxnCP: 6]
I. 06/30 12:16:34. 0000000139 PostChk
...
I. 06/30 15:06:55. 0000000139 Disconnect: SA connHandle: 1000000127 SA connID: 22 IQ connID: 0000000139 User: dbo
Read more...
Environment
- SAP IQ 12.7
- SAP IQ 15.x
- SAP IQ 16.x
Product
Keywords
ev_begintxn, checkpoint, grant , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview