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.
SAP Knowledge Base Article - Preview