SQL Break Failed

[Former Member]

I have recently seen in my system that all update work process hanged and no was able able to work and the wp process started timing out.

here is the mail part of wp trace

M Mon Jan 25 15:44:15 2010

M ThRollOut: act roll state = DP_ROLLED_OUT

M ThRollOut: roll level <> 0, don't call ab_rollout

M ThRollOut: full roll out of U22 M0 I0 (Level 7) ok

M ThIErrHandle: prv_action of W21: 0x8

M ThCallDbBreak: use db_sqlbreak

C SQLBREAK: DBSL_CMD_SQLBREAK: CbOnCancel was not set. rc: 15

M *** WARNING => sql break failed (16388)

M ThIErrHandle: don't try rollback again

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

M ThIErrHandle: Entering ThReplyToMsg

M ThIErrHandle: Entering ThErrHdlUser

M ThErrHdlUser: set th_errno (11)

M ThErrHdlUser: save context

M ThEmContextDetach2: detach T21/M0 from em memory (em_hdl=60, force=0)

M ThEmContextDetach2: reset local em info

M call ThrShutDown ...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 021 000 R/3 000000000 ACTIVE YES YES NO 000 255 255 20091218 191945 ERPSQL

C DbSlDisconnect NOT DONE because thread IDs are different.

B Disconnected from connection 0

B statistics db_con_commit (com_total=82, com_tx=41)

B statistics db_con_rollback (roll_total=0, roll_tx=0)

M ***LOG Q02=> wp_halt, WPStop (Workproc21 4256) [dpnttool.c 333]

B Mon Jan 25 15:55:06 2010

B dbmyclu : info : my major identification is 3960472447, minor one 804.

B dbmyclu : info : Time Reference is 1.12.2001 00:00:00h GMT.

B dbmyclu : info : my initial uuid is DF09FC4C150615F194610015C5FDA6C1.

B dbmyclu : info : current optimistic cluster level: 3

B dbmyclu : info : pessimistic reads set to 2.

M

M Mon Jan 25 15:59:49 2010

M *** WARNING => PfSetGuiTime: gui time too large, discard (gui=-608670296/resptime=0)

Please let me know the preventive steps that we can take to avoid this situation.

Thanks

[Former Member]

Hi Himanshu,

Did you able to resolve this? we are also facing the same problem.

Thanks,

Manoj

[markus_doehr2]

Difficult to give a suggest since you posted only the log with the wp restart, not the log with the original problem.

Did you check SM21 for possible issues?

Markus

[Former Member]

Yes I have throughly checked the SM21 log but there is nothing useful

Now I am copying the full trace

Mon Jan 25 15:42:59 2010

M in_ThErrHandle: 1

M ThResetEmMagic: reset em magic for T18/M0/I0

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

M

M Info for wp 18

M

M pid = 4304

M severity = 0

M status = 0

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_VBWP

M act_reqtype = DP_RQ_VBWP

M rq_info = 8576

M tid = 18

M mode = 0

M len = 945

M rq_id = 39043

M rq_source = FROM_WP_CA

M last_tid = 18

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 = 1000000

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 = >ZSD_REPT_SERVICE_INVOICE <

M action = 11

M tab_name = >BKPF <

M attachedVm = no VM

M

M Modeinfo for User T18/M0

M

M tm state = 2

M uid = 19

M term type = 0x2

M display = 0x0

M cpic_no = 0

M cpic_idx = -1

M usr = >ROSEMARIEES <

M terminal = >mdc-ctx22 <

M client = >300<

M conversation_ID = > <

M appc_tm_conv_idx = -1

M its_plugin = NO

M allowCreateMode = YES

M wp_ca block = 1540

M appc_ca block = 2800

M blockSoftCanel = NO

M session_id = >FDEF09DF3A62F12DAC8C0019B9F4265A<

M ext_session_id = >F3BB09DF7BE8F1FFAC8C0019B9F4265A<

M imode = 0

M mode state = 0x42

M mode clean_state = 1

M task_type = ZTTAVB

M lastThFc = THFCVBIN

M lastAction = TH_IACT_NO_ACTION

M th_errno = 11

M rollout_reason = 0

M last_rollout_level = 0

M async_receives = 0

M cpic_receive = 0

M em handle = 48

M roll state = 2

M abap state = 2

M em state = 3

M eg state = 1

M spa state = 3

M enq state = 0

M softcancel = 0

M cancelInitiator = ?

M clean_state = DP_DEFAULT_CLEANING

M next hook = T-1/U-1/M255

M master hook = T-1/U-1/M255

M slave hook = T-1/U-1/M255

M debug_tid = 255

M debug_mode = 0

M mode type = 0x1

M debug = 0

M msg_count = 48518

M tcode = > <

M last_wp = 18

M client conversation_ID = > <

M server conversation_ID = > <

M lock = 0

M max enq infos = 0

M act enq infos = 0

M em_hyper_hdl = 000007FF3ED408B0

M plugin_info = NULL

M act_plugin_hdl = -1

M act_plugin_no = 0

M max_plugin_no = 0

M

M Adresse Offset Data from input buffer

M -

---

M 000000001D401510 000000 00000000 01000000 34003100 30003300 |........4.1.0.3.|

M 000000001D401520 000016 4d004400 43002d00 53004100 50002d00 |M.D.C.-.S.A.P.-.|

M 000000001D401530 000032 41005000 50003000 32005f00 50005200 |A.P.P.0.2._.P.R.|

M 000000001D401540 000048 44005f00 30003200 46003600 45004600 |D._.0.2.F.6.E.F.|

M 000000001D401550 000064 30003900 44004600 45003600 41003300 |0.9.D.F.E.6.A.3.|

M 000000001D401560 000080 46003100 45004500 41004300 38004300 |F.1.E.E.A.C.8.C.|

M 000000001D401570 000096 30003000 31003900 42003900 46003400 |0.0.1.9.B.9.F.4.|

M 000000001D401580 000112 32003600 35004100 20002000 20002000 |2.6.5.A. . . . .|

M 000000001D401590 000128 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D4015A0 000144 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D4015B0 000160 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D4015C0 000176 20002000 20002000 20002000 52004f00 | . . . . . .R.O.|

M 000000001D4015D0 000192 53004500 4d004100 52004900 45004500 |S.E.M.A.R.I.E.E.|

M 000000001D4015E0 000208 53002000 33003000 30000601 02002000 |S. .3.0.0..... .|

M 000000001D4015F0 000224 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401600 000240 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401610 000256 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401620 000272 20002000 20002000 00002000 20002000 | . . . ... . . .|

M 000000001D401630 000288 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401640 000304 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401650 000320 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401660 000336 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401670 000352 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401680 000368 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D401690 000384 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000001D4016A0 000400 20002000 20002000 20002424 54485f55 | . . . . .$$TH_U|

M 000000001D4016B0 000416 5345525f 4b45592c 4c454e3d 30313738 |SER_KEY,LEN=0178|

M 000000001D4016C0 000432 2424312d 3330322d 322d3538 31392d33 |$$1-302-2-5819-3|

M 000000001D4016D0 000448 2d302d34 2d342d35 2d313732 2e31362e |-0-4-4-5-172.16.|

M 000000001D4016E0 000464 332e3132 362d362d 73617067 7730322d |3.126-6-sapgw02-|

M 000000001D4016F0 000480 372d3137 322e3136 2e332e38 382d3137 |7-172.16.3.88-17|

M 000000001D401700 000496 2d313732 2e31362e 332e3132 362d3138 |-172.16.3.126-18|

M -

---

M

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

M *

M * LOCATION SAP-Server MDC-SAP-APP02_PRD_02 on host MDC-SAP-APP02 (wp 18)

M * ERROR ThSigHandler: signal

M *

M * TIME Mon Jan 25 15:42:59 2010

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 11

