Hi,
We've hit a problem with Coldfusion 5 on Solaris 8 using OpenClient
11.1.1.7883 to access a Sybase 12 database. The CF process grows until it
hits around 200Mb in size, then it dies with "? mts:
{mts_append_large_block} failed to update index of memory pages". There is
around 3Gb of free RAM on the box at this point so it's not running out of
memory.
Here is the truss output :-
close(29) = 0
door_info(16, 0xFC30B918) = 0
door_call(16, 0xFC30B900) = 0
open("/dev/tcp", O_RDWR) = 29
ioctl(29, I_FIND, "timod") = 0
ioctl(29, I_PUSH, "timod") = 0
ioctl(29, I_STR, 0xFC30D970) = 0
time() = 1054147097
fstat(29, 0xFC30D8F8) = 0
brk(0x0D6A7000) = 0
write(8, " ? m t s : ", 7) = 7
time() = 1054147097
write(8, " {", 1) = 1
write(8, 0x00A946A8, 22) = 22
m t s _ a p p e n d _ l a r g e _ b l o c k
write(8, 0x00ADBAB3, 39) = 39
} f a i l e d t o u p d a t e i n d e x o f m e m o r
y p a g e s
write(8, "\n", 1) = 1
_exit(110)
I can reproduce this by simultenously kicking off multiple requests for a
coldfusion page which calls stored procs that return large result sets.
Note: we are using CFSTOREDPROC , not CFQUERY.
Macromedia point their finger at 3 possible things :-
- CFX tags which aren't threadsafe.
- Incorrect locking.
- Old / unsafe database drivers.
I have ruled out the first two - we don't use CFX tags and I used full
checking of locks to ensure the locking was correct.
I have tried OpenClient version 12.0.0.0 but get the same thing. Even tried
Merant ODBC drivers but they are more trouble than they are worth - e.g.
when calling procs the parameters have to be positional etc.
Searching forums shows that many people are having these problems but no
one is finding answers.
Has anyone seen this before? And know how to fix it, work around it, have
any suggestions?
Thanks,
Will.
This communication is for informational purposes only. It is not intended as
an offer or solicitation for the purchase or sale of any financial instrument
or as an official confirmation of any transaction. All market prices, data
and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=10
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=10
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
