Symptom
* Problem :
All Secondary server(**AR1, ...) got crashed after about 70 dbfiles were added in coordinator server.
It looked **AR1 server met this crash first, while replaying TLVlog.
Other Secondary servers (**AW1) looked to complete TLV reply, but thie server became crash too.
After the Secondary servers became crash, DBA tried to re-start servers.
But all Secondary would not bring up and finally sync process was executed and brought up well.
* IQMSG
- INVALID_DBSPACE error is shown in iqmsg file(**AR1).
It looked DBFile "/.../rdat47004" seemed to heva I/O problem.
But the 'rdat47004' dbfile was created as a main db file on 2016-02-07 02:51:34.00.
There was no reason why this dbfile was printed.
I. 02/22 18:19:48. 0000110413 Connect: SA connHandle: 1000107128 SA connID: 84 IQ connID: 0000110413 User: dbo
I. 02/22 18:19:48. 0000110413 ev_begintxn started
...
I. 02/22 18:19:48. 0000110413 Read2 blkno 890818473 for 16 block(s) (dbBlkSz 8192) File: /.../rdat47004
I. 02/22 18:19:48. 0000110413 main Bufman: I/O error while reading; from slib/s_buf.cxx:1309
...
I. 02/22 18:19:48. 0000110413 **************************************************
I. 02/22 18:19:48. 0000110413 *** SAP IQ Abort:
I. 02/22 18:19:48. 0000110413 *** From: slib/s_blockmap.cxx:5645
I. 02/22 18:19:48. 0000110413 *** PID: 18494
I. 02/22 18:19:48. 0000110413 *** Exception Location: 0x9ffffffe6dd36610
I. 02/22 18:19:48. 0000110413 *** Error ID: 2094, Exception Type: s_readexception
I. 02/22 18:19:48. 0000110413 *** Thread: 136 (TID: 15, Original TID: 15)
I. 02/22 18:19:48. 0000110413 *** Error #: 0, O/S Error #: 0
I. 02/22 18:19:48. 0000110413 *** Argument: -- (slib/s_blockmap.cxx 5645)
I. 02/22 18:19:48. 0000110413 *** Argument: INVALID_DBSPACE
I. 02/22 18:19:48. 0000110413 **************************************************
Read more...
Environment
IQ 16.0 SP10.08
Product
Keywords
"s_blockmap.cxx" ; "INVALID_DBSPACE" ; "db_catReplRow" ; "UpdateCatalogFromReplRows" ; , 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.