Symptom
Connections are being terminated unexpectedly.
In the log:
=======
Cancellation request received: SA connHandle: xxxxxxx SA connID: 66 IQ connID: yyyyyyy User: us001
Exception Thrown from oslib/hos_clientfileio.cxx:204, Err# 9, tid 123456789 origtid 123456789
O/S Err#: 0, ErrID: 522 (hos_ioexception); SQLCode: -1006140, SQLState: 'QBB40', Severity: 14
I/O Error on file /xxxxxxxx/logs/17f666e29f93508a0d2a6c757b9b790c_0.dat.pipe
-- (oslib/hos_clientfileio.cxx 204)
temp Bufman: I/O error while reading; from slib/s_buf.cxx:1619 into buffer 0x9l992c9c4058
expected: btype=23,pbn=2241793,txn=0,sp=0,nlb=128,npb=128,iscmp=0,uid=9223372037131188353,blk=2041793,mn=1,upmn=1,flgs=0x80000000
buffer: 0x1700800080008383013522000000000000000000000000000000000001000000
Expected Pad1: 1 (0x01), Pad2: 47233 (0xb881)
Got Pad1: 0 (0x00), Pad2: 0 (0x0000)
There was an s_buf::Read() error during s_bufman::Find().
Warning: s_blockmap is throwing while user locked. bmp:0x7f9b2c021538 lockRefCount:1 created from::0 locked from:slib/s_blockmap.cxx:1373
...
...
s_blockmap::ThrowError
s_nonTranslatingBlockmap::Find
s_SerializedFileBlockmap::FindInternal
s_SerializedFileBlockmap::Find
dfo_FileSource::ScanWorkUnitIntoCache
dfo_FileSource::ScanFileForNextWork
....
....
Exception Thrown from slib/s_blockmap.cxx:6464, Err# 0, tid xxxxxxxxxxxxxxx origtid xxxxxxxxxxxxxxxx
O/S Err#: 0, ErrID: 2094 (s_readexception); SQLCode: -1009044, SQLState: 'QSA44', Severity: 23
An IO error was encountered while reading a database page in DBSpace. Please check your IQ message file for additional information.
-- (slib/s_blockmap.cxx 6464)
=======
IQ was not started with encryption, and is not using -p 65535.
Read more...
Environment
SAP IQ 16.1 SP05 PL10
Product
Keywords
connections temp Bufman IO error buffer I/O s_nonTranslatingBlockmap::Find s_SerializedFileBlockmap::FindInternal s_SerializedFileBlockmap::Find dfo_FileSource::ScanWorkUnitIntoCache dfo_FileSource::ScanFileForNextWork IO error was encountered while reading a database page in DBSpace 829507 CR 829507 CR829507 CR#829507 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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