Pilot Archive
Thread: SpaceLoot.com: now with streaming chat
Ok, so here's what's going on - some subset of data within the repaired database is bad, and when mysql tries to read from that subset, it craps out.
There are some repair utilities. I'm in the process of converting the database to a repairable format to try to fix the problem.
Worst comes to worst, I'll write a script that dumps the whole thing to XML and eyeball it *shudder*
I've cleaned up some bad rows in two tables...as far as I can tell the corruption was very limited.
Also, checked the dates on the component table and it appears that we lost about ten days of data. Itet is going to get to celebrate the one thousand component mark all over again.
I'd appreciate it if you guys would get in there to try to crash it again. I've executed a couple hundred queries without trouble so far, but I didn't get any errors the first time through either.
Error Occurred While Processing Request
Cannot find CFML template for custom tag FormURL2AttributesBeta.
ColdFusion attempted looking in the tree of installed custom tags but did not find a custom tag with this name.
The error occurred in D:\ACME\index.cfm: line 13
11 : --->
12 :
13 : cf_FormURL2AttributesBeta
14 :
15 : cfapplication name = "oops" applicationtimeout = "#CreateTimeSpan(0, 1, 0, 0)#" clientmanagement = "yes" sessionmanagement="yes" setclientcookies="yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,60,0)#"
Please try the following:
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414
Remote Address 24.255.196.244
Referrer
Date/Time 17-Oct-05 01:00 PM
Stack Trace
at cfindex2ecfm1494700259.runPage(D:\ACME\index.cfm:13)
coldfusion.tagext.lang.ModuleTag$CannotOpenCfmlException: Cannot find CFML template for custom tag FormURL2AttributesBeta.
at coldfusion.tagext.lang.ModuleTag.setName(ModuleTag.java:92)
at coldfusion.tagext.lang.CustomTag.setName(CustomTag.java:34)
at cfindex2ecfm1494700259.runPage(D:\ACME\index.cfm:13)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
I only get the first part down to the browser info in IE.
(Ewww, IE, *shudder*, only a test, suck it up this once....)
-Edit-
Oops, forgot, can't use arrow brackets.
Message Edited by Stawei_Idow on 10-17-2005 11:57 AM
Message Edited by Itet on 10-17-2005 10:47 AM
Stawei_Idow wrote:
I get this in Mozilla:
(big ugly error ommitted)
Message Edited by Stawei_Idow on 10-17-2005 11:57 AM
Are the minimum and maximum values stored separately for quicker access? None of my level 8 components are listed which is expected since those were my most recently added, however a 53.8 recharge capacitor seems to hold the top spot (from this page) and I am pretty sure it was mine. Clicking on the link for max recharge gives no associated component, so that seems likely.
[I am not worried about anything being wrong, and I do expect oddities with the rebuilding, I am just curious how the system works.]
Seiryuu wrote:
It's good to see the site back up!
Are the minimum and maximum values stored separately for quicker access? None of my level 8 components are listed which is expected since those were my most recently added, however a 53.8 recharge capacitor seems to hold the top spot (from this page) and I am pretty sure it was mine. Clicking on the link for max recharge gives no associated component, so that seems likely.
[I am not worried about anything being wrong, and I do expect oddities with the rebuilding, I am just curious how the system works.]
Yeah, I wondered if anyone would catch this. Every time a component is added two tables that cache the min, max and some other aggregate data are updated. Apparently we lost more out of the component table time-wise than we did out of the two caching tables. I COULD recalculate the cache tables but I'm not currently planning on it because 1) it's pretty resource-intensive and 2) the data is still good, it just doesn't have the component data to back it up and 3) it's a self correcting problem, as when a new component of of the appropriate type/level/class is submitted, the cached data will be pinpoint-recalculated for the matching characteristics and the missing-component data will be erased.
Good eye.
SubPro "Valiant" Z2 Capacitor - RE 3
Yes, its Z2, not Z3, I'm looking at the screenshot right now.
Stawei_Idow wrote:
Found a new class shield to add:
SubPro "Valiant" Z2 Capacitor - RE 3
Yes, its Z2, not Z3, I'm looking at the screenshot right now.
done