id go for a named lock around it either that or cant you place both the query statements in the same cfquery
did you say mysql i though @@identity was sql server Alex -----Original Message----- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 24 June 2003 17:28 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MX "Locking Up" + other issues I've done some more digging... > I think the first suggestion is to check the permissions on the > folders that you are uploading to to check that the CF user can > actually upload files (ie save etc) to that directory... Permissions are fine. > whats the cpu utilisation Low: load average: 0.03, 0.08, 0.08 After looking around I think I've found the issue in the template I'd already discovered to be one of the ones "stalling": There are two queries, the first inserting a new row, the second grabbing back the new ID as so: <!--- get the file id ---> <cfquery name="qfileIdent" datasource="#request.dsn#"> SELECT @@identity AS fileident </cfquery> It appears that the stall is happening here. If I comment out this query and default the value to a fake one, everything runs fine. So why would this stall? I've tried running the two queries directly from the command line to MySQL and I get the right result back in a good time. Also, there are a number of other pages on this site and others on the same box that use an almost carbon-copy of the above (just var names changing etc) that work fine... Hmmmmm... I'm now wondering where to go with this. How to find out which other templates could be effected? Is this a CF issue or a DB issue? Is it more than one problem or is everything the same/related? Gah... Tim. ------------------------------------------------------- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. ------------------------------------------------------- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 ------------------------------------------------------- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. ------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
