On Tue, Nov 11, 2003 at 11:24:47PM -0500, Seena Kasmai wrote: > 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.
Don Baccus exaplained here that the underlying cause is an Oracle bug: http://openacs.org/forums/message-view?message_id=141431 > 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. Don says there that his workaround was to set CLOBs to empty string rather than empty_clob(). Seems you've tried NULL and that works too. So can't you just update all the empty_clobs in your tables to empty string or NULL, and you're fine? > 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. At least from that thread on OpenACS, I don't think Don or anyone else new exactly when or where that bug was fixed. He was also talking about a entirely different problem, a 9i memory leak, which fixed in 9.2.0.3. You might want to open a TAR with Oracle in order to get more detail and help from the Oracle people. After all, you might as well get some benefit out of the support money away.com is paying to Oracle... Short of that, it would be useful for you to search on Metalink and fid precisely what Oracle bug number this is, so you can check in just what versions it's fixed, etc. Or move your database from Solaris to Linux. :) Ok, you don't want to do that just to fix this problem, and we've no idea how much data you're talking about, and it could be a big job. You COULD do it, but unfortunately only by exporting everything and then import it all back in. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.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.
