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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.