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

    Unanswered: ASE 12.5.3 Stack trace

    Hi

    I installed an HP-UX 11iv3 server with Sybase ASE 12.5.3. Also configured the system as to the software vendors specification.

    When a user commits a specific transaction to the database, he recieves a generic application error.

    But when I view the sybase log file, I find a stack trace at exactly the same time then the user tried to commit the transaction.

    03:00000:00051:2008/07/02 20:41:32.80 kernel current process (0x1f001f) infected with 11
    03:00000:00051:2008/07/02 20:41:32.80 kernel Error at address 0x40000000008b07c7 (set_cast+0x89f)
    03:00000:00051:2008/07/02 20:41:32.82 kernel ir=0000000005926c00.0000000000000020
    03:00000:00051:2008/07/02 20:41:32.82 kernel pc=000000000268d400.40000000008b07cb psw=0000000000000001
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr0-3 0000000000000000 000000000000003f c00000001f28c000 c00000
    001f319780
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr4-7 0000000000000037 0000000000000038 c00000001175d304 000000
    0000000023
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr8-11 000000000000000b 800000000025b770 0000000000000037 000000
    0000000080
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr12-15 80000000005e28e0 8000000000615a28 0000000000000055 000000
    0000000024
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr16-19 0000000000000080 c00000001a128420 0000000000000000 000000
    000471b57b
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr20-23 c00000001f31bff0 0000000000000000 c00000001a12d568 000000
    0000000080
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr24-27 c00000001f11f428 0000000000000020 0000000000000000 800000
    00005fc0e0
    03:00000:00051:2008/07/02 20:41:32.82 kernel gr28-31 0000000040000020 c00000001f11f520 c00000001175d610 000000
    0040000000
    03:00000:00051:2008/07/02 20:41:32.83 kernel ************************************
    03:00000:00051:2008/07/02 20:41:32.83 kernel SQL causing error : .770000,NULL,NULL,NULL,NULL,NULL,NULL,
    NULL, NULL,'M', 'M', 'M', 'M', NULL,
    NULL,
    NULL
    Select @nRC
    03:00000:00051:2008/07/02 20:41:32.83 kernel ************************************
    03:00000:00051:2008/07/02 20:41:32.83 server SQL Text: .770000,NULL,NULL,NULL,NULL,NULL,NULL,
    NULL, NULL,'M', 'M', 'M', 'M', NULL,
    NULL,
    NULL
    Select @nRC
    03:00000:00051:2008/07/02 20:41:32.83 kernel curdb = 5 tempdb = 2 pstat = 0x10000
    03:00000:00051:2008/07/02 20:41:32.83 kernel lasterror = 0 preverror = 0 transtate = 0
    03:00000:00051:2008/07/02 20:41:32.83 kernel curcmd = 224 program = CENTURA Sybase App
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e8e280 pcstkwalk+0x50()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e8eb20 ucstkgentrace+0x2c8()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e4ad30 ucbacktrace+0x80()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008e36e8 terminate_process+0xf00()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000e677a8 kisignal+0x230()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000869800 _sigreturn()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008b07c4 set_cast+0x89c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000916e40 n3__subq_set_cast+0x40()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008d4884 n3_binaryop+0x344()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008be728 norm3_expr+0x438()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008bf120 norm3_propagate+0x188()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cf158 norm3+0x18()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006ced34 norm3__idriver+0x9c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cec5c norm3_driver+0x3c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000006cebd4 normalize+0x7c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008b1220 s_normquery+0x170()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008a6ab4 s__call_normquery+0x9c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000890f4c s_normalize+0x14c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000bea824 s_renormalize+0xc4()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000939b3c s_recompile+0x53c()
    03:00000:00051:2008/07/02 20:41:32.83 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
    ng function:-]
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x4000000000811984 sequencer+0x8ac()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008103a0 execproc+0x4b8()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000007a8634 s_execute+0x2094()
    03:00000:00051:2008/07/02 20:41:32.83 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
    ng function:-]
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x400000000081133c sequencer+0x264()
    03:00000:00051:2008/07/02 20:41:32.83 kernel pc: 0x40000000008103a0 execproc+0x4b8()
    03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000007a8634 s_execute+0x2094()
    03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x400000000068bb10 s_handle installed by the followi
    ng function:-]
    03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x400000000081133c sequencer+0x264()
    03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000008bca18 tdsrecv_language+0xb0()
    03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000961428 hdl_backout installed by the foll
    owing function:-]
    03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000b85328 ut_handle installed by the follow
    ing function:-]
    03:00000:00051:2008/07/02 20:41:32.84 kernel [Handler pc: 0x4000000000b85328 ut_handle installed by the follow
    ing function:-]
    03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x4000000000835198 conn_hdlr+0x798()
    03:00000:00051:2008/07/02 20:41:32.84 kernel pc: 0x40000000007b0ce0 proc_stack_switch+0x60()
    03:00000:00051:2008/07/02 20:41:32.84 kernel end of stack trace, spid 51, kpid 2031647, suid 1





    Can anyone help?

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    If you see the last meaninful function.

    Its set_cast. So, from what it looks like ASE is unable to convert a particular datatype.

    It looks like you may be hitting CR 374710

    Try doing one of the below
    a) drop/recreate stored proc
    b) check the datatypes of variables used in the SQL and the column datatypes.
    c) traceflag 291 in the startup

  3. #3
    Join Date
    Jun 2008
    Posts
    4
    thx trvishi

    Trace Flag 291 was already configured at sybase startup, we managed to bypass the error by also configuring T7710.

Posting Permissions

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