Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: dbsrv8 crashes with a Segmentation Fault

    Greetings.

    I have a third party application that runs on Sybase ASA 8.0.1 on Red Hat Linux 7.3.

    It runs O.K. except when running a particular report that gets a lot of information from the DB from January 2003 up to today. When that reports is run, the DB crashes with a Segmentation Fault.

    Is there any known issue with Sybsae that might make overflow with queries that return a large amount of data?


  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya,

    Nothing that I know off, you might just want to apply the 8.0.2 patch to the ASA side of things.

    From what you are saying, it may be running out of memory and hence core dumping. You can increase the cache limit using the -cl and -ch cache watermark level and throw more memory to db engine.

    See if that helps.

    Cheers,

    Willy

  3. #3
    Join Date
    Jul 2003
    Posts
    2
    Thank for the suggestion.

    I just tried that and didn't work either.

    I have tried with NCurses 4.2 and 5.2
    glibx 2.2.5
    Different kernel versions, starting from 2.4.18, and they give back the same behavior, and the weird part is that it is always the same queries.

    There are other queries more complex that these and that return more data and are working correctly.

    Not even Sybase support knows that this is yet....

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    You might just want to check with Sybase Support if the old crashes have come back in a different form.

    There were some reported crashes on kernel prior to 2.4.9(for SMP only).

    http://my.sybase.com/detail?id=1002288

    Cheers,

    Willy

  5. #5
    Join Date
    Jul 2003
    Posts
    14
    As u said other queries works with it ... check u r DB with dbcc..

    Originally posted by vsurfer
    Thank for the suggestion.

    I just tried that and didn't work either.

    I have tried with NCurses 4.2 and 5.2
    glibx 2.2.5
    Different kernel versions, starting from 2.4.18, and they give back the same behavior, and the weird part is that it is always the same queries.

    There are other queries more complex that these and that return more data and are working correctly.

    Not even Sybase support knows that this is yet....

  6. #6
    Join Date
    Jul 2003
    Posts
    14
    Change u r Sybase Version to 12.5.. which is free........
    Originally posted by vsurfer
    Thank for the suggestion.

    I just tried that and didn't work either.

    I have tried with NCurses 4.2 and 5.2
    glibx 2.2.5
    Different kernel versions, starting from 2.4.18, and they give back the same behavior, and the weird part is that it is always the same queries.

    There are other queries more complex that these and that return more data and are working correctly.

    Not even Sybase support knows that this is yet....

  7. #7
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    ASA and ASE are 2 different products. They are used for 2 different puposes and upgrade is not an option.

    DBCC's are ASE specific not in ASA.

    ASE 12.5 is not free.

    Originally posted by nileshpathak
    Change u r Sybase Version to 12.5.. which is free........

Posting Permissions

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