Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Red face Unanswered: Stack dump during Sybase start

    Hi,
    I recently upgraded from ASE 12.5.2 to ASE 12.5.3 using the EBF13331, on a Windows Server 2003. During the ASE startup, the databases get loaded fine, but at the end I get a stack dump:
    **************************
    server Database 'dbccdb' is now online.
    kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
    kernel Symbolic stack trace information is successfully loaded
    kernel pc: 0x77BD399B wscanf+ 0x766 (0x0227E900, 0x0227F5F4, 0x0227E930, 0x0227FBB9)
    kernel pc: 0x77BD399B wscanf+ 0x766 (0x0227E9D8, 0x0227F5F4, 0x00000003, 0x0227FA10)
    kernel pc: 0x77BD08B9 sprintf+ 0x31 (0x00000002, 0x0227E9D8, 0x0227F5F4, 0x00000071)
    kernel pc: 0x004730AC ex_stuffp+ 0x355 (0x00003124, 0x0000000A, 0x00000002, 0x0227F844)
    kernel [Handler pc: 0x00470380 ex_stop_recursion installed by the following function:-]
    kernel pc: 0x0047100B ex_doprint+ 0x4f3 (0x00003124, 0x0000000A, 0x00000002, 0x0227F844)
    kernel pc: 0x00470B11 ex_print+ 0x7e (0x00003124, 0x0000000A, 0x00000002, 0x00000003)
    kernel pc: 0x00472C8B ex_callprint+ 0x93 (0x00003124, 0x0000000A, 0x00000002, 0x00000003)
    kernel pc: 0x0076B77B mnt_ex_print+ 0xfb (0x00000001, 0x00000000, 0x004E11B2, 0x00000001)
    kernel [Handler pc: 0x0047E128 hdl_backout_msg installed by the following function:-]
    kernel pc: 0x006BD22E rec__tune_bufpools+ 0xca1 (0x23C27000, 0x0227FC9C, 0x0227FE8F, 0x00000001)
    kernel pc: 0x006BC57A rec_run_parallel_recovery+ 0x945 (0x00000001, 0x21311780, 0x2002F020, 0x00000000)
    kernel [Handler pc: 0x006C95B1 rec__caller_hdlr installed by the following function:-]
    kernel pc: 0x006BF3D5 dorecover+ 0x1a2 (0x00000000, 0x00000000, 0x00000000, 0x00000001)
    kernel pc: 0x0040AF5D ds__recoverdbs+ 0x790 (0x00000000, 0x00000000, 0x00000000, 0x236C95D0)
    kernel pc: 0x00405CC1 dsinit+ 0x1281 (0x236C95D0, 0x00000000, 0x00000000, 0x236C95D0)
    kernel pc: 0x00BCCAD7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel pc: 0x77E6482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel end of stack trace, spid 1, kpid 524296, suid 0
    kernel ************************************
    kernel SQL causing error : @ [

    kernel ************************************
    server SQL Text: @ [

    kernel curdb = 1 tempdb = 2 pstat = 0x4000
    kernel lasterror = 0 preverror = 0 transtate = 1
    kernel curcmd = 0 program =
    kernel pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x0227DCD0, 0x77E61A60, 0x77E64598, 0xFFFFFFFF)
    kernel pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x0227DCD0, 0x0227DA88, 0x0000270F, 0x00000002)
    kernel pc: 0x00C2D4D5 pcstkwalk+ 0x204 (0x00080008, 0x00000002, 0x0000270F, 0x00000000)
    kernel pc: 0x00C2D15F ucstkgentrace+ 0x25f (0x00080008, 0x00000001, 0x00000000, 0x00000000)
    kernel pc: 0x00BD7A0B ucbacktrace+ 0xab (0x00080008, 0xFFFFFFFF, 0x0227E278, 0xC0000005)
    kernel pc: 0x0040760C terminate_process+ 0xccd (0xC0000005, 0x77BC6CD5, 0x0227E2AC, 0x00000000)
    kernel pc: 0x00BCBF44 kiexception+ 0x4b9 (0x236C95D0, 0x00000000, 0x00000000, 0x236C95D0)
    kernel pc: 0x00BCCB57 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel pc: 0x77E6482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel end of stack trace, spid 1, kpid 524296, suid 0
    server Error: 12580, Severity: 10, State: 2
    kernel SQL Server system exception (0xc0000005) generated by a storage access violation.
    kernel pc: 0x77BD399B wscanf+ 0x766 (0x0227CC6C, 0x0227D960, 0x0227CC9C, 0x0227DF25)
    kernel pc: 0x77BD399B wscanf+ 0x766 (0x0227CD44, 0x0227D960, 0x00000002, 0x0227DC88)
    kernel pc: 0x77BD08B9 sprintf+ 0x31 (0x00000002, 0x0227CD44, 0x0227D960, 0x00000071)
    kernel pc: 0x004730AC ex_stuffp+ 0x355 (0x00003124, 0x0000000A, 0x00000002, 0x0227DBB0)
    kernel [Handler pc: 0x00470380 ex_stop_recursion installed by the following function:-]
    kernel pc: 0x0047100B ex_doprint+ 0x4f3 (0x00003124, 0x0000000A, 0x00000002, 0x0227DBB0)
    kernel pc: 0x00470B11 ex_print+ 0x7e (0x00003124, 0x0000000A, 0x00000002, 0x00000002)
    kernel pc: 0x00472C8B ex_callprint+ 0x93 (0x00003124, 0x0000000A, 0x00000002, 0x00000002)
    kernel pc: 0x0076B77B mnt_ex_print+ 0xfb (0x00000001, 0x00000000, 0x200D6500, 0x00000000)
    kernel [Handler pc: 0x0047E128 hdl_backout_msg installed by the following function:-]
    kernel pc: 0x006BD322 rec__tune_bufpools+ 0xd95 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel pc: 0x006C91D0 rec_caller_backout+ 0x29b (0x220A898C, 0xFFFFFFFF, 0x00000000, 0x00000000)
    kernel [Handler pc: 0x0047E114 hdl_backout installed by the following function:-]
    kernel pc: 0x00425134 kill_proc+ 0x15c (0x00080008, 0xFFFFFFFF, 0x0227E278, 0xC0000005)
    kernel pc: 0x00407B2B terminate_process+ 0x11ec (0xC0000005, 0x77BC6CD5, 0x0227E2AC, 0x00000000)
    kernel pc: 0x00BCBF44 kiexception+ 0x4b9 (0x236C95D0, 0x00000000, 0x00000000, 0x236C95D0)
    kernel pc: 0x00BCCB57 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel pc: 0x77E6482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel end of stack trace, spid 1, kpid 524296, suid 0
    kernel ************************************
    kernel pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x0227C03C, 0x77E61A60, 0x77E64598, 0xFFFFFFFF)
    kernel pc: 0x00C57F38 os_get_cur_stk_desc+ 0x170 (0x0227C03C, 0x0227BDF4, 0x0000270F, 0x00000002)
    kernel pc: 0x00C2D4D5 pcstkwalk+ 0x204 (0x00080008, 0x00000002, 0x0000270F, 0x00000000)
    kernel pc: 0x00C2D15F ucstkgentrace+ 0x25f (0x00080008, 0x00000001, 0x00000000, 0x00000000)
    kernel pc: 0x00BD7A0B ucbacktrace+ 0xab (0x00080008, 0xFFFFFFFF, 0x0227C5E4, 0xC0000005)
    kernel pc: 0x00406B04 terminate_process+ 0x1c5 (0xC0000005, 0x77BC6CD5, 0x0227C618, 0x00000000)
    kernel pc: 0x00BCBF44 kiexception+ 0x4b9 (0x236C95D0, 0x00000000, 0x00000000, 0x236C95D0)
    kernel pc: 0x00BCCB57 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel pc: 0x77E6482F GetModuleHandleA+ 0xdf (0x00000000, 0x00000000, 0x00000000, 0x00000000)
    kernel end of stack trace, spid 1, kpid 524296, suid 0
    *************************
    I desperately need help from all Sybase experts, as my users are suffering from this downtime. Sybase won't help me since I'm in a lower version than their current version.

    Thanks
    Debasish

  2. #2
    Join Date
    Aug 2007
    Location
    Johannesburg, South Africa
    Posts
    11
    Not sure if this will help but it may be a place to start; "generated by a storage access violation" is listed in the stack trace, are all the volumes/storage correct and usable and can it be written and read from?
    Also, I would seriously start looking at going to the up to date version of ASE, ASE 15. ASE 12 has reached end of life, and get support contract if you don't have already. It's like a backup, you think you may not need it until the day you do.
    Last edited by scorn; 10-28-10 at 07:43. Reason: Missed Some Info

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    Red face Stack dump during Sybase start

    Hi Scorn,

    Thanks very much for your reply. Yes my colleague has opened up a case with Sybase support and we are waiting for them to reply. As for the volumes and storage, I consulted our Network division and they say that the hard drives are good and we were able to create and delete files from the same volume. So somewhat certain that they are fine.
    Now for upgrading to ASE 15, its in the works, but at this point of time several developers are awaiting for the sybase server to come up and then we can start working on the upgrade.
    So in a nutshell we are still getting the errors and can't figure out why.

  4. #4
    Join Date
    Aug 2007
    Location
    Johannesburg, South Africa
    Posts
    11
    You're Welcome.
    Sorry that I could not provide more valuable input so support is your best bet at this point.
    I also tried a generic search for server Error: 12580, Severity: 10, State: 2 but no luck.

    Did you guys have the same issues when you were testing the upgrade in a dev environment, or is this dev?
    If all else fails, try rolling back, (If possible), until a satisfactory answer can be found.

    Best of luck to you, please let us know the outcome should be interesting.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •