Antclick trouble
Hi there!
I'm running jetty/mckoi on a remote linux machine. Starting AntClick I get the following messages:
Starting HTTP server on port 8080 Adding to classpath: /home/www/web1/html/ant/lib/ext/mckoidb.jar Starting Helma 1.2.5 (2003/06/06) on Java 1.4.2_01 java.io.IOException: Area (pointer = 16960664) is not allocated! at com.mckoi.store.AbstractStore.findAllocatedAreasNotIn(AbstractStore.java:657) at com.mckoi.database.V2MasterTableDataSource.scanForLeaks(V2MasterTableDataSource.java:785) at com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java:406)
... and a lot more of these message´s. I think the db is corrupted. That's the reason I started the mckoi repair tool: java -cp mckoidb.jar com.mckoi.tools.DBConglomerateRepairTool -path /home/www/web1/html/ant/data -name DefaultDatabase
This runs until: ....
- Repairing V2MasterTableDataSource 083APP_AV_ACCESSLOG
- Store: [ JournalledFileStore: 083APP_AV_ACCESSLOG ]
- Store areas are intact.
- Rebuilding free bins.
- Store repair complete.
- Checking record integrity. <-- always stopping there at 083APP_AV_ACCESSLOG
Is there any chance to repair my db? Any ideas are highly welcome!!!
asco
tobi Verwaltung
can you open the mckoi db admin tool and do some sql on the accesslog table? if so, maybe you should truncate it (delete all records). the accesslog table might not be so important most of the time but you certainly will loose your referrers and backlinks. but i am just guessing wildly here...
anyway, if you want to use antville seriously (ie. in a production environment) i recommend you switch to mysql.
asco
Thank You very much for your reply!
Unfortunately I could not find any mckoi db admin tool, but I tried to use the JDBCQueryTool (did You mean this?):
java -cp lib\ext\mckoidb.jar com.mckoi.tools.JDBCQueryTool -url "jdbc:mckoi:local://./db.conf" -u "xx" -p "xx"
It didn't help. I got the error messages:
Using JDBC Driver: com.mckoi.JDBCDriver
java.io.IOException: Area (pointer = 16960664) is not allocated!
....
....
At least the above mentioned tool wanted to have an X11-display (which is currently not available).
I helped myself by copying a the _AV_ACCESSLOG.koi from a backup
(this time my admin-account didn't work anymore).
I needed the older files _AV_MEMBERSHIP.koi and _AV_USER.koi, too...
I think I'm going to switch over to apache/mysql as soon as I can find a way to migrate.
Has anybody done this before from AntClick 1.0 to a "normal antville installation"?
darkfader
"I think I'm going to switch over to apache/mysql as soon as I can find a way to migrate.
Has anybody done this before from AntClick 1.0 to a "normal antville installation"?"
I ended up asking a DBA here at work to help me getting through the migration (antclick-1.0.1)
I can drop You a line as soon as it's worked out...
florian