Donnerstag, 28. August 2003
DB broken?
Erstellt von husky69 um 09:10
in
errors
Hi all :-)
For some days now I've got a problem starting my (local) Antclick :-(
When executing hop.bat I get the following output in the command.com:
------------------- cut here ---------------------
Starting HTTP server on port 8080
Serving applications from C:\Dokumente und Einstellungen\xxx\Eige
ne Dateien\Webseiten\antclick-1.0
java
ECHO ist ausgeschaltet (OFF).
C:\Dokumente und Einstellungen\xxx\Eigene Dateien\Webseiten\antcl
ick-1.0
-w 8080 -h "C:\Dokumente und Einstellungen\xxx\Eigene Dateien\We
bseiten\antclick-1.0
Adding to classpath: C:\Dokumente und Einstellungen\xxx\Eigene Da
teien\Webseiten\antclick-1.0\lib\ext\mckoidb.jar
Starting Helma 1.2.3 (2003/03/07) on Java 1.4.1_04
java.lang.Error: Assert failed - area not marked as deleted.
at com.mckoi.store.AbstractStore.addToBinChain(AbstractStore.java:1005)
at com.mckoi.store.AbstractStore.free(AbstractStore.java:1340)
at com.mckoi.database.V2MasterTableDataSource.scanForLeaks(V2MasterTable
DataSource.java:762)
at com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSour
ce.java:401)
at com.mckoi.database.TableDataConglomerate.readVisibleTables(TableDataC
onglomerate.java:408)
at com.mckoi.database.TableDataConglomerate.open(TableDataConglomerate.j
ava:1098)
at com.mckoi.database.Database.init(Database.java:1731)
at com.mckoi.database.control.DBController.startDatabase(DBController.ja
va:129)
at com.mckoi.database.jdbcserver.DefaultLocalBootable.boot(DefaultLocalB
ootable.java:135)
at com.mckoi.database.jdbc.MDriver.connectToLocal(MDriver.java:448)
at com.mckoi.database.jdbc.MDriver.connect(MDriver.java:484)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at helma.objectmodel.db.DbSource.getConnection(DbSource.java:71)
at helma.scripting.fesi.extensions.ESDatabase.(Database.java:67)
at helma.scripting.fesi.extensions.Database$GlobalGetDBConnection.callFu
nction(Database.java:744)
at FESI.Data.ESObject.doIndirectCallInScope(ESObject.java:551)
at FESI.Interpreter.ScopeChain.doIndirectCall(ScopeChain.java:144)
at FESI.Data.ESObject.doIndirectCallInScope(ESObject.java:548)
at FESI.Data.ESArguments.doIndirectCallInScope(ESArguments.java:100)
at FESI.Interpreter.ScopeChain.doIndirectCall(ScopeChain.java:144)
at FESI.Interpreter.Evaluator.doIndirectCall(Evaluator.java:482)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:779)
at FESI.AST.ASTCompositeReference.jjtAccept(ASTCompositeReference.java:2
6)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:362)
at FESI.AST.ASTVariableDeclaration.jjtAccept(ASTVariableDeclaration.java
:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:339)
at FESI.AST.ASTStatement.jjtAccept(ASTStatement.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:320)
at FESI.AST.ASTStatementList.jjtAccept(ASTStatementList.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.evaluateFunction(EcmaScrip
tEvaluateVisitor.java:161)
at FESI.Interpreter.Evaluator.evaluateFunction(Evaluator.java:783)
at FESI.Data.ConstructedFunctionObject.callFunction(ConstructedFunctionO
bject.java:122)
at FESI.Data.ESObject.doIndirectCallInScope(ESObject.java:551)
at FESI.Interpreter.ScopeChain.doIndirectCall(ScopeChain.java:144)
at FESI.Data.ESObject.doIndirectCallInScope(ESObject.java:548)
at FESI.Data.ESArguments.doIndirectCallInScope(ESArguments.java:100)
at FESI.Interpreter.ScopeChain.doIndirectCall(ScopeChain.java:144)
at FESI.Interpreter.Evaluator.doIndirectCall(Evaluator.java:482)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:779)
at FESI.AST.ASTCompositeReference.jjtAccept(ASTCompositeReference.java:2
6)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:339)
at FESI.AST.ASTStatement.jjtAccept(ASTStatement.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.visit(EcmaScriptEvaluateVi
sitor.java:320)
at FESI.AST.ASTStatementList.jjtAccept(ASTStatementList.java:26)
at FESI.Interpreter.EcmaScriptEvaluateVisitor.evaluateFunction(EcmaScrip
tEvaluateVisitor.java:161)
at FESI.Interpreter.Evaluator.evaluateFunction(Evaluator.java:783)
at FESI.Data.ConstructedFunctionObject.callFunction(ConstructedFunctionO
bject.java:122)
at FESI.Data.ESObject.doIndirectCall(ESObject.java:530)
at helma.scripting.fesi.FesiEngine.invoke(FesiEngine.java:508)
at helma.scripting.fesi.PhantomEngine.invoke(PhantomEngine.java:30)
at helma.framework.core.RequestEvaluator.run(RequestEvaluator.java:525)
at java.lang.Thread.run(Unknown Source)
------------------- cut here ---------------------
Does anyone know how to fix this?
I'm using Antclick 1.0 on a WinXP puter. Installing Antclick 1.0.1 in a different dir and copying the DB didn't improve thing :-(
thanks in advance,
husky69
hns
is currupt. Unfortunately this sometimes happens with the database versions shipped in Antclick 1.0.* You want to try the things I recommend in this posting (running the repair tool and updating to the newest mckoi release).
husky
thx for the tip(s) - anyway, it didn't succeed :-(
When running the given command I get:
------------------ cut here ----------------------
C:\DOKUME~1\xxx\EIGENE~1\WEBSEI~1\ANTCLI~1.0>java -cp lib/ext/mckoidb.jar c
om.mckoi.tools.DBConglomerateRepairTool -path data
+ Found state store: DefaultDatabase_sf
+ Initialized the state store: DefaultDatabase_sf
+ Repairing V2MasterTableDataSource 062SYS_INFO_sUSRSequenceInfo
Exception in thread "main" java.lang.RuntimeException: Can not create - store wi
th name 062SYS_INFO_sUSRSequenceInfo already exists.
at com.mckoi.database.V1FileStoreSystem.createStore(V1FileStoreSystem.ja
va:120)
at com.mckoi.database.V2MasterTableDataSource.checkAndRepair(V2MasterTab
leDataSource.java:786)
at com.mckoi.database.TableDataConglomerate.checkVisibleTables(TableData
Conglomerate.java:463)
at com.mckoi.database.TableDataConglomerate.fix(TableDataConglomerate.ja
va:2341)
at com.mckoi.tools.DBConglomerateRepairTool.repair(DBConglomerateRepairT
ool.java:57)
at com.mckoi.tools.DBConglomerateRepairTool.main(DBConglomerateRepairToo
l.java:85)
------------------ cut here ----------------------
Replacing mckoidb.jar doesn't help either.
thx anyway. best is that I was able to re-collect most of the data.
patpatpat
this helped in my case anyhow. repladed mckoidb.jar, did the db-repairthing (several times, just to be sure...), restartetd, got tons of messages like:
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
Inconsistant: Row is indexed but marked as removed or uncommitted.
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
Row: 5129 Type: 3 Table: APP.AV_TEXT
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
Inconsistant: Row is indexed but marked as removed or uncommitted.
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
but didn't care, and waited till the "rain was over", tried my url and things were fine again. Puuuhhh! lucky me...
------
second time around:
no, didn't work! only partly. /manage works, the logs don't...
Chronistin
error message looked just like above. upgrading to the latest mckoidb.jar & using the repair tool alone did not do much in my case, i started merging several backups (did not want to go back all the way because there's a lot of stories I generated/updated one day before the catastrophe happened). by running the repair tool in various states of the merging process, I got most of my data back. No I'm back to a working version, but it still has three "ghost rows" in three tables. those are rows that I can see in the query tool, but i cannot edit or delete them, neither directly nor through antclick. (helma gives an error message when trying to access these entries: "Error retrieving Node: com.mckoi.database.jdbc.MSQLException: Assertion failed: record is deleted!" - while the query tool just states "sql error"). of course, this problem keeps me from migrating to mySQL also.
any ideas how to fix this? i'd even try editing the db-files in a hex editor - if i had any idea where to start.