OK - I think we have resolved this. It appears there is a variable which has not been var'd in coapiUtilities.cfc
Adding iProp as a var at the top of the getRelatedContent method appears to fix this. Raised as FC core bug (appears to be still there is later versions than the one we're running). http://bugs.farcrycms.org/browse/FC-2231 On Mar 22, 2:51 pm, Colin Jones <[email protected]> wrote: > Hi we're getting an odd problem under load. This has been happening > since we went live with the new site on FarCry When multiple requests > are going to pages we are occasionally (very small percentage) getting > server 500 errors. This can be recreated by using jMeter to load > concurrent server requests to pages. > > As a user, just refreshing the same page, and it will work perfectly > the next time. > > This errors coming back fall into two major groups, DATABASE "errors" > and UNDEFINED element errors. Both seem to be random - i.e. you will > get different errors at different times, with different variables > stated. > > Are we looking at an objectBroker problem here? Is it somehow > corrupting the initial query and results? (as the database ones really > are 'valid' errors, they really don't exist - so why does FC ask for > them) > > Running FarCry 5.2.3, CF 8.0.1 cluster. MySQL 5.0 and 5.1 with built- > in and MySQLs own JDBC drivers tried (all giving same, so pointing > towards application rather than DB). > > ====================================== > DATABASE type - > RANDOM table and elements which really DON'T exist. > ====================================== > > ErrorCode 1146 > Message Table 'farcryprod.dmHTML_Title' doesn't exist > SQLState 42S02 > StackTrace com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table > 'farcryprod.dmHTML_Title' doesn't exist at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at … > > ErrorCode 1054 > Message Unknown column 'schoolTelephone' in 'field list' > SQLState 42S22 > StackTrace com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown column 'schoolTelephone' in 'field list' at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at … > > ErrorCode 1054 > Message Unknown column 'aAccreditations2' in 'field list' > SQLState 42S22 > StackTrace com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: > Unknown column 'aAccreditations2' in 'field list' at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO … > > ErrorCode 1146 > Message Table 'farcryprod.dmHTML_locked' doesn't exist > SQLState 42S02 > StackTrace com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table > 'farcryprod.dmHTML_locked' doesn't exist at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941 … > > ----- > > ====================================== > Then the other type of error is the UNDEFINED type: > ====================================== > > ErrNumber 0 > Message Element schoolFax is undefined in a CFML structure referenced > as part of an expression. > Resolvedname [empty string] > StackTrace coldfusion.runtime.UndefinedElementException: Element > schoolFax is undefined in a CFML structure referenced as part of an > expression. at coldfusion.runtime.CfJspPage.ArrayGetAt(CfJspPage.java: > 919) at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:930) > at coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:925) at > cfcoapiUtilities2ecfc1691784977$funcGETRELATEDCONTENT.runFunction(C: > \Inetpub\farcry\core\packages\coapi\coapiUtilities.cfc:264) at > coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at > coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at … > > ErrNumber 0 > Message Element METADATA.FTJOIN is undefined in a CFML structure > referenced as part of an expression. > Resolvedname [empty string] > StackTrace coldfusion.runtime.UndefinedElementException: Element > METADATA.FTJOIN is undefined in a CFML structure referenced as part of > an expression. at > coldfusion.runtime.DotResolver.resolveSplitNameInMap(DotResolver.java: > 108) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1494) at > coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java: > 1712) at … > > ErrNumber 0 > Message Element AO is undefined in a CFML structure referenced as part > of an expression. > Resolvedname [empty string] > StackTrace coldfusion.runtime.UndefinedElementException: Element AO is > undefined in a CFML structure referenced as part of an expression. at > coldfusion.runtime.CfJspPage.ArrayGetAt(CfJspPage.java:919) at > coldfusion.runtime.CfJspPage._arrayGetAt(CfJspPage.java:930) … -- 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 To unsubscribe from this group, send email to farcry-dev+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