M * MODULE thxxhead.c

M * LINE 10744

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: save update info into thr_wpadm

M Adresse Offset upd info

M -

---

M 000000000374B2E0 000000 46003600 45004600 30003900 44004600 |F.6.E.F.0.9.D.F.|

M 000000000374B2F0 000016 45003600 41003300 46003100 45004500 |E.6.A.3.F.1.E.E.|

M 000000000374B300 000032 41004300 38004300 30003000 31003900 |A.C.8.C.0.0.1.9.|

M 000000000374B310 000048 42003900 46003400 32003600 35004100 |B.9.F.4.2.6.5.A.|

M 000000000374B320 000064 00000000 00000000 00000000 00000000 |................|

M 000000000374B330 000080 00000000 00000000 00000000 00000000 |................|

M 000000000374B340 000096 00000000 00000000 00000000 00000000 |................|

M 000000000374B350 000112 00000000 00000000 00000000 00000000 |................|

M 000000000374B360 000128 00000000 00000000 00000000 00000000 |................|

M 000000000374B370 000144 00000000 00000000 00000000 00000000 |................|

M 000000000374B380 000160 00000000 00000000 00000000 00000000 |................|

M 000000000374B390 000176 00000000 00000000 00000000 00000000 |................|

M 000000000374B3A0 000192 00000000 00005600 46003000 31002000 |......V.F.0.1. .|

M 000000000374B3B0 000208 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000000374B3C0 000224 20002000 20002000 20002000 20000000 | . . . . . . ...|

M 000000000374B3D0 000240 00000000 00000000 00000000 00000000 |................|

M 000000000374B3E0 000256 00000000 00000000 00000000 00000000 |................|

M 000000000374B3F0 000272 00000000 00000000 00000000 00000000 |................|

M 000000000374B400 000288 00000000 00000000 00000000 00000000 |................|

M 000000000374B410 000304 00000000 00000000 00000000 00000000 |................|

M 000000000374B420 000320 00000000 00000000 00000000 00000000 |................|

M 000000000374B430 000336 00000000 00000000 00000000 00000000 |................|

M 000000000374B440 000352 00000000 00000000 00000000 00000000 |................|

M 000000000374B450 000368 00000000 00000000 00000000 00000000 |................|

M 000000000374B460 000384 00000000 00000000 00000000 00000000 |................|

M 000000000374B470 000400 00000000 00000000 00000000 00000000 |................|

M 000000000374B480 000416 00000000 00000000 00000000 00000000 |................|

M 000000000374B490 000432 00000000 00000000 00000000 00000000 |................|

M 000000000374B4A0 000448 00000000 00000000 00000000 00000000 |................|

M 000000000374B4B0 000464 00000000 00000000 00000000 00000000 |................|

M 000000000374B4C0 000480 00000000 00000000 00000000 00000000 |................|

M 000000000374B4D0 000496 00000000 00000000 00000000 00000000 |................|

M 000000000374B4E0 000512 00000000 00000000 00000000 00000000 |................|

M 000000000374B4F0 000528 00000000 00000000 00000000 00000000 |................|

M 000000000374B500 000544 00000000 00000000 00000000 00000000 |................|

M 000000000374B510 000560 00000000 00000000 00000000 00000000 |................|

M 000000000374B520 000576 00000000 00000000 00000000 00000000 |................|

M 000000000374B530 000592 00000000 00000000 00000000 00000000 |................|

M 000000000374B540 000608 00000000 00000000 00000000 00000000 |................|

M 000000000374B550 000624 00000000 00000000 00000000 00000000 |................|

M 000000000374B560 000640 00000000 00000000 00000000 00000000 |................|

M 000000000374B570 000656 00000000 00000000 00000000 00000000 |................|

M 000000000374B580 000672 00000000 00000000 00000000 00000000 |................|

M 000000000374B590 000688 00000000 00000000 00000000 00000000 |................|

M 000000000374B5A0 000704 00000000 00000000 00000000 00000000 |................|

