Ecc6.0 instance dump,ERROR ThSigHandler: signal

[Former Member]

Hi Expert,

ECC6.0 instance WP is not starting.

O.S : WINDOWS 2003

DB:Oracle 10g

Kernel: 700

Patch:201

Below is the part of log dev_W0:

---

trc file: "dev_w0", trc level: 1, release: "700"

---

I

I Sat Jun 18 13:49:11 2011

I MtxInit: 0 0 0

M SHM_PRES_BUF (addr: 0B560040, size: 4400000)

M SHM_ROLL_AREA (addr: 788A0040, size: 61440000)

M SHM_PAGING_AREA (addr: 0B9A0040, size: 32768000)

M SHM_ROLL_ADM (addr: 0D8F0040, size: 633840)

M SHM_PAGING_ADM (addr: 0D990040, size: 525344)

M ThCreateNoBuffer allocated 544152 bytes for 1000 entries at 0DA20040

M ThCreateNoBuffer index size: 3000 elems

M ThCreateVBAdm allocated 12160 bytes (50 server) at 07150040

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X ES initialized.

X mm.dump: set maximum dump mem to 96 MB

B dbntab: NTAB buffers attached

B dbntab: Buffer FTAB(hash header) (addr: 0DB40088, size: 536)

B dbntab: Buffer FTAB(anchor array) (addr: 0DB402A0, size: 160036)

B dbntab: Buffer FTAB(item array) (addr: 0DB673C8, size: 720000)

B dbntab: Buffer FTAB(data area) (addr: 0DC17048, size: 30720000)

B dbntab: Buffer IREC(hash header) (addr: 0F970088, size: 536)

B dbntab: Buffer IREC(anchor array) (addr: 0F9702A0, size: 160036)

B dbntab: Buffer IREC(item array) (addr: 0F9973C8, size: 180000)

B dbntab: Buffer IREC(data area) (addr: 0F9C32E8, size: 6144000)

B dbntab: Buffer STAB(hash header) (addr: 10940088, size: 536)

B dbntab: Buffer STAB(anchor array) (addr: 109402A0, size: 160036)

B dbntab: Buffer STAB(item array) (addr: 109673C8, size: 180000)

B dbntab: Buffer STAB(data area) (addr: 109932E8, size: 3072000)

B dbntab: Buffer TTAB(hash header) (addr: 10C90088, size: 1888)

B dbntab: Buffer TTAB(anchor array) (addr: 10C907E8, size: 160036)

B dbntab: Buffer TTAB(item array) (addr: 10CB7910, size: 480000)

B dbntab: Buffer TTAB(data area) (addr: 10D2CC10, size: 5840000)

B db_con_shm_ini: WP_ID = 0, WP_CNT = 13, CON_ID = -1

B dbstat: TABSTAT buffer attached (addr: 12AE9F90)

B dbtbxbuf: Buffer TABL (addr: 150200C8, size: 30000000, end: 16CBC448)

B dbtbxbuf: Buffer TABLP (addr: 112C00C8, size: 10240000, end: 11C840C8)

B dbexpbuf: Buffer EIBUF (addr: 11C900D0, size: 4194304, end: 120900D0)

B dbexpbuf: Buffer ESM (addr: 120A00D0, size: 4194304, end: 124A00D0)

B dbexpbuf: Buffer CUA (addr: 124B00D0, size: 3072000, end: 1279E0D0)

B dbexpbuf: Buffer OTR (addr: 16CC00D0, size: 4194304, end: 170C00D0)

B dbcalbuf: Buffer CALE (addr: 170D0040, size: 500000, end: 1714A160)

M CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

S

S Sat Jun 18 13:49:13 2011

S *** init spool environment

S TSPEVJOB updates inside critical section: event_update_nocsec = 0

S initialize debug system

T Stack direction is downwards.

T debug control: prepare exclude for printer trace

T new memory block 1C590D20

S spool kernel/ddic check: Ok

S using table TSP02FX for frontend printing

S 1 spool work process(es) found

S frontend print via spool service enabled

S printer list size is 150

S printer type list size is 50

S queue size (profile) = 300

S hostspool list size = 3000

S option list size is 30

S found processing queue enabled

S found spool memory service RSPO-RCLOCKS at 207B00A8

S doing lock recovery

S setting server cache root

S found spool memory service RSPO-SERVERCACHE at 207B0430

S using messages for server info

S size of spec char cache entry: 297028 bytes (timeout 100 sec)

S size of open spool request entry: 2236 bytes

S immediate print option for implicitely closed spool requests is disabled

A

A Sat Jun 18 13:49:14 2011

A **GENER Trace switched on ***

A

A -PXA-

A PXA INITIALIZATION

