I've commited the var'd version to the p610 branch and trunk. If you still have the VarScoper report can you send me that. I thought we had been there and done that, but I guess not.
Blair On Thu, Dec 8, 2011 at 10:48 AM, James Buckingham <[email protected]>wrote: > Hi group, > > Over the past week we've been having a lot of stability issues. In fact > since we went live with 6.1.1 mid-November our production server hasn't > been the most reliable. We've also seen a large drop in page speed since > go-live. > > We're investigating what's going on at the moment and making a few changes > to our server configuration but obviously with the biggest change being the > upgrade that's were we're currently looking for answers. > > I thought it best to post our findings so far and by all means if anyone > has any recommendation on how to diagnosis and fix this it would be much > appreciated. > > ----- > > Looking at our JRun logs and the farLog table I'm seeing a large number of > these types of errors appearing:- > > 12/07 22:06:59 Error [jrpp-499] - Error Executing Database Query. Column > count doesn't match value count at row 1 [SQL: INSERT INTO farLog ( > CREATEDBY > , LOCATION , LASTUPDATEDBY , TYPE , DATETIMELASTUPDATED , OBJECTID , NOTES > , DATETIMECREATED , USERID , OBJECT , LOCKEDBY , LOCKED , EVENT ) VALUES > ( (param 1) , (param 2) , (param 3) (param 4) , (param 5) , > (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , > (param 11) , (param 12) , (param 13) ) ] > > AND statement in the WHERE clause.... > > SELECT columns FROM dmImage WHERE AND objectid = > '07CCA55F-1275-11DF-B173000D609CAA9E'; > > Duplicated LASTUPDATTEDBY in this one.... > > Column 'lastupdatedby' specified twice [SQL: INSERT INTO farLog ( > CREATEDBY , LASTUPDATEDBY , LASTUPDATEDBY , TYPE , DATETIMELASTUPDATED , > OBJECTID , NOTES , DATETIMECREATED , USERID , OBJECT , LOCKEDBY , LOCKED , > EVENT ) > > --- > > I'm also seeing things like missing commas between column names. > > At the last check earlier today the farLog table had accepted over 750 new > error records, in a 24hr period, from user "anonymous" and is highlighting > problems with calling the getData() method. > > --- > > I've seen this kind of thing in the past and typically it comes down to a > lack of "var"ing being applied in CFCs. I've run a copy of VarScoper > against the Core today and I'm seeing a lot of results coming back. The > ones that are jumping out at me though are the Gateways, in particular I'm > getting 7 coming back from the BaseGateway referring to the variable bFirst. > > That seems to be a flag used for determining how the SQL should be > formatted and is used in a number of different functions. Given this is > persisted and that variable is defaulting to global I'm pretty sure > multiple requests are hitting the Gateway and causing these deformed > queries. > > My main concern here is that although this kind of thing is being logged > by FarCry and handled by CF what are the ramifications of these objects > constantly changing in state. The theory I currently have is that this > problem could be going deeper and causing these server crashes we're now > getting. > > --- > > I'm going to need to fix these and probably review the others in more > detail but as I say if anyone has any further advice it would be much > appreciated :-). > > Cheers, > James > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: [email protected] > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
