Hi,
Thanks again Jens: I've switched it to use log4j (have not yet mastered the
intricacies of logback, one day..... :) ) and have a bit more information.
There doesn't seem to be much difference between DEBUG and INFO for opengrok,
though.
If I manually delete the history db (cachedb_test in this case) I get
212 12:06:16,994 org.opensolaris.opengrok.index.Indexer INFO: Done...
218 12:06:17,000 org.opensolaris.opengrok.index.Indexer INFO: Generating
history cache for all repositories ...
290 12:06:17,072 org.opensolaris.opengrok INFO: Create historycache for
/BUILD/spool/test/opengrok/src/HEAD (CVSRepository)
291 12:06:17,073 org.opensolaris.opengrok INFO: Creating historycache for
/BUILD/spool/test/opengrok/src/HEAD took (1ms)
1120 12:06:17,902 org.opensolaris.opengrok WARN: Failed optimizing the history
cache database
org.opensolaris.opengrok.history.HistoryException:
java.sql.SQLNonTransientConnectionException: No current connection.
at
org.opensolaris.opengrok.history.JDBCHistoryCache.optimize(JDBCHistoryCache.java:756)
at
org.opensolaris.opengrok.history.HistoryGuru.createCacheReal(HistoryGuru.java:504)
at
org.opensolaris.opengrok.history.HistoryGuru.createCache(HistoryGuru.java:549)
at
org.opensolaris.opengrok.index.Indexer.prepareIndexer(Indexer.java:671)
at org.opensolaris.opengrok.index.Indexer.main(Indexer.java:494)
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.Connection.rollback(Unknown Source)
at
org.opensolaris.opengrok.jdbc.ConnectionResource.rollback(ConnectionResource.java:83)
at
org.opensolaris.opengrok.jdbc.ConnectionManager.releaseConnection(ConnectionManager.java:92)
at
org.opensolaris.opengrok.history.JDBCHistoryCache.optimize(JDBCHistoryCache.java:753)
... 4 more
Caused by: org.apache.derby.client.am.SqlException: No current connection.
at
org.apache.derby.client.am.Connection.checkForClosedConnection(Unknown Source)
... 8 more
1123 12:06:17,905 org.opensolaris.opengrok.index.Indexer INFO: Done...
1124 12:06:17,906 org.opensolaris.opengrok.index.Indexer INFO: Starting
indexing
2081 12:06:18,863 org.opensolaris.opengrok.index.IndexDatabase ERROR: Problem
updating lucene index database:
org.opensolaris.opengrok.history.HistoryException:
java.sql.SQLSyntaxErrorException: Schema 'OPENGROK' does not exist
at
org.opensolaris.opengrok.history.JDBCHistoryCache.hasCacheForDirectory(JDBCHistoryCache.java:348)
at
org.opensolaris.opengrok.history.HistoryGuru.ensureHistoryCacheExists(HistoryGuru.java:592)
... and it dies, but after creating the database. If I run it a second time
Continue...
393 12:09:48,991 org.opensolaris.opengrok.index.Indexer INFO: Done...
394 12:09:48,992 org.opensolaris.opengrok.index.Indexer INFO: Generating
history cache for all repositories ...
446 12:09:49,044 org.opensolaris.opengrok INFO: Create historycache for
/BUILD/spool/test/opengrok/src/HEAD (CVSRepository)
446 12:09:49,044 org.opensolaris.opengrok INFO: Creating historycache for
/BUILD/spool/test/opengrok/src/HEAD took (1ms)
674 12:09:49,272 org.opensolaris.opengrok.index.Indexer INFO: Done...
675 12:09:49,273 org.opensolaris.opengrok.index.Indexer INFO: Starting indexing
1229 12:09:49,827 org.opensolaris.opengrok INFO: Create historycache for
/BUILD/spool/test/opengrok/src/HEAD (CVSRepository)
1229 12:09:49,827 org.opensolaris.opengrok INFO: Creating historycache for
/BUILD/spool/test/opengrok/src/HEAD took (0ms)
2657 12:09:51,255 org.opensolaris.opengrok.index.Indexer INFO: Send
configuration to: localhost:2425
The tables are created but still not populated. Note that
2657 12:09:51,255 org.opensolaris.opengrok.index.Indexer INFO: Send
configuration to: localhost:2425
2659 12:09:51,257 org.opensolaris.opengrok.index.Indexer ERROR: Failed to send
configuration to localhost:2425 (is web application server running with
opengrok deployed?)
java.net.ConnectException: Connection refused
is deliberate - I don't want to overwrite my "live" configuration.
I note also that the config file contains two identical "cmds" sections:
<?xml version="1.0" encoding="UTF-8"?>
<java version="1.6.0" class="java.beans.XMLDecoder">
<object class="org.opensolaris.opengrok.configuration.Configuration">
<void property="allowLeadingWildcard">
<boolean>true</boolean>
</void>
<void property="cmds">
<void method="put">
<string>org.opensolaris.opengrok.history.ClearCaseRepository</string>
<string>cleartool</string>
</void>
<void method="put">
<string>org.opensolaris.opengrok.history.PerforceRepository</string>
<string>p4</string>
</void>
<void method="put">
<string>org.opensolaris.opengrok.history.CVSRepository</string>
<string>/opt/freeware/bin/cvs</string>
</void>
</void>
<void property="ctags">
<string>/BUILD/local/apps/ctags/bin/ctags</string>
</void>
<void property="dataRoot">
<string>/BUILD/spool/test/opengrok/data</string>
</void>
<void property="databaseDriver">
<string>org.apache.derby.jdbc.ClientDriver</string>
</void>
<void property="databaseUrl">
<string>jdbc:derby://localhost:1527/cachedb_test;create=true</string>
</void>
<void property="historyCacheInDB">
<boolean>true</boolean>
</void>
<void property="projects">
<void method="add">
<object class="org.opensolaris.opengrok.configuration.Project">
<void property="description">
<string>HEAD</string>
</void>
<void property="path">
<string>/HEAD</string>
</void>
</object>
</void>
</void>
<void property="remoteScmSupported">
<boolean>true</boolean>
</void>
<void property="repositories">
<void method="add">
<object class="org.opensolaris.opengrok.history.RepositoryInfo">
<void property="datePattern">
<string>yyyy-MM-dd hh:mm:ss</string>
</void>
<void property="directoryName">
<string>/BUILD/spool/test/opengrok/src/HEAD</string>
</void>
<void property="type">
<string>CVS</string>
</void>
</object>
</void>
</void>
<void property="sourceRoot">
<string>/BUILD/spool/test/opengrok/src</string>
</void>
<void property="urlPrefix">
<string>/opengrok/s?</string>
</void>
<void property="verbose">
<boolean>true</boolean>
</void>
<void property="cmds">
<void method="put">
<string>org.opensolaris.opengrok.history.ClearCaseRepository</string>
<string>cleartool</string>
</void>
<void method="put">
<string>org.opensolaris.opengrok.history.PerforceRepository</string>
<string>p4</string>
</void>
<void method="put">
<string>org.opensolaris.opengrok.history.CVSRepository</string>
<string>/opt/freeware/bin/cvs</string>
</void>
</void>
</object>
</java>
Weird. Anyway - thanks for your help. I don't have much more time to devote to
this, and in any case everything is working apart from the history cache (I can
still do history searches), so I think I'll just drop the issue for the time
being.
Best regards and thanks to all who took a look at this,
Mark
-----Message d'origine-----
De : opengrok-discuss-boun...@opensolaris.org
[mailto:opengrok-discuss-boun...@opensolaris.org] De la part de Jens Elkner
Envoyé : dimanche 24 juin 2012 05:45
À : opengrok-discuss@opensolaris.org
Objet : Re: [opengrok] javadb historycache not being used with CVS
On Fri, Jun 22, 2012 at 09:18:56AM +0200, Clements Mark wrote:
Hi Clements,
> Jens: thanks for the suggestion.
>
> >Looks like /BUILD/spool is a symlink to /BUILD/environments_nolog2/spool ?
> >Any changes, if you index /BUILD/environments_nolog2/spool ... directly ?
>
> Alas, it doesn't appear to change anything.
Hmmm, looks strange. A better log output would be more helpful.
Consider to change it to something like
http://iws.cs.uni-magdeburg.de/~elkner/s11/opengrok-logback.html#default
or if you don't mind switch over to logback (described below at the same page),
which is much better anyway.
Have fun,
jel.
--
Otto-von-Guericke University http://www.cs.uni-magdeburg.de/
Department of Computer Science Geb. 29 R 027, Universitaetsplatz 2
39106 Magdeburg, Germany Tel: +49 391 67 12768
_______________________________________________
opengrok-discuss mailing list
opengrok-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/opengrok-discuss
_______________________________________________
opengrok-discuss mailing list
opengrok-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/opengrok-discuss
