[cfaussie] cfquery cachedwithin
Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] cfquery cachedwithin
Yes if the query is dynamic it would be re-retrieved from the database server. And then cached. Unless the original query was not altered the cache would remain. So keep the cache in place unless the query is more dynamic than static - otherwise the memory and resources could probably be better used by the system elsewhere. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:02, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] cfquery cachedwithin
The cache is based on the QUERY=myQuery. If that query is altered (dynamic) from when the cache was created - basically a totally different query - the cache would be recreated using the new SQL that was requested. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:06, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Yes if the query is dynamic it would be re-retrieved from the database server. And then cached. Unless the original query was not altered the cache would remain. So keep the cache in place unless the query is more dynamic than static - otherwise the memory and resources could probably be better used by the system elsewhere. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:02, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] cfquery cachedwithin
Do you use ColdFire? ( now works with FF 4 ) You can watch all queries on each page hit and it will tell you if its cached or not. You can also watch this with *Enable Request Debugging Output* turend on although it will mess up your HTML in some cases. That way you can prove if its being cached or not. Paul. On Tue, Jun 21, 2011 at 5:02 PM, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Paul Kukiel -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] cfquery cachedwithin
Query caching is great for things that you KNOW won't change for ages, eg OZ PostCode/Suburbs you can safely cache for 24hours but still a pain in the butt to get source file from AusPost but as an example. Not every query needs to or even should be cached. Basic rule of thumb is if SQL or whatever database server you use (what are you using? I use 3 iterations of SQL Server) changes between CF and the database server - expecting a different and not the same result (same result use the cached result) a new query will be made and THAT will then be cached. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:08, Paul Kukiel kuki...@gmail.com wrote: Do you use ColdFire? ( now works with FF 4 ) You can watch all queries on each page hit and it will tell you if its cached or not. You can also watch this with Enable Request Debugging Output turend on although it will mess up your HTML in some cases. That way you can prove if its being cached or not. Paul. On Tue, Jun 21, 2011 at 5:02 PM, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Paul Kukiel -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: cfquery cachedwithin
Thanks guys. What's confusing me is that the query is *not* dynamic. The underlying data *may* change in the meantime (it's a count - and we're prepared to accept the discrepancy), but the query itself accepts no parameters and the sql will be identical each time it's called. That's what confuses me, because I was under the impression that under these conditions it should stay cached, and it doesn't seem to be. Doing a cfdump shows cached = true most of the time, but every now and then it shows cached = false. I'm thinking of just putting the value in a variables and caching it with cfcache, but I'd really like to understand why it's not working as expected... Andrew. On Jun 21, 5:15 pm, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Query caching is great for things that you KNOW won't change for ages, eg OZ PostCode/Suburbs you can safely cache for 24hours but still a pain in the butt to get source file from AusPost but as an example. Not every query needs to or even should be cached. Basic rule of thumb is if SQL or whatever database server you use (what are you using? I use 3 iterations of SQL Server) changes between CF and the database server - expecting a different and not the same result (same result use the cached result) a new query will be made and THAT will then be cached. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW:http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:08, Paul Kukiel kuki...@gmail.com wrote: Do you use ColdFire? ( now works with FF 4 ) You can watch all queries on each page hit and it will tell you if its cached or not. You can also watch this with Enable Request Debugging Output turend on although it will mess up your HTML in some cases. That way you can prove if its being cached or not. Paul. On Tue, Jun 21, 2011 at 5:02 PM, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that cause this one to be lost? Or would they both be cached independently? Because this is a possibility, as we have a staging instance on the same coldfusion instance. Hopefully that all makes sense...it's a bit hard to explain... Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Paul Kukiel -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.- Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: MAD! Melbourne Adobe Developers meeting details for Thursday 23 June 2011
Yeah...if they're flying!!! On 21 June 2011 15:09, Peter Robertson peter.r.robert...@gmail.com wrote: Thanks Andrew, you could just jump on a plane :). -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
Just to clarify, the cached = false appears every couple of minutes, despite the cachedwithin timespan asking for 5 hours... On 21 June 2011 17:36, Andrew am2...@gmail.com wrote: Doing a cfdump shows cached = true most of the time, but every now and then it shows cached = false. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: cfquery cachedwithin
If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW: http://www.coldgen.com/ ABN: 80 826 226 128 NOTICE: This email remains the property of ColdGen Internet Solutions. Confidentiality and legal privilege associated with information transmitted in this email, including any attachments, are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please destroy the document and notify the sender immediately by telephone or by email to in...@coldgen.com. Do not remove this notice from this email. Emails belong in computers, trees belong in forests; if you must print this, do it on recycled paper. -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Sent: Tuesday, 21 June 2011 5:37 PM To: cfaussie Subject: [cfaussie] Re: cfquery cachedwithin Thanks guys. What's confusing me is that the query is *not* dynamic. The underlying data *may* change in the meantime (it's a count - and we're prepared to accept the discrepancy), but the query itself accepts no parameters and the sql will be identical each time it's called. That's what confuses me, because I was under the impression that under these conditions it should stay cached, and it doesn't seem to be. Doing a cfdump shows cached = true most of the time, but every now and then it shows cached = false. I'm thinking of just putting the value in a variables and caching it with cfcache, but I'd really like to understand why it's not working as expected... Andrew. On Jun 21, 5:15 pm, ColdGen Internet Solutions coldgen.internet.soluti...@gmail.com wrote: Query caching is great for things that you KNOW won't change for ages, eg OZ PostCode/Suburbs you can safely cache for 24hours but still a pain in the butt to get source file from AusPost but as an example. Not every query needs to or even should be cached. Basic rule of thumb is if SQL or whatever database server you use (what are you using? I use 3 iterations of SQL Server) changes between CF and the database server - expecting a different and not the same result (same result use the cached result) a new query will be made and THAT will then be cached. Peter Tilbrook Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion 9 Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6284-2727 Mob: +61-2-0457-449-016 Email Address: pe...@coldgen.com WWW:http://www.coldgen.com/ ABN: 80 826 226 128 On 21 June 2011 17:08, Paul Kukiel kuki...@gmail.com wrote: Do you use ColdFire? ( now works with FF 4 ) You can watch all queries on each page hit and it will tell you if its cached or not. You can also watch this with Enable Request Debugging Output turend on although it will mess up your HTML in some cases. That way you can prove if its being cached or not. Paul. On Tue, Jun 21, 2011 at 5:02 PM, Andrew am2...@gmail.com wrote: Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So my question is - how can I debug this? I believe the requirements specified in the doco are being meet, eg: the current query must use the same SQL statement, data source, query name, user name, and password However, one possible thing I can think of is, what if there was the same SQL statement being called with a different datasource. Would that
Re: [cfaussie] Re: cfquery cachedwithin
I would have a look into that datasource idea with your staging environment again. Maybe just build a simple testcase and see if calling the logic that runs the query in staging triggers the re-execution of the query in production. Also - you're 100% sure there that it doesn't get kicked out of the query cache? Just to clarify, the cached = false appears every couple of minutes, despite the cachedwithin timespan asking for 5 hours... On 21 June 2011 17:36, Andrew am2...@gmail.com wrote: Doing a cfdump shows cached = true most of the time, but every now and then it shows cached = false. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote: If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: cfquery cachedwithin
But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? Yes - it should. Because you are caching results that do not change for a long time. The CACHEDWITHIN is a measure of how long CF will store a QUERY until it is notified that a cached query has changed - it does this automatically. So. 1. CF request a QUERY from your database server. 2. DB sends back result and CF caches it - for 5 or how many hours. 3. Multiple request made to DB and CF gets same result so uses the cache instead. All good. 4. But one single requests alters the DB response. CF caches the new result. This new result is now the CACHE result. 5. All good no more changes for 5 hours. At 5:15 a new query to DB. Cache has expired. DB responds. CF creates a new CACHE with that result. That in a nutshell is how is works. Only been using CF for 16 years next month so am I right? On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote: If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: cfquery cachedwithin
But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? It takes milliseconds for CF to check as opposed to many many seconds to retrieve database records that you would normally cache and not HIT the server every time when you know as a developer the result will not often change. My postcode example in point, say 10,000+ records? That is when you use caching. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
Nope, you're wrong re 4. There's no underlying magic that notifies CF that a query has changed. If you cache a query for whatever timespan CF doesn't talk to the server for that timespan at all unless you flush the query cache by for instance setting cachedwithin for that query to a zero-timespan or restart the CF service/daemon Cheers Kai But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? Yes – it should. Because you are caching results that do not change for a long time. The CACHEDWITHIN is a measure of how long CF will store a QUERY until it is notified that a cached query has changed – it does this automatically. So. 1. CF request a QUERY from your database server. 2. DB sends back result and CF caches it – for 5 or how many hours. 3. Multiple request made to DB and CF gets same result so uses the cache instead. All good. 4. But one single requests alters the DB response. CF caches the new result. This new result is now the CACHE result. 5. All good no more changes for 5 hours. At 5:15 a new query to DB. Cache has expired. DB responds. CF creates a new CACHE with that result. That in a nutshell is how is works. Only been using CF for 16 years next month so am I right? On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote: If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: cfquery cachedwithin
Basterd ;) I think you are right - been a long time since I've needed to cache a query. You are right I remember. Cache for 5 minutes - yup 5 minutes - unless some sort of error? An interesting point - caching the WRONG or OUT OF DATE stuff can be worse than not caching at all. Tired - went to bed at 4am and woke up at 9am thinking I overslept and it was 2pm! Long day! I certainly recommend caching queries. Even for 5-15 minutes on a heavy trafficked site can make a difference. Every site and application will be different. The developer fun is finding or tuning the sweetspot. Nope, you're wrong re 4. There's no underlying magic that notifies CF that a query has changed. If you cache a query for whatever timespan CF doesn't talk to the server for that timespan at all unless you flush the query cache by for instance setting cachedwithin for that query to a zero-timespan or restart the CF service/daemon Cheers Kai -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: cfquery cachedwithin
Do you really think that sort of language is needed or appropriate? From: Peter Tilbrook [mailto:peter.tilbr...@gmail.com] Sent: Tuesday, 21 June 2011 6:22 PM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Re: cfquery cachedwithin Basterd ;) I think you are right - been a long time since I've needed to cache a query. You are right I remember. Cache for 5 minutes - yup 5 minutes - unless some sort of error? An interesting point - caching the WRONG or OUT OF DATE stuff can be worse than not caching at all. Tired - went to bed at 4am and woke up at 9am thinking I overslept and it was 2pm! Long day! I certainly recommend caching queries. Even for 5-15 minutes on a heavy trafficked site can make a difference. Every site and application will be different. The developer fun is finding or tuning the sweetspot. Nope, you're wrong re 4. There's no underlying magic that notifies CF that a query has changed. If you cache a query for whatever timespan CF doesn't talk to the server for that timespan at all unless you flush the query cache by for instance setting cachedwithin for that query to a zero-timespan or restart the CF service/daemon Cheers Kai -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
Andrew, I realise I'm jumping in late, so apologies if this has already been mentioned, or I'm completely wrong. I think the query name needs to be more unique. If your server runs another query with the same name but different SQL, the cache will be overwritten. Maybe do a search thru you code base for another query with the same name. Or rename the query, ie: qCountOfHorsesInRace#raceNo# (just an example) From the docs: To use cached data, current query must use same SQL statement, data source, query name, user name, password. Cheers. ps: maybe you could ride a horse down to the Melbourne user group ;) On 21/06/2011, at 6:01 PM, Peter Tilbrook peter.tilbr...@gmail.com wrote: But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? Yes – it should. Because you are caching results that do not change for a long time. The CACHEDWITHIN is a measure of how long CF will store a QUERY until it is notified that a cached query has changed – it does this automatically. So. 1. CF request a QUERY from your database server. 2. DB sends back result and CF caches it – for 5 or how many hours. 3. Multiple request made to DB and CF gets same result so uses the cache instead. All good. 4. But one single requests alters the DB response. CF caches the new result. This new result is now the CACHE result. 5. All good no more changes for 5 hours. At 5:15 a new query to DB. Cache has expired. DB responds. CF creates a new CACHE with that result. That in a nutshell is how is works. Only been using CF for 16 years next month so am I right? On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote: If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
Sorry Steve - tongue in cheek not meant to offend! Sorry again! -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
That's what I tried to say! Thx Mr Buzzy! Definately use caching where appropriate. On DB heavy apps it can be really handy. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
Thanks guys. A few things for me to check tomorrow. I'm not overly familiar with this part of the app, and I'll also look at whether 5 hrs is an appropriate length of time to cache it for too. Andrew. Sent from my mobile On 21/06/2011, at 6:24 PM, MrBuzzy mrbu...@gmail.com wrote: Andrew, I realise I'm jumping in late, so apologies if this has already been mentioned, or I'm completely wrong. I think the query name needs to be more unique. If your server runs another query with the same name but different SQL, the cache will be overwritten. Maybe do a search thru you code base for another query with the same name. Or rename the query, ie: qCountOfHorsesInRace#raceNo# (just an example) From the docs: To use cached data, current query must use same SQL statement, data source, query name, user name, password. Cheers. ps: maybe you could ride a horse down to the Melbourne user group ;) On 21/06/2011, at 6:01 PM, Peter Tilbrook peter.tilbr...@gmail.com wrote: But it shouldn't go back to the database to check if it's changed, if it's truly cached. What would be the point of caching, if it had to check anyway? Yes – it should. Because you are caching results that do not change for a long time. The CACHEDWITHIN is a measure of how long CF will store a QUERY until it is notified that a cached query has changed – it does this automatically. So. 1. CF request a QUERY from your database server. 2. DB sends back result and CF caches it – for 5 or how many hours. 3. Multiple request made to DB and CF gets same result so uses the cache instead. All good. 4. But one single requests alters the DB response. CF caches the new result. This new result is now the CACHE result. 5. All good no more changes for 5 hours. At 5:15 a new query to DB. Cache has expired. DB responds. CF creates a new CACHE with that result. That in a nutshell is how is works. Only been using CF for 16 years next month so am I right? On 21 June 2011 17:53, Peter Tilbrook peter.tilbr...@gmail.com wrote: If the QUERY result changes (the result) the CACHE changes. This is the point. If the query has NOT changed CF will use what is stored. Otherwise it re-requests the data from the database server. ColdFusion is NOT a database server. Your database returns a result to ColdFusion based on what CF request. If the database server itself says the results are different now than obviously the result given to CF is now changed. Hence a new QUERY.RESULT and a NEW AND UPDATED cache. Get it? -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: cfquery cachedwithin
:) -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] cfquery cachedwithin
Andrew, I've read all the replies so far, but here are some points which no one has mentioned that I think may help. (Not trying to be a tall poppy: just sharing the kind of stuff I share often when I'm helping people troubleshoot such problems via my services.) 1) First, it is possible that the cache is being flushed--without respect to the particular query you're focused on, or how it's created. Note that the query cache is server-wide (one for all, and all in one). Here are a few ways that could be cleared: a) Of course, the cache is cleared when CF restarts (don't ignore that as a real possibility). You mention using the CF Server Monitor. It reports on its overview page the time/date of the server having started. For those not running Enterprise or the Developer edition, I show some code to programmatically determine CF uptime here: http://www.carehart.org/blog/client/index.cfm/2006/8/13/cfserver_uptime b) And it could be someone clearing the query cache programmatically (somewhere else in that or any application, server-wide), which could be done with the horribly named cfobjectcache (all it does is clear the query cache, so should have been named cfquerycache) or some undocumented java object calls (perhaps also the Admin API: I can't recall) c) Finally, it could also be someone changing the query cache size in the CF Admin: yep, that clears the cache Of course, as you noted (and don't think is happening), it could also be that the individual query could be removed from the cache due to its filling, and you say you don't think that's happening. That leads to the next point. 2) Second, you say you are confirming that with the CF Server Monitor: looking at the monitor it seems to fluctuate between about 2 and 8 cached queries in total, so I am pretty sure we aren't hitting the limit. So let's clarify: which page are you watching? The Query Cache Status page? Or Cached Queries? To be clear, the former is a great report in that it does NOT require any of the start buttons to be enabled, so it's essentially free. The latter not only requires start monitoring *and profiling* but here's a gotcha: those must be enabled BEFORE a query is placed into the cache, otherwise it will not show up in its report. (Again, that's not true of the Query Cache Status page, so that's your best first bet for saying how many queries are in the cache.) Back to the points above about how the query cache might be being cleared, you can observe in that query cache status graph if/when any of the above cache-clear operations may be happening (except a restart, of course, as that takes out the server monitor, too, but at least you can see that via the timestamp on the front page.) 3) Finally, as for your wondering about how the cached results are keyed, it is as you saw: the datasource, queryname, username/password, and sql statement all form the key for the cached entry. If they change, then a NEW cache entry is created. And that means even if a single space or line-end character changes in the SQL. (Also, note that I say a new cache entry is created: the old one is not overwritten, as some suggested. An old cache entry is only replaced by its removal from the cache: by timing out, or any of the above.) And to drive again the point of it being server-wide (within a given CF instance), note that there's NO reference to the application name nor certainly the file name or its location. A given cached query could therefore be (and reasonably should be) shared across all apps on a server, as long as the key values are identical (and the query is set to be cached with the cachedwithin or cachedafter attributes). But there's nothing about that which should be contributing to the confusion you're seeing. Hope that helps. /charlie arehart char...@carehart.org Providing fast, remote, on-demand troubleshooting services for CF (and CFBuilder) More at http://www.carehart.org/consulting -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Sent: Tuesday, June 21, 2011 3:02 AM To: cfaussie Subject: [cfaussie] cfquery cachedwithin Hi, A colleague has asked me to investigate some code that he claims used to cache, but at some point recently doesn't anymore. Sadly, I can't replicate the exact code / query here (I expect my boss would have a fit if I did), but to paraphrase it, it's something like: cfquery name=qCount datasource=somedatasource cachedwithin=#CreateTimeSpan(0,5,0,0)# /cfquery Please take my word for it that the query does not change, but it DOES have a couple of nested selects (not sure that would be a factor?). I set up a test page, and it appears to remain cached for a couple of minutes and then disappear from the cache. The CF Administrator is set to cache 100 queries, and looking at the monitor it seems to flucuate between about 2 and 8 cached queries in total, so I am pretty sure we
RE: [cfaussie] Re: cfquery cachedwithin
I've not heard of that being a feature with CF. It was/is a feature of BlueDragon.net. If it is a feature of CF, I'd love to hear what combination would make it go, as it would be really valuable. (Perhaps it's a part of the new ehcache caching, but I've not worked with it as much to know.) /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Kym Kovan Sent: Tuesday, June 21, 2011 8:53 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Re: cfquery cachedwithin Andrew, sorry more than a bit late on this (16 new CF servers to do in 3 days and don't even mention DistIT) but to add to the confusion some databases will flag that there has been a change in data and CF can pick that up so the cache gets dropped. I can't remember the combo and you haven't said what SQL server and cfml platform but it might be relevant. -- Yours, Kym Kovan -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:www.andyscott.id.au/2011/3/30/Can-Adobe-get-anything-right-Latest-security-updates-break-ColdFusion+org/owasp/esapi/errors/EncodingException+coldfusioncd=2hl=enct=clnkgl=auclient=firefox-asource=www.google.com.au I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Hi, this is just a copy/paste from a MXUnit post - but I wonder if this is your issue? Marc, Thanks for getting back to me. That was the strange part, i was only getting a white screen. The error that i posted about was when i ran it through eclipse. But i had a coworker (Nathan Mische) sit with me today as i attempted to install the hotfix again and he noticed my error. When applying the hotfix the directions say to remove hf901-1.jar from the updates folder. I was deleting chf9010001.jar (the cumulative hotfix) by mistake. I restored this file and things are working now. I'm all for short file names but i wonder how many other people are also making this mistake. Thanks everyone for checking it out. John - Gavin. On Jun 22, 8:15 am, Andrew am2...@gmail.com wrote: Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:www... I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Thanks Gavin. Will check it out. On 22 June 2011 08:48, Gavin Baumanis beauecli...@gmail.com wrote: Hi, this is just a copy/paste from a MXUnit post - but I wonder if this is your issue? Marc, Thanks for getting back to me. That was the strange part, i was only getting a white screen. The error that i posted about was when i ran it through eclipse. But i had a coworker (Nathan Mische) sit with me today as i attempted to install the hotfix again and he noticed my error. When applying the hotfix the directions say to remove hf901-1.jar from the updates folder. I was deleting chf9010001.jar (the cumulative hotfix) by mistake. I restored this file and things are working now. I'm all for short file names but i wonder how many other people are also making this mistake. Thanks everyone for checking it out. John - Gavin. On Jun 22, 8:15 am, Andrew am2...@gmail.com wrote: Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:www... I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Ooops, found the issue. I've copied lib into WEB-INF/cfusion/lib, so ended up with WEB-INF/cfusion/lib/lib Anyone else noticed I'm having a shocker lately??? :( On 22 June 2011 08:50, Andrew Myers am2...@gmail.com wrote: Thanks Gavin. Will check it out. On 22 June 2011 08:48, Gavin Baumanis beauecli...@gmail.com wrote: Hi, this is just a copy/paste from a MXUnit post - but I wonder if this is your issue? Marc, Thanks for getting back to me. That was the strange part, i was only getting a white screen. The error that i posted about was when i ran it through eclipse. But i had a coworker (Nathan Mische) sit with me today as i attempted to install the hotfix again and he noticed my error. When applying the hotfix the directions say to remove hf901-1.jar from the updates folder. I was deleting chf9010001.jar (the cumulative hotfix) by mistake. I restored this file and things are working now. I'm all for short file names but i wonder how many other people are also making this mistake. Thanks everyone for checking it out. John - Gavin. On Jun 22, 8:15 am, Andrew am2...@gmail.com wrote: Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:www. .. I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Yeah I pulled that post because it was my screw up that caused the problem, it seems like you also missed the one crucial step in the patch as I did at that time. Suggestion, copy all the files and patch again. Adobe Engineers sat down with me and we tried this over a connect session and it all worked fine. Worth a shot. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Sent: Wednesday, 22 June 2011 8:15 AM To: cfaussie Subject: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15 Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:ww w.andyscott.id.au/2011/3/30/Can-Adobe-get-anything-right-Latest-security- updates-break- ColdFusion+org/owasp/esapi/errors/EncodingException+coldfusioncd=2 hl=enct=clnkgl=auclient=firefox-asource=www.google.com.au I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15
Thanks Andrew. Yep my screw up also. Tried to apply the updates early in the day, but should have had coffee first I think... On 22 June 2011 10:41, Andrew Scott andr...@andyscott.id.au wrote: Yeah I pulled that post because it was my screw up that caused the problem, it seems like you also missed the one crucial step in the patch as I did at that time. Suggestion, copy all the files and patch again. Adobe Engineers sat down with me and we tried this over a connect session and it all worked fine. Worth a shot. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Andrew Sent: Wednesday, 22 June 2011 8:15 AM To: cfaussie Subject: [cfaussie] Re: ColdFusion Security Hotfix APSB11-14 and APSB11-15 Hmm I've applied the updates but it appears to have causes some issues - ie I get an error 500 when trying to acccess the coldfusion administrator. Here's the error: Error,web-0,06/22/11,08:09:37,,Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: org/owasp/ esapi/errors/EncodingException. The specific sequence of files included or processed is: /opt/jrun4/servers/mura-inter/cfusion.ear/ cfusion.war/WEB-INF/exception/coldfusion/runtime/ObjectException.cfm, line: 12 Andy Scott looks to have blogged about this after installing a prior update (seems his blog is currently unvailable but here's a cached version): http://webcache.googleusercontent.com/search?q=cache:uFtKTCyXIX8J:ww w.andyscott.id.au/2011/3/30/Can-Adobe-get-anything-right-Latest-security- updates-break- ColdFusion+org/owasp/esapi/errors/EncodingException+coldfusioncd=2 hl=enct=clnkgl=auclient=firefox-asource=www.google.com.au I'm currently googling a solution but if anyone has struck it and can save me the time it'd be nice to hear how you fixed it :-) Andrew. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.