|
Problem: Upgrade in EU_IMPORT2 hangs because of db_full situation. Trying to add a volume using dbmcli db_addvolumne doesn't solve the problem, because the database session, used by the db_addvolume is blocked by db_full situation itself.
Reason: Before executing the db_addvolume inquiries SysView_ActiveConfiguration. The corresponding select enters a db_full wait situation while building the temorary result set, which doesn't find enough pages within the datacache and therefore has to write a page to the datavolum
1. dbm.prt
---------------
2008-09-08 15:02:44 0x00002527 INF 1 DBMSrvCo A DBM Server client connection was established at 2008-09-08 14:49:21 (client process has process ID 9509 on computer lsia6437).
2008-09-08 15:02:44 0x00002527 INF 283 DBMSrv Command 'db_addvolume DATA /sapdb/QE1/sapdata/DISKD0008 F 4000000' is being executed.
2. x_cons (0x2527 --> 9511)
------------------------------------------
T227 7 7826 User 9511 DB FULL (198) 0 0 729885(s)
3. Callstack von dbmsrv (pid 9511)
#0 0xa000000000010621 in __kernel_syscall_via_break ()
#1 0x20000000005306a0 in __GC___libc_nanosleep () from /lib/libc.so.6.1
#2 0x2000000000587710 in usleep () from /lib/libc.so.6.1
#3 0x40000000007b6b70 in RTE_ISystem::DoSleep ()
#4 0x4000000000264070 in DBMSrvKnl_Session::Receive ()
#5 0x4000000000272910 in DBMSrvKnl_Session::Receive ()
#6 0x4000000000272df0 in DBMSrvKnl_Session::InternExecute ()
#7 0x4000000000274040 in DBMSrvKnl_Session::Execute ()
#8 0x4000000000055310 in cn29ReadParamsFromDB ()
#9 0x400000000005ed90 in cn29ParamStartSession ()
#10 0x400000000004c0e0 in cn20ParamAddDevSpace ()
#11 0x40000000000f3480 in cn40DbAddDevice ()
#12 0x40000000002f73b0 in DBMSrvCmdDb_DbAddVolume::run ()
#13 0x4000000000234ea0 in DBMSrvFrmReq_HandlerClassic::handleRequest ()
#14 0x4000000000231f50 in DBMSrvFrmReq_Handler::handle ()
#15 0x400000000002d910 in DBMSrvThread_MainThread::DBMSrvThreadMain ()
#16 0x400000000002e5a0 in DBMSrvThread_Thread::ThreadMain ()
#17 0x40000000007b2bd0 in RTEThread_Thread::CThreadMain ()
#18 0x40000000007b54f0 in RTEThread_Thread::AppointMainThreadToThreadObject ()
#19 0x400000000000ba80 in main ()
--------------------------------------------------
4. Callstack im Kernel (T227)
------------------------------------------
----> Symbolic stack backtrace <----
0: _ZN17RTEDiag_CallStack18TraceStackSymbolicEPK19RTEDiag_RegisterSet + 0x50
1: _ZN12RTETask_Task23HandleDebugTaskRequestsEP26RTETask_CommonQueueElement + 0x640
2: WaitForReschedule + 0x240
...
22: _ZN27SysView_ActiveConfiguration7ExecuteEv + 0x460
|
|