A PXA: Locked PXA-Semaphore.

A System page size: 4kb, total admin_size: 19356kb, dir_size: 19300kb.

A PXA allocated (address 3F620040, size 300000K)

A System name

A ORACLE...........................QAS........200706 27030657.....................................

A is used for RFC security.

A Sharedbuffer token: 41534050...33 (len: 111)====== 66092e69785ca0c479c0b06e...

A abap/pxa = shared protect gen_remote

A PXA INITIALIZATION FINISHED

A -PXA-

A

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

A

A Sat Jun 18 13:49:15 2011

A ABAP ShmAdm attached (addr=6C874000 leng

955136 end=6DC70000)

A >> Shm MMADM area (addr=6CCD44B0 leng=126848 end=6CCF3430)

A >> Shm MMDAT area (addr=6CCF4000 leng=16236544 end=6DC70000)

A RFC Destination> destination IDES_QAS_00 host IDES system QAS systnr 0 (IDES_QAS_00)

A RFC Options> H=IDES,S=00,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 27042 bytes at 07170040

N SsfSapSecin: putenv(SECUDIR=C:\usr\sap\QAS\DVEBMGS00\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is C:\usr\sap\QAS\DVEBMGS00\exe\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...completed with return code 5.

N =================================================

N

N Sat Jun 18 13:49:16 2011

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 700, [7000.0.201.20050900]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [20]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

E Enqueue Info: rdisp/wp_no_enq=1, rdisp/enqname=<empty>, assume IDES_QAS_00

M ***LOG GEF=> [enxxmini.h 918]

M ***LOG GZZ=> Illegal Format/Version of Shared [enxxmini.h 918]

M call semaphore clean-up function ...

M ***LOG Q0E=> DpSigGenHandler, Exception (c0000094) [dpnttool.c 438]

M --- C-STACK ---

SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

---

Application exception occurred:

Exception : c0000094 (Divide by zero)

App : disp+work.EXE (pid=6012)

When : 6/18/2011 13:49:17.382

Threads : 2

---

Computer Name : IDES

User Name : qasadm

---

Number of Processors: 4

Processor Type: x86 Family 6 Model 15 Stepping 7

Windows Version : 5.2 Current Build: 3790

---

State Dump for Thread Id 6c8

eax=00000000 ebx=00000396 ecx=212f0040 edx=00000000 esi=7c35043c edi=00000000

eip=00fcb151 esp=05b0fc84 ebp=04ea34f4 iopl=0 nv up ei pl nz na pe nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00210202

function : Alert

00fcb138 33ed xor ebp,ebp

00fcb13a 38442414 cmp [esp+0x14],al ss:0b61d90f=00

00fcb13e 7458 jz Alert+0x72 (00fcb198)

00fcb140 33ff xor edi,edi

00fcb142 47 inc edi

00fcb143 8bf7 mov esi,edi

00fcb145 eb44 jmp Alert+0x65 (00fcb18b)

00fcb147 8b81c0050000 mov eax,[ecx+0x5c0] ds:212f0600=00000000

00fcb14d 6bc064 imul eax,eax,0x64

00fcb150 99 cdq

FAULT-> 00fcb151 f7b900060000 idiv dword ptr [ecx+0x600] ds:212f0640=00000000

00fcb157 6a02 push 0x2

00fcb159 33ff xor edi,edi

00fcb15b 5e pop esi

00fcb15c 8bd8 mov ebx,eax

00fcb15e 8b81c8050000 mov eax,[ecx+0x5c8] ds:212f0608=00000000

00fcb164 6bc064 imul eax,eax,0x64

00fcb167 99 cdq

00fcb168 f7b9ec050000 idiv dword ptr [ecx+0x5ec] ds:212f062c=00000000

00fcb16e 8be8 mov ebp,eax

00fcb170 8b81cc050000 mov eax,[ecx+0x5cc] ds:212f060c=00000000

00fcb176 6bc064 imul eax,eax,0x64

-> Stack Back Trace <-

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

05b0fc90 00fd785d 00000001 00000002 00000000 04defdc4 disp+work!Alert [enxxmgen.h (520)]

05b0fce0 00fdbe6e 00000000 00fe5bef 00000002 00000000 disp+work!EnqMemInstall2 [enxxmini.h (429)]

05b0fce8 00fe5bef 00000002 00000000 04defdc4 04deb808 disp+work!EnqMemInstall [enxxmini.h (291)]

05b0fd00 00fb3ec5 04deb808 04e39540 05b0fe14 04deb9f6 disp+work!EnqueOpMem [enxxmop.h (82)]

05b0fd24 00fbe807 04de004e 00000001 05e30044 7c35056a disp+work!EnqExecReq [enxxhead.c (2729)]

05b0fdd8 00fbecca 0000004e 00000000 00000000 05b0fe14 disp+work!EnCcEnque4 [enxxhead.c (10587)]

05b0fdf8 00fbf0e4 0000004e 05b0fe14 05237780 ffffffff disp+work!EnCcEnque [enxxhead.c (9755)]

05b0fe4c 00496650 00000003 00000002 05b0ff00 00000000 disp+work!EnqCcInitialize [enxxhead.c (10857)]

05b0fee0 004a3bdf 00000001 00000000 00000000 00430000 disp+work!ThInit [thxxhead.c (1925)]

05b0ff00 00423d5f 00000000 00000000 7ffdf000 05b0ff60 disp+work!ThStart [thxxhead.c (1144)]

05b0ff14 00401085 00000003 002468d8 00000001 00000000 disp+work!DpMain [dpxxdisp.c (1166)]

05b0ff60 01288b60 00000003 002468d8 00247910 01d82000 disp+work!nlsui_main [thxxanf.c (84)]

05b0ffc0 77e6f23b 00000000 00000000 7ffdf000 00000000 disp+work!wmainCRTStartup [crtexe.c (395)]

05b0fff0 00000000 01288a1d 00000000 00000000 00000000 kernel32!ProcessIdToSessionId

---

State Dump for Thread Id 528

eax=00000001 ebx=00000103 ecx=7c829f59 edx=00560000 esi=00000000 edi=00000000

eip=7c8285ec esp=081dfec0 ebp=081dff04 iopl=0 nv up ei pl zr na po nc

cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000246

function : KiFastSystemCallRet

7c8285ec c3 ret

7c8285ed 8da42400000000 lea esp,[esp] ss:081dfec0=7c8270fb

7c8285f4 8d642400 lea esp,[esp] ss:0dcedb4b=00000000

--> Stack Back Trace <--

FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name

081dff04 011cd13e 00000694 00000000 00000000 0024f8b8 ntdll!KiFastSystemCallRet

081dff84 7c349565 00000000 00000000 00000000 05cdce88 disp+work!SigIMsgFunc [signt.c (678)]

081dffb8 77e64829 05cdce88 00000000 00000000 05cdce88 MSVCR71!endthreadex

081dffec 00000000 7c3494f6 05cdce88 00000000 00000000 kernel32!GetModuleHandleA

---

M ---

M

M Sat Jun 18 13:49:17 2011

M call clean-up function ...

M in_ThErrHandle: 1

M ThSigHandler: signal (step 1, th_errno 11, action 4)

M

M Info for wp 0

M

M pid = 6012

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server IDES_QAS_00 on host IDES (wp 0)

M * ERROR ThSigHandler: signal

M *

M * TIME Sat Jun 18 13:49:17 2011

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 11

M * MODULE thxxhead.c

M * LINE 10781

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M TrThHookFunc: called for WP dump

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M ThrSaveSPAFields: save spa fields

M ThrSaveSPAFields: not an update task, no update info saved

M ThrSaveSPAFields: not a batch task, field zttabtckey not saved

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 6012) [dpnttool.c 333]

M return from clean-up function ...

Regards,

[former_member296748]

Hi Nadeem

Save your init<SID>.ora.

You can try to set processes and sessions parameters in the init<sid>.ora to the following value :

processes = 800

sessions =1600

- Stop your instance

- Stop your DB

- Recreate the spfile

- Start your DB

- Start your instance

If the issue does not solve the problem, you return back.

Otherwise, when you start your instance is that the processes dw.sap <SID> _DVEBMGSXX starts then dies or they do not start?

Best regards.

[Former Member]

Hi Nadeem,

This trace does not contain exact problem. It looks like you have it on Windows. so can you please look in SAP MMC and see which nodes are getting started and which are failing? I mean, is the message server/dispatcher/etc. starting up? If MS and/or dispatcher are down, check dev_disp and dev_ms for more traces.

Might be related to some memory problems, in which case you can try a reboot of the server.

Also, can you specify if there was a Kernel upgrade or any other activity in the system recently?

Regards,

Shitij

[Former Member]

Hi Karim,

Below is the parameter from init<sid>.ora,

processes=80

sessions=96

Regards.

[Former Member]

Hi subhash,

The output of r3trans -d is 00000, which means dispatcher is working and its connecting to database.Please suggest any other

parameter do i need to check.

Regards.

[former_member296748]

Hi,

Could you give me the processes and the sessions parameter in the init<SID>.ora

please.

Best regards.

[former_member185031]

Have you done any upgrade recently ? First check the Database by R3trans -d and see the output, if it is not 0000 then paste the trans.log. Also check the dev_disp log file.

Regards,

Subhash