IQ Server stacktrace after restore
298 views
Skip to first unread message
Sedick Clarke
Feb 24, 2011, 2:18:03 AM2/24/11
to iq...@googlegroups.com, iq...@dssolutions.com
Hi,
I have restored an IQ 12.7 ESD#5 Server from a full backup (to nfs share) to the same machine.
When I started it up after the restore the following happened :
Starting server newiq_w1 on newiq at port 5000 (02/24 08:00:22)
Run Directory : /newiq/newiq_w1
Server Executable : /opt/sybase/ASIQ-12_7/bin/asiqsrv12
Server Output Log : /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log
Server Version : 12.7.0/ESD 5
Open Client Version : 15.0/P-EBF13571 ESD #4
User Parameters : '@params.cfg' './newiq_w1.db'
Default Parameters : -hs -gn 35
Server Executable : /opt/sybase/ASIQ-12_7/bin/asiqsrv12
Server Output Log : /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log
Server Version : 12.7.0/ESD 5
Open Client Version : 15.0/P-EBF13571 ESD #4
User Parameters : '@params.cfg' './newiq_w1.db'
Default Parameters : -hs -gn 35
I. 02/24 08:00:23. 1: -n
I. 02/24 08:00:23. 2: newiq_w1
I. 02/24 08:00:23. 3: -x
I. 02/24 08:00:23. 4: tcpip{port=5000}
I. 02/24 08:00:23. 5: -c
I. 02/24 08:00:23. 6: 48m
I. 02/24 08:00:23. 7: -gc
I. 02/24 08:00:23. 8: 20
I. 02/24 08:00:23. 9: -gd
I. 02/24 08:00:23. 10: all
I. 02/24 08:00:23. 11: -gl
I. 02/24 08:00:23. 12: all
I. 02/24 08:00:23. 13: -gm
I. 02/24 08:00:23. 14: 30
I. 02/24 08:00:23. 15: -gp
I. 02/24 08:00:23. 16: 4096
I. 02/24 08:00:23. 17: -ti
I. 02/24 08:00:23. 18: 4400
I. 02/24 08:00:23. 19: -iqmc
I. 02/24 08:00:23. 20: 8000
I. 02/24 08:00:23. 21: -iqtc
I. 02/24 08:00:23. 22: 12000
I. 02/24 08:00:23. 23: -s
I. 02/24 08:00:23. 24: none
I. 02/24 08:00:23. 25: -zr
I. 02/24 08:00:23. 26: SQL
I. 02/24 08:00:23. 27: -zo
I. 02/24 08:00:23. 28: /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_sql.log
I. 02/24 08:00:23. 29: -o
I. 02/24 08:00:23. 30: /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log
I. 02/24 08:00:23. 31: -z
I. 02/24 08:00:23. 32: ./newiq_w1.db
I. 02/24 08:00:23. 33: -hs
I. 02/24 08:00:23. 34: -gn
I. 02/24 08:00:23. 35: 35
I. 02/24 08:00:23. 36: -hn
I. 02/24 08:00:23. 37: 8
I. 02/24 08:00:23.
I. 02/24 08:00:23. Adaptive Server IQ
I. 02/24 08:00:23. Version 12.7
I. 02/24 08:00:23. (64bit mode)
I. 02/24 08:00:23. Copyright 1992-2008 by Sybase, Inc. All rights reserved
I. 02/24 08:00:23.
I. 02/24 08:00:23. 8 physical processor(s) detected.
I. 02/24 08:00:23. Running on Linux 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 ED T 2006 x
I. 02/24 08:00:24. 49152K of memory used for caching
I. 02/24 08:00:24. Minimum cache size: 49152K, maximum cache size: 262012K
I. 02/24 08:00:24. Using a maximum page size of 4096 bytes
I. 02/24 08:00:24. Starting database "newiq_w1" (/newiq/newiq_w1/newiq_w1.db) at Thu Feb 24 2011 08:00
I. 02/24 08:00:24. Database recovery in progress
I. 02/24 08:00:24. Last checkpoint at Tue Feb 22 2011 09:06
I. 02/24 08:00:24. Checkpoint log...
I. 02/24 08:00:23. 2: newiq_w1
I. 02/24 08:00:23. 3: -x
I. 02/24 08:00:23. 4: tcpip{port=5000}
I. 02/24 08:00:23. 5: -c
I. 02/24 08:00:23. 6: 48m
I. 02/24 08:00:23. 7: -gc
I. 02/24 08:00:23. 8: 20
I. 02/24 08:00:23. 9: -gd
I. 02/24 08:00:23. 10: all
I. 02/24 08:00:23. 11: -gl
I. 02/24 08:00:23. 12: all
I. 02/24 08:00:23. 13: -gm
I. 02/24 08:00:23. 14: 30
I. 02/24 08:00:23. 15: -gp
I. 02/24 08:00:23. 16: 4096
I. 02/24 08:00:23. 17: -ti
I. 02/24 08:00:23. 18: 4400
I. 02/24 08:00:23. 19: -iqmc
I. 02/24 08:00:23. 20: 8000
I. 02/24 08:00:23. 21: -iqtc
I. 02/24 08:00:23. 22: 12000
I. 02/24 08:00:23. 23: -s
I. 02/24 08:00:23. 24: none
I. 02/24 08:00:23. 25: -zr
I. 02/24 08:00:23. 26: SQL
I. 02/24 08:00:23. 27: -zo
I. 02/24 08:00:23. 28: /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_sql.log
I. 02/24 08:00:23. 29: -o
I. 02/24 08:00:23. 30: /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log
I. 02/24 08:00:23. 31: -z
I. 02/24 08:00:23. 32: ./newiq_w1.db
I. 02/24 08:00:23. 33: -hs
I. 02/24 08:00:23. 34: -gn
I. 02/24 08:00:23. 35: 35
I. 02/24 08:00:23. 36: -hn
I. 02/24 08:00:23. 37: 8
I. 02/24 08:00:23.
I. 02/24 08:00:23. Adaptive Server IQ
I. 02/24 08:00:23. Version 12.7
I. 02/24 08:00:23. (64bit mode)
I. 02/24 08:00:23. Copyright 1992-2008 by Sybase, Inc. All rights reserved
I. 02/24 08:00:23.
I. 02/24 08:00:23. 8 physical processor(s) detected.
I. 02/24 08:00:23. Running on Linux 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 ED T 2006 x
I. 02/24 08:00:24. 49152K of memory used for caching
I. 02/24 08:00:24. Minimum cache size: 49152K, maximum cache size: 262012K
I. 02/24 08:00:24. Using a maximum page size of 4096 bytes
I. 02/24 08:00:24. Starting database "newiq_w1" (/newiq/newiq_w1/newiq_w1.db) at Thu Feb 24 2011 08:00
I. 02/24 08:00:24. Database recovery in progress
I. 02/24 08:00:24. Last checkpoint at Tue Feb 22 2011 09:06
I. 02/24 08:00:24. Checkpoint log...
=============================================================
IQ server starting with:
30 connections ( -gm )
26 cmd resources ( -iqgovern )
505 threads ( -iqmt )
512 Kb thread stack size ( -iqtss )
258560 Kb thread memory size ( -iqmt * -iqtss )
8 IQ number of cpus ( -iqnumbercpus )
=============================================================
I. 02/24 08:00:27. Transaction log: /newiq/newiq_w1/newiq_w1.log...
I. 02/24 08:00:27. Transaction log mirror: /newiq/newiq_w1/mirror/newiq_w1.mlg
I. 02/24 08:00:27. Rollback log...
I. 02/24 08:00:27. Checkpointing...
I. 02/24 08:00:27. Starting checkpoint of "newiq_w1" (newiq_w1.db) at Thu Feb 24 2011 08:00
I. 02/24 08:00:27. Transaction log mirror: /newiq/newiq_w1/mirror/newiq_w1.mlg
I. 02/24 08:00:27. Rollback log...
I. 02/24 08:00:27. Checkpointing...
I. 02/24 08:00:27. Starting checkpoint of "newiq_w1" (newiq_w1.db) at Thu Feb 24 2011 08:00
**************************************************
*** Sybase IQ Abort:
*** From: st_threadInterfacen.cxx:190
*** PID: 10262
*** Message: Unexpected throw from IQ command
*** Thread: 1418393952 (TID: 503)
**************************************************
*** Sybase IQ Abort:
*** From: st_threadInterfacen.cxx:190
*** PID: 10262
*** Message: Unexpected throw from IQ command
*** Thread: 1418393952 (TID: 503)
**************************************************
Wrapping iqmsg: Disabled.
DBSPAWN ERROR: -80
Unable to start database server
DBSPAWN ERROR: -80
Unable to start database server
Server failed to start (Return Code 1)
I then started it up using iqfrec - which started the server and allowed me to connect.
Once I was logged in I ran sp_iqcheckdb 'allocation database' - which then caused the server to stacktrace and crash.
Below are the first 50 lines from the stack :
newiq.pnp.co.za:/newiq/newiq_w1> head -50 stktrc-20110224-085845_1.iq
** Error from IQ connection: SA connHandle: 1 SA connID: 2 IQ connID: 0000000002 User: DBA ** Time of error: 2011-02-24 08:58:45 ** IQ Version: Sybase IQ/12.7.0/080707/P/ESD 5 ** OS info: IQ built on: Enterprise Linux64 - amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp, Executed on: Linux/newiq.pnp.co.za/2.6.9-42.ELsmp/#1 SMP Wed Jul 12 23:32:02 EDT 2006/x86_64 ** Command status when error occured: COMMAND ACTIVE ** Command text:
sp_iqcheckdb 'allocation database'
Dump all thread stacks at hos_throw.cxx:311 for PID: 16806
***************** This is the STACKTRACE ***************
** Error from IQ connection: SA connHandle: 1 SA connID: 2 IQ connID: 0000000002 User: DBA ** Time of error: 2011-02-24 08:58:45 ** IQ Version: Sybase IQ/12.7.0/080707/P/ESD 5 ** OS info: IQ built on: Enterprise Linux64 - amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp, Executed on: Linux/newiq.pnp.co.za/2.6.9-42.ELsmp/#1 SMP Wed Jul 12 23:32:02 EDT 2006/x86_64 ** Command status when error occured: COMMAND ACTIVE ** Command text:
sp_iqcheckdb 'allocation database'
Dump all thread stacks at hos_throw.cxx:311 for PID: 16806
***************** This is the STACKTRACE ***************
===== Thread Number 1418393952 (IQ connID: 0000000002) =====
pc: 0x0 ()
pc: 0x2aa6dc2f1b pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x10b()
pc: 0x2aa6dc1a96 ucstkgentrace(int, int)+0xb6()
pc: 0x2aa6dc187c DumpAllThreads(char const*, unsigned, int)+0x15c()
pc: 0x2aa6ba9782 hos_ABORT(char const*, unsigned, hos_exception const&, char*, char*)+0x2b2()
pc: 0x2aa6dd6438 ThrowAbort(hos_exception const&)+0x158()
pc: 0x2aa6dd5e55 Throw(hos_exception const&)+0x2e5()
pc: 0x2aa6d9af24 hos_memmgr::FreeHosMem(void*)+0x84()
pc: 0x2aa6d9b37b operator delete(void*)+0x1b()
pc: 0x2aa70d4207 RWCString::~RWCString [in-charge deleting]()+0x77()
pc: 0x2aa7058721 hs_xstats::~hs_xstats [in-charge deleting]()+0x101()
pc: 0x2aa68ed7a9 void throwsafe_delete_ptrarr<hs_xstats>(hs_xstats**&, unsigned long)+0x69()
pc: 0x2aa68ee7f7 db_dbccIter::~db_dbccIter [in-charge deleting]()+0xc3()
pc: 0x2aa68eb52d db_CheckDBCursor::db_CheckDBCursor[in-charge](char*, unsigned)+0x76d()
pc: 0x2aa6931202 db_iqutilityOpenCursor::Parse()+0x1762()
pc: 0x2aa707b2da st_command::DoCmdThroughResourceGate()+0x3a()
pc: 0x2aa692bcf9 db_iqddl::IQUtilityOpenCursor(a_statement const*, UIConnection*, void**)+0x29()
pc: 0x2aa6de8b03 UIQDDL_IQUtilityOpenCursor+0x23()
pc: 0x2aa70b2229 st_thrInterfaceInfo::callFunction()+0x29()
pc: 0x2aa70b4dfb st_threadInterface::IQwaitForFunc()+0x19b()
pc: 0x2aa70b41eb IQLeaderThread+0x2b()
pc: 0x2aa6dd5822 hos_thread::Main()+0x19a()
pc: 0x0 ()
pc: 0x2aa6dc2f1b pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x10b()
pc: 0x2aa6dc1a96 ucstkgentrace(int, int)+0xb6()
pc: 0x2aa6dc187c DumpAllThreads(char const*, unsigned, int)+0x15c()
pc: 0x2aa6ba9782 hos_ABORT(char const*, unsigned, hos_exception const&, char*, char*)+0x2b2()
pc: 0x2aa6dd6438 ThrowAbort(hos_exception const&)+0x158()
pc: 0x2aa6dd5e55 Throw(hos_exception const&)+0x2e5()
pc: 0x2aa6d9af24 hos_memmgr::FreeHosMem(void*)+0x84()
pc: 0x2aa6d9b37b operator delete(void*)+0x1b()
pc: 0x2aa70d4207 RWCString::~RWCString [in-charge deleting]()+0x77()
pc: 0x2aa7058721 hs_xstats::~hs_xstats [in-charge deleting]()+0x101()
pc: 0x2aa68ed7a9 void throwsafe_delete_ptrarr<hs_xstats>(hs_xstats**&, unsigned long)+0x69()
pc: 0x2aa68ee7f7 db_dbccIter::~db_dbccIter [in-charge deleting]()+0xc3()
pc: 0x2aa68eb52d db_CheckDBCursor::db_CheckDBCursor[in-charge](char*, unsigned)+0x76d()
pc: 0x2aa6931202 db_iqutilityOpenCursor::Parse()+0x1762()
pc: 0x2aa707b2da st_command::DoCmdThroughResourceGate()+0x3a()
pc: 0x2aa692bcf9 db_iqddl::IQUtilityOpenCursor(a_statement const*, UIConnection*, void**)+0x29()
pc: 0x2aa6de8b03 UIQDDL_IQUtilityOpenCursor+0x23()
pc: 0x2aa70b2229 st_thrInterfaceInfo::callFunction()+0x29()
pc: 0x2aa70b4dfb st_threadInterface::IQwaitForFunc()+0x19b()
pc: 0x2aa70b41eb IQLeaderThread+0x2b()
pc: 0x2aa6dd5822 hos_thread::Main()+0x19a()
===== Thread Number 1418922336 =====
pc: 0x0 ()
pc: 0x2aa6dc2f1b pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x10b()
pc: 0x2aa6dc1a96 ucstkgentrace(int, int)+0xb6()
pc: 0x2aa70b1a5e SigHndlrUSR1+0xe()
pc: 0x3979f0c430 _fini+0xddf14618()
pc: 0x2aa70b5334 st_threadInterface::IQwaitForFunc()+0x6d4()
pc: 0x2aa70b41eb IQLeaderThread+0x2b()
pc: 0x2aa6dd5822 hos_thread::Main()+0x19a()
===== Thread Number 1417865568 =====
pc: 0x0 ()
pc: 0x2aa6dc2f1b pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x10b()
pc: 0x2aa6dc1a96 ucstkgentrace(int, int)+0xb6()
pc: 0x2aa70b1a5e SigHndlrUSR1+0xe()
pc: 0x3979f0c430 _fini+0xddf14618()
pc: 0x2aa6efb007 s_bufman::Sweep()+0xa7()
Is there any other way that would aloow me to start up and use the database?
Any assistance will be greatly appreciated.
Regards,
Sedick Clarke
Message has been deleted
Sedick Clarke
Feb 24, 2011, 1:27:42 PM2/24/11
to William Bell, iq...@googlegroups.com, joe....@sybase.com, iq...@dssolutions.com
Hi,
Thanks so much for the responses. I have tried with iqnotemp as well as changing the port number and it still stacktraces.
This is an excerpt from the .iqmsg file :
I. 02/24 20:20:23. 0000000000 OpenDatabase Completed
I. 02/24 20:20:23. 0000000000 IQ cmd line srv opts: -iqmc 8000 -iqtc 12000 -iqnotemp 50
I. 02/24 20:20:23. 0000000000 IQ full cmd line: -n newiq_w1 -x tcpip{port=4100} -c 48m -gc 20 -gd all -gl all -gm 30 -gp 4096 -ti 4400 -iqmc 8000 -iqtc 12000
-s none -zr SQL -zo /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_sql.log -o /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log -z -iqnotemp 50 ./newiq.db -hs -gn
35 -hn 8
I. 02/24 20:20:23. 0000000000 DB: r/w, Main Buffs=63793, Temp Buffs=95690, Pgsz=131072/8192blksz/16bpc
I. 02/24 20:20:23. 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
I. 02/24 20:20:23. 0000000000 DB: Versn: 12.7.0/080707/P/ESD 5/Enterprise Linux64 - amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp/64bit/2008-07-07 14:27:26
I. 02/24 20:20:23. 0000000000 DB: Name: /newiq/newiq_w1/newiq.db
I. 02/24 20:20:23. 0000000000 DB: Txn ID Seq: 2363679
I. 02/24 20:20:23. 0000000000 DB: DBID Blk: 482
I. 02/24 20:20:23. 0000000000 DB: IQ Server newiq_w1, PID 7672
I. 02/24 20:20:23. 0000000000 DB: Database encryption is OFF.
I. 02/24 20:20:23. 0000000000 Mem: 20152mb/M20154
I. 02/24 20:20:23. 0000000004 RcvPlaybck
I. 02/24 20:20:23. 0000000006 RcvPlaybck
I. 02/24 20:20:23. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000000 RcvyCmpl
I. 02/24 20:20:27. 0000000000 Chk
I. 02/24 20:20:27. 0000000000 The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
I. 02/24 20:20:27. 0000000000 from s_blockmap::GetBlockmapEntryInfo
I. 02/24 20:20:27. 0000000000 _Identity: 0x2aa63ffef0
I. 02/24 20:20:27. 0000000000 _OrigRootBlock: 2379717
I. 02/24 20:20:27. 0000000000 _Bufman: 0x735158
I. 02/24 20:20:27. 0000000000 _RWAccess: 1
I. 02/24 20:20:27. 0000000000 _allocationPrivilege: 1
I. 02/24 20:20:27. 0000000000 _allocFromLastLink: 1
I. 02/24 20:20:27. 0000000000 _perConnStats 0x2f94500088
I. 02/24 20:20:27. 0000000000 _LockRefCount: 1
I. 02/24 20:20:27. 0000000000 _PrefetchRefCount: 0
I. 02/24 20:20:27. 0000000000 _ScanModeRefCount: 0
I. 02/24 20:20:27. 0000000000 _DirtyReferences: 0
I. 02/24 20:20:27. 0000000000 _DirtyLinks: 0
I. 02/24 20:20:27. 0000000000 physicalBlockId: 0
I. 02/24 20:20:27. 0000000000 logicalBlockId: 1
I. 02/24 20:20:27. 0000000000 numBlocks: 3
I. 02/24 20:20:27. 0000000000 link: 0
I. 02/24 20:20:27. 0000000000 | I I N I I H I I I I I I I I |
I. 02/24 20:20:27. 0000000000 Flags: | s s e s s a s s n s s s s s |
I. 02/24 20:20:27. 0000000000 | D D e V B s B C W P S P U M |
I. 02/24 20:20:27. 0000000000 | i i d e u B l h a r p r s a |
I. 02/24 20:20:27. 0000000000 | r r s r s u o e s e e e e p |
I. 02/24 20:20:27. 0000000000 | t t D s y s c c h A c f r |
I. 02/24 20:20:27. 0000000000 | i y e i y k S A l i e L |
I. 02/24 20:20:27. 0000000000 | a a o W M u r l a t o |
I. 02/24 20:20:27. 0000000000 | b l n a a m e o l c c |
I. 02/24 20:20:27. 0000000000 s_buf(s) | l l e i p V a c F h k |
I. 02/24 20:20:27. 0000000000 follow.. | e o d t p a e L e e |
I. 02/24 20:20:27. 0000000000 | c e e l d B d d |
I. 02/24 20:20:27. 0000000000 | r d i u |
I. 02/24 20:20:27. 0000000000 | s d f |
I. 02/24 20:20:27. 0000000000 -----------+-----------------------------+------------+------------+------------+------------+------------+------------+-------
------
I. 02/24 20:20:27. 0000000000 &s_buf | A D N V Y W B C I P S F U M | Lock Cnt | Index |BlkMapUID |LogBlkNum | _dskBlk | BlockMap | Versio
nRange
I. 02/24 20:20:27. 0000000000 -----------+-----------------------------+------------+------------+------------+------------+------------+------------+-------
------
I. 02/24 20:20:27. 0000000000 0x2aacc153b0 | a d n v y w b c I P s f u M | 0 | 312 | 7 | 2379717 | 0x2ab89a3000 | 0 | 0,
0..0,0
I. 02/24 20:20:27. 0000000000 0x2ab89a3000 | blockmap | 0 | 0 | 1 | 2379717 | 0x2ab89a3020 | 16 |
16 | NONE/NONE
I. 02/24 20:20:27. 0000000000 Blockmap On Disk (blondi)
I. 02/24 20:20:27. 0000000000 Block Number: 2379717
I. 02/24 20:20:27. 0000000000 Owning Bufman ID: 0
I. 02/24 20:20:27. 0000000000 Bitvec Words: 225
I. 02/24 20:20:27. 0000000000 HasNextLogical: 0
I. 02/24 20:20:27. 0000000000 Entries/Capacity: 0/14348
I. 02/24 20:20:27. 0000000000 -------+-----------------+-----------------+---+-----+----
I. 02/24 20:20:27. 0000000000 Index# | Logical Block# | Physical Block# |EBM| Size| Cmp
I. 02/24 20:20:27. 0000000000 -------+-----------------+-----------------+---+-----+----
I. 02/24 20:20:27. 0000000000 0 | 1 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 1 | 2 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 2 | 3 | 0 | 0 | 94 | 0
I. 02/24 20:20:27. 0000000000 3 | 4 | 0 | 0 | 91 | 1
I. 02/24 20:20:27. 0000000000 4 | 5 | 0 | 0 | 6 | 0
I. 02/24 20:20:27. 0000000000 5 | 6 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 6 | 7 | 0 | 0 | 8 | 0
I. 02/24 20:20:27. 0000000000 7 | 8 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 8 | 9 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 9 | 10 | 0 | 0 | 126 | 0
I. 02/24 20:20:27. 0000000000 10 | 11 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 11 | 12 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 12 | 13 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 13 | 14 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 14 | 15 | 0 | 0 | 17 | 1
I. 02/24 20:20:27. 0000000000 15 | 16 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 16 | 17 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 17 | 18 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 18 | 19 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 19 | 20 | 0 | 0 | 100 | 0
I. 02/24 20:20:27. 0000000000 20 | 21 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 21 | 22 | 0 | 0 | 8 | 0
I. 02/24 20:20:27. 0000000000 22 | 23 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 23 | 24 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 24 | 25 | 0 | 0 | 27 | 1
I. 02/24 20:20:27. 0000000000 25 | 26 | 0 | 0 | 63 | 1
I. 02/24 20:20:27. 0000000000 26 | 27 | 0 | 0 | 1 | 1
I. 02/24 20:20:27. 0000000000 28 | 29 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 29 | 30 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 30 | 31 | 0 | 0 | 54 | 0
I. 02/24 20:20:27. 0000000000 31 | 32 | 0 | 0 | 33 | 1
I. 02/24 20:20:27. 0000000000 32 | 33 | 0 | 0 | 43 | 1
I. 02/24 20:20:27. 0000000000 33 | 34 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 34 | 35 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 35 | 36 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 36 | 37 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 37 | 38 | 0 | 0 | 111 | 1
I. 02/24 20:20:27. 0000000000 38 | 39 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 39 | 40 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 40 | 41 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 41 | 42 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 42 | 43 | 0 | 0 | 126 | 0
I. 02/24 20:20:27. 0000000000 43 | 44 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 44 | 45 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 45 | 46 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 46 | 47 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 47 | 48 | 0 | 0 | 18 | 0
I. 02/24 20:20:27. 0000000000 48 | 49 | 0 | 0 | 64 | 0
I. 02/24 20:20:27. 0000000000 49 | 50 | 0 | 0 | 1 | 1
I. 02/24 20:20:27. 0000000000 51 | 52 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 52 | 53 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 53 | 54 | 0 | 0 | 111 | 1
I. 02/24 20:20:27. 0000000000 54 | 55 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 55 | 56 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 56 | 57 | 0 | 0 | 33 | 1
I. 02/24 20:20:27. 0000000000 57 | 58 | 0 | 0 | 77 | 1
I. 02/24 20:20:27. 0000000000 58 | 59 | 0 | 0 | 7 | 1
...
I will log a case with support in the morning.
Kind Regards,
Sedick Clarke
Thanks so much for the responses. I have tried with iqnotemp as well as changing the port number and it still stacktraces.
This is an excerpt from the .iqmsg file :
I. 02/24 20:20:23. 0000000000 OpenDatabase Completed
I. 02/24 20:20:23. 0000000000 IQ cmd line srv opts: -iqmc 8000 -iqtc 12000 -iqnotemp 50
I. 02/24 20:20:23. 0000000000 IQ full cmd line: -n newiq_w1 -x tcpip{port=4100} -c 48m -gc 20 -gd all -gl all -gm 30 -gp 4096 -ti 4400 -iqmc 8000 -iqtc 12000
-s none -zr SQL -zo /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_sql.log -o /opt/sybase/ASIQ-12_7/logfiles/newiq_w1_server.log -z -iqnotemp 50 ./newiq.db -hs -gn
35 -hn 8
I. 02/24 20:20:23. 0000000000 DB: r/w, Main Buffs=63793, Temp Buffs=95690, Pgsz=131072/8192blksz/16bpc
I. 02/24 20:20:23. 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
I. 02/24 20:20:23. 0000000000 DB: Versn: 12.7.0/080707/P/ESD 5/Enterprise Linux64 - amd64,Opteron64,X86_64/2.4.21-27.0.1.ELsmp/64bit/2008-07-07 14:27:26
I. 02/24 20:20:23. 0000000000 DB: Name: /newiq/newiq_w1/newiq.db
I. 02/24 20:20:23. 0000000000 DB: Txn ID Seq: 2363679
I. 02/24 20:20:23. 0000000000 DB: DBID Blk: 482
I. 02/24 20:20:23. 0000000000 DB: IQ Server newiq_w1, PID 7672
I. 02/24 20:20:23. 0000000000 DB: Database encryption is OFF.
I. 02/24 20:20:23. 0000000000 Mem: 20152mb/M20154
I. 02/24 20:20:23. 0000000004 RcvPlaybck
I. 02/24 20:20:23. 0000000006 RcvPlaybck
I. 02/24 20:20:23. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:24. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:25. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:26. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000006 RcvPlaybck
I. 02/24 20:20:27. 0000000000 RcvyCmpl
I. 02/24 20:20:27. 0000000000 Chk
I. 02/24 20:20:27. 0000000000 The following exception is BUFMAN_BLOCKMAP_INFO_ERROR (-1009047)
I. 02/24 20:20:27. 0000000000 from s_blockmap::GetBlockmapEntryInfo
I. 02/24 20:20:27. 0000000000 _Identity: 0x2aa63ffef0
I. 02/24 20:20:27. 0000000000 _OrigRootBlock: 2379717
I. 02/24 20:20:27. 0000000000 _Bufman: 0x735158
I. 02/24 20:20:27. 0000000000 _RWAccess: 1
I. 02/24 20:20:27. 0000000000 _allocationPrivilege: 1
I. 02/24 20:20:27. 0000000000 _allocFromLastLink: 1
I. 02/24 20:20:27. 0000000000 _perConnStats 0x2f94500088
I. 02/24 20:20:27. 0000000000 _LockRefCount: 1
I. 02/24 20:20:27. 0000000000 _PrefetchRefCount: 0
I. 02/24 20:20:27. 0000000000 _ScanModeRefCount: 0
I. 02/24 20:20:27. 0000000000 _DirtyReferences: 0
I. 02/24 20:20:27. 0000000000 _DirtyLinks: 0
I. 02/24 20:20:27. 0000000000 physicalBlockId: 0
I. 02/24 20:20:27. 0000000000 logicalBlockId: 1
I. 02/24 20:20:27. 0000000000 numBlocks: 3
I. 02/24 20:20:27. 0000000000 link: 0
I. 02/24 20:20:27. 0000000000 | I I N I I H I I I I I I I I |
I. 02/24 20:20:27. 0000000000 Flags: | s s e s s a s s n s s s s s |
I. 02/24 20:20:27. 0000000000 | D D e V B s B C W P S P U M |
I. 02/24 20:20:27. 0000000000 | i i d e u B l h a r p r s a |
I. 02/24 20:20:27. 0000000000 | r r s r s u o e s e e e e p |
I. 02/24 20:20:27. 0000000000 | t t D s y s c c h A c f r |
I. 02/24 20:20:27. 0000000000 | i y e i y k S A l i e L |
I. 02/24 20:20:27. 0000000000 | a a o W M u r l a t o |
I. 02/24 20:20:27. 0000000000 | b l n a a m e o l c c |
I. 02/24 20:20:27. 0000000000 s_buf(s) | l l e i p V a c F h k |
I. 02/24 20:20:27. 0000000000 follow.. | e o d t p a e L e e |
I. 02/24 20:20:27. 0000000000 | c e e l d B d d |
I. 02/24 20:20:27. 0000000000 | r d i u |
I. 02/24 20:20:27. 0000000000 | s d f |
I. 02/24 20:20:27. 0000000000 -----------+-----------------------------+------------+------------+------------+------------+------------+------------+-------
------
I. 02/24 20:20:27. 0000000000 &s_buf | A D N V Y W B C I P S F U M | Lock Cnt | Index |BlkMapUID |LogBlkNum | _dskBlk | BlockMap | Versio
nRange
I. 02/24 20:20:27. 0000000000 -----------+-----------------------------+------------+------------+------------+------------+------------+------------+-------
------
I. 02/24 20:20:27. 0000000000 0x2aacc153b0 | a d n v y w b c I P s f u M | 0 | 312 | 7 | 2379717 | 0x2ab89a3000 | 0 | 0,
0..0,0
I. 02/24 20:20:27. 0000000000 0x2ab89a3000 | blockmap | 0 | 0 | 1 | 2379717 | 0x2ab89a3020 | 16 |
16 | NONE/NONE
I. 02/24 20:20:27. 0000000000 Blockmap On Disk (blondi)
I. 02/24 20:20:27. 0000000000 Block Number: 2379717
I. 02/24 20:20:27. 0000000000 Owning Bufman ID: 0
I. 02/24 20:20:27. 0000000000 Bitvec Words: 225
I. 02/24 20:20:27. 0000000000 HasNextLogical: 0
I. 02/24 20:20:27. 0000000000 Entries/Capacity: 0/14348
I. 02/24 20:20:27. 0000000000 -------+-----------------+-----------------+---+-----+----
I. 02/24 20:20:27. 0000000000 Index# | Logical Block# | Physical Block# |EBM| Size| Cmp
I. 02/24 20:20:27. 0000000000 -------+-----------------+-----------------+---+-----+----
I. 02/24 20:20:27. 0000000000 0 | 1 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 1 | 2 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 2 | 3 | 0 | 0 | 94 | 0
I. 02/24 20:20:27. 0000000000 3 | 4 | 0 | 0 | 91 | 1
I. 02/24 20:20:27. 0000000000 4 | 5 | 0 | 0 | 6 | 0
I. 02/24 20:20:27. 0000000000 5 | 6 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 6 | 7 | 0 | 0 | 8 | 0
I. 02/24 20:20:27. 0000000000 7 | 8 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 8 | 9 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 9 | 10 | 0 | 0 | 126 | 0
I. 02/24 20:20:27. 0000000000 10 | 11 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 11 | 12 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 12 | 13 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 13 | 14 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 14 | 15 | 0 | 0 | 17 | 1
I. 02/24 20:20:27. 0000000000 15 | 16 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 16 | 17 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 17 | 18 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 18 | 19 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 19 | 20 | 0 | 0 | 100 | 0
I. 02/24 20:20:27. 0000000000 20 | 21 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 21 | 22 | 0 | 0 | 8 | 0
I. 02/24 20:20:27. 0000000000 22 | 23 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 23 | 24 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 24 | 25 | 0 | 0 | 27 | 1
I. 02/24 20:20:27. 0000000000 25 | 26 | 0 | 0 | 63 | 1
I. 02/24 20:20:27. 0000000000 26 | 27 | 0 | 0 | 1 | 1
I. 02/24 20:20:27. 0000000000 28 | 29 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 29 | 30 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 30 | 31 | 0 | 0 | 54 | 0
I. 02/24 20:20:27. 0000000000 31 | 32 | 0 | 0 | 33 | 1
I. 02/24 20:20:27. 0000000000 32 | 33 | 0 | 0 | 43 | 1
I. 02/24 20:20:27. 0000000000 33 | 34 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 34 | 35 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 35 | 36 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 36 | 37 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 37 | 38 | 0 | 0 | 111 | 1
I. 02/24 20:20:27. 0000000000 38 | 39 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 39 | 40 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 40 | 41 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 41 | 42 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 42 | 43 | 0 | 0 | 126 | 0
I. 02/24 20:20:27. 0000000000 43 | 44 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 44 | 45 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 45 | 46 | 0 | 0 | 3 | 1
I. 02/24 20:20:27. 0000000000 46 | 47 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 47 | 48 | 0 | 0 | 18 | 0
I. 02/24 20:20:27. 0000000000 48 | 49 | 0 | 0 | 64 | 0
I. 02/24 20:20:27. 0000000000 49 | 50 | 0 | 0 | 1 | 1
I. 02/24 20:20:27. 0000000000 51 | 52 | 0 | 0 | 7 | 1
I. 02/24 20:20:27. 0000000000 52 | 53 | 0 | 0 | 4 | 0
I. 02/24 20:20:27. 0000000000 53 | 54 | 0 | 0 | 111 | 1
I. 02/24 20:20:27. 0000000000 54 | 55 | 0 | 0 | 2 | 0
I. 02/24 20:20:27. 0000000000 55 | 56 | 0 | 0 | 12 | 0
I. 02/24 20:20:27. 0000000000 56 | 57 | 0 | 0 | 33 | 1
I. 02/24 20:20:27. 0000000000 57 | 58 | 0 | 0 | 77 | 1
I. 02/24 20:20:27. 0000000000 58 | 59 | 0 | 0 | 7 | 1
...
I will log a case with support in the morning.
Kind Regards,
Sedick Clarke
On Thu, Feb 24, 2011 at 7:40 PM, William Bell <william...@gmail.com> wrote:
Another thing to try is change the port that the IQ Server is listening on - I have seen a similar stack trace if the chosen port is in use (note that 5000 is the default port for ASE)
On Thu, Feb 24, 2011 at 11:13 AM, <joe....@sybase.com> wrote:
Hi Sedlick,
Pending no responses from other folks, here are my two suggestions:
1) Any time you have a valid stack trace, call TS.
2) Beyond that, your situation looks like one I have encountered several
times after restore when the correct temp stores are not available.
Perhaps try also starting with the -iqnotemp 50 (small on the fly 50M temp
store in a file) and see if that helps, if so, at least you will have found
the area to focus on.
...............................................................................................................
Joe Love | Staff Database Design Engineer | Sybase 365 DBA Support
One Sybase Drive, Dublin, California, 94568, USA | Tel: (925) 236-7579 |
Cell: (510) 207-8257 | joe....@sybase.com | www.sybase.com
The information contained in this email is confidential and intended only
for the addressee. If you are not the intended recipient (or have received
this e-mail in error), please notify the sender immediately and destroy
this e-mail. Any unauthorized copying, disclosure or distribution of the
material in this e-mail is strictly forbidden.
(Embedded image moved to file: pic26695.jpg)
Sedick Clarke
<sed...@biitb.com
> To
Sent by: <iq...@googlegroups.com>,
<sedick.clarke@gm <iq...@dssolutions.com>
ail.com> cc
Subject
02/23/2011 11:18 [iqug] IQ Server stacktrace after
PM restore
Please respond to
<iqug@dssolutions
.com>
---------------------------------------------------------------------
To unsubscribe, e-mail: iqug-uns...@dssolutions.com
For additional commands, e-mail: iqug...@dssolutions.com
--
You received this message because you are subscribed to the Google Groups "iqug" group.
To post to this group, send email to iq...@googlegroups.com.
To unsubscribe from this group, send email to iqug+uns...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/iqug?hl=en.
Reply all
Reply to author
Forward
0 new messages