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.
