Greetings, We've been using AOLserver with Oracle in Unix/Sun platform; recently we've attempted to expand our servers with running AOLserver (3.4.2) on Intel/Linux (RH 6.2 & 7.1), while the performance is good and all of our application seem to work on this stack, the major issue has been frequent AOLserver crashes with no pattern. After a long and painful troubleshooting process, we found the cause of these crashes, and that is: selecting an empty clob using ACS API (or ns_db process). Running the same query via SQL/Plus from this Linux box, works fine.
Note that the club has to be Only initialized with the empty_clob() in order to trigger the crash, so if you actually insert NULL in there, we are fine. But since there are lots of these empty clobs around, we have couple crashes every hour when we put this server in live traffic. Our Oracle database server (8.1.6.3) is running on a Solaris box and the Oracle client on Linux is 8.1.7.0, the ns_ora (Oracle Driver) version is 2.6. There are no errors coming to logs, only on the DB logs we see the following at the time of crashes: ORA-07445: exception encountered: core dump [ttci2u()+2356] [SIGSEGV] [Address not mapped to object] [0] [] [] Any other solution or advice regarding this issue will be a big breakthrough for us. There has been a suggestion as to upgrade the Oracle client on the Linux to 9.2.0.2, any comments on that would also be appreciated. Thanks in advanced for your help. Seena Kasmai Web Application Engineer The Away Network 702 H Street, NW Washington, DC 20001 The leading resource for active travel and the outdoor lifestyle www.away.com www.gorp.com www.outsidemag.com -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.