M 000000000374B5B0 000720 00000000 00000000 00000000 00000000 |................|

M 000000000374B5C0 000736 00000000 00000000 00000000 00000000 |................|

M 000000000374B5D0 000752 00000000 00000000 00000000 00000000 |................|

M 000000000374B5E0 000768 00000000 00000000 00000000 00000000 |................|

M 000000000374B5F0 000784 00000000 00000000 00000000 00000000 |................|

M 000000000374B600 000800 00000000 00000000 00000000 00000000 |................|

M 000000000374B610 000816 00000000 00000000 00000000 00000000 |................|

M 000000000374B620 000832 00000000 00000000 06010201 01000000 |................|

M 000000000374B630 000848 46003600 45004600 30003900 44004600 |F.6.E.F.0.9.D.F.|

M 000000000374B640 000864 45003600 41003300 46003100 45004500 |E.6.A.3.F.1.E.E.|

M 000000000374B650 000880 41004300 38004300 30003000 31003900 |A.C.8.C.0.0.1.9.|

M 000000000374B660 000896 42003900 46003400 32003600 35004100 |B.9.F.4.2.6.5.A.|

M 000000000374B670 000912 52004f00 53004500 4d004100 52004900 |R.O.S.E.M.A.R.I.|

M 000000000374B680 000928 45004500 53002000 33003000 30000000 |E.E.S. .3.0.0...|

M 000000000374B690 000944 02000000 52005600 5f004d00 45005300 |....R.V._.M.E.S.|

M 000000000374B6A0 000960 53004100 47004500 5f005500 50004400 |S.A.G.E._.U.P.D.|

M 000000000374B6B0 000976 41005400 45002000 20002000 20002000 |A.T.E. . . . . .|

M 000000000374B6C0 000992 20002000 20002000 20002000 20002000 | . . . . . . . .|

M 000000000374B6D0 001008 00000000 00000000 00000000 00000000 |................|

M 000000000374B6E0 001024 00000000 00000000 00000000 00000000 |................|

M 000000000374B6F0 001040 00000000 00000000 00000000 00000000 |................|

M 000000000374B700 001056 00000000 00000000 00000000 00000000 |................|

M 000000000374B710 001072 00000000 00000000 00000000 00000000 |................|

M 000000000374B720 001088 00000000 |.... |

M -

---

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

M ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M Entering ThSetStatError

M ThIErrHandle: incomplete previous roll out, do a full roll out

M ThRollOut: roll out T18/U19/M0/I0 (level=7, short_roll_out=0)

M ThRollOut: call rrol_out (1)

M ThRollOut: act roll state = DP_ROLLED_OUT

M ThRollOut: roll level <> 0, don't call ab_rollout

M ThRollOut: full roll out of U19 M0 I0 (Level 7) ok

M ThIErrHandle: prv_action of W18: 0x8

M ThCallDbBreak: use db_sqlbreak

C SQLBREAK: DBSL_CMD_SQLBREAK: CbOnCancel was not set. rc: 15

M *** WARNING => sql break failed (16388)

M ThIErrHandle: don't try rollback again

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

M ThIErrHandle: Entering ThReplyToMsg

M ThIErrHandle: Entering ThErrHdlUser

M ThErrHdlUser: set th_errno (11)

M ThErrHdlUser: save context

M ThEmContextDetach2: detach T18/M0 from em memory (em_hdl=48, force=0)

M ThEmContextDetach2: reset local em info

M call ThrShutDown ...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 018 000 R/3 000000000 ACTIVE YES YES NO 000 255 255 20091218 191945 ERPSQL

C DbSlDisconnect NOT DONE because thread IDs are different.

B Disconnected from connection 0

B statistics db_con_commit (com_total=171298, com_tx=85501)

B statistics db_con_rollback (roll_total=2, roll_tx=2)

M ***LOG Q02=> wp_halt, WPStop (Workproc18 4304) [dpnttool.c 333]

-

---