Symptom
- SAP IQ server configured with dbspace and associated dbfiles that has previously been correctly created and has been already successfully been used without issues.
- Client data INSERT type transactions start to fail with errors similar to:
org.springframework.dao.ConcurrencyFailureException: CallableStatementCallback; SQL [{call SCALA.LoadActualPosition(?, ?, ?, ?, ?, ?)}];
SQL Anywhere Error -1285: An IO error was encountered while writing a database page in DBSpace. Please check your IQ message file for additional information.
-- (slib/s_bufman.cxx 5608) -- Transaction rolled back; nested exception is java.sql.SQLException:
- Corresponding I/O errors messages seen in the iqmsg file:
I. 08/09 11:48:11. 0000000000 Exception Thrown from oslib/hos_bio.cxx:849, Err# 33, tid 1166 origtid 1166
I. 08/09 11:48:11. 0000000000 O/S Err#: 28, ErrID: 518 (hos_bioexception); SQLCode: -1006094, SQLState: 'QBA94', Severity: 14
I. 08/09 11:48:11. 0000000000 [20332]: Disk is or will be full on I/O to or allocation of file /pathname/of/dbfile/IQ_USER_MAIN_49
-- (oslib/hos_bio.cxx 849)
I. 08/09 11:48:11. 0000000000 Write blk 960261 for 16 blk(s) (dbBlkSz 32768)
I. 08/09 11:48:11. 0000000000 main Bufman: I/O error while writing; buffer={btype=14,nlb=16,blk=206017028,pbn=206017028,
npb=16,uid=593216,mn=1406141,upmn=1406141,flgs=0x8000000a page={btype=14,nlb=16,npb=16,ctr
I. 08/09 11:48:11. 0000000000 =131,cta=131,pbn=206017028,txn=165362221,sp=4,ver=1,pb=4,pus=3392}. slib/s_buf.cxx:2414
...
I. 08/09 11:48:11. 0001467603 Exception Thrown from slib/s_bufman.cxx:5608, Err# 0, tid 15 origtid 15
I. 08/09 11:48:11. 0001467603 O/S Err#: 0, ErrID: 2095 (s_writeexception); SQLCode: -1009171, SQLState: 'QSB67', Severity: 23
I. 08/09 11:48:11. 0001467603 [20224]: An IO error was encountered while writing a database page in DBSpace. Please check your IQ message file for additional information.
-- (slib/s_bufman.cxx 5608)
- The dbfile reported in the error is one of a number of dbfiles within the same dbspace, is defined with striping on and is mapped to a RAW device.
- The dbfile reported in the error message is online, in a read write state but is nearly fully utilized, however there is space available in other dbfiles in the dbspace which are being written to successfully without issue.
Read more...
Environment
- SAP IQ 16 any version on Unix based platforms
- Dbspaces defined with multiple DBfiles striped across raw devices
Product
Keywords
abort, sybase, disk failure, filesystem, file system, db_file, loading, writing, readwrite, update , 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.