oracle - ColdFusion - Duplicate POST Being Fired -
oracle - ColdFusion - Duplicate POST Being Fired -
i have unusual thing happening , cannot seem track down. have simple cfm simple form, user presses submit button, page posts , calls chlorofluorocarbon function <cfinvoke>
. function beingness invoked has single <cfstoredproc>
phone call oracle. oracle procedure supposed create around 3,000+ records. it's creating double amount. set <cflog>
right before <cfstoredproc>
phone call , there 2 entries beingness created. function beingness fired sec time somehow. same user, same sessionid, different threadid. have no thought sec phone call coming from.
i set <cflock>
around <cfstoredproc>
phone call , fixed problem, 3000+ recs created. lock timeout error mysterious sec call.
another unusual thing <cflock>
has timeout of 30 seconds. <cflog>
shows 1 entry initially, 60 seconds later sec log entry appears , <cflock>
error happens. dropped <cflock>
timeout downwards 15 seconds , results still same. why sec mysterious phone call beingness logged 1 min after first 1 every time?
i'm running coldfusion 10,0,13,287689.
"severity","threadid","date","time","application","message" "information","ajp-bio-8012-exec-9","06/26/14","14:59:34",,"d:\coldfusion10\cfusion\logs\cbruserwo_cfc.log initialized" "information","ajp-bio-8012-exec-9","06/26/14","14:59:34","xxx","usera // usera // 1958938 // lockname: b-100139230442054" "information","ajp-bio-8012-exec-7","06/26/14","15:00:35","xxx","usera // usera // 1958938 // lockname: b-100139230442054" <-- mysterious one, comes in 1 min later "information","ajp-bio-8012-exec-12","06/26/14","15:08:36","xxx","usera // usera // 1958938 // lockname: b-100139230442054" "information","ajp-bio-8012-exec-5","06/26/14","15:09:37","xxx","usera // usera // 1958938 // lockname: b-100139230442054" <-- mysterious one, comes in 1 min later "information","ajp-bio-8012-exec-1","06/26/14","15:19:54","xxx","usera // usera // 1958938 // lockname: b-100139230442054" "information","ajp-bio-8012-exec-7","06/26/14","15:20:57","xxx","usera // usera // 1958938 // lockname: b-100139230442054" <-- mysterious one, comes in 1 min later
i using application.cfc both onrequest
, oncfcrequest
methods (along other usual ones).
some of code ...
<cfcomponent> <cffunction name="create" access="public"> ...removed trivial code... <!--- start: debug craziness ---> <cflock timeout="30" name="a-#form.cbrorderunid#"> <cfif not isdefined("session.cbruserwo_cfc.calledcnt")> <cfset session.cbruserwo_cfc.calledcnt = 1> <cfelse> <cfset session.cbruserwo_cfc.calledcnt = session.cbruserwo_cfc.calledcnt+1> </cfif> <cflog file="cbruserwo_cfc" text="#session.sv.un# // #session.sv.fullname# // #session.sv.csid# // lockname: b-#form.cbrorderunid#"> <cfsavecontent variable="xxx"> <cfoutput> session.cbruserwo_cfc.calledcnt: #session.cbruserwo_cfc.calledcnt#<br> cgi: <cfdump var="#cgi#"> form: <cfdump var="#form#"> url: <cfdump var="#url#"> arguments: <cfdump var="#arguments#"> </cfoutput> </cfsavecontent> <cffile action= "write" file="d:\temp\cbruserwo_cfc.html" addnewline="no" output="#xxx#"> </cflock> <!--- end: debug craziness ---> <!--- debug code above shows post/call/request beingness made, network traffic shows 1 post happening ---> <cflock timeout="30" name="b-#form.cbrorderunid#"> <cfstoredproc> <!--- phone call 3000+ inserts, omitted contents, irrelavent question. cflock around fixes duplicate records beingness created, lock timeout errors mysterious sec request. ---> </cfstoredproc> </cflock> ...removed trivial code... </cffunction> </cfcomponent>
update...
some people inquire code , saying don't post code, don't know heck guys want. admit weird one. added application.cfc->onrequest function. not sure if has it. @ time this...
<cffunction name="onrequest" access="public"> <cfargument name="targetpage" type="string" required="true" /> <!--- create these functions globally accessible ---> <cfset structappend(url, createobject("component", "lib_globalfunctions"))> <!--- include requested page. ---> <cfinclude template="#arguments.targetpage#" /> </cffunction>
i inspected apache ssl_requestlog's, there 1 post happening. that's why didn't show of html, form, button, submit code.
i'll seek ripping out customtags / proprietary code , come bare bones generic replication of bug. if can i'll rewrite question , post that. it'll take time. wondering if had heard of bug before, looks no 1 has, thanks.
more updates...
it looking less , less coldfusion issue.
each bullet point consistently repeatable each user.
me - latest version of chrome, sec mysterious request happens. another user - same building, same version of chrome, no sec request. me - ie10, no sec request. another user - outside building, ie10, sec mysterious request happens.
check application.cfc/application.cfm , see if there manipulation post info in onrequest function.
oracle coldfusion
Comments
Post a Comment