-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi, all.
By way of background, we've created an application that keeps tracks of a
user's click stream within a site.
We've run into a curious problem; when the following query is executed in Cold
Fusion Ent 4.5.1 SP2 on Win2K SP1, CF's memory usage explodes and eventually
crashes the server (usage hovers around 250MB and then jumps to 1.8GB, paging
starts to occur, and then we're out of virtual memory and a hard reboot is
necessary). However, if we execute the query against a Microsoft ODBC for
ORACLE data source, it runs without a hitch.
If anyone is willing or able to test this particular scenario on their
DEVELOPMENT servers (watch them carefully; the CF Server's memory is gobbled up
in 50MB chunks) so we can gather more data points, that would be great!
Thanks a lot in advance!
Joe
We've isolated a single recordset that causes this to crash; other recordsets
don't seem to effect in the same way. Here are the details:
ERRANT QUERY:
=====
SELECT page_id,
min(click_sequence) as click_sequence,
(sum(time_end - time_start)*24*60*60) as total_time
FROM learnlab.click_detail_1415
WHERE session_id = '1415'
AND time_end is not null
GROUP BY page_id
UNION
SELECT page_id, min(click_sequence), 0 as total_time
FROM learnlab.click_detail_1415
WHERE session_id = '1415'
AND time_end is null
GROUP BY page_id
TABLE DESCRIPTION:
===========
Column Name Null? Type
- ------------------------------ -------- ----
SESSION_ID NOT NULL NUMBER(5)
PAGE_ID NOT NULL VARCHAR2(10)
CLICK_SEQUENCE NOT NULL NUMBER(5)
TIME_START NOT NULL DATE
TIME_END DATE
PREV_PAGE_ID VARCHAR2(10)
NEXT_PAGE_ID VARCHAR2(10)
INTRO_FLAG CHAR(1)
TABLE CONTENTS:
===============
SESSION_ID PAGE_ID CLICK_SEQU TIME_START TIME_END
PREV_PAGE_ NEXT_PAGE_ I
- ---------- ---------- ---------- -------------------- --------------------
- ---------- ---------- -
1415 CATEGORIES 18 17-MAR-01 17-MAR-01
INTROPROD FUTNWCOV N
1415 CATEGORIES 53 17-MAR-01 17-MAR-01
INTROPROD INTERVIEWS N
1415 CATEGORIES 55 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 CATEGORIES 59 17-MAR-01 17-MAR-01
INTERVIEWS REVIEWS N
1415 CATEGORIES 61 17-MAR-01 17-MAR-01
REVIEWS MAINMENU3 N
1415 CATEGORIES 64 17-MAR-01 17-MAR-01
INTROPROD INTERVIEWS N
1415 CATEGORIES 76 17-MAR-01 17-MAR-01
INTPOINT INTERVIEWS N
1415 CATEGORIES 83 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 CATEGORIES 91 17-MAR-01 17-MAR-01
INTERVIEWS REVIEWS N
1415 CATEGORIES 97 17-MAR-01 17-MAR-01
REVIEWS PRINT N
1415 CATEGORIES 119 17-MAR-01 17-MAR-01
PRINT REVIEWS N
1415 CATEGORIES 121 17-MAR-01 17-MAR-01
REVIEWS PRINT N
1415 CATEGORIES 125 17-MAR-01 17-MAR-01
PRINT REVIEWS N
1415 CATEGORIES 129 17-MAR-01 17-MAR-01
REVIEWS WEBINFO N
1415 CATEGORIES 138 17-MAR-01 17-MAR-01
WEBINFO TVADS N
1415 CATEGORIES 145 17-MAR-01 17-MAR-01
TVADS MAINMENU3 N
1415 CATEGORIES 148 17-MAR-01 17-MAR-01
INTROPROD INTROEXIT N
1415 FUTACCID 12 17-MAR-01 17-MAR-01
FUTCALIF FUTKILLER N
1415 FUTACCID 47 17-MAR-01 17-MAR-01
FUTCALIF FUTKILLER N
1415 FUTCALIF 11 17-MAR-01 17-MAR-01
FUTEAST FUTACCID N
1415 FUTCALIF 46 17-MAR-01 17-MAR-01
FUTEAST FUTACCID N
1415 FUTEAST 10 17-MAR-01 17-MAR-01
FUTOPENS FUTCALIF N
1415 FUTEAST 45 17-MAR-01 17-MAR-01
FUTOPENS FUTCALIF N
1415 FUTEXPENSE 14 17-MAR-01 17-MAR-01
FUTKILLER FUTNETWORK N
1415 FUTEXPENSE 49 17-MAR-01 17-MAR-01
FUTKILLER FUTNETWORK N
1415 FUTINTRO 6 17-MAR-01 17-MAR-01
INTROTOC FUTNWCOV N
1415 FUTKILLER 13 17-MAR-01 17-MAR-01
FUTACCID FUTEXPENSE N
1415 FUTKILLER 48 17-MAR-01 17-MAR-01
FUTACCID FUTEXPENSE N
1415 FUTNETWORK 15 17-MAR-01 17-MAR-01
FUTEXPENSE MAINMENU2 N
1415 FUTNETWORK 50 17-MAR-01 17-MAR-01
FUTEXPENSE MAINMENU2 N
1415 FUTNW1 21 17-MAR-01 17-MAR-01
FUTNW2 FUTNW2 N
1415 FUTNW1 24 17-MAR-01 17-MAR-01
FUTNW3 FUTNWCOV N
1415 FUTNW1 29 17-MAR-01 17-MAR-01
FUTNW2 FUTNWCOV N
1415 FUTNW1 33 17-MAR-01 17-MAR-01
FUTNW3 FUTNWCOV N
1415 FUTNW1 37 17-MAR-01 17-MAR-01
FUTNW3 FUTNW2 N
1415 FUTNW2 20 17-MAR-01 17-MAR-01
FUTNWCOV FUTNW1 N
1415 FUTNW2 22 17-MAR-01 17-MAR-01
FUTNW1 FUTNW3 N
1415 FUTNW2 26 17-MAR-01 17-MAR-01
FUTNWCOV FUTNW3 N
1415 FUTNW2 28 17-MAR-01 17-MAR-01
FUTNW3 FUTNW1 N
1415 FUTNW2 31 17-MAR-01 17-MAR-01
FUTNWCOV FUTNW3 N
1415 FUTNW2 35 17-MAR-01 17-MAR-01
FUTNWCOV FUTNW3 N
1415 FUTNW2 38 17-MAR-01 17-MAR-01
FUTNW1 FUTWJGREEN N
1415 FUTNW3 23 17-MAR-01 17-MAR-01
FUTNW2 FUTNW1 N
1415 FUTNW3 27 17-MAR-01 17-MAR-01
FUTNW2 FUTNW2 N
1415 FUTNW3 32 17-MAR-01 17-MAR-01
FUTNW2 FUTNW1 N
1415 FUTNW3 36 17-MAR-01 17-MAR-01
FUTNW2 FUTNW1 N
1415 FUTNWCOV 7 17-MAR-01 17-MAR-01
FUTINTRO FUTWJGREEN N
1415 FUTNWCOV 19 17-MAR-01 17-MAR-01
CATEGORIES FUTNW2 N
1415 FUTNWCOV 25 17-MAR-01 17-MAR-01
FUTNW1 FUTNW2 N
1415 FUTNWCOV 30 17-MAR-01 17-MAR-01
FUTNW1 FUTNW2 N
1415 FUTNWCOV 34 17-MAR-01 17-MAR-01
FUTNW1 FUTNW2 N
1415 FUTNWCOV 40 17-MAR-01 17-MAR-01
FUTWJGREEN FUTWJGREEN N
1415 FUTNWCOV 42 17-MAR-01 17-MAR-01
FUTWJGREEN FUTWJGREEN N
1415 FUTOPENS 9 17-MAR-01 17-MAR-01
FUTWJGREEN FUTEAST N
1415 FUTOPENS 44 17-MAR-01 17-MAR-01
FUTWJGREEN FUTEAST N
1415 FUTWJGREEN 8 17-MAR-01 17-MAR-01
FUTNWCOV FUTOPENS N
1415 FUTWJGREEN 39 17-MAR-01 17-MAR-01
FUTNW2 FUTNWCOV N
1415 FUTWJGREEN 41 17-MAR-01 17-MAR-01
FUTNWCOV FUTNWCOV N
1415 FUTWJGREEN 43 17-MAR-01 17-MAR-01
FUTNWCOV FUTOPENS N
1415 INTERVIEWS 54 17-MAR-01 17-MAR-01
CATEGORIES CATEGORIES N
1415 INTERVIEWS 56 17-MAR-01 17-MAR-01
CATEGORIES INTFREAKY N
1415 INTERVIEWS 58 17-MAR-01 17-MAR-01
INTFREAKY CATEGORIES N
1415 INTERVIEWS 65 17-MAR-01 17-MAR-01
CATEGORIES INTERVIEWS N
1415 INTERVIEWS 66 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTERVIEWS 67 17-MAR-01 17-MAR-01
INTERVIEWS INTPOINT N
1415 INTERVIEWS 69 17-MAR-01 17-MAR-01
INTPOINT INTPOINT N
1415 INTERVIEWS 77 17-MAR-01 17-MAR-01
CATEGORIES INTERVIEWS N
1415 INTERVIEWS 78 17-MAR-01 17-MAR-01
INTERVIEWS INTUNCOMF N
1415 INTERVIEWS 80 17-MAR-01 17-MAR-01
INTUNCOMF INTFREAKY N
1415 INTERVIEWS 82 17-MAR-01 17-MAR-01
INTFREAKY CATEGORIES N
1415 INTERVIEWS 84 17-MAR-01 17-MAR-01
CATEGORIES INTTIMESAV N
1415 INTERVIEWS 86 17-MAR-01 17-MAR-01
INTTIMESAV INTFREAKY N
1415 INTERVIEWS 88 17-MAR-01 17-MAR-01
INTFREAKY INTUNCOMF N
1415 INTERVIEWS 90 17-MAR-01 17-MAR-01
INTUNCOMF CATEGORIES N
1415 INTFREAKY 57 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTFREAKY 81 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTFREAKY 87 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTPOINT 68 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTPOINT 70 17-MAR-01 17-MAR-01
INTERVIEWS INTPOINT N
1415 INTPOINT 71 17-MAR-01 17-MAR-01
INTPOINT INTPOINT N
1415 INTPOINT 72 17-MAR-01 17-MAR-01
INTPOINT INTPOINT N
1415 INTPOINT 73 17-MAR-01 17-MAR-01
INTPOINT INTPOINT N
1415 INTPOINT 74 17-MAR-01 17-MAR-01
INTPOINT INTPOINT N
1415 INTPOINT 75 17-MAR-01 17-MAR-01
INTPOINT CATEGORIES N
1415 INTROAPP 2 17-MAR-01 17-MAR-01
ADMINMENU MAINMENU1 N
1415 INTROEXIT 100 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 INTROEXIT 133 17-MAR-01 17-MAR-01
WEBACCESS WEBINFO N
1415 INTROEXIT 136 17-MAR-01 17-MAR-01
WEBACCESS WEBINFO N
1415 INTROEXIT 149 17-MAR-01 17-MAR-01
CATEGORIES SURVEXIT1 N
1415 INTROFUTUR 4 17-MAR-01 17-MAR-01
MAINMENU1 INTROTOC N
1415 INTROPROD 17 17-MAR-01 17-MAR-01
MAINMENU2 CATEGORIES N
1415 INTROPROD 52 17-MAR-01 17-MAR-01
MAINMENU2 CATEGORIES N
1415 INTROPROD 63 17-MAR-01 17-MAR-01
MAINMENU3 CATEGORIES N
1415 INTROPROD 147 17-MAR-01 17-MAR-01
MAINMENU3 CATEGORIES N
1415 INTROTOC 5 17-MAR-01 17-MAR-01
INTROFUTUR FUTINTRO N
1415 INTTIMESAV 85 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTUNCOMF 79 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 INTUNCOMF 89 17-MAR-01 17-MAR-01
INTERVIEWS INTERVIEWS N
1415 MAINMENU1 3 17-MAR-01 17-MAR-01
INTROAPP INTROFUTUR N
1415 MAINMENU2 16 17-MAR-01 17-MAR-01
FUTNETWORK INTROPROD N
1415 MAINMENU2 51 17-MAR-01 17-MAR-01
FUTNETWORK INTROPROD N
1415 MAINMENU3 62 17-MAR-01 17-MAR-01
CATEGORIES INTROPROD N
1415 MAINMENU3 146 17-MAR-01 17-MAR-01
CATEGORIES INTROPROD N
1415 PRINT 98 17-MAR-01 17-MAR-01
CATEGORIES PRINT N
1415 PRINT 99 17-MAR-01 17-MAR-01
PRINT INTROEXIT N
1415 PRINT 101 17-MAR-01 17-MAR-01
INTROEXIT PRTINFOCAR N
1415 PRINT 104 17-MAR-01 17-MAR-01
PRTINFOCAR PRTCONTROL N
1415 PRINT 106 17-MAR-01 17-MAR-01
PRTCONTROL PRTBORING N
1415 PRINT 108 17-MAR-01 17-MAR-01
PRTBORING PRTRESPONS N
1415 PRINT 110 17-MAR-01 17-MAR-01
PRTRESPONS PRTWITH N
1415 PRINT 112 17-MAR-01 17-MAR-01
PRTWITH PRTRUBBISH N
1415 PRINT 114 17-MAR-01 17-MAR-01
PRTRUBBISH PRTRUBBISH N
1415 PRINT 116 17-MAR-01 17-MAR-01
PRTRUBBISH PRTWITH N
1415 PRINT 118 17-MAR-01 17-MAR-01
PRTWITH CATEGORIES N
1415 PRINT 122 17-MAR-01 17-MAR-01
CATEGORIES PRTRESPONS N
1415 PRINT 124 17-MAR-01 17-MAR-01
PRTRESPONS CATEGORIES N
1415 PRTBORING 107 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTCONTROL 105 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTINFOCAR 102 17-MAR-01 17-MAR-01
PRINT PRTINFOCAR N
1415 PRTINFOCAR 103 17-MAR-01 17-MAR-01
PRTINFOCAR PRINT N
1415 PRTRESPONS 109 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTRESPONS 123 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTRUBBISH 113 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTRUBBISH 115 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTWITH 111 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 PRTWITH 117 17-MAR-01 17-MAR-01
PRINT PRINT N
1415 REVDUMBFND 95 17-MAR-01 17-MAR-01
REVIEWS REVIEWS N
1415 REVIEWS 60 17-MAR-01 17-MAR-01
CATEGORIES CATEGORIES N
1415 REVIEWS 92 17-MAR-01 17-MAR-01
CATEGORIES REVSHUTTLE N
1415 REVIEWS 94 17-MAR-01 17-MAR-01
REVSHUTTLE REVDUMBFND N
1415 REVIEWS 96 17-MAR-01 17-MAR-01
REVDUMBFND CATEGORIES N
1415 REVIEWS 120 17-MAR-01 17-MAR-01
CATEGORIES CATEGORIES N
1415 REVIEWS 126 17-MAR-01 17-MAR-01
CATEGORIES REVSHUTTLE N
1415 REVIEWS 128 17-MAR-01 17-MAR-01
REVSHUTTLE CATEGORIES N
1415 REVSHUTTLE 93 17-MAR-01 17-MAR-01
REVIEWS REVIEWS N
1415 REVSHUTTLE 127 17-MAR-01 17-MAR-01
REVIEWS REVIEWS N
1415 SURVEXIT1 150 17-MAR-01 17-MAR-01
INTROEXIT SURVEXIT2 N
1415 SURVEXIT10 159 17-MAR-01 17-MAR-01
SURVEXIT9 SURVEXIT11 N
1415 SURVEXIT11 160 17-MAR-01 17-MAR-01
SURVEXIT10 SURVEXIT12 N
1415 SURVEXIT12 161 17-MAR-01 17-MAR-01
SURVEXIT11 SURVEXIT13 N
1415 SURVEXIT13 162 17-MAR-01 17-MAR-01
SURVEXIT12 SURVEXIT14 N
1415 SURVEXIT14 163 17-MAR-01 17-MAR-01
SURVEXIT13 END N
1415 SURVEXIT2 151 17-MAR-01 17-MAR-01
SURVEXIT1 SURVEXIT3 N
1415 SURVEXIT3 152 17-MAR-01 17-MAR-01
SURVEXIT2 SURVEXIT4 N
1415 SURVEXIT4 153 17-MAR-01 17-MAR-01
SURVEXIT3 SURVEXIT5 N
1415 SURVEXIT5 154 17-MAR-01 17-MAR-01
SURVEXIT4 SURVEXIT6 N
1415 SURVEXIT6 155 17-MAR-01 17-MAR-01
SURVEXIT5 SURVEXIT7 N
1415 SURVEXIT7 156 17-MAR-01 17-MAR-01
SURVEXIT6 SURVEXIT8 N
1415 SURVEXIT8 157 17-MAR-01 17-MAR-01
SURVEXIT7 SURVEXIT9 N
1415 SURVEXIT9 158 17-MAR-01 17-MAR-01
SURVEXIT8 SURVEXIT10 N
1415 TVADS 139 17-MAR-01 17-MAR-01
CATEGORIES TVEYES N
1415 TVADS 141 17-MAR-01 17-MAR-01
TVEYES TVADS N
1415 TVADS 142 17-MAR-01 17-MAR-01
TVADS TVEYES N
1415 TVADS 144 17-MAR-01 17-MAR-01
TVEYES CATEGORIES N
1415 TVEYES 140 17-MAR-01 17-MAR-01
TVADS TVADS N
1415 TVEYES 143 17-MAR-01 17-MAR-01
TVADS TVADS N
1415 WEBACCESS 131 17-MAR-01 17-MAR-01
WEBINFO WEBACCESS N
1415 WEBACCESS 132 17-MAR-01 17-MAR-01
WEBACCESS INTROEXIT N
1415 WEBACCESS 135 17-MAR-01 17-MAR-01
WEBINFO INTROEXIT N
1415 WEBINFO 130 17-MAR-01 17-MAR-01
CATEGORIES WEBACCESS N
1415 WEBINFO 134 17-MAR-01 17-MAR-01
INTROEXIT WEBACCESS N
1415 WEBINFO 137 17-MAR-01 17-MAR-01
INTROEXIT CATEGORIES N
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBOrtZqtCGp5RuWHIBEQI5GgCgtiEd/ZdNlg58CSxlyOfXFduSORAAoNBw
i6BpV1cphA4h/DLqZzhHZaV2
=NmFP
-----END PGP SIGNATURE-----
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
