Hi Will, I have also seen this resolved by making the following change to the start script:
Add two additional variables named CF_THREAD_STACK_SIZE and CF_MTS_HEAPS. Here's the description from our documentation: "Controlling the number of heaps The new memory allocation library used on Solaris has a configurable number of "heaps". These heaps are assigned in a round-robin fashion to each thread in the ColdFusion server. If there are at least as many heaps as there are threads running, the amount of locking done while allocating memory is reduced to the absolute minimum, and performance is increased. This provides maximum performance for all configuration, but may consume more memory than is necessary. You can tune the number of heaps allocated when ColdFusion starts up by setting the environment variable CF_MTS_HEAPS to be the number of heaps you prefer. In our testing we have found that having too many heaps does not hurt performance, while having too few has a dramatic negative affect on performance. To set the CF_MTS_HEAPS and CF_THREAD_STACK_SIZE environment variable, add them to the /opt/coldfusion/bin/start script. You must also add these variables to the "VAR_LIST" for the variable to be used by ColdFusion." For example: CF_THREAD_STACK_SIZE=10000 CF_MTS_HEAPS=1 ... VAR_LIST="LD_LIBRARY_PATH CFHOME ODBCINI ORACLE_HOME CF_MTS_HEAPS CF_THREAD_STACK_SIZE" The values above of 10000 and 1 are what customers I've worked with have used to resolve the error. Christine -----Original Message----- From: Will Dell [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 7:55 AM To: CF-Server Subject: mts_append_large_block No I haven't tried ColdFusion MX. But yes it may well work around the problem by using JDBC drivers. Am hoping that is a last resort though. Thanks, Will. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=10 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=10 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
