SAP Knowledge Base Article - Preview

3372157 - SAP IQ 16.1 SP05 PL09 Network client bulk load - I/O error on file - SAP IQ

Symptom

Load table statement with using client file clause hangs.
After connection liveness timeout value expiration following I/O error is seen in .iqmsg file.

------

I. 07/26 16:24:58. 0000000000 Cancellation request received:  SA connHandle: 5950  SA connID: 133  IQ connID: 0000098209  User: loader
I. 07/26 16:24:58. 0000098209  I. 07/26 16:24:58. Exception Thrown from oslib/hos_clientfileio.cxx:204, Err# 9, tid 140000285906688 origtid 140000285906688
I. 07/26 16:24:58. 0000098209    O/S Err#: 0, ErrID: 522 (hos_ioexception); SQLCode: -1006140, SQLState: 'QBB40', Severity: 14
I. 07/26 16:24:58. 0000098209 [20378]: I/O Error on file E:\load.dat
-- (oslib/hos_clientfileio.cxx 204)
I. 07/26 16:24:58. 0000098209 \{140000285906688\} temp Bufman: I/O error while reading; from slib/s_buf.cxx:1620 into buffer 0x7f563206d230
I. 07/26 16:24:58. 0000098209 \{140000285906688\} expected: btype=23,pbn=1,txn=0,sp=0,nlb=128,npb=128,iscmp=0,uid=334979540,blk=1,mn=1,upmn=1,flgs=0x80000000
I. 07/26 16:24:58. 0000098209 \{140000285906688\} buffer: 0x1700800080008383010000000000000000000000000000000000000001000000
I. 07/26 16:24:58. 0000098209 \{140000285906688\} Expected Pad1: 1 (0x01), Pad2: 25044 (0x61d4)
I. 07/26 16:24:58. 0000098209 \{140000285906688\} Got Pad1: 0 (0x00), Pad2: 0 (0x0000)
I. 07/26 16:24:58. 0000098209 There was an s_buf::Read() error during s_bufman::Find().
I. 07/26 16:24:58. 0000098209 Warning: s_blockmap is throwing while user locked. bmp:0x7f560c62b948 lockRefCount:1 created from::0 locked from:slib/s_blockmap.cxx:1373
I. 07/26 16:24:58. 0000098209
I. 07/26 16:24:58. 0000098209     ********************************************************
I. 07/26 16:24:58. 0000098209     **
I. 07/26 16:24:58. 0000098209     **       Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
I. 07/26 16:24:58. 0000098209     **       at slib/s_blockmap.cxx:13458 on thread 140000285906688 (TIX 1100)
I. 07/26 16:24:58. 0000098209     **
I. 07/26 16:24:58. 0000098209     **  Error from IQ connection:  SA connHandle: 5950  SA connID: 133  IQ connID: 0000098209  User: loader
I. 07/26 16:24:58. 0000098209     **  Time of error:  2023-07-26 16:24:58
I. 07/26 16:24:58. 0000098209     **  IQ Version:  SAP IQ/16.1.050/13176/P/SP05.09
I. 07/26 16:24:58. 0000098209     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/../3.10.0-1160.92.1.el7.x86_64/#1 SMP Thu
 May 18 11:23:40 UTC 2023/x86_64
I. 07/26 16:24:58. 0000098209 ***************** This is the STACKTRACE ***************
I. 07/26 16:24:58. 0000098209 ===== Thread Number 140000285906688 (IQ connID: 0000098209) =====
I. 07/26 16:24:58. 0000098209 pc: 0x400e81 <unknown>
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b994ef4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b995620 ucstkgentrace(int, int)+190
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b996546 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+2c6
I. 07/26 16:24:58. 0000098209 pc: 0x7f547ba56f70 s_blockmap::ThrowError(s_bufman_errorInfo, char const*, int)+4a0
I. 07/26 16:24:58. 0000098209 pc: 0x7f547ba5875c s_nonTranslatingBlockmap::Find(unsigned long long, short, int, s_bufmanCallerStats*)+24c
I. 07/26 16:24:58. 0000098209 pc: 0x7f547ba588d9 s_SerializedFileBlockmap::FindInternal(unsigned long long, short, int, s_bufmanCallerStats*)+59
I. 07/26 16:24:58. 0000098209 pc: 0x7f547c4aafc2 s_SerializedFileBlockmap::Find(unsigned long long, short, int, s_bufmanCallerStats*)+e2
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b49b0e3 dfo_FileSource::ScanWorkUnitIntoCache(dfo_FileSource::df_FileSourceFile*, long&, long, long&, long&, int&, s_bufmanCall
erStats*)+103
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b49e8dc dfo_FileSource::ScanFileForNextWork(int, int, long&, long, long&, int&, db_RecScanner*)+84c
I. 07/26 16:24:58. 0000098209 pc: 0x7f547c3d70a7 s_FileOffsetWorkAllocator::AssignNextWork_Unlocked(unsigned int, unsigned int)+e7
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b435d6c df_CombinerFetchContext::PrepareForNextWorkUnit_Unlocked(int, unsigned int)+7c
I. 07/26 16:24:58. 0000098209 pc: 0x7f547c366dcd hc_dmfrun::InitNextWorkUnit(hc_dfrun*&, int&, int, int, unsigned int)+1bd
I. 07/26 16:24:58. 0000098209 pc: 0x7f547c49e7b4 hc_dmfrun::InitNextWorkUnit(unsigned int, int, unsigned int)+4c4
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b96b304 workAllocator::DoWork(unsigned int)+c4
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b98a999 hos_thread::Main()+209
I. 07/26 16:24:58. 0000098209 pc: 0x7f547b8fe319 hos_lwtask::Start(hos_lwtask*)+69
I. 07/26 16:24:58. 0000098209 pc: 0x7f58d19d84fe IQWorkerStarter(void*)+3e
I. 07/26 16:24:58. 0000098209 pc: 0x7f58d20ee93e run_task_body+1e
I. 07/26 16:24:58. 0000098209 pc: 0x7f58d1ca87b8 UnixTask::pre_body(void*)+78
I. 07/26 16:24:58. 0000098209 pc: 0x7f58d146cea5 <unknown>
I. 07/26 16:24:58. 0000098209 pc: 0x7f58d0987b0d <unknown>
I. 07/26 16:24:58. 0000098209 ******************* End of STACKTRACE ******************
I. 07/26 16:24:58. 0000098209     **
I. 07/26 16:24:58. 0000098209     **       End of informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap
I. 07/26 16:24:58. 0000098209     **
I. 07/26 16:24:58. 0000098209     ********************************************************
I. 07/26 16:24:58. 0000098209
I. 07/26 16:24:58. 0000098209  I. 07/26 16:24:58. Exception Thrown from slib/s_blockmap.cxx:6464, Err# 0, tid 140000285906688 origtid 140000285906688
I. 07/26 16:24:58. 0000098209    O/S Err#: 0, ErrID: 2094 (s_readexception); SQLCode: -1009044, SQLState: 'QSA44', Severity: 23
I. 07/26 16:24:58. 0000098209 [20065]: An IO error was encountered while reading a database page in  DBSpace. Please check your IQ message file for additional informati
on.
-----


Read more...

Environment

  • SAP IQ 16.1 Network client
  • SAP 16.1 SP04+

Keywords

s_nonTranslatingBlockmap::Find , s_SerializedFileBlockmap::FindInternal , s_SerializedFileBlockmap::Find, , 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.