SAP Knowledge Base Article - Preview

2794932 - Backup database command crashed with s_globalFLrequestexception exception -- SAP IQ

Symptom

Backup database command crashes coordinator with function stack like this.
----
s_blockmap::CreateDontZero
s_scratchPage::CreateBuf
v2s_bmcontext::bmlev1sgblkalloc
v2s_bmcontext::bmint
s_bm::And
s_dbmvbio::CalcFullBackupBM
s_iqstore::CalcFullBackupBM
db_backupMgr::CalcBackupBlocksIfNecessary
st_database::CheckpointComplete
st_txnMgr::Checkpoint
----

sp_iqcheckdb does not detect any problems.
dbspace 32703 belongs to IQ_SHARED_TEMP.
Even if every dbfile in  IQ_SHARED_TEMP is dropped, backup database keeps crashing.

Error messages in IQ diagnostic files look like these.

---- iqmsg ( Timestamp - MM/YY HH:MM:SS , 10 digit IQ Connection ID - 9999999999 )

I. MM/YY HH:MM:SS. 9999999999 ValidateBackup
I. MM/YY HH:MM:SS. 9999999999 Chk
I. MM/YY HH:MM:SS. 9999999999 Failure on privileged blockmap ; _blockmap @ 0x7faee800bba8
I. MM/YY HH:MM:SS. 9999999999 Blockmap Member Variables for 0x7faee800bba8
I. MM/YY HH:MM:SS. 9999999999 From dblib/db_backupID.cxx:997
I. MM/YY HH:MM:SS. 9999999999   _nextPartitionForHelperFlush = 0
I. MM/YY HH:MM:SS. 9999999999                   IsEBufNoWait = 0
I. MM/YY HH:MM:SS. 9999999999                IsProxyFreelist = 0
I. MM/YY HH:MM:SS. 9999999999                 _OrigRootBlock = 0
I. MM/YY HH:MM:SS. 9999999999                           _Bio = 0x7faecc045d58
I. MM/YY HH:MM:SS. 9999999999                     _tempSpace = 0x7faecc282e08
I. MM/YY HH:MM:SS. 9999999999                        _Bufman = 0x7faecc2f6248 temp Bufman
I. MM/YY HH:MM:SS. 9999999999             _allocFromLastLink = 0
I. MM/YY HH:MM:SS. 9999999999                        _isMeta = 0
I. MM/YY HH:MM:SS. 9999999999                   _m_dbspaceID = 32703
I. MM/YY HH:MM:SS. 9999999999                     _dbspaceID = 32703

...

I. MM/YY HH:MM:SS. 9999999999                        _psuAll = 0
I. MM/YY HH:MM:SS. 9999999999 [s_blockmap_identity]
I. MM/YY HH:MM:SS. 9999999999 _UniqueId: 8998599
I. MM/YY HH:MM:SS. 9999999999 _RootBlockId: 0
I. MM/YY HH:MM:SS. 9999999999 _NEntries: 0
I. MM/YY HH:MM:SS. 9999999999 _LastWriterTxnId: 0
I. MM/YY HH:MM:SS. 9999999999 _LastWriterSavePoint: 0
I. MM/YY HH:MM:SS. 9999999999 _FanOutAndFlags2: 0x0
I. MM/YY HH:MM:SS. 9999999999 _Flags: 0x21
I. MM/YY HH:MM:SS. 9999999999 _Version: 1
I. MM/YY HH:MM:SS. 9999999999 _NLinks: 0
I. MM/YY HH:MM:SS. 9999999999 _EntriesPerLink: 0
I. MM/YY HH:MM:SS. 9999999999 _FirstAvailLink: 0
I. MM/YY HH:MM:SS. 9999999999 _MaxLink: 0
I. MM/YY HH:MM:SS. 9999999999 _ModNum: 2
I. MM/YY HH:MM:SS. 9999999999 _RootModNum: 1
I. MM/YY HH:MM:SS. 9999999999 [end s_blockmap_identity]
...
I. MM/YY HH:MM:SS. 9999999999 **************************************************
I. MM/YY HH:MM:SS. 9999999999 ***   SAP IQ Abort:
I. MM/YY HH:MM:SS. 9999999999 ***      From:  slib/s_blockmap.cxx:6014
I. MM/YY HH:MM:SS. 9999999999 ***      Rethrown from:  oslib/hos_throw.cxx:313
I. MM/YY HH:MM:SS. 9999999999 ***      PID: 65258
I. MM/YY HH:MM:SS. 9999999999 ***      Exception Location: 0x0x7faf652b3050
I. MM/YY HH:MM:SS. 9999999999 ***      Error ID: 2110,  Exception Type: s_globalFLrequestexception

----- stktrc-YYYYMMDD-HHMMSS_1.iq

    **  Error from IQ connection:  SA connHandle: .  SA connID: ..  IQ connID: 9999999999  User: .    **  Time of error:  YYYY-MM-DD HH:MM:SS    **  IQ Version:  SAP IQ/16.0.110/11355/P/sp11.20    **  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/../3.10.0-693.44.1.el7.x86_64/#1 SMP Tue Jan 22 16:32:19 UTC 2019/x86_64    **  Command status when error occured:  COMMAND ACTIVE    **  Command text:

backup database full to '/var/hostlinks/sybaseiq/BACKUPS/FILES/FULL_BACKUP_MPX' size 2048000

Dump all thread stacks at slib/s_blockmap.cxx:6014 for PID: 183225

    ***************** This is the STACKTRACE ***************

===== Thread Number  139781149095680  (IQ connID: 9999999999) =====

pc: 0x7f20d97fe4a2 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
pc: 0x7f20d97feb11 ucstkgentrace(int, int)+0x121
pc: 0x7f20d9801143 DumpAllThreads(char const*, unsigned int, int)+0x273
pc: 0x7f20d9574e0b hos_ABORT(char const*, unsigned int, hos_exception const&, char*, char*, sigcontext*)+0x43b
pc: 0x7f20d97ddd5c Throw(hos_exception const&)+0x3fc
pc: 0x7f20d98990b8 s_blockmap::ThrowError(s_bufman_errorInfo, char const*, int)+0x238
pc: 0x7f20d98c3b2c s_blockmap::CreateDontZero(short, int, hos_cmprstype, unsigned int, unsigned int)+0x43c
pc: 0x7f20da0e90ba s_scratchPage::CreateBuf()+0x4a
pc: 0x7f20da26d46a v2s_bmcontext::bmlev1sgblkalloc(int, int)+0x2fa
pc: 0x7f20da27eec6 v2s_bmcontext::bmint(s_bm*, s_bm const&, s_bm const&)+0x206
pc: 0x7f20d98e99b3 s_bm::And(s_bm const&, s_bm const&)+0x5d3
pc: 0x7f20d9a16236 s_dbmvbio::CalcFullBackupBM(s_bm*)+0xd6
pc: 0x7f20d9f1abc7 s_iqstore::CalcFullBackupBM(s_bm*)+0x27
pc: 0x7f20da447a16 db_backupMgr::CalcBackupBlocksIfNecessary()+0x336
pc: 0x7f20da336dc2 st_database::CheckpointComplete()+0x42
pc: 0x7f20db651be1 st_txnMgr::Checkpoint(st_database*, unsigned long long*)+0xb23
pc: 0x7f20da525bb3 db_Checkpoint::Execute()+0x233
pc: 0x7f20da2fbc92 st_command::DoCmdThroughResourceGate()+0x82
pc: 0x7f20da350493 st_iqtxn::Checkpoint(UIDatabase*, unsigned long long*)+0x23


Read more...

Environment

IQ 16.x

Product

SAP IQ 16.0

Keywords

s_blockmap::CreateDontZero , s_scratchPage::CreateBuf , backup , multiplex , coordinator , logical server , s_globalFLrequestexception , _dbspaceID = 32703 , Failure on privileged blockmap , IQ_SHARED_TEMP , 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.