SAP Knowledge Base Article - Preview

2716055 - sp_iqcheckdb verify cause IQ_SYSTEM_TEMP full and error s_bufpartition::GetCleanPage is retrying to avert a potential deadlock - SAP IQ

Symptom

On SAP IQ 16.1 SP 02 run sp_iqcheckdb verify on the database on a table could fail with errors:

Warning, s_bufpartition::GetCleanPage is retrying to avert a potential deadlock, retry=1, tid=584
Warning: s_dbmvbio::Allocate has timed out on _proxyFLcv inside tid:584
Warning: s_dbmvbio::Allocate has timed out on _proxyFLcv inside tid:5636

Exception Thrown from slib\s_blockmap.cxx:6062, Err# 0, tid 690 origtid 690
O/S Err#: 0, ErrID: 2096 (s_nodbspaceexception); SQLCode: -1009170, SQLState: 'QSB66', Severity: 14
You have run out of space in IQ_SYSTEM_TEMP DBSpace. Current DBSpace size is 983040MB.
-- (slib\s_blockmap.cxx 6062)


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

CR 817329, CR#817329, 817329, "SQLCode: -1009170", s_nodbspaceexception, s_dbmvbio::Allocate, _proxyFLcv, , 